/// <summary>
/// 绑定数据
/// </summary>
/// <param name="pageIndex"></param>
public void BindGrid(int pageIndex)
{
//从窗口接收开始,都是馆里人员操作,不用考虑建设单位等身份
string strWhere = " AND A.SingleProjectID=" + Common.DNTRequest.GetQueryString("SingleProjectID");
if (PublicModel.isSuperAdmin())
{//管理员管理员获取所有工程
strWhere += " AND D.AREA_CODE LIKE '" + Common.Session.GetSession("AREA_CODE") + "%'";
}
else if (PublicModel.isArchiveUser())
{//档案馆用户看自己的
strWhere += " AND D.AREA_CODE LIKE '" + Common.Session.GetSession("OLD_AREA_CODE") + "%'";
}
if (ViewState["CurrentPageIndex"] == null && Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")) > 0)
{
pageIndex = Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex"));
ViewState["CurrentPageIndex"] = pageIndex;
}
else
{
pageIndex = ConvertEx.ToInt(ViewState["CurrentPageIndex"]);
}
DataTable dt = trBll.GetListPaging(strWhere, pageSize, pageIndex, out itemCount, null);;
AspNetPager.AlwaysShow = true;
AspNetPager.PageSize = pageSize;
AspNetPager.RecordCount = itemCount;
AspNetPager.CurrentPageIndex = pageIndex;
rpData.DataSource = dt;
rpData.DataBind();
}
/// <summary>
/// 绑定数据
/// </summary>
/// <param name="pageIndex"></param>
public void BindGrid(int pageIndex)
{
//工程状态必须走到了 整理接收 且没有入库 !=3722 才可以做补卷管理
string strWhere = " AND D.WorkFlow_DoStatus >=(select WorkFlowID from T_WorkFlow where LOWER(WorkFlowCode)='" +
SystemSet.EumWorkFlowCode.WINRECV.ToString().ToLower() + "') and d.Status!=3722 ";
if (PublicModel.isSuperAdmin()) //管理员管理员获取所有工程
{
strWhere += " AND D.AREA_CODE LIKE '" + Common.Session.GetSession("AREA_CODE") + "%'";
}
else if (PublicModel.isArchiveUser()) //档案馆用户看自己的
{
strWhere += " AND D.AREA_CODE LIKE '" + Common.Session.GetSession("OLD_AREA_CODE") + "%'";
}
else
{
if (PublicModel.isLeader()) //建设单位只看到自己
{
strWhere += " AND A.SingleProjectID in (select SingleProjectID from T_SingleProject A,(select distinct ConstructionProjectID from T_Construction_Project ";
strWhere += " where CompanyID=" + Common.Session.GetSession("CompanyID") + ") B where A.ConstructionProjectID=B.ConstructionProjectID)";
}
}
if (txtgcmc.Text.Trim().Length > 0)
{
strWhere += " AND D.gcmc LIKE '%" + txtgcmc.Text.Trim() + "%'";
}
if (txtgcbm.Text.Trim().Length > 0)
{
strWhere += " AND D.gcbm LIKE '%" + txtgcbm.Text + "%'";
}
if (txtajtm.Text.Trim().Length > 0)
{
strWhere += " AND A.ajtm like '%" + txtajtm.Text.Trim() + "%' ";
}
if (ViewState["CurrentPageIndex"] == null && Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")) > 0)
{
pageIndex = Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex"));
ViewState["CurrentPageIndex"] = pageIndex;
}
else
{
pageIndex = ConvertEx.ToInt(ViewState["CurrentPageIndex"]);
}
DataTable dt = archiveBLL.GetListPaging(strWhere, pageSize, pageIndex, out itemCount);;
AspNetPager.AlwaysShow = true;
AspNetPager.PageSize = pageSize;
AspNetPager.RecordCount = itemCount;
AspNetPager.CurrentPageIndex = pageIndex;
rpData.DataSource = dt;
rpData.DataBind();
}
/// <summary>
/// 绑定数据
/// </summary>
/// <param name="pageIndex"></param>
public void BindGrid(int pageIndex)
{
//从窗口接收开始,都是馆里人员操作,不用考虑建设单位等身份
string strWhere = " AND A.SingleProjectID=" + Common.DNTRequest.GetQueryString("SingleProjectID");
if (PublicModel.isSuperAdmin()) //管理员管理员获取所有工程
{
strWhere += " AND D.AREA_CODE LIKE '" + Common.Session.GetSession("AREA_CODE") + "%'";
}
else if (PublicModel.isArchiveUser()) //档案馆用户看自己的
{
strWhere += " AND D.AREA_CODE LIKE '" + Common.Session.GetSession("OLD_AREA_CODE") + "%'";
}
Hashtable ht = new Hashtable();
if (ddlChkStatus.SelectedValue != "") //关于审核状态,都是查询最后一次的审核信息
{
ht.Add("CheckStatus", ddlChkStatus.SelectedValue);
ht.Add("SingleProjectID", singleProjectID);
ht.Add("WorkFlowID", workFlowID);
}
if (txtXH.Text != "")
{
strWhere += " AND XH=" + ConvertEx.ToInt(txtXH.Text.Trim()) + "";
}
if (txtTitle.Text.Trim().Length > 0)
{
strWhere += " AND A.ajtm like '%" + txtTitle.Text.Trim() + "%' ";
}
if (ViewState["CurrentPageIndex"] == null && Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")) > 0)
{
pageIndex = Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex"));
ViewState["CurrentPageIndex"] = pageIndex;
}
else
{
pageIndex = ConvertEx.ToInt(ViewState["CurrentPageIndex"]);
}
DataTable dt = trBll.GetListPaging(strWhere, pageSize, pageIndex, out itemCount, ht);;
AspNetPager.AlwaysShow = true;
AspNetPager.PageSize = pageSize;
AspNetPager.RecordCount = itemCount;
AspNetPager.CurrentPageIndex = pageIndex;
rpData.DataSource = dt;
rpData.DataBind();
}