?? setmoney.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 setmoney : Form
{
data da = new data();
public setmoney()
{
InitializeComponent();
}
//確定
private void yesbtn_Click(object sender, EventArgs e)
{
SqlDataAdapter sqlda = new SqlDataAdapter("select * from compensationView", da.link());
SqlCommand sqlcomm = new SqlCommand("update compensation set addworkcompensation=@addworkcompensation where compensationID=@compensationID", da.link());
sqlcomm.Parameters.AddWithValue("@addworkcompensation", moneytxt.Text);
SqlParameter para = sqlcomm.Parameters.Add("@compensationID", this.Tag.ToString());
para.SourceVersion = DataRowVersion.Current;
sqlda.UpdateCommand = sqlcomm;
sqlda.UpdateCommand.ExecuteNonQuery();
this.Close();
}
//取消
private void outbtn_Click(object sender, EventArgs e)
{
DialogResult sss = MessageBox.Show("請確認要退出!", "請確認要退出!", MessageBoxButtons.YesNo);
if (sss == DialogResult.Yes)
{
this.Close();
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -