private void ReFreshLiuShui(int rowindex)
{
try
{
DataTable dt = new DataTable();
string strLiuShui = string.Empty;
if (intAccountType <= 0) return;
switch (intAccountType)
{
case 1:
strLiuShui = @"公司级别 暂无";
break;
case 2://部门
strLiuShui = @"select * from zzz_dept t
where t.OWNERCOMPANYID ='" + dataGridErrAcData.Rows[rowindex].Cells["OWNERCOMPANYID"].Value.ToString()
+ "' and t.OWNERDEPARTMENTID='" + dataGridErrAcData.Rows[rowindex].Cells["OWNERDEPARTMENTID"].Value.ToString()
+ "' and t.SUBJECTID='" + dataGridErrAcData.Rows[rowindex].Cells["SUBJECTID"].Value.ToString() + "'"
+ " order by t.Updatedate";
break;
case 3://个人
strLiuShui = @"select * from zzz_person t
where t.OWNERCOMPANYID ='" + dataGridErrAcData.Rows[rowindex].Cells["OWNERCOMPANYID"].Value.ToString()
+ "' and t.OWNERID='" + dataGridErrAcData.Rows[rowindex].Cells["OWNERID"].Value.ToString()
+ "' and t.SUBJECTID='" + dataGridErrAcData.Rows[rowindex].Cells["SUBJECTID"].Value.ToString() + "'"
+ " order by t.Updatedate";
break;
}
dt = (DataTable)dal.GetDataTable(strLiuShui);
dataGridSequence.DataSource = dt;
decimal money = 0;
foreach (DataRow dr in dt.Rows)
{
if (dr["ORDERTYPENAME"].ToString() == "还款单"
&& dr["CHECKSTATESNAME"].ToString() == "审核中")
{
}
else if (dr["CHECKSTATESNAME"].ToString() == "审核中或未汇总")
{
}
else
{
money += decimal.Parse(dr["BUDGETMONEY"].ToString());
}
}
txtMoneyReslut.Text = money.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void btbSelect_Click(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
string strLiuShui = string.Empty;
if (intAccountType <= 0) return;
switch (intAccountType)
{
case 1:
strLiuShui = @"公司级别 暂无";
break;
case 2://部门
strLiuShui = @"select * from zzz_dept t
where t.OWNERCOMPANYNAME ='" +txtCompany.Text
+ "' and t.OWNERDEPARTMENTNAME='" +txtDepartment.Text
+ "' and t.SUBJECTNAME='" +txtSubject.Text
+ "' order by t.Updatedate";
break;
case 3://个人
strLiuShui = @"select * from zzz_person t
where t.OWNERCOMPANYNAME ='" + txtCompany.Text
+ "' and t.OWNERNAME='" + txtPerson.Text
+ "' and t.SUBJECTNAME='" + txtSubject.Text
+ "' order by t.Updatedate";
break;
}
dt = (DataTable)dal.GetDataTable(strLiuShui);
dataGridSequence.DataSource = dt;
decimal money = 0;
foreach (DataRow dr in dt.Rows)
{
if (dr["ORDERTYPENAME"].ToString() == "还款单"
&& dr["CHECKSTATESNAME"].ToString() == "审核中")
{
}
else if (dr["CHECKSTATESNAME"].ToString() == "审核中或未汇总")
{
}
else
{
money += decimal.Parse(dr["BUDGETMONEY"].ToString());
}
}
txtMoneyReslut.Text = money.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void btnCompany_Click(object sender, EventArgs e)
{
try
{
int i = cmbAcountType.SelectedIndex;
if (i <= 0) return;
this.intAccountType = i;
DataTable dt = new DataTable();
string str = "select c.cname,c.companyid from smthrm.t_hr_company c order by c.cname ";
dt = (DataTable)dal.GetDataTable(str);
dataGridCompany.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
