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()); } }