?? setattendancetype.cs
字號:
?using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace 人事管理
{
public partial class SetAttendanceType : Form
{
data da = new data();
public SetAttendanceType()
{
InitializeComponent();
}
//確定
private void button1_Click(object sender, EventArgs e)
{
SqlDataAdapter sqlda = new SqlDataAdapter("select * from WorkerAttendanceView", da.link());
SqlCommand sqlcomm = new SqlCommand("update WorkerAttendance set AttendanceType=@AttendanceType where AttendanceID=@AttendanceID", da.link());
sqlcomm.Parameters.AddWithValue("@AttendanceType", comboBox1.Text);
SqlParameter para = sqlcomm.Parameters.Add("@AttendanceID", this.Tag.ToString());
para.SourceVersion = DataRowVersion.Current;
sqlda.UpdateCommand = sqlcomm;
sqlda.UpdateCommand.ExecuteNonQuery();
this.Close();
}
//取消
private void button2_Click(object sender, EventArgs e)
{
DialogResult sss = MessageBox.Show("請確認要退出!", "請確認要退出!", MessageBoxButtons.YesNo);
if (sss == DialogResult.Yes)
{
this.Close();
}
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -