public void Bind() { string strWhere = " d_class='根目录'"; int pid = 281; if (WebCommon.Public.ToString(Request.QueryString["folder"]) != "") { pid = WebCommon.Public.ToInt(Request.QueryString["folderid"]); strWhere = " d_class='" + Request.QueryString["folder"] + "'"; } //绑定文件夹数据 Rep_List.DataSource = WebBLL.Tbl_ClassManager.GetTbl_ClassByParentID(pid); Rep_List.DataBind(); if (WebCommon.Public.ToString(Request.QueryString["where"]) != "") { strWhere = Request.QueryString["where"]; } //分页设置 AspNetPager1.PageSize = 10; AspNetPager1.RecordCount = WebBLL.Tbl_DiskManager.GetDataTableByCount(strWhere); //绑定文件数据 Rep_List1.DataSource = WebBLL.Tbl_DiskManager.GetDataTableByPage(AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, strWhere, " ID desc"); Rep_List1.DataBind(); }
public void Bind() { string strWhere = ""; //分页 AspNetPager1.PageSize = 15; AspNetPager1.RecordCount = WebBLL.Tbl_LimitManager.GetDataTableByCount(strWhere); //绑定分页数据 Rep_List.DataSource = WebBLL.Tbl_LimitManager.GetDataTableByPage(AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, strWhere, "LimitName"); Rep_List.DataBind(); }
public void Bind() { string strWhere = ""; if (WebCommon.Public.ToString(Request.QueryString["where"]) != "") { strWhere = Request.QueryString["where"]; } //分页设置 AspNetPager1.PageSize = 15; AspNetPager1.RecordCount = WebBLL.Tbl_FlowManager.GetDataTableByCount(strWhere); //绑定分页数据 Rep_List.DataSource = WebBLL.Tbl_FlowManager.GetDataTableByPage(AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, strWhere, "id desc"); Rep_List.DataBind(); }
public void Bind() { string strWhere = "(UserName='******' or NodeUser like '%" + WebCommon.Public.GetUserName() + "%')"; if (WebCommon.Public.ToString(Request.QueryString["where"]) != "") { strWhere += " and " + Request.QueryString["where"]; } //分页设置 AspNetPager1.PageSize = 15; AspNetPager1.RecordCount = WebBLL.Tbl_FlowWorkManager.GetDataTableByCount(strWhere); //绑定分页数据 Rep_List.DataSource = WebBLL.Tbl_FlowWorkManager.GetDataTableByPage(AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, strWhere, "id desc"); Rep_List.DataBind(); }
public void Bind() { string strWhere = "POP_Type='" + Title + "'"; if (WebCommon.Public.ToString(Request.QueryString["where"]) != "") { strWhere = Request.QueryString["where"]; } //分页设置 AspNetPager1.PageSize = 15; AspNetPager1.RecordCount = WebBLL.Tbl_ProjectOuterPayManager.GetDataTableByCount(strWhere); //绑定分页数据 Rep_List.DataSource = WebBLL.Tbl_ProjectOuterPayManager.GetDataTableByPage(AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, strWhere, "projectid desc,pop_num desc"); Rep_List.DataBind(); }
public void Bind() { string strWhere = ""; if (Request.QueryString["limit"] != "") { strWhere = " POC_Type1='" + Request.QueryString["limit"] + "'"; } if (WebCommon.Public.ToString(Request.QueryString["where"]) != "") { strWhere += " and " + Request.QueryString["where"]; } //分页设置 AspNetPager1.PageSize = 15; AspNetPager1.RecordCount = WebBLL.Tbl_ProjectOuterCompanyManager.GetDataTableByCount(strWhere); //绑定分页数据 Rep_List.DataSource = WebBLL.Tbl_ProjectOuterCompanyManager.GetDataTableByPage(AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, strWhere, "id desc"); Rep_List.DataBind(); }
public void Bind() { string strWhere = "PCP_Type='经营收费'"; if (WebCommon.Public.ToString(Request.QueryString["where"]) != "") { strWhere = Request.QueryString["where"]; } //分页设置 AspNetPager1.PageSize = 15; AspNetPager1.RecordCount = WebBLL.Tbl_ProjectContractPayManager.GetDataTableByCount(strWhere); //绑定分页数据 Rep_List.DataSource = WebBLL.Tbl_ProjectContractPayManager.GetDataTableByPage(AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, strWhere, "Tbl_ProjectContractPay.projectid desc,Tbl_ProjectContractPay.PCP_Num desc"); Rep_List.DataBind(); //统计结果 System.Data.DataTable dt = WebBLL.Tbl_ProjectContractPayManager.GetDataTableByStatistics(strWhere); Label1.Text = (Convert.ToDouble(dt.Rows[0][0]) / 10000).ToString() + "万"; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string typeStr = WebCommon.Public.ToString(Request.QueryString["Type"]); int ProjectID = WebCommon.Public.ToInt(Request.QueryString["ProjectID"]); //如果领导未审撤回 if (typeStr == "cancel") { WebModels.Tbl_Project project = WebBLL.Tbl_ProjectManager.GetTbl_ProjectById(ProjectID); project.NodeNo = "项目撤回"; project.NodeUser = project.UserName; project.Status = "结束"; WebBLL.Tbl_ProjectManager.UpdateTbl_Project(project); WebCommon.Script.AlertAndGoBack("撤回成功"); } //项目结束并存档 if (typeStr == "save") { int count = 0; int DesignTaskID = 0;// WebCommon.Public.ToInt(WebBLL.Tbl_DesignTaskManager.GetDataTableByPage(1, 1, "ProjectID=" + ProjectID.ToString(), "id desc").Rows[0]["ID"]); foreach (System.Data.DataRow dr in WebBLL.Tbl_DesignTaskManager.GetDataTableByPage(100, 1, "ProjectID=" + ProjectID.ToString(), "id desc").Rows) { DesignTaskID = Convert.ToInt32(dr["ID"]); WebModels.Tbl_DesignTask designtask = WebBLL.Tbl_DesignTaskManager.GetTbl_DesignTaskById(DesignTaskID); WebModels.Tbl_ProjectArchive archive = new WebModels.Tbl_ProjectArchive(); archive.ProjectID = designtask.ProjectID; archive.ClassName1 = designtask.ClassName1; archive.ClassName2 = designtask.ClassName2; archive.ClassName3 = designtask.ClassName3; archive.PA_Type1 = "项目档案"; archive.PA_Type2 = "电子版"; archive.ParentID = 0; archive.PA_Limit = "普通"; archive.PA_Name = designtask.ClassName3; archive.PA_File = WebBLL.Tbl_DesignCorrectManager.GetDataTableByPage(1, 1, "DesignTaskID=" + designtask.ID + " and Tbl_DesignCorrect.status='结束'", "Tbl_DesignCorrect.id desc").Rows[0]["DC_File"].ToString(); archive.PA_FileNo = ""; archive.PA_Info = "项目流程自动存档"; archive.Status = "已审核"; archive.DealUser = WebCommon.Public.GetUserName(); WebBLL.Tbl_ProjectArchiveManager.AddTbl_ProjectArchive(archive); count++; } if (count > 0) { WebModels.Tbl_Project project = WebBLL.Tbl_ProjectManager.GetTbl_ProjectById(ProjectID); project.Status = "结束"; WebBLL.Tbl_ProjectManager.UpdateTbl_Project(project); WebCommon.Script.AlertAndGoBack("项目自动存档成功"); } else { WebCommon.Script.AlertAndGoBack("存档失败"); } } //绑定项目工作 string username = WebCommon.Public.GetUserName(); //进行中的节点用户或如果是设计工作处理节点的任务工作者 string whereStr = "status='进行中' and (nodeuser like '%" + username + "%' or (nodeno='设计工作处理' and (select count(*) from tbl_designtask where projectid=tbl_project.id and (dt_shejiren='" + username + "' or dt_jiaoduiren='" + username + "' or dt_shenheren='" + username + "' or dt_shendingren='" + username + "'))>0))"; Rep_List.DataSource = WebBLL.Tbl_ProjectManager.GetDataTableByPage(30, 1, whereStr, "id desc"); Rep_List.DataBind(); //绑定任务工作//按单个任务罗列 //string strWhere = "status<>'结束' and status<>'任务录入' and status<>'任务审批' and NodeUser like '%" + WebCommon.Public.GetUserName() + "%'"; //Rep_List2.DataSource = WebBLL.Tbl_DesignTaskManager.GetDataTableByPage(30, 1, strWhere, "id desc"); //Rep_List2.DataBind(); //绑定任务工作//按单个项目罗列 string strWhere = "id in (select projectid from tbl_designtask where status<>'结束' and status<>'任务录入' and status<>'任务审批' and NodeUser like '%" + WebCommon.Public.GetUserName() + "%')"; Rep_List2.DataSource = WebBLL.Tbl_ProjectManager.GetDataTableByPage(30, 1, strWhere, ""); Rep_List2.DataBind(); } }
public void Bind() { Rep_List.DataSource = WebBLL.Tbl_OutFileManager.GetDataTableByPage(AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, ViewState["strWhere"].ToString(), " ID desc"); Rep_List.DataBind(); }