private EntityData GetEntityData()
{
SupplierSubjectSetStrategyBuilder sb = new SupplierSubjectSetStrategyBuilder();
sb.AddStrategy(new Strategy(SupplierSubjectSetStrategyName.SupplierCode, txtSupplierCode.Value));
if (this.txtIsGroup.Value == "1")
{
sb.AddStrategy(new Strategy(SupplierSubjectSetStrategyName.ProjectCode, ""));
}
else
{
if (this.txtProjectCode.Value != "")
{
sb.AddStrategy(new Strategy(SupplierSubjectSetStrategyName.ProjectCode, this.txtProjectCode.Value));
}
}
if (this.txtSubjectSetCode.Value != "")
{
sb.AddStrategy(new Strategy(SupplierSubjectSetStrategyName.SubjectSetCode, this.txtSubjectSetCode.Value));
}
string sql = sb.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("SupplierSubjectSet", sql);
qa.Dispose();
return(entity);
}
public static EntityData GetSupplierSubjectSetBySupplier(string SupplierCode, string ProjectCode, string SubjectSetCode)
{
EntityData data2;
try
{
SupplierSubjectSetStrategyBuilder builder = new SupplierSubjectSetStrategyBuilder();
builder.AddStrategy(new Strategy(SupplierSubjectSetStrategyName.SupplierCode, SupplierCode));
builder.AddStrategy(new Strategy(SupplierSubjectSetStrategyName.ProjectCode, ProjectCode));
builder.AddStrategy(new Strategy(SupplierSubjectSetStrategyName.SubjectSetCode, SubjectSetCode));
string queryString = builder.BuildMainQueryString();
QueryAgent agent = new QueryAgent();
EntityData data = agent.FillEntityData("SupplierSubjectSet", queryString);
agent.Dispose();
data2 = data;
}
catch (Exception exception)
{
throw exception;
}
return(data2);
}
private void LoadDataGrid()
{
try
{
SupplierSubjectSetStrategyBuilder sb = new SupplierSubjectSetStrategyBuilder();
sb.AddStrategy(new Strategy(SupplierSubjectSetStrategyName.SubjectSetCode, txtSubjectSetCode.Value));
if (this.txtSupplierName.Value != "")
{
sb.AddStrategy(new Strategy(SupplierSubjectSetStrategyName.SupplierName, "%" + txtSupplierName.Value + "%"));
}
if (this.sltProject.Value != "")
{
if (this.sltProject.Value.ToLower() == "group")
{
sb.AddStrategy(new Strategy(SupplierSubjectSetStrategyName.ProjectCode, ""));
}
else
{
sb.AddStrategy(new Strategy(SupplierSubjectSetStrategyName.ProjectCode, this.sltProject.Value));
}
}
else
{
if (BLL.ConvertRule.ToString(ViewState["FinanceInterfaceSupplierCode"]).ToUpper() != "ByGroup".ToUpper())
{
sb.AddStrategy(new Strategy(SupplierSubjectSetStrategyName.ProjectNotNull));
}
}
if (this.txtU8Code.Value != "")
{
sb.AddStrategy(new Strategy(SupplierSubjectSetStrategyName.U8Code, "%" + this.txtU8Code.Value + "%"));
}
//排序
string sortsql = BLL.GridSort.GetSortSQL(ViewState);
if (sortsql == "")
{
//缺省排序
// sb.AddOrder( "SupplierName", true);
// sb.AddOrder( "ProjectName", true);
}
string sql = sb.BuildQueryViewString();
if (sortsql != "")
{
//点列标题排序
sql = sql + " order by " + sortsql;
}
QueryAgent qa = new QueryAgent();
DataTable tb = qa.ExecSqlForDataSet(sql).Tables[0];
qa.Dispose();
this.dgList.DataSource = tb;
this.dgList.DataBind();
this.GridPagination1.RowsCount = tb.Rows.Count.ToString();
tb.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(Rms.Web.JavaScript.Alert(true, "显示出错：" + ex.Message));
}
}
