public static EntityData GetLastConstructProgressReport(string PBSUnitCode, string EndDate, int n)
{
EntityData data2;
try
{
ConstructProgressStrategyBuilder builder = new ConstructProgressStrategyBuilder();
builder.AddStrategy(new Strategy(ConstructProgressStrategyName.PBSUnitCode, PBSUnitCode));
ArrayList pas = new ArrayList();
pas.Add("");
pas.Add(EndDate);
builder.AddStrategy(new Strategy(ConstructProgressStrategyName.ReportDateRange, pas));
builder.AddOrder("ReportDate", false);
builder.AddOrder("ProgressCode", false);
string queryString = builder.BuildQueryViewString();
QueryAgent agent = new QueryAgent();
agent.SetTopNumber(n);
EntityData data = agent.FillEntityData("ConstructProgress", queryString);
agent.Dispose();
data2 = data;
}
catch (Exception exception)
{
throw exception;
}
return(data2);
}
public static EntityData GetConstructProgressReportFirstKg(string PBSUnitCode)
{
EntityData data2;
try
{
string visualProgressNotStartInStr = PBSRule.GetVisualProgressNotStartInStr();
ConstructProgressStrategyBuilder builder = new ConstructProgressStrategyBuilder();
builder.AddStrategy(new Strategy(ConstructProgressStrategyName.PBSUnitCode, PBSUnitCode));
builder.AddStrategy(new Strategy(ConstructProgressStrategyName.VisualProgressNotIn, visualProgressNotStartInStr));
builder.AddOrder("ReportDate", true);
builder.AddOrder("ProgressCode", true);
string queryString = builder.BuildQueryViewString();
QueryAgent agent = new QueryAgent();
agent.SetTopNumber(1);
EntityData data = agent.FillEntityData("ConstructProgress", queryString);
agent.Dispose();
data2 = data;
}
catch (Exception exception)
{
throw exception;
}
return(data2);
}
public static EntityData GetV_ConstructProgressByPBSUnit(string PBSUnitCode)
{
EntityData data2;
try
{
ConstructProgressStrategyBuilder builder = new ConstructProgressStrategyBuilder();
builder.AddStrategy(new Strategy(ConstructProgressStrategyName.PBSUnitCode, PBSUnitCode));
builder.AddOrder("ReportDate", true);
builder.AddOrder("ProgressCode", true);
string queryString = builder.BuildQueryViewString();
QueryAgent agent = new QueryAgent();
EntityData data = agent.FillEntityData("ConstructProgress", queryString);
agent.Dispose();
data2 = data;
}
catch (Exception exception)
{
throw exception;
}
return(data2);
}
public static EntityData GetLastConstructProgressReportByVisualProgress(string PBSUnitCode, string VisualProgress)
{
EntityData data2;
try
{
ConstructProgressStrategyBuilder builder = new ConstructProgressStrategyBuilder();
builder.AddStrategy(new Strategy(ConstructProgressStrategyName.PBSUnitCode, PBSUnitCode));
builder.AddStrategy(new Strategy(ConstructProgressStrategyName.VisualProgress, VisualProgress));
builder.AddOrder("ReportDate", false);
builder.AddOrder("ProgressCode", false);
string queryString = builder.BuildQueryViewString();
QueryAgent agent = new QueryAgent();
agent.SetTopNumber(1);
EntityData data = agent.FillEntityData("ConstructProgress", queryString);
agent.Dispose();
data2 = data;
}
catch (Exception exception)
{
throw exception;
}
return(data2);
}
private void LoadDataGrid()
{
try
{
string PBSUnitCode = this.sltSearchPBSUnitCode.Value.Trim();
ConstructProgressStrategyBuilder sb = new ConstructProgressStrategyBuilder();
sb.AddStrategy(new Strategy(ConstructProgressStrategyName.ProjectCode, this.txtProjectCode.Value));
if (PBSUnitCode.Length > 0)
{
sb.AddStrategy(new Strategy(ConstructProgressStrategyName.PBSUnitCode, PBSUnitCode));
}
if (this.dtSearchReportDateBegin.Value != "" || this.dtSearchReportDateEnd.Value != "")
{
ArrayList ar = new ArrayList();
ar.Add(this.dtSearchReportDateBegin.Value);
ar.Add(this.dtSearchReportDateEnd.Value);
sb.AddStrategy(new Strategy(ConstructProgressStrategyName.ReportDateRange, ar));
}
if (this.txtReportPerson.Value != "")
{
sb.AddStrategy(new Strategy(ConstructProgressStrategyName.ReportPerson, this.txtReportPerson.Value));
}
if (this.sltSearchVisualProgress.Value != "")
{
sb.AddStrategy(new Strategy(ConstructProgressStrategyName.VisualProgress, this.sltSearchVisualProgress.Value));
}
if (this.txtSearchContent.Value != "")
{
sb.AddStrategy(new Strategy(ConstructProgressStrategyName.Content, this.txtSearchContent.Value));
}
if (this.txtSearchRiskRemark.Value != "")
{
sb.AddStrategy(new Strategy(ConstructProgressStrategyName.RiskRemark, this.txtSearchRiskRemark.Value));
}
//排序
string sortsql = BLL.GridSort.GetSortSQL(ViewState);
if (sortsql == "")
{
//缺省排序
sb.AddOrder("ReportDate", false);
sb.AddOrder("ProgressCode", false);
}
string sql = sb.BuildQueryViewString();
if (sortsql != "")
{
//点列标题排序
sql = sql + " order by " + sortsql;
}
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("ConstructProgress", sql);
qa.Dispose();
// EntityData entity = DAL.EntityDAO.ConstructDAO.GetConstructProgressByPBSUnit(PBSUnitCode);
this.dgList.DataSource = entity;
this.dgList.DataBind();
entity.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(Rms.Web.JavaScript.Alert(true, "初始化页面出错：" + ex.Message));
}
}