private void btnBoss_Browse_Click(object sender, EventArgs e)
{
string time = "";
string sql = "";
string year = "";
string month = "";
string sql_0 = String.Format("select count(*) from t_employee where eno ='{0}'", Eno);
int count_0 = (int)DAO.ExecuteScalar(sql_0);
if (count_0 <= 0)
{
dgvPersonalSalary.Columns.Clear();
MessageBox.Show("请输入正确的编号！");
return;
}
else
{
if (level == 0)//按年
{
if (cmbYear.SelectedIndex == -1)
{
dgvPersonalSalary.Columns.Clear();
MessageBox.Show("请选择时间！");
return;
}
else
{
year = this.cmbYear.SelectedItem.ToString().Trim();
time += year;
}
}
else
{
if (cmbMonth.SelectedIndex == -1 || cmbYear.SelectedIndex == -1)
{
dgvPersonalSalary.Columns.Clear();
MessageBox.Show("请选择时间！");
return;
}
else
{
year = this.cmbYear.SelectedItem.ToString().Trim();
month = this.cmbMonth.SelectedItem.ToString().Trim();
time = year + "-" + month;
}
}
string sql_1 = String.Format("select count(*) from t_salary where eno='{0}' and CONVERT(varchar(20), EnterTime, 120) like '{1}%'", Eno, time);
int count_1 = (int)DAO.ExecuteScalar(sql_1);
if (count_1 <= 0)
{
dgvPersonalSalary.Columns.Clear();
MessageBox.Show("该时间没有数据！！");
return;
}
else
{
sql = String.Format("select sum(LevelSalary) as 基本工资, SUM(OvertimeWork) as 加班工资, SUM(BenifitSum) as 补贴, SUM(AllowanceSum) as 津贴, SUM(Awd_PunSum) as 奖惩总额, SUM(AllSum) as 总工资 from t_salary where eno='{0}' and CONVERT(varchar(20), EnterTime, 120) like '{1}%'", Eno, time);
DataTable dt = DAO.GetTable(sql);
InitialDataGridView(dgvPersonalSalary, dt);
}
}
}
private void btnBrowse_Click(object sender, EventArgs e)
{
string[] salary = new string[6];
string time = "";
string sql = String.Format("select deptno from t_employee where eno='{0}'", Eno);
deptno = int.Parse(DAO.ExecuteScalar(sql).ToString());
if (level == 0)//按年
{
if (cmbYear.SelectedIndex == -1)
{
dataGridView1.Columns.Clear();
pnlDepartment.Visible = false;
MessageBox.Show("请选择时间！");
return;
}
else
{
time = cmbYear.SelectedItem.ToString();
string sql_0 = String.Format("select COUNT(*) from t_Salary a, t_Employee b where a.Eno=b.Eno and DeptNo=(select DeptNo from t_Employee where Eno='{0}') and CONVERT(varchar(20), EnterTime, 120) like '{1}%'", Eno, time);
int count_0 = (int)DAO.ExecuteScalar(sql_0);
if (count_0 <= 0)
{
dataGridView1.Columns.Clear();
MessageBox.Show("该时间没有数据！");
return;
}
else
{
string sql_1 = String.Format("select sum(LevelSalary) as 基本工资, SUM(OvertimeWork) as 加班工资, SUM(BenifitSum) as 补贴, SUM(AllowanceSum) as 津贴, SUM(Awd_PunSum) as 奖惩总额, SUM(AllSum) as 总工资 from t_Salary a, t_Employee b where a.Eno=b.Eno and CONVERT(varchar(20), EnterTime, 120) like '{0}%' and DeptNo=(select DeptNo from t_Employee where Eno='{1}')", time, Eno);
DataTable dt = DAO.GetTable(sql_1);
DataRow dr = dt.Rows[0];
for (int i = 0; i < 6; i++)
{
salary[i] = dr[i].ToString();
}
txtBasicSal.Text = salary[0];
txtOverWork.Text = salary[1];
txtBenifit.Text = salary[2];
txtAllwance.Text = salary[3];
txtAwd_Pun.Text = salary[4];
txtAllSum.Text = salary[5];
string sql_2 = String.Format("select LevelSalary as 基本工资, OvertimeWork as 加班工资, BenifitSum as 补贴, AllowanceSum as 津贴, Awd_PunSum as 奖惩总额, AllSum as 总工资 from t_Salary a, t_Employee b where a.Eno=b.Eno and CONVERT(varchar(20), EnterTime, 120) like '{0}%' and DeptNo=(select DeptNo from t_Employee where Eno='{1}')", time, Eno);
DataTable dt_2 = DAO.GetTable(sql_2);
InitialDataGridView(dataGridView1, dt_2);
pnlDepartment.Visible = true;
cmbDepartment.SelectedIndex = deptno - 1;
}
}
}
else//按月
{
if (cmbYear.SelectedIndex == -1 && cmbMonth.SelectedIndex == -1)
{
dataGridView1.Columns.Clear();
pnlDepartment.Visible = false;
MessageBox.Show("请选择时间！");
return;
}
else
{
time = cmbYear.SelectedItem.ToString().Trim() + "-" + cmbMonth.SelectedItem.ToString().Trim();
string sql_0 = String.Format("select COUNT(*) from t_Salary a, t_Employee b where a.Eno=b.Eno and DeptNo=(select DeptNo from t_Employee where Eno='{0}') and CONVERT(varchar(20), EnterTime, 120) like '{1}%'", Eno, time);
int count_0 = (int)DAO.ExecuteScalar(sql_0);
if (count_0 <= 0)
{
dataGridView1.Columns.Clear();
MessageBox.Show("该时间没有数据！");
return;
}
else
{
string sql_1 = String.Format("select sum(LevelSalary) as 基本工资, SUM(OvertimeWork) as 加班工资, SUM(BenifitSum) as 补贴, SUM(AllowanceSum) as 津贴, SUM(Awd_PunSum) as 奖惩总额, SUM(AllSum) as 总工资 from t_Salary a, t_Employee b where a.Eno=b.Eno and CONVERT(varchar(20), EnterTime, 120) like '{0}%' and DeptNo=(select DeptNo from t_Employee where Eno='{1}')", time, Eno);
DataTable dt = DAO.GetTable(sql_1);
DataRow dr = dt.Rows[0];
for (int i = 0; i < 6; i++)
{
salary[i] = dr[i].ToString();
}
txtBasicSal.Text = salary[0];
txtOverWork.Text = salary[1];
txtBenifit.Text = salary[2];
txtAllwance.Text = salary[3];
txtAwd_Pun.Text = salary[4];
txtAllSum.Text = salary[5];
string sql_2 = String.Format("select LevelSalary as 基本工资, OvertimeWork as 加班工资, BenifitSum as 补贴, AllowanceSum as 津贴, Awd_PunSum as 奖惩总额, AllSum as 总工资 from t_Salary a, t_Employee b where a.Eno=b.Eno and CONVERT(varchar(20), EnterTime, 120) like '{0}%' and DeptNo=(select DeptNo from t_Employee where Eno='{1}')", time, Eno);
DataTable dt_2 = DAO.GetTable(sql_2);
InitialDataGridView(dataGridView1, dt_2);
pnlDepartment.Visible = true;
cmbDepartment.SelectedIndex = deptno - 1;
}
}
}
}
private void LoadData(string time, GroupBox gpb)
{
int deptno = int.Parse(gpb.Tag.ToString());
string[] salary = new string[6];
string sql_1 = String.Format("select sum(LevelSalary) as 基本工资, SUM(OvertimeWork) as 加班工资, SUM(BenifitSum) as 补贴, SUM(AllowanceSum) as 津贴, SUM(Awd_PunSum) as 奖惩总额, SUM(AllSum) as 总工资 from t_Salary a, t_Employee b where a.Eno=b.Eno and CONVERT(varchar(20), EnterTime, 120) like '{0}%' and DeptNo='{1}'", time, deptno);
DataTable dt_1 = DAO.GetTable(sql_1);
DataRow dr_1 = dt_1.Rows[0];
for (int i = 0; i < 6; i++)
{
salary[i] = dr_1[i].ToString();
}
if (deptno == 1)
{
this.txtRS_BasicSal.Text = salary[0];
txtRS_OverWork.Text = salary[1];
txtRS_Benifit.Text = salary[2];
txtRS_Allwance.Text = salary[3];
txtRS_Awd_Pun.Text = salary[4];
txtRS_AllSum.Text = salary[5];
}
else if (deptno == 2)
{
txtSC_BasicSal.Text = salary[0];
txtSC_OverWork.Text = salary[1];
txtSC_Benifit.Text = salary[2];
txtSC_Allwance.Text = salary[3];
txtSC_Awd_Pun.Text = salary[4];
txtSC_AllSum.Text = salary[5];
}
else
{
txtCW_BasicSal.Text = salary[0];
txtCW_OverWork.Text = salary[1];
txtCW_BasicSal.Text = salary[2];
txtCW_Allwance.Text = salary[3];
txtCW_Awd_Pun.Text = salary[4];
txtCW_AllSum.Text = salary[5];
}
string sql_2 = String.Format("select a.Eno as 编号, b.EName as 姓名, LevelSalary as 基本工资, OvertimeWork as 加班工资, BenifitSum as 补贴, AllowanceSum as 津贴, Awd_PunSum as 奖惩总额, AllSum as 总工资 from t_Salary a, t_Employee b where a.Eno=b.Eno and CONVERT(varchar(20), EnterTime, 120) like '{0}%' and DeptNo='{1}'", time, deptno);
DataTable dt_2 = DAO.GetTable(sql_2);
foreach (Control c in gpb.Controls)
{
if (c is DataGridView)
{
DataGridView dgv = (DataGridView)c;
InitialDataGridView(dgv, dt_2);
}
}
foreach (Control c in gpb.Controls)
{
if (c is TextBox)
{
if (c.Text == "")
{
c.Text = "0";
}
}
}
}