private void BuildSearchString()
{
string projectCode = Request["ProjectCode"] + "";
RmsPM.DAL.QueryStrategy.ContractStrategyBuilder CSB = new RmsPM.DAL.QueryStrategy.ContractStrategyBuilder();
string status = BLL.PageFacade.GetListGroupSelectedValues(this.cblStatus);
if (status != "")
{
CSB.AddStrategy(new Strategy(DAL.QueryStrategy.ContractStrategyName.Status, status));
}
if (projectCode != "") //材料库要选合同，不分项目 2006.11.2
{
CSB.AddStrategy(new Strategy(DAL.QueryStrategy.ContractStrategyName.ProjectCode, projectCode));
}
if (this.txtContractName.Value.Trim() != "")
{
CSB.AddStrategy(new Strategy(DAL.QueryStrategy.ContractStrategyName.ContractName, "%" + this.txtContractName.Value.Trim() + "%"));
}
if (this.txtContractID.Value.Trim() != "")
{
CSB.AddStrategy(new Strategy(DAL.QueryStrategy.ContractStrategyName.ContractID, "%" + this.txtContractID.Value.Trim() + "%"));
}
ArrayList arA = new ArrayList();
arA.Add("050101");
arA.Add(user.UserCode);
arA.Add(user.BuildStationCodes());
CSB.AddStrategy(new Strategy(DAL.QueryStrategy.ContractStrategyName.AccessRange, arA));
if (this.sltUnit.Value != "")
{
CSB.AddStrategy(new Strategy(DAL.QueryStrategy.ContractStrategyName.UnitCode, this.sltUnit.Value));
}
if (this.txtSupplierCode.Value != "")
{
CSB.AddStrategy(new Strategy(DAL.QueryStrategy.ContractStrategyName.SupplierCode, this.txtSupplierCode.Value));
}
if (this.inputSystemGroup.Value != "")
{
CSB.AddStrategy(new Strategy(DAL.QueryStrategy.ContractStrategyName.Type, this.inputSystemGroup.Value));
}
CSB.AddOrder("ContractDate", false);
string sql = CSB.BuildMainQueryString();
this.ViewState.Add("SearchString", sql);
}
private void LoadData()
{
try
{
string ContractCode = Request.QueryString["ContractCode"] + "";
string ContractLabel = "";
EntityData entity = DAL.EntityDAO.ContractDAO.GetContractByCode(ContractCode);
if (entity.HasRecord())
{
ContractLabel = entity.GetString("ContractLabel");
}
RmsPM.DAL.QueryStrategy.ContractStrategyBuilder CSB = new RmsPM.DAL.QueryStrategy.ContractStrategyBuilder();
//显示该合同所有的变更记录
CSB.AddStrategy(new Strategy(DAL.QueryStrategy.ContractStrategyName.NotOriginalContract));
// CSB.AddStrategy( new Strategy( DAL.QueryStrategy.ContractStrategyName.Status,"6"));
CSB.AddStrategy(new Strategy(DAL.QueryStrategy.ContractStrategyName.ContractLabel, ContractLabel));
string sql = CSB.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
EntityData entityTemp = qa.FillEntityData("Contract", sql);
qa.Dispose();
this.dgList.DataSource = entityTemp.CurrentTable;
this.dgList.DataBind();
entity.Dispose();
entityTemp.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "加载合同列表错误。");
}
}