public void Bind() { int ID = Convert.ToInt32(Request.QueryString["ProjectID"]); WebModels.Tbl_Project project = WebBLL.Tbl_ProjectManager.GetTbl_ProjectById(ID); this.ProjectName.Value = project.ProjectName; this.ProjectNo.Value = project.ProjectNo; //绑定主设人员 UserName.DataSource = WebBLL.Tbl_UserManager.GetDataTableByPage(50, 1, "u_designlimit like '%主设%'", ""); UserName.DataTextField = "UserName"; UserName.DataValueField = "UserName"; UserName.DataBind(); //UserName.Items.Insert(0, new ListItem("选择主设", "")); }
protected void Button1_Click(object sender, EventArgs e) { int ID = Convert.ToInt32(Request.QueryString["ProjectID"]); //添加合同成功的时候更新项目的节点信息 WebModels.Tbl_Project project = WebBLL.Tbl_ProjectManager.GetTbl_ProjectById(ID); project.NodeNo = "主设人员审批"; //遍历查询各位主设的室主任 string NodeUsers = ""; int i = 0; string zhuanye = ""; string zhuanyeleader = ""; foreach (WebModels.Tbl_ProjectDesigner pd in WebBLL.Tbl_ProjectDesignerManager.GetTbl_ProjectDesignerByProjectId(ID)) { try { zhuanye = WebBLL.Tbl_UserManager.GetTbl_UserByUserName(pd.UserName).U_Specialty; zhuanyeleader = WebBLL.Tbl_ClassManager.GetDataTableByPage(1, 1, "parentid=15 and CharINDEX(classname,'" + zhuanye + "')>0", "").Rows[0]["status"].ToString(); if (i == 0) { NodeUsers = zhuanyeleader; } if (i > 0 && !NodeUsers.Contains(zhuanyeleader)) { NodeUsers += "," + zhuanyeleader; } i++; } catch { ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('" + pd.UserName + "的室主任查询失败,请检查该人的专业设置是否有误!');", true); return; } } project.NodeUser = NodeUsers; WebBLL.Tbl_ProjectManager.UpdateTbl_Project(project); ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('提交成功,等待" + NodeUsers + "主设人员审批!');window.external.reload();window.external.close();", true); }