📄 computeform.cs
字号:
//MyRange = MyWorkSheet.get_Range("A5", MyColumns.ToString() + "5");
//int Count = 0;
//foreach (DataColumn MyNewColumn in this.myPersonnelDataSet.工资核算表.Columns)
//{
// MyData[0, Count] = MyNewColumn.ColumnName;
// Count = Count + 1;
//}
//j = 1;
////输出数据库记录
//foreach (DataRow MyRow in this.myPersonnelDataSet.工资核算表.Rows)
//{
// for (i = 0; i < this.myPersonnelDataSet.工资核算表.Columns.Count ; i++)
// {
// MyData[j, i] = MyRow[i].ToString();
// }
// j++;
//}
//MyRange = MyRange.get_Resize(this.myPersonnelDataSet.工资核算表.Rows.Count + 1, this.myPersonnelDataSet.工资核算表.Columns.Count);
//MyRange.Value2 = MyData;
//MyRange.EntireColumn.AutoFit();
//MyWorkSheet.Cells[2, 2] = this.MyCompany +this.部门ToolStripComboBox.Text +"工资核算表";
//MyWorkSheet.Cells[4, 1] = "日期：" +this.年份ToolStripComboBox.Text+ "年"+this.月份ToolStripComboBox.Text+"月";
}
private void 发工资ToolStripButton_Click(object sender, EventArgs e)
{
int My年份=Convert.ToInt16(this.年份ToolStripComboBox.Text);
int My月份=Convert.ToInt16(this.月份ToolStripComboBox.Text);
string MyInfo = "是否确定发放" + My年份.ToString() + "年" + My月份.ToString() + "月" + this.部门ToolStripComboBox.Text + "员工的工资？\n注意：一旦发放当月工资，就不能再进行修改！";
if (MessageBox.Show(MyInfo,"信息提示",MessageBoxButtons.YesNo,MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
String MySQLConnectionString = global::MyPersonnel.Properties.Settings.Default.MyPersonnelConnectionString;
SqlConnection MyConnection = new SqlConnection(MySQLConnectionString);
MyConnection.Open();
int MyCount = 0;
foreach (DataRow MyRow in this.myPersonnelDataSet.工资核算表.Rows)
{
string My员工编号=MyRow[1].ToString();
string My发放年份= this.年份ToolStripComboBox.Text;
string My发放月份= this.月份ToolStripComboBox.Text;
string MySQL = "Select COUNT(*) From 工资发放表 Where 发放年份="+this.年份ToolStripComboBox.Text+" AND 发放月份="+this.月份ToolStripComboBox.Text+" AND 员工编号='"+My员工编号+"'";
SqlCommand MyCommand = new SqlCommand(MySQL, MyConnection);
MyCount = (int)MyCommand.ExecuteScalar();
if (MyCount>0)
{
continue;
}
string My自编号 = GetMy自编号();
System.Data.DataTable MyQueryTable = new System.Data.DataTable();
MySQL = "Select 银行帐号,养老保险帐号,医疗保险帐号,住房基金帐号,身份证号码 From 基本档案 WHERE 员工编号='" + My员工编号 + "'";
SqlDataAdapter MyDataAdapter = new SqlDataAdapter(MySQL, MyConnection);
MyDataAdapter.Fill(MyQueryTable);
string My银行帐号 = MyQueryTable.Rows[0][0].ToString();
string My养老保险帐号 = MyQueryTable.Rows[0][1].ToString();
string My医疗保险帐号 = MyQueryTable.Rows[0][2].ToString();
string My住房基金帐号 = MyQueryTable.Rows[0][3].ToString();
string My身份证号码 = MyQueryTable.Rows[0][4].ToString();
MySQL = "INSERT INTO 工资发放表([自编号] ,[员工编号], [员工姓名], [基本工资],[津贴] ,[奖金], [工龄工资], [岗位工资],[其他应增项] ,[所得税], [养老险],[医疗险] ,[住房基金], [其他应减项], [银行帐号],[养老保险帐号] ,[医疗保险帐号], [住房基金帐号], [身份证号码],[发放年份] ,[发放月份], [说明]) VALUES (@自编号 ,@员工编号,@员工姓名,@基本工资,@津贴 ,@奖金,@工龄工资,@岗位工资,@其他应增项 ,@所得税,@养老险,@医疗险 ,@住房基金,@其他应减项,@银行帐号,@养老保险帐号 ,@医疗保险帐号,@住房基金帐号,@身份证号码,@发放年份 ,@发放月份,@说明)";
MyCommand = MyConnection.CreateCommand();
MyCommand.CommandText = MySQL;
MyCommand.Parameters.Add(new SqlParameter("@自编号", SqlDbType.VarChar));
MyCommand.Parameters.Add(new SqlParameter("@员工编号", SqlDbType.VarChar));
MyCommand.Parameters.Add(new SqlParameter("@员工姓名", SqlDbType.VarChar));
MyCommand.Parameters.Add(new SqlParameter("@基本工资", SqlDbType.Float));
MyCommand.Parameters.Add(new SqlParameter("@津贴", SqlDbType.Float));
MyCommand.Parameters.Add(new SqlParameter("@奖金", SqlDbType.Float));
MyCommand.Parameters.Add(new SqlParameter("@工龄工资", SqlDbType.Float));
MyCommand.Parameters.Add(new SqlParameter("@岗位工资", SqlDbType.Float));
MyCommand.Parameters.Add(new SqlParameter("@其他应增项", SqlDbType.Float));
MyCommand.Parameters.Add(new SqlParameter("@所得税", SqlDbType.Float));
MyCommand.Parameters.Add(new SqlParameter("@养老险", SqlDbType.Float));
MyCommand.Parameters.Add(new SqlParameter("@医疗险", SqlDbType.Float));
MyCommand.Parameters.Add(new SqlParameter("@住房基金", SqlDbType.Float));
MyCommand.Parameters.Add(new SqlParameter("@其他应减项", SqlDbType.Float));
MyCommand.Parameters.Add(new SqlParameter("@银行帐号", SqlDbType.VarChar));
MyCommand.Parameters.Add(new SqlParameter("@养老保险帐号", SqlDbType.VarChar));
MyCommand.Parameters.Add(new SqlParameter("@医疗保险帐号", SqlDbType.VarChar));
MyCommand.Parameters.Add(new SqlParameter("@住房基金帐号", SqlDbType.VarChar));
MyCommand.Parameters.Add(new SqlParameter("@身份证号码", SqlDbType.VarChar));
MyCommand.Parameters.Add(new SqlParameter("@发放年份", SqlDbType.Int));
MyCommand.Parameters.Add(new SqlParameter("@发放月份", SqlDbType.Int));
MyCommand.Parameters.Add(new SqlParameter("@说明", SqlDbType.VarChar));
MyCommand.Parameters["@自编号"].Value = My自编号;
MyCommand.Parameters["@员工编号"].Value = My员工编号;
MyCommand.Parameters["@员工姓名"].Value = MyRow[2].ToString();
MyCommand.Parameters["@基本工资"].Value = MyRow[3];
MyCommand.Parameters["@津贴"].Value = MyRow[4];
MyCommand.Parameters["@奖金"].Value = MyRow[5];
MyCommand.Parameters["@工龄工资"].Value = MyRow[6];
MyCommand.Parameters["@岗位工资"].Value = MyRow[7];
MyCommand.Parameters["@其他应增项"].Value = MyRow[8];
MyCommand.Parameters["@所得税"].Value = MyRow[9];
MyCommand.Parameters["@养老险"].Value = MyRow[10];
MyCommand.Parameters["@医疗险"].Value = MyRow[11];
MyCommand.Parameters["@住房基金"].Value = MyRow[12];
MyCommand.Parameters["@其他应减项"].Value = MyRow[13];
MyCommand.Parameters["@银行帐号"].Value = My银行帐号;
MyCommand.Parameters["@养老保险帐号"].Value = My养老保险帐号;
MyCommand.Parameters["@医疗保险帐号"].Value = My医疗保险帐号;
MyCommand.Parameters["@住房基金帐号"].Value = My住房基金帐号;
MyCommand.Parameters["@身份证号码"].Value = My身份证号码;
MyCommand.Parameters["@发放年份"].Value = My发放年份;
MyCommand.Parameters["@发放月份"].Value = My发放月份;
MyCommand.Parameters["@说明"].Value = MyRow[14];
MyCommand.ExecuteNonQuery();
}
if (MyConnection.State == ConnectionState.Open)
{
MyConnection.Close();
}
if(MyCount==0)
{
MyInfo = "发放" + My年份.ToString() + "年" + My月份.ToString() + "月" + this.部门ToolStripComboBox.Text + "员工的工资操作成功！";
MessageBox.Show(MyInfo,"信息提示",MessageBoxButtons.OK ,MessageBoxIcon.Information);
}
}
private string GetMy自编号()
{
String MySQLConnectionString = global::MyPersonnel.Properties.Settings.Default.MyPersonnelConnectionString;
SqlConnection MyConnection = new SqlConnection(MySQLConnectionString);
MyConnection.Open();
SqlCommand MyCommand = MyConnection.CreateCommand();
MyCommand.CommandText = "Select max(自编号) 最大编号 From 工资发放表";
object MyResult = MyCommand.ExecuteScalar();
Int64 MyID = 1;
if (MyResult != System.DBNull.Value)
{
String MyMaxID = MyResult.ToString().Trim();
MyMaxID = MyMaxID.Substring(2, MyMaxID.Length - 2);
MyID = Convert.ToInt64(MyMaxID) + 1;
}
int MyLength = MyID.ToString().Length;
string MyNewID = "";
switch (MyLength)
{
case 1:
MyNewID = "FF0000000" + MyID.ToString();
break;
case 2:
MyNewID = "FF000000" + MyID.ToString();
break;
case 3:
MyNewID = "FF00000" + MyID.ToString();
break;
case 4:
MyNewID = "FF0000" + MyID.ToString();
break;
case 5:
MyNewID = "FF000" + MyID.ToString();
break;
case 6:
MyNewID = "FF00" + MyID.ToString();
break;
case 7:
MyNewID = "FF0" + MyID.ToString();
break;
}
if (MyConnection.State == ConnectionState.Open)
{
MyConnection.Close();
}
return MyNewID;
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -