/// <summary> /// 绑定数据 /// </summary> /// <param name="WorkFlowID"></param> /// <param name="pageInde"></param> private void BindGrid(int pageIndex) { BLL.T_WorkFlow_BLL wfBLL = new T_WorkFlow_BLL(); Model.T_WorkFlow_MDL wfMDL = wfBLL.GetModel(workFlowID); workFlowCode = wfMDL.WorkFlowCode; string sqlWhere = string.Empty; if (PublicModel.isSuperAdmin()) //管理员管理员获取所有工程 { sqlWhere = " AND AREA_CODE LIKE '" + Common.Session.GetSession("AREA_CODE") + "%'"; //加区域了。 } else if (PublicModel.isArchiveUser()) //档案馆用户看自己的 { sqlWhere = " AND AREA_CODE LIKE '" + Common.Session.GetSession("OLD_AREA_CODE") + "%'"; //加区域了。 } if (!String.IsNullOrEmpty(txtGcmc.Text)) { sqlWhere += " AND gcmc like '%" + txtGcmc.Text + "%'"; } if (!String.IsNullOrEmpty(txtGcbm.Text)) { sqlWhere += " AND gcbm like '%" + txtGcbm.Text + "%'"; } DataTable dt = null; 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"]); } if (PublicModel.isSuperAdmin()) { dt = flowDefineBLL.GetLHSignatureListPaging(workFlowID.ToString(), false, "", "", sqlWhere, pageSize, pageIndex, out itemCount); } else { dt = flowDefineBLL.GetLHSignatureListPaging(workFlowID.ToString(), Common.Session.GetSessionBool("IsCompany"), Common.Session.GetSession("RoleID"), Common.Session.GetSession("UserID"), sqlWhere, pageSize, pageIndex, out itemCount); } AspNetPager.AlwaysShow = true; AspNetPager.PageSize = pageSize; AspNetPager.RecordCount = itemCount; AspNetPager.CurrentPageIndex = pageIndex; gvData.DataSource = dt; gvData.DataBind(); }
/// <summary> /// 创建页面控件 /// </summary> private void CreatePage() { DataTable roleDt = roleRightBLL.GetList("RoleID=" + Common.Session.GetSession("RoleID")).Tables[0]; string RoleID = Common.Session.GetSession("RoleID"); string UserID = Common.Session.GetSession("UserID"); string Area_Code = string.Empty; if (PublicModel.isSuperAdmin()) //超级管理员,可以看全部 { RoleID = ""; Area_Code = Common.Session.GetSession("Area_Code"); } else { Area_Code = Common.Session.GetSession("OLD_AREA_CODE"); } DataSet ds = workFlowBLL.GetWorkFlowList(RoleID, UserID, Area_Code, Common.Session.GetSessionBool("IsCompany")); DataTable dt = new DataTable(); //对数据集按照父子关系排序 dt.Columns.Add("WorkFlowID"); dt.Columns.Add("WorkFlowName"); dt.Columns.Add("DetailCount"); dt.Columns.Add("roleid"); dt.Columns.Add("userid"); dt.Columns.Add("UseForCompany"); dt.Columns.Add("OrderIndex"); dt.Columns.Add("DescriptionToArchive"); dt.Columns.Add("DescriptionToCompany"); OrderDs(dt, ds, "0"); StringBuilder strBuilder = new StringBuilder(); int index = 0; foreach (DataRow row in dt.Rows) { index++; string description = string.Empty; //流程说明 if (PublicModel.isCompany()) { description = row["DescriptionToCompany"].ToString(); } else { description = row["DescriptionToArchive"].ToString(); } string strClick = string.Empty; strBuilder.Append(" <li class=\"thumb1\"><a href=\"#\">"); bool isShowDetailCount = false; if (PublicModel.isSuperAdmin() || isIncludeWorkFlow(roleDt, ConvertEx.ToInt(row["WorkFlowID"]))) { isShowDetailCount = true; strClick = " onclick=\"parent.addCustomIframe('MyTaskList.aspx?WorkFlowID=" + ConvertEx.ToInt(row["WorkFlowID"]) + "','83995083" + ConvertEx.ToInt(row["WorkFlowID"]) + "','" + ConvertEx.ToString(row["WorkFlowName"]) + "')\" "; strBuilder.Append(" <img " + strClick + " src=\"../Javascript/Layer/image/lc" + index.ToString("d3") + ".png\" />"); } else { strBuilder.Append(" <img src=\"../Javascript/Layer/image/hc" + index.ToString("d3") + ".png\" />"); } strBuilder.Append(" <div class=\"title\">"); if (!PublicModel.isCompany() || isShowDetailCount) { isShowDetailCount = false; strBuilder.Append(" <span>(" + ConvertEx.ToString(row["DetailCount"]) + ")</span><br />"); } strBuilder.Append(" " + ConvertEx.ToString(row["WorkFlowName"]) + ""); strBuilder.Append(" </div>"); strBuilder.Append(" <p " + strClick + " > "); strBuilder.Append(description); strBuilder.Append(" </p> "); strBuilder.Append(" </a>"); strBuilder.Append(" <div class=\"dd" + index.ToString("d2") + "\"></div>"); strBuilder.Append(" </li>"); } ltWorkFlow.Text = strBuilder.ToString(); }
/// <summary> /// 绑定数据 /// </summary> /// <param name="pageIndex"></param> private void BindGrid(int pageIndex) { BLL.T_WorkFlow_BLL wfBLL = new T_WorkFlow_BLL(); Model.T_WorkFlow_MDL wfMDL = wfBLL.GetModel(ConvertEx.ToInt(workFlowID)); workFlowCode = wfMDL.WorkFlowCode; string sqlWhere = string.Empty; if (PublicModel.isSuperAdmin()) //管理员管理员获取所有工程 { sqlWhere = " AND AREA_CODE LIKE '" + Common.Session.GetSession("AREA_CODE") + "%'"; } else if (PublicModel.isArchiveUser()) //档案馆用户看自己的 { sqlWhere = " AND AREA_CODE LIKE '" + Common.Session.GetSession("OLD_AREA_CODE") + "%'"; } if (!String.IsNullOrEmpty(gcmc.Text)) { sqlWhere += " AND gcmc like '%" + gcmc.Text + "%'"; } if (!String.IsNullOrEmpty(gcbm.Text)) { sqlWhere += " AND gcbm like '%" + gcbm.Text + "%'"; } 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"]); } bool isChargeUser = false; if ((SystemSet._DEFAULT_RECV_WORKFLOWID + ",").IndexOf(workFlowID + ",") > -1) { isChargeUser = true; } DataTable dt = null; if (PublicModel.isSuperAdmin()) { dt = flowDefineBLL.GetListPaging(workFlowID, false, "", "", sqlWhere, pageSize, pageIndex, out itemCount); } else { dt = flowDefineBLL.GetListPaging(workFlowID, Common.Session.GetSessionBool("IsCompany"), "", Common.Session.GetSession("UserID"), sqlWhere, pageSize, pageIndex, out itemCount, isChargeUser); } AspNetPager.AlwaysShow = true; AspNetPager.PageSize = pageSize; AspNetPager.RecordCount = itemCount; AspNetPager.CurrentPageIndex = pageIndex; rpData.DataSource = dt; rpData.DataBind(); }