private void btnChangeActualmoney_Click(object sender, EventArgs e)
{
DAL.AcountCheckTempTableAdapters.ZZZ_DEPTTableAdapter depAD = new DAL.AcountCheckTempTableAdapters.ZZZ_DEPTTableAdapter();
DAL.AcountCheckTemp.ZZZ_DEPTDataTable depDT = new AcountCheckTemp.ZZZ_DEPTDataTable();
if (accErrTable == null || accErrTable.Rows.Count <= 0)
{
MessageBox.Show("无任何需要处理的数据");
return;
}
foreach (AcountCheckTemp.T_FB_BUDGETACCOUNTRow dr in accErrTable.Rows)
{
switch (dr.ACCOUNTOBJECTTYPE.ToString())
{
case "1"://公司
break;
case "2"://部门
//查出流水
//实际额度
string str = @"select sum(zzz.BUDGETMONEY) from ZZZ_DEPT zzz where zzz.OWNERCOMPANYID='" + dr.OWNERCOMPANYID +
"' and zzz.SUBJECTID='" + dr.SUBJECTID + "' and zzz.OWNERDEPARTMENTID='" + dr.OWNERDEPARTMENTID + "'"
+ "and zzz.CHECKSTATESNAME='审核通过'";
object Actualobj = dal.ExecuteCustomerSql(str);
//可用额度
string str2 = @"select sum(zzz.BUDGETMONEY) from ZZZ_DEPT zzz where zzz.OWNERCOMPANYID='" + dr.OWNERCOMPANYID +
"' and zzz.SUBJECTID='" + dr.SUBJECTID + "' and zzz.OWNERDEPARTMENTID='" + dr.OWNERDEPARTMENTID + "'"
+ "and zzz.CHECKSTATESNAME <> '审核中或未汇总'";
object Usableobj = dal.ExecuteCustomerSql(str);
decimal Actualmoney = 0;
if (Actualobj != null)
{
decimal.TryParse(Actualobj.ToString(), out Actualmoney);
}
decimal Usablemoney = 0;
if (Usableobj != null)
{
decimal.TryParse(Usableobj.ToString(), out Usablemoney);
}
string updateid = dr.BUDGETACCOUNTID;
string strUpdate = "update budgetaccount_temp20111021 t set t.actualmoney=" + Actualmoney
+ ", t.usablemoney=" + Usablemoney + " where t.budgetaccountid='" + updateid + "'";
object falg = dal.ExecuteCustomerSql(strUpdate);
break;
case "3"://个人
break;
}
}
MessageBox.Show("数据完毕");
}
private void BtnAcountIn_Click(object sender, EventArgs e)
{
DAL.AcountCheckTempTableAdapters.ZZZ_DEPTTableAdapter depAD = new DAL.AcountCheckTempTableAdapters.ZZZ_DEPTTableAdapter();
DAL.AcountCheckTemp.ZZZ_DEPTDataTable depDT = new AcountCheckTemp.ZZZ_DEPTDataTable();
if (dt == null || dt.Rows.Count <= 0)
{
MessageBox.Show("无任何需要处理的数据");
return;
}
foreach (AcountCheckTemp.ERRORACCOUT_DOUBLERow dr in dt.Rows)
{
switch (dr.ACCOUNTOBJECTTYPE.ToString())
{
case "1"://公司
break;
case "2"://部门
MergeDuplicateDepartFees(dr);
break;
case "3"://个人
MergeDuplicatePersonFees(dr);
break;
}
}
MessageBox.Show("处理完成！");
}
