private void LoadDataGrid()
{
try
{
SalSuplStrategyBuilder sb = new SalSuplStrategyBuilder();
string ProjectCode = this.sltSearchProject.Value.Trim();
if (ProjectCode != "")
{
sb.AddStrategy(new Strategy(SalSuplStrategyName.ProjectCode, ProjectCode));
}
string SuplCode = this.txtSearchSuplCode.Value.Trim();
if (SuplCode != "")
{
sb.AddStrategy(new Strategy(SalSuplStrategyName.SuplCode, SuplCode));
}
string SuplName = this.txtSearchSuplName.Value.Trim();
if (SuplName != "")
{
sb.AddStrategy(new Strategy(SalSuplStrategyName.SuplName, SuplName));
}
sb.AddOrder("SuplCode", true);
string sql = sb.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("SalSupl", sql);
qa.Dispose();
// EntityData entity = DAL.EntityDAO.SalDAO.GetSalSuplByProjectCode(this.txtProjectCode.Value);
dgList.DataSource = entity;
dgList.DataBind();
entity.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(Rms.Web.JavaScript.Alert(true, "显示列表出错：" + ex.Message));
}
}
private void LoadDataGrid(bool isEmpty)
{
try
{
DataTable tb;
if (this.rbType.SelectedValue == "0")
{
SalSuplStrategyBuilder sb = new SalSuplStrategyBuilder();
if (isEmpty)
{
sb.AddStrategy(new Strategy(SalSuplStrategyName.False));
}
string SuplName = this.txtSearchSuplName.Value.Trim();
if (SuplName != "")
{
sb.AddStrategy(new Strategy(SalSuplStrategyName.SuplName, SuplName));
}
sb.AddOrder("SuplName", true);
string sql = sb.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("SalSupl", sql);
tb = entity.CurrentTable;
qa.Dispose();
entity.Dispose();
}
else
{
SupplierStrategyBuilder sb = new SupplierStrategyBuilder();
if (isEmpty)
{
sb.AddStrategy(new Strategy(SupplierStrategyName.False));
}
string SuplName = this.txtSearchSuplName.Value.Trim();
if (SuplName != "")
{
sb.AddStrategy(new Strategy(SupplierStrategyName.SupplierName, SuplName));
}
sb.AddOrder("SupplierName", true);
string sql = sb.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("Supplier", sql);
tb = entity.CurrentTable;
qa.Dispose();
entity.Dispose();
}
dgList.DataSource = tb;
dgList.DataBind();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
}
}