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();
}
