public static EntityData GetV_DocumentByCode(string code)
{
EntityData data2;
try
{
DocumentStrategyBuilder builder = new DocumentStrategyBuilder();
builder.AddStrategy(new Strategy(DocumentStrategyName.DocumentCode, code));
string queryString = builder.BuildQueryViewString();
QueryAgent agent = new QueryAgent();
EntityData data = agent.FillEntityData("Document", queryString);
agent.Dispose();
data2 = data;
}
catch (Exception exception)
{
throw exception;
}
return(data2);
}
private void LoadDataGrid()
{
try
{
// string DocumentTypeCode = Request.QueryString["DocumentTypeCode"]+"";
DAL.QueryStrategy.DocumentStrategyBuilder sb = new DocumentStrategyBuilder();
// if (DocumentTypeCode != "")
// {
// sb.AddStrategy( new Strategy( DocumentStrategyName.DocumentTypeCodeFull ,DocumentTypeCode) );
// this.lblDocumentTypeName.Text = BLL.DocumentRule.Instance().GetDocumentTypeName(DocumentTypeCode);
// }
// else
// {
// this.lblDocumentTypeName.Text = "所有文档";
// }
if (this.txtGroupFullID.Value != "")
{
sb.AddStrategy(new Strategy(DocumentStrategyName.GroupFullIDs, this.txtGroupFullID.Value));
}
string title = this.txtSearchTitle.Value.Trim();
if (title.Length > 0)
{
sb.AddStrategy(new Strategy(DAL.QueryStrategy.DocumentStrategyName.Title, title));
}
//状态
ArrayList arStatus = new ArrayList();
if (this.chkStatus0.Checked)
{
arStatus.Add("0");
}
if (this.chkStatus1.Checked)
{
arStatus.Add("1");
}
string status = BLL.ConvertRule.GetArrayLinkString(arStatus);
if (status != "")
{
sb.AddStrategy(new Strategy(DocumentStrategyName.Status, status));
}
if (this.txtAdvSearch.Value != "none")
{
string CreateDate_begin = this.dtCreateDate_begin.Value.Trim();
string CreateDate_end = this.dtCreateDate_end.Value.Trim();
string ModifyDate_begin = this.dtModifyDate_begin.Value.Trim();
string ModifyDate_end = this.dtModifyDate_end.Value.Trim();
string DocumentID = this.txtSearchDocumentID.Value.Trim();
string author = this.txtSearchAuthor.Value.Trim();
string CreatePerson = this.ucCreatePerson.Value.Trim();
string ModifyPerson = this.ucModifyPerson.Value.Trim();
string FixedType = this.sltFixedType.Value.Trim();
string Code = this.txtCode.Value.Trim();
ArrayList ar = new ArrayList();
ar.Add(CreateDate_begin);
ar.Add(CreateDate_end);
ArrayList ar2 = new ArrayList();
ar2.Add(ModifyDate_begin);
ar2.Add(ModifyDate_end);
sb.AddStrategy(new Strategy(DAL.QueryStrategy.DocumentStrategyName.CreateDateRange, ar));
sb.AddStrategy(new Strategy(DAL.QueryStrategy.DocumentStrategyName.ModifyDateRange, ar2));
if (DocumentID.Length > 0)
{
sb.AddStrategy(new Strategy(DAL.QueryStrategy.DocumentStrategyName.DocumentID, "%" + DocumentID + "%"));
}
if (author.Length > 0)
{
sb.AddStrategy(new Strategy(DAL.QueryStrategy.DocumentStrategyName.Author, author));
}
if (CreatePerson.Length > 0)
{
sb.AddStrategy(new Strategy(DAL.QueryStrategy.DocumentStrategyName.CreatePerson, CreatePerson));
}
if (ModifyPerson.Length > 0)
{
sb.AddStrategy(new Strategy(DAL.QueryStrategy.DocumentStrategyName.ModifyPerson, ModifyPerson));
}
if (Code.Length > 0)
{
if (FixedType.Length > 0)
{
ArrayList arTmp = new ArrayList();
arTmp.Add(FixedType);
arTmp.Add(Code);
sb.AddStrategy(new Strategy(DAL.QueryStrategy.DocumentStrategyName.RelationKey, arTmp));
}
else
{
// ssb.AddStrategy( new Strategy(DAL.QueryStrategy.DocumentStrategyName.Code, Code));
}
}
}
//权限
ArrayList arA = new ArrayList();
arA.Add("100101");
arA.Add(user.UserCode);
arA.Add(user.BuildStationCodes());
sb.AddStrategy(new Strategy(DAL.QueryStrategy.DocumentStrategyName.AccessRange, arA));
//排序
string sortsql = BLL.GridSort.GetSortSQL(ViewState);
if (sortsql == "")
{
//缺省排序
sb.AddOrder("CreateDate", false);
}
string sql = sb.BuildQueryViewString();
if (sortsql != "")
{
//点列标题排序
sql = sql + " order by " + sortsql;
}
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("Document", sql);
qa.Dispose();
this.dgList.DataSource = entity.CurrentTable;
this.dgList.DataBind();
this.GridPagination1.RowsCount = entity.CurrentTable.Rows.Count.ToString();
entity.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(Rms.Web.JavaScript.Alert(true, "显示列表出错：" + ex.Message));
}
}