//判断各种操作类型 protected void Page_Load(object sender, EventArgs e) { if (Request["OperateType"] != null) { CloudBLL.Entprise bllEnt = new CloudBLL.Entprise(); string connectstr = Session["ConnString"].ToString(); string data = ""; string OperateType = Request["OperateType"].ToString(); string sql = ""; int entId = (int)Session["UserID"]; if (OperateType.Equals("employee")) { if (!string.IsNullOrEmpty(Request["TreeNumber"]))//这个好像暂时没有用 { data = ToArrayString(connectstr, "select 人员ID,人员名称 from EmployeeList where 人员ID not in (select EmployeeID from GroupVSEmploy where PrjGroupID=" + Request["TreeNumber"].ToString() + ") and 归属角色 in (select RoleID from Group_Role where PrjGroupID=" + Request["TreeNumber"].Trim() + ")", "人员ID", "人员名称"); } } else if (OperateType.Equals("allemployee")) { sql = "select 人员ID,人员名称 from EmployeeList WHERE entId=" + entId; data = bllEnt.GetComboData(sql, "人员ID", "人员名称", connectstr); } else if (OperateType.Equals("ProjectList")) { sql = "select 项目编号,项目名称 from ProjList WHERE entId = " + entId; data = bllEnt.GetComboData(sql, "项目编号", "项目名称", connectstr); } else if (OperateType.Equals("ProjectState")) { sql = "select StateID,StateText from ProjectState"; data = bllEnt.GetComboData(sql, "StateID", "StateText", connectstr); } else if (OperateType.Equals("ProjectType")) { sql = "select TypeID,TypeText from ProjectType"; data = bllEnt.GetComboData(sql, "TypeID", "TypeText", connectstr); } else if (OperateType.Equals("role")) { sql = "select ID,Name from RoleList WHERE entId = " + entId; data = bllEnt.GetComboData(sql, "ID", "Name", connectstr); } else if (OperateType.Equals("DepartList")) { sql = "select 部门编号,部门名称 from DeptList WHERE entId = " + entId; data = bllEnt.GetComboData(sql, "部门编号", "部门名称", connectstr); } else if (OperateType.Equals("TaskState")) { sql = "select TaskStateID,TaskStateName from TaskState"; data = bllEnt.GetComboData(sql, "TaskStateID", "TaskStateName", connectstr); } Response.Write(data); Response.End(); Response.Clear(); } }
protected void Page_Load(object sender, EventArgs e) { //string PlatForm_connectstr = Session["PlatForm_connectstr"].ToString(); 云平台数据库 if (Request["OperateType"] != null) { string connectstr = Session["ConnString"].ToString(); //企业内部数据库 string sql = ""; string OperateType = Request["OperateType"]; if (OperateType.Equals("delete")) { string id = Request["id"]; sql = "delete from ProjList where 序号 in (" + Request["id"] + ")"; //通过点击得到的id,安全 if (sqlExecute.sqlmanage.ExecuteSQL(sql, connectstr)) //Nonquery方法 { SQLToTreeJson.TreeJson tj = new SQLToTreeJson.TreeJson(); string IDs = string.Join(",", tj.getChildID("ProjectTaskTree", connectstr, "ID", "ParentID", "select * from ProjectTaskTree where ProjectID in(" + id + ")")); if (!string.IsNullOrWhiteSpace(IDs)) { sqlExecute.sqlmanage.ExecuteSQL("delete from ProjectTaskTree where ID in (" + IDs + ")", connectstr); sqlExecute.sqlmanage.ExecuteSQL("delete from TaskList where BelongProjectTreeNode in (" + IDs + ")", connectstr); Response.Clear(); Response.Write("项目信息删除成功!"); } } else { Response.Clear(); Response.Write("项目信息删除失败!"); } Response.End(); } else if (OperateType.Equals("ProjectTaskTree_Data")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(connectstr, true); string tempsql = "select Name,ID, ParentID, CreateDate, Creator, Chargor, ProjectID,E1.人员名称 as CreatorPeopleName,E2.人员名称 as ChargorPeopleName,ProjList.项目名称 as ProjectName from ProjectTaskTree,EmployeeList E1,EmployeeList E2,ProjList where ParentID is null and ProjectTaskTree.Creator=E1.人员ID and ProjectTaskTree.Chargor=E2.人员ID and ProjectTaskTree.ProjectID=ProjList.序号 and ProjectID=" + Request["ProjectID"].ToString(); sb.AppendFormat("[{0}]", ff.fillTreeView(tempsql, new string[] { "Name" }, "ID", "ParentID", " ProjectTaskTree.Creator=E1.人员ID and ProjectTaskTree.Chargor=E2.人员ID and ProjectTaskTree.ProjectID *=ProjList.序号 ")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); } else if (OperateType.Equals("TaskDicWord")) { CloudBLL.Entprise bllEnt = new CloudBLL.Entprise(); string s = bllEnt.GetAttrNameJson(); Response.Write(s); Response.End(); Response.Clear(); } } }