private void btnGetActualmoney_Click(object sender, EventArgs e) { DAL.AcountCheckTempTableAdapters.T_FB_BUDGETACCOUNTTableAdapter ad = new DAL.AcountCheckTempTableAdapters.T_FB_BUDGETACCOUNTTableAdapter(); AcountCheckTemp.T_FB_BUDGETACCOUNTDataTable accTable = new AcountCheckTemp.T_FB_BUDGETACCOUNTDataTable(); ad.Fill(accTable); List<AcountCheckTemp.T_FB_BUDGETACCOUNTRow> rowTemps = accTable.Where(t => t.USABLEMONEY > t.ACTUALMONEY).ToList(); if (rowTemps.Count == 0) { MessageBox.Show("无记录"); return; } foreach (AcountCheckTemp.T_FB_BUDGETACCOUNTRow item in rowTemps) { AcountCheckTemp.T_FB_BUDGETACCOUNTRow rowTemp = accErrTable.NewT_FB_BUDGETACCOUNTRow(); rowTemp.BUDGETACCOUNTID = item.BUDGETACCOUNTID; rowTemp.BUDGETYEAR = item.BUDGETYEAR; rowTemp.BUDGETMONTH = item.BUDGETMONTH; rowTemp.ACCOUNTOBJECTTYPE = item.ACCOUNTOBJECTTYPE; rowTemp.SUBJECTID = item.SUBJECTID; rowTemp.BUDGETMONEY = item.BUDGETMONEY; rowTemp.USABLEMONEY = item.USABLEMONEY; rowTemp.ACTUALMONEY = item.ACTUALMONEY; rowTemp.PAIEDMONEY = item.PAIEDMONEY; rowTemp.OWNERCOMPANYID = item.OWNERCOMPANYID; rowTemp.OWNERDEPARTMENTID = item.OWNERDEPARTMENTID; rowTemp.OWNERPOSTID = item.OWNERPOSTID; rowTemp.OWNERID = item.OWNERID; rowTemp.CREATEUSERID = item.CREATEUSERID; rowTemp.CREATEDATE = item.CREATEDATE; rowTemp.UPDATEUSERID = item.UPDATEUSERID; rowTemp.UPDATEDATE = item.UPDATEDATE; accErrTable.Rows.Add(rowTemp); } dataGridView3.DataSource = accErrTable; }
private void btnSelectErrData_Click(object sender, EventArgs e) { AcountCheckTemp.T_FB_BUDGETACCOUNTDataTable dtAcount = new AcountCheckTemp.T_FB_BUDGETACCOUNTDataTable(); DAL.AcountCheckTempTableAdapters.T_FB_BUDGETACCOUNTTableAdapter Adacount = new DAL.AcountCheckTempTableAdapters.T_FB_BUDGETACCOUNTTableAdapter(); Adacount.Fill(dtAcount); //AcountCheckTemp.ACCOUNTDDataTable dtAcount = new AcountCheckTemp.ACCOUNTDDataTable(); //if (dtAcount.Rows.Count <= 0) //{ // DAL.AcountCheckTempTableAdapters.ACCOUNTDTableAdapter AdacountAd = new DAL.AcountCheckTempTableAdapters.ACCOUNTDTableAdapter(); // AdacountAd.Fill(dtAcount); //} // string strCompanys = string.Empty; for (int i = 0; i < dataGridCompany.Rows.Count; i++) { if (dataGridCompany.Rows[i].Cells["CheckColumn"].Value != null) { if ((bool)dataGridCompany.Rows[i].Cells["CheckColumn"].Value) { strCompanys += "'" + dataGridCompany.Rows[i].Cells[2].Value.ToString() + "'"+ ","; } } } string strFilter = "USABLEMONEY < 0"; if(!string.IsNullOrEmpty(strCompanys)) { strCompanys=strCompanys.Substring(0, strCompanys.Length - 1); strFilter += "and ACCOUNTOBJECTTYPE = "+intAccountType+" and OWNERCOMPANYID in(" + strCompanys + ")"; } //DataRow[] rows= dtAcount.Select(strFilter); dataGridErrAcData.DataSource = dtAcount.Select(strFilter); }