/// <summary> /// 显示列表 /// </summary> private void LoadDataGrid() { this.lblMessage.Text = ""; try { string VoucherID = this.txtSearchVoucherID.Value.Trim(); VoucherStrategyBuilder sb = new VoucherStrategyBuilder(); sb.AddStrategy(new Strategy(VoucherStrategyName.ProjectCode, this.txtProjectCode.Value)); if (VoucherID.Length > 0) { sb.AddStrategy(new Strategy(DAL.QueryStrategy.VoucherStrategyName.VoucherID, VoucherID)); } if (this.sltSearchVoucherType.Value != "") { sb.AddStrategy(new Strategy(VoucherStrategyName.VoucherType, this.sltSearchVoucherType.Value)); } sb.AddOrder("VoucherID", true); string sql = sb.BuildQueryViewString(); Rms.ORMap.QueryAgent qa = new QueryAgent(); EntityData entity = qa.FillEntityData("Voucher", sql); this.dgList.DataSource = entity.CurrentTable; this.dgList.DataBind(); entity.Dispose(); qa.Dispose(); } catch (Exception ex) { this.lblMessage.Text = "选择凭证查询出错"; ApplicationLog.WriteLog(this.ToString(), ex, "选择凭证查询出错"); } }
private void LoadDataGrid() { try { VoucherStrategyBuilder sb = new VoucherStrategyBuilder(); sb.AddStrategy(new Strategy(VoucherStrategyName.ProjectCode, txtProjectCode.Value)); if (this.ucAccountant.Value != "") { sb.AddStrategy(new Strategy(VoucherStrategyName.Accountant, this.ucAccountant.Value)); } if (this.dtbMakeDate0.Value != "" || this.dtbMakeDate1.Value != "") { ArrayList ar = new ArrayList(); ar.Add(this.dtbMakeDate0.Value); ar.Add(this.dtbMakeDate1.Value); sb.AddStrategy(new Strategy(VoucherStrategyName.MakeDate, ar)); } if (this.sltVoucherType.Value != "") { sb.AddStrategy(new Strategy(VoucherStrategyName.VoucherType, this.sltVoucherType.Value)); } if (this.txtVoucherID.Value != "") { sb.AddStrategy(new Strategy(VoucherStrategyName.VoucherID, this.txtVoucherID.Value)); } ArrayList arStatus = new ArrayList(); if (this.chkStatus0.Checked) { arStatus.Add("0"); } if (this.chkStatus1.Checked) { arStatus.Add("1"); } if (this.chkStatus2.Checked) { arStatus.Add("2"); } string status = BLL.ConvertRule.GetArrayLinkString(arStatus); if (status != "") { sb.AddStrategy(new Strategy(VoucherStrategyName.Status, status)); } // if ( this.sltIsExported.Value != "" ) // sb.AddStrategy( new Strategy( VoucherStrategyName.IsExported,this.sltIsExported.Value )); sb.AddOrder("MakeDate", false); sb.AddOrder("VoucherCode", false); string sql = sb.BuildQueryViewString(); QueryAgent qa = new QueryAgent(); EntityData entity = qa.FillEntityData("Voucher", sql); qa.Dispose(); string[] arrField = { "TotalMoney" }; decimal[] arrSum = BLL.MathRule.SumColumn(entity.CurrentTable, arrField); this.dgList.Columns[3].FooterText = arrSum[0].ToString("N"); this.dgList.DataSource = entity.CurrentTable; this.dgList.DataBind(); entity.Dispose(); } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, ""); Response.Write(Rms.Web.JavaScript.Alert(true, "显示列表出错:" + ex.Message)); } }