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("处理完成!"); }