protected void Page_Load(object sender, EventArgs e) { string connectstr = Session["connectstr"].ToString(); string PlatForm_connectstr = Session["PlatForm_connectstr"].ToString(); if (Request["OperateType"] != null) { string OperateType = Request["OperateType"].ToString(); if (OperateType.Equals("ProjectTaskTree")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(connectstr, true); string tempsql = "select ID,Name,ParentID,Chargor,TaskList.BelongProjectTreeNode from ProjectTaskTree,TaskList where ParentID is null and ProjectTaskTree.ID*=TaskList.BelongProjectTreeNode"; sb.AppendFormat("[{0}]", ff.fillTreeView(tempsql, new string[] { "id", "text" }, "ID", "ParentID", " ProjectTaskTree.ID*=TaskList.BelongProjectTreeNode ")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); } else if (OperateType.Equals("ProjectTaskTreeNoCheckBox")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(connectstr, false); string tempsql = "select ID,Name,ParentID,Chargor from ProjectTaskTree where ParentID is null "; sb.AppendFormat("[{0}]", ff.fillTreeView(tempsql, new string[] { "id", "text" }, "ID", "ParentID")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); } } }
protected void Page_Load(object sender, EventArgs e) { string data = ""; string PlatForm_connectstr = Session["PlatForm_connectstr"].ToString(); string OperateType = Request["OperateType"].ToString(); if (!string.IsNullOrEmpty(PlatForm_connectstr) && !string.IsNullOrEmpty(OperateType)) { if (OperateType.Equals("BlankType")) { data = ToArrayString(PlatForm_connectstr, "select ID,Name from BlankType", "ID", "Name"); } else if (OperateType.Equals("GeoChaType")) { data = ToArrayString(PlatForm_connectstr, "select ID,Name from GeoChaType", "ID", "Name"); } else if (OperateType.Equals("Material")) { data = ToArrayString(PlatForm_connectstr, "select ID,Name from Material", "ID", "Name"); } else if (OperateType.Equals("CompSort2")) { data = ToArrayString(PlatForm_connectstr, "select ID,Name from CompSort2", "ID", "Name"); } else if (OperateType.Equals("PartGeoType")) { data = ToArrayString(PlatForm_connectstr, "select ID,Name from PartGeoType", "ID", "Name"); } else if (OperateType.Equals("AmountSort")) { data = ToArrayString(PlatForm_connectstr, "select ID,Name from AmountSort", "ID", "Name"); } else if (OperateType.Equals("IndustrySort")) { data = ToArrayString(PlatForm_connectstr, "select ID,Name from IndustrySort", "ID", "Name"); } else if (OperateType.Equals("DieClass")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(PlatForm_connectstr, false); sb.AppendFormat("[{0}]", ff.fillTreeView("select ID,Name,ParentID from DieClass where ParentID is null ", new string[] { "id", "text" }, "ID", "ParentID")); data = sb.ToString(); } else if (OperateType.Equals("Craft")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(PlatForm_connectstr, false); sb.AppendFormat("[{0}]", ff.fillTreeView("select ID,Name,ParentID from Craft where ParentID is null ", new string[] { "id", "text" }, "ID", "ParentID")); data = sb.ToString(); } 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(); } } }
protected void Page_Load(object sender, EventArgs e) { // string connectstr = Session["connectstr"].ToString(); string PlatForm_connectstr = Session["PlatForm_connectstr"].ToString(); if (Request["OperateType"] != null) { string OperateType = Request["OperateType"].ToString(); if (OperateType.Equals("StandardTaskTreeNoCheckBox")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(PlatForm_connectstr, false); sb.AppendFormat("[{0}]", ff.fillTreeView("select NodeId,StandardTaskName,TaskTemplate.name as TemplateName,PNodeId from ServiceTree,TaskTemplate where PNodeId is null and ServiceTree.TemplateID*=TaskTemplate.TaskTemplateID ", new string[] { "id", "text", "TemplateName" }, "NodeId", "PNodeId", " ServiceTree.TemplateID*=TaskTemplate.TaskTemplateID ")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); } else if (OperateType.Equals("TaskDicWord")) { string sql = "select AttributeName as Name,Chinese as Text from Attributes"; string s = GetJsonStr(sql, PlatForm_connectstr); Response.Write(s); Response.End(); Response.Clear(); } else if (OperateType.Equals("GetTaskTemplateName")) { string WordsInf = sqlExecute.sqlmanage.GetUniqueRecord("select name from TaskTemplate where TaskTemplateID =( select TemplateID from StandardTask where StandardTaskID=" + Request["TaskTemplateID"].ToString() + ")", PlatForm_connectstr, new string[] { "name" }); if (WordsInf.Contains(",") || WordsInf.Contains("|")) { Response.Write("Erro"); } else { Response.Write(WordsInf); } Response.End(); Response.Clear(); } else if (OperateType.Equals("State_Name")) { string sql = "select TaskStateID,TaskStateName from TaskState"; string s = GetJsonStr(sql, PlatForm_connectstr, "TaskStateID", "TaskStateName"); Response.Write(s); Response.End(); Response.Clear(); } } }
protected void Page_Load(object sender, EventArgs e) { string connectstr = Session["connectstr"].ToString(); if (Request["OperateType"] != null) { string OperateType = Request["OperateType"].ToString(); if (Request["OperateType"].Equals("OrgStructureTree")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(connectstr, false); sb.AppendFormat("[{0}]", ff.fillTreeView("select 部门编号,部门名称,部门编号 from DeptList where 上级部门 is null ", new string[] { "id", "text", "qtip" }, "部门编号", "上级部门")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); } } }
protected void Page_Load(object sender, EventArgs e) { string connectstr = Session["connectstr"].ToString(); string PlatForm_connectstr = Session["PlatForm_connectstr"].ToString(); if (Request["OperateType"] != null) { string OperateType = Request["OperateType"].ToString(); if (OperateType.Equals("OrgStructureTreeNoCheckBox")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(connectstr, false); string tempsql = "select 部门编号,部门名称,上级部门 from DeptList where 上级部门 is null "; sb.AppendFormat("[{0}]", ff.fillTreeView(tempsql, new string[] { "id", "text" }, "部门编号", "上级部门")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); } else if (OperateType.Equals("LoadPeopleByDepart")) { if (Request["DepartID"] == null || string.IsNullOrEmpty(Request["DepartID"].ToString())) { Response.Write(ToArrayString(connectstr, "select 人员ID,人员名称 from EmployeeList ", "人员ID", "人员名称")); } else { string sss = "select * from DeptList where 部门编号='" + Request["DepartID"] + "'"; string[] childIDs = new TreeJson().getChildID("DeptList", connectstr, "部门编号", "上级部门", sss); Response.Write(ToArrayString(connectstr, "select 人员ID,人员名称 from EmployeeList where 归属部门 in ('" + String.Join("','", childIDs) + "')", "人员ID", "人员名称")); } Response.End(); Response.Clear(); } else if (OperateType.Equals("TaskDicWord")) { string sql = "select AttributeName as Name,Chinese as Text from Attributes"; string s = GetJsonStr(sql, PlatForm_connectstr); Response.Write(s); Response.End(); Response.Clear(); } } }
protected void Page_Load(object sender, EventArgs e) { // string connectstr = Session["connectstr"].ToString(); // string PlatForm_connectstr = "server=;Initial Catalog=CloudMDB;User ID=sa;Password=zju308;connect timeout=30"; string PlatForm_connectstr = Session["PlatForm_connectstr"].ToString(); Session["PlatForm_connectstr"] = PlatForm_connectstr; if (Request["OperateType"] != null) { string OperateType = Request["OperateType"].ToString(); if (OperateType.Equals("AllStandardTaskType")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(PlatForm_connectstr, false); sb.AppendFormat("[{0}]", ff.fillTreeView("select NodeId,StandardTaskName,PNodeId from ServiceTree where PNodeId is null ", new string[] { "id", "text" }, "NodeId", "PNodeId")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); return; } else if (OperateType.Equals("TaskTemplate_AllNode")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(PlatForm_connectstr, false); sb.AppendFormat("[{0}]", ff.fillTreeView("select TaskTemplateID,Coalesce(fieldLabel,Chinese) as fieldLabel,Type,TaskTemplateParentID from TaskTemplate,Attributes where TaskTemplate.DicWordID*=Attributes.AttributeID and TaskTemplateParentID is null ", new string[] { "id", "text", "type" }, "TaskTemplateID", "TaskTemplateParentID", " TaskTemplate.DicWordID*=Attributes.AttributeID ")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); return; } else if (OperateType.Equals("TaskTemplate_CertainNode")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(PlatForm_connectstr, false); string[] childIDs = new TreeJson().getChildID("ServiceTree", PlatForm_connectstr, "NodeId", "PNodeId", "select NodeId,PNodeId from ServiceTree where NodeId=" + Request["StandardTaskID"].ToString()); sb.AppendFormat("[{0}]", ff.fillTreeView("select TaskTemplateID,Coalesce(fieldLabel,Chinese) as fieldLabel,Type,TaskTemplateParentID from TaskTemplate,Attributes where TaskTemplate.DicWordID*=Attributes.AttributeID and TaskTemplateParentID is null and BidingStandardTaskID in (" + string.Join(",", childIDs) + ")", new string[] { "id", "text", "type" }, "TaskTemplateID", "TaskTemplateParentID", " TaskTemplate.DicWordID*=Attributes.AttributeID ")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); return; } else if (OperateType.Equals("ViewReply")) { Response.Write(GetLastReply(PlatForm_connectstr, Request["TopicID"].ToString())); Response.End(); Response.Clear(); return; } else if (OperateType.Equals("NewTopic")) { string temp = ""; temp += "'" + Request["title"] + "',"; temp += "'" + Request["TopicContent"] + "',"; temp += "'" + Request["ID"] + "',"; temp += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',"; temp += "'0','-1'"; string sql = "insert into Forum_Topic (TopicName,TopicContent,TemplateID,CreateTime,CompanyID,CreatorID) values (" + temp + ")"; if (sqlExecute.sqlmanage.ExecuteSQL(sql, PlatForm_connectstr)) { Response.Write("{success:true,msg:'创建成功!'}"); } else { Response.Write("{success:false,msg:'创建失败!'}"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("AddReply")) { string temp = ""; temp += "'" + Request["ReplyContent"] + "',"; temp += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',"; temp += "'" + Request["ID"].ToString() + "',"; temp += "'" + Request["Score"].ToString() + "',"; temp += "'0','-1'"; string sql = "insert into Reply_Topic (ReplyContent,ReplyTime,TopicID,Score,CompanyID,UserID) values (" + temp + ")"; if (sqlExecute.sqlmanage.ExecuteSQL(sql, PlatForm_connectstr)) { Response.Write("{success:true,msg:'回复成功!'}"); } else { Response.Write("{success:false,msg:'回复失败!'}"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("DeleteTopic")) { string sql = "delete from Forum_Topic where ID in (" + Request["TopicID"].ToString() + ")"; if (sqlExecute.sqlmanage.ExecuteSQL(sql, PlatForm_connectstr)) { Response.Write("删除成功!"); } else { Response.Write("删除失败!"); } Response.End(); Response.Clear(); return; } } }
protected void Page_Load(object sender, EventArgs e) { connectstr = Session["connectstr"].ToString(); string PlatForm_connectstr = Session["PlatForm_connectstr"].ToString(); if (Request["OperateType"] != null) { string OperateType = Request["OperateType"].ToString(); if (OperateType.Equals("State_Color")) { string sql = "select TaskStateID,ColorValue from TaskState"; string s = GetJsonStr(sql, PlatForm_connectstr, "TaskStateID", "ColorValue"); Response.Write(s); Response.End(); Response.Clear(); } else if (OperateType.Equals("State_Name")) { string sql = "select TaskStateID,TaskStateName from TaskState"; string s = GetJsonStr(sql, PlatForm_connectstr, "TaskStateID", "TaskStateName"); Response.Write(s); Response.End(); Response.Clear(); } else if (OperateType.Equals("Task_State")) { string sql = "select TaskID,TaskState from TaskList where TaskID in (" + Request["TaskIDs"].ToString() + ")"; string s = GetJsonStr(sql, connectstr, "TaskID", "TaskState"); Response.Write(s); Response.End(); Response.Clear(); } else if (OperateType.Equals("TaskDicWord")) { string sql = "select AttributeName as Name,Chinese as Text from Attributes"; string s = GetJsonStr(sql, PlatForm_connectstr, "Name", "Text"); Response.Write(s); Response.End(); Response.Clear(); } else if (OperateType.Equals("ProjectTaskTreeNoCheckBox")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(connectstr, false); string tempsql = "select ID,Name,ParentID,Chargor from ProjectTaskTree where ParentID is null "; sb.AppendFormat("[{0}]", ff.fillTreeView(tempsql, new string[] { "id", "text" }, "ID", "ParentID")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); } else if (OperateType.Equals("StandardTaskTreeNoCheckBox")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(PlatForm_connectstr, false); sb.AppendFormat("[{0}]", ff.fillTreeView("select NodeId,StandardTaskName,TaskTemplate.name as TemplateName,PNodeId from ServiceTree,TaskTemplate where PNodeId is null and ServiceTree.TemplateID*=TaskTemplate.TaskTemplateID ", new string[] { "id", "text", "TemplateName" }, "NodeId", "PNodeId", " ServiceTree.TemplateID*=TaskTemplate.TaskTemplateID ")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); } else if (OperateType.Equals("WorkFlowTask")) { string sql = "Set ARITHABORT ON select TaskList.*,workflow.name as WorkFlowName,TaskType.TypeName,TaskState.TaskStateName,TaskDetailInf.value('(/Task/@StandardTaskID)[1]','int') as StandardTaskID,TaskDetailInf.value('(/Task/@StandardTaskID)[1]','int') as TaskTemplateID,EmployeeList.人员名称 as CreatorName,P1.Name as ProjectName,P2.Name as PrjTaskTreeName,P2.Chargor as TaskCreator,ProjList.项目负责人 as ProjectChargorID from TaskList,workflow,TaskState,TaskType,EmployeeList,ProjectTaskTree P1,ProjectTaskTree P2,ProjList " + "where TaskList.TaskState*= TaskState.TaskStateID and TaskList.TypeID*=TaskType.TypeID and TaskList.WorkFlowID*=workflow.ID and TaskList.BelongProject=P1.ID and TaskList.BelongProjectTreeNode=P2.ID and P2.ProjectID=ProjList.序号 and P2.Chargor=EmployeeList.人员ID and WorkFlowID =(" + Request["WorkFlowID"].ToString() + ") order by TaskCreateDate"; string getcountSql = "select TaskID from TaskList where WorkFlowID=" + Request["WorkFlowID"].ToString(); SQLToJson.ReaderSQLToJson.SetCount(getcountSql, connectstr); Response.Write(GetJsonStr(sql, connectstr)); Response.End(); Response.Clear(); } } }
protected void Page_Load(object sender, EventArgs e) { // string connectstr = Session["connectstr"].ToString(); //string PlatForm_connectstr = "server=(local);Initial Catalog=CloudMDB;User ID=sa;Password=zju308;connect timeout=30"; string PlatForm_connectstr = Session["PlatForm_connectstr"].ToString(); if (Request["OperateType"] != null) { string OperateType = Request["OperateType"].ToString(); if (OperateType.Equals("AllStandardTaskType")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff2 = new TreeFullJson.TreeFullJson(PlatForm_connectstr, true); sb.AppendFormat("[{0}]", ff2.fillTreeView("select ServiceTree.*,TaskTemplate.fieldLabel as TemplateDisplayName from ServiceTree,TaskTemplate where PNodeId is null and ServiceTree.TemplateID *=TaskTemplate.TaskTemplateID ", new string[] { }, "NodeId", "PNodeId", " ServiceTree.TemplateID *=TaskTemplate.TaskTemplateID ")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); return; } else if (OperateType.Equals("StandardTask_Search")) { string fileter = ""; if (!string.IsNullOrWhiteSpace(Request["Name"].ToString())) { // fileter = " and StandardTaskName like '%" + Request["Name"].ToString() + "%' "; fileter = " and (StandardTaskName like '%" + Request["Name"].ToString() + "%' or NodeName like '%" + Request["Name"].ToString() + "%')"; } else { fileter = " and PNodeId is null "; } StringBuilder sb = new StringBuilder(); TreeFullJson.TreeCurrentSql ff1 = new TreeFullJson.TreeCurrentSql(PlatForm_connectstr, true); sb.AppendFormat("[{0}]", ff1.fillTreeView("select ServiceTree.*,TaskTemplate.fieldLabel as TemplateDisplayName from ServiceTree,TaskTemplate where ServiceTree.TemplateID *=TaskTemplate.TaskTemplateID " + fileter, new string[] { }, "NodeId", "PNodeId")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); return; } else if (OperateType.Equals("LoadByStandardTaskID")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff3 = new TreeFullJson.TreeFullJson(PlatForm_connectstr, true); sb.AppendFormat("[{0}]", ff3.fillTreeView("select Coalesce(fieldLabel,Chinese) as DisplayName,name,emptyText,width,height,Type,BidingStandardTaskID,State,TaskTemplateID,TaskTemplateParentID,TaskTemplateCreateDate,DicWordID,ServiceTree.StandardTaskName from TaskTemplate,ServiceTree,Attributes where TaskTemplate.BidingStandardTaskID*=ServiceTree.NodeId and TaskTemplate.DicWordID*=Attributes.AttributeID and State=2 and TaskTemplateParentID is null and BidingStandardTaskID=" + Request["StandardTaskID"].ToString(), new string[] { }, "TaskTemplateID", "TaskTemplateParentID", " TaskTemplate.DicWordID*=Attributes.AttributeID and TaskTemplate.BidingStandardTaskID*=ServiceTree.NodeId ")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); return; } else if (OperateType.Equals("TaskTemplate_Search")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff4 = new TreeFullJson.TreeFullJson(PlatForm_connectstr, true); sb.AppendFormat("[{0}]", ff4.fillTreeView("select Coalesce(fieldLabel,Chinese) as DisplayName,name,emptyText,width,height,Type,BidingStandardTaskID,State,TaskTemplateID,TaskTemplateParentID,TaskTemplateCreateDate,DicWordID,ServiceTree.StandardTaskName from TaskTemplate,ServiceTree,Attributes where TaskTemplate.BidingStandardTaskID*=ServiceTree.NodeId and TaskTemplate.DicWordID*=Attributes.AttributeID and TaskTemplateParentID is null and State=2 and BidingStandardTaskID=" + Request["StandardTaskID"].ToString() + " and fieldLabel like '%" + Request["Name"].ToString() + "%'", new string[] { }, "TaskTemplateID", "TaskTemplateParentID", " TaskTemplate.DicWordID*=Attributes.AttributeID and TaskTemplate.BidingStandardTaskID*=ServiceTree.NodeId ")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); return; } else if (OperateType.Equals("AddTaskType")) { string temp = ""; if (sqlExecute.sqlmanage.HasRecord(PlatForm_connectstr, "select * from ServiceTree where StandardTaskName='" + Request["StandardTaskTypeName"].ToString() + "' or NodeName='" + Request["StandardServiceTypeName"].ToString() + "' or CodingInit='" + Request["CodingInit"].ToString() + "'")) { Response.Write("{success:false,msg:'该任务名或服务名或编号已被使用!',tr:'another inf'}"); Response.End(); Response.Clear(); } else { temp += "'" + Request["StandardTaskTypeName"] + "',"; temp += "'" + Request["StandardServiceTypeName"] + "',"; temp += "'" + Request["CodingInit"] + "',"; temp += "'" + Request["Description"] + "',"; temp += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',"; temp += "'" + Request["ID"] + "'"; if (sqlExecute.sqlmanage.ExecuteSQL("insert into ServiceTree (StandardTaskName,NodeName,CodingInit,Description,CreateDate,PNodeId) values (" + temp + ")", PlatForm_connectstr)) { Response.Write("{success:true,msg:'标准任务/服务添加成功!',tr:'another inf'}"); } else { Response.Write("{success:false,msg:'标准任务/服务添加失败!',tr:'another inf'}"); } Response.End(); Response.Clear(); } } else if (OperateType.Equals("EditTaskType")) { if (sqlExecute.sqlmanage.HasRecord(PlatForm_connectstr, "select * from ServiceTree where (StandardTaskName='" + Request["StandardTaskTypeName"].ToString() + "' or NodeName='" + Request["StandardServiceTypeName"].ToString() + "' or CodingInit='" + Request["CodingInit"].ToString() + "') and NodeId<>'" + Request["ID"] + "' ")) { Response.Write("{success:false,msg:'该任务名或服务名或编号已被使用!',tr:'another inf'}"); Response.End(); Response.Clear(); } else { string sql = ""; sql = "update ServiceTree set StandardTaskName='" + Request["StandardTaskTypeName"] + "', NodeName='" + Request["StandardServiceTypeName"] + "', CodingInit='" + Request["CodingInit"] + "', Description='" + Request["Description"] + "' where NodeId='" + Request["ID"] + "'"; if (sqlExecute.sqlmanage.ExecuteSQL(sql, PlatForm_connectstr)) { Response.Write("{success:true,msg:'标准任务/服务修改成功!',tr:'another inf'}"); } else { Response.Write("{success:false,msg:'标准任务/服务修改失败!',tr:'another inf'}"); } Response.End(); Response.Clear(); } } else if (OperateType.Equals("DeleteNodes")) { SQLToTreeJson.TreeJson tj = new SQLToTreeJson.TreeJson(); string IDs = String.Join(",", tj.getChildID("ServiceTree", PlatForm_connectstr, "NodeId", "PNodeId", "select * from ServiceTree where NodeId in(" + Request["IDs"].ToString() + ")")); if (sqlExecute.sqlmanage.ExecuteSQL("delete from ServiceTree where NodeId in (" + IDs + ")", PlatForm_connectstr)) { Response.Write("标准任务/服务修改成功!"); } else { Response.Write("标准任务/服务修改失败!"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("TaskTempalteBiding")) { string sql = ""; sql = "update ServiceTree set TemplateID='" + Request["TemplateID"].ToString() + "' where NodeId=" + Request["ID"].ToString(); if (sqlExecute.sqlmanage.ExecuteSQL(sql, PlatForm_connectstr)) { sqlExecute.sqlmanage.ExecuteSQL("update TaskTemplate set state=3 where TaskTemplateID=" + Request["TemplateID"].ToString(), PlatForm_connectstr); Response.Write("模板绑定成功!"); } else { Response.Write("模板绑定失败!"); } Response.End(); Response.Clear(); } } }
protected void Page_Load(object sender, EventArgs e) { string connectstr = Session["connectstr"].ToString(); string PlatForm_connectstr = Session["PlatForm_connectstr"].ToString(); if (Request["OperateType"] != null) { string OperateType = Request["OperateType"].ToString(); if (OperateType.Equals("State_Color")) { string sql = "select TaskStateID,ColorValue from TaskState"; string s = GetJsonStr(sql, PlatForm_connectstr, "TaskStateID", "ColorValue"); Response.Write(s); Response.End(); Response.Clear(); } else if (OperateType.Equals("State_Name")) { string sql = "select TaskStateID,TaskStateName from TaskState"; string s = GetJsonStr(sql, PlatForm_connectstr, "TaskStateID", "TaskStateName"); Response.Write(s); Response.End(); Response.Clear(); } else if (OperateType.Equals("Task_State")) { string sql = "select TaskID,TaskState from TaskList where TaskID in (" + Request["TaskIDs"].ToString() + ")"; string s = GetJsonStr(sql, connectstr, "TaskID", "TaskState"); Response.Write(s); Response.End(); Response.Clear(); } else if (OperateType.Equals("TaskDicWord")) { string sql = "select AttributeName as Name,Chinese as Text from Attributes"; string s = GetJsonStr(sql, PlatForm_connectstr, "Name", "Text"); Response.Write(s); Response.End(); Response.Clear(); } else if (OperateType.Equals("ProjectTaskTreeNoCheckBox")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(connectstr, false); string tempsql = "select ID,Name,ParentID,Chargor from ProjectTaskTree where ParentID is null "; sb.AppendFormat("[{0}]", ff.fillTreeView(tempsql, new string[] { "id", "text" }, "ID", "ParentID")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); } else if (OperateType.Equals("StandardTaskTreeNoCheckBox")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(PlatForm_connectstr, false); sb.AppendFormat("[{0}]", ff.fillTreeView("select NodeId,StandardTaskName,TaskTemplate.name as TemplateName,PNodeId from ServiceTree,TaskTemplate where PNodeId is null and ServiceTree.TemplateID*=TaskTemplate.TaskTemplateID ", new string[] { "id", "text", "TemplateName" }, "NodeId", "PNodeId", " ServiceTree.TemplateID*=TaskTemplate.TaskTemplateID ")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); } else if (OperateType.Equals("OptimizingMatch")) { if (sqlExecute.sqlmanage.HasRecord(connectstr, " select TaskID from TaskList where WorkFlowID=" + Request["WorkFID"] + " and TaskState!=4")) { Response.Write("流程绑定任务的状态已不能进行此操作!"); } else { sqlExecute.sqlmanage.ExecuteSQL("update TaskList set TaskState=8 where WorkFlowID=(select ID from WorkFlow where UserWorkFlowID=" + Request["WorkFID"].ToString() + " and Publisher=" + Session["ENTID"].ToString() + ")", PlatForm_connectstr); sqlExecute.sqlmanage.ExecuteSQL("update TaskList set TaskState=8 where WorkFlowID=" + Request["WorkFID"].ToString(), connectstr); Response.Write("操作成功,系统将会为你的流程进行优化匹配。"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("WorkFlowTask")) { string sql = "Set ARITHABORT ON select TaskList.*,workflow.name as WorkFlowName,TaskType.TypeName,TaskState.TaskStateName,TaskDetailInf.value('(/Task/@StandardTaskID)[1]','int') as StandardTaskID,TaskDetailInf.value('(/Task/@StandardTaskID)[1]','int') as TaskTemplateID,EmployeeList.人员名称 as CreatorName,P1.Name as ProjectName,P2.Name as PrjTaskTreeName,P2.Chargor as TaskCreator,ProjList.项目负责人 as ProjectChargorID from TaskList,workflow,TaskState,TaskType,EmployeeList,ProjectTaskTree P1,ProjectTaskTree P2,ProjList " + "where TaskList.TaskState*= TaskState.TaskStateID and TaskList.TypeID*=TaskType.TypeID and TaskList.WorkFlowID*=workflow.ID and TaskList.BelongProject=P1.ID and TaskList.BelongProjectTreeNode=P2.ID and P2.ProjectID=ProjList.序号 and P2.Chargor=EmployeeList.人员ID and WorkFlowID =(" + Request["WorkFlowID"].ToString() + ") order by TaskCreateDate"; string getcountSql = "select TaskID from TaskList where WorkFlowID=" + Request["WorkFlowID"].ToString(); SQLToJson.ReaderSQLToJson.SetCount(getcountSql, connectstr); Response.Write(GetJsonStr(sql, connectstr)); Response.End(); Response.Clear(); } else if (OperateType.Equals("SendShortMsg")) { string[] userInfs = sqlExecute.sqlmanage.GetUniqueRecord("select 人员ID as ID,移动电话 as Telephone from EmployeeList where 人员ID in ( select Chargor from ProjectTaskTree where ID in (select BelongProjectTreeNode from TaskList where TaskID in ( " + Request["TaskIDs"].ToString() + ")))", connectstr, new string[] { "Telephone", "ID" }).Split('|'); string msg = Request["Message"].ToString(); if (msg.Trim().Equals("")) { Response.Write("不能发送空内容!"); Response.End(); Response.Clear(); return; } else { foreach (string userInf in userInfs) { ClassLibrary1.WebCloudSendMsg.MySendMsg.sendMsg(userInf.Split(',')[0].Trim(), "来自" + Session["username"] + "的信息:" + msg, Session["userID"].ToString(), Session["ENTID"].ToString(), userInf.Split(',')[1].Trim(), Session["ENTID"].ToString()); } Response.Write("发送成功!"); Response.End(); Response.Clear(); } } } }
protected void Page_Load(object sender, EventArgs e) { string connectstr = Session["connectstr"].ToString(); string PlatForm_connectstr = Session["PlatForm_connectstr"].ToString(); if (Request["OperateType"] != null) { string OperateType = Request["OperateType"].ToString(); if (OperateType.Equals("ProjectTaskTree")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(connectstr, true); string tempsql = "select ID,Name,ParentID,Chargor,TaskList.BelongProjectTreeNode from ProjectTaskTree,TaskList where ParentID is null and ProjectTaskTree.ID*=TaskList.BelongProjectTreeNode"; sb.AppendFormat("[{0}]", ff.fillTreeView(tempsql, new string[] { "id", "text" }, "ID", "ParentID", " ProjectTaskTree.ID*=TaskList.BelongProjectTreeNode ")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); } else if (OperateType.Equals("ProjectTaskTreeNoCheckBox")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(connectstr, false); string tempsql = "select ID,Name,ParentID,Chargor from ProjectTaskTree where ParentID is null "; sb.AppendFormat("[{0}]", ff.fillTreeView(tempsql, new string[] { "id", "text" }, "ID", "ParentID")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); } else if (OperateType.Equals("StandardTaskTreeNoCheckBox")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(PlatForm_connectstr, false); sb.AppendFormat("[{0}]", ff.fillTreeView("select NodeId,StandardTaskName,TaskTemplate.name as TemplateName,PNodeId from ServiceTree,TaskTemplate where PNodeId is null and ServiceTree.TemplateID*=TaskTemplate.TaskTemplateID ", new string[] { "id", "text", "TemplateName" }, "NodeId", "PNodeId", " ServiceTree.TemplateID*=TaskTemplate.TaskTemplateID ")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); } else if (OperateType.Equals("TaskDicWord")) { string sql = "select AttributeName as Name,Chinese as Text from Attributes"; string s = GetJsonStr(sql, PlatForm_connectstr); Response.Write(s); Response.End(); Response.Clear(); } else if (OperateType.Equals("GetTaskTemplateName")) { string WordsInf = sqlExecute.sqlmanage.GetUniqueRecord("select name from TaskTemplate where TaskTemplateID =( select TemplateID from StandardTask where StandardTaskID=" + Request["TaskTemplateID"].ToString() + ")", PlatForm_connectstr, new string[] { "name" }); if (WordsInf.Contains(",") || WordsInf.Contains("|")) { Response.Write("Erro"); } else { Response.Write(WordsInf); } Response.End(); Response.Clear(); } else if (OperateType.Equals("ViewTaskProgress")) { Response.Write(GetTaskProgress(PlatForm_connectstr, Request["TaskID"].ToString())); Response.End(); Response.Clear(); } else if (OperateType.Equals("SendShortMsg")) { string[] userInfs = sqlExecute.sqlmanage.GetUniqueRecord("select 人员ID as ID,移动电话 as Telephone from EmployeeList where 人员ID in (" + Request["UserIDs"].ToString() + ")", connectstr, new string[] { "Telephone", "ID" }).Split('|'); string msg = Request["Message"].ToString(); if (msg.Trim().Equals("")) { Response.Write("不能发送空内容!"); Response.End(); Response.Clear(); return; } else { foreach (string userInf in userInfs) { ClassLibrary1.WebCloudSendMsg.MySendMsg.sendMsg(userInf.Split(',')[0].Trim(), "来自企业管理员的信息:" + msg, "-1", Session["userID"].ToString(), userInf.Split(',')[1].Trim(), Session["ENTID"].ToString()); } Response.Write("发送成功!"); Response.End(); Response.Clear(); } } } }
protected void Page_Load(object sender, EventArgs e) { int start = 0; int limit = 15; string roletype = ""; connectstr = Session["connectstr"].ToString(); if (connectstr != "") { // connectstr = "server=(local);Initial Catalog=" + connectstr + ";User ID=sa;Password=zju308;connect timeout=30"; if (!string.IsNullOrEmpty(Request["limit"])) { limit = int.Parse(Request["limit"]); } if (!string.IsNullOrEmpty(Request["start"])) { start = int.Parse(Request["start"]); } if (!string.IsNullOrEmpty(Request["roletype"])) { roletype = Request["roletype"]; } if (string.IsNullOrEmpty(roletype))//如果没有传来的projectname的值就显示所有文档EmployeeList { sql = "select top " + limit + " EmployeeList.*,DeptList.部门名称,R1.Name as Role1Name,R2.Name as Role2Name " + " from DeptList,EmployeeList,RoleList R1,RoleList R2 where 人员编号 not in (select top " + start + " 人员编号 from EmployeeList) and EmployeeList.归属部门 *=DeptList.部门编号 and EmployeeList.归属角色 *=R1.ID and EmployeeList.第二角色 *=R2.ID"; getcountSql = "select 人员编号 from EmployeeList"; } else if (roletype.Equals("PeopleSearch")) { string filter = ""; if (Request["depart"] != null && !Request["depart"].ToString().Equals("")) { filter += " and 归属部门='" + Request["depart"].ToString().Trim() + "'"; } if (Request["PeopleName"] != null && !Request["PeopleName"].ToString().Equals("")) { filter += " and 人员名称='" + Request["PeopleName"].ToString().Trim() + "'"; } if (Request["FirstRole"] != null && !Request["FirstRole"].ToString().Equals("")) { filter += " and 归属角色='" + Request["FirstRole"].ToString().Trim() + "'"; } if (Request["PeopleNum"] != null && !Request["PeopleNum"].ToString().Equals("")) { filter += " and 人员编号='" + Request["PeopleNum"].ToString().Trim() + "'"; } if (Request["PeopleGrade"] != null && !Request["PeopleGrade"].ToString().Equals("")) { filter += " and 学历='" + Request["PeopleGrade"].ToString().Trim() + "'"; } sql = "select top " + limit + " ProjList.*,ProjectState.StateText,ProjectType.TypeText,E1.人员名称,E2.人员名称 as PrjCreator " + " from ProjList,ProjectState,ProjectType,EmployeeList E1,EmployeeList E2 where 序号 not in (select top " + start + " 序号 from ProjList where 序号>-1 " + filter + " order by 序号 ) and ProjList.项目负责人*=E1.人员ID and ProjList.项目创建人*=E2.人员ID and ProjList.项目类型*=ProjectType.TypeID and ProjList.项目状态*=ProjectState.StateID " + filter + " order by 序号"; // sql = "select ProjList.*,ProjectState.StateText,ProjectType.TypeText,E1.人员名称,E2.人员名称 as PrjCreator from ProjList,ProjectState,ProjectType,EmployeeList E1,EmployeeList E2 where ProjList.项目负责人*=E1.人员ID and ProjList.项目创建人*=E2.人员ID and ProjList.项目类型*=ProjectType.TypeID and ProjList.项目状态*=ProjectState.StateID " + filter; ; getcountSql = "select 序号 from ProjList where 序号>-1 " + filter; } else if (roletype.Equals("DepartList"))//80为Craft表中热处理的ID { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(connectstr, true); sb.AppendFormat("[{0}]", ff.fillTreeView("select 部门编号,部门名称,上级部门 from DeptList where 上级部门 is null", new string[] { "id", "text" }, "部门编号", "上级部门")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); return; } SQLToJson.ReaderSQLToJson.SetCount(getcountSql, connectstr); Response.Write(GetJsonStr(sql)); Response.End(); Response.Clear(); } }
protected void Page_Load(object sender, EventArgs e) { string PlatForm_connectstr = Session["PlatForm_connectstr"].ToString(); if (Request["OperateType"] != null) { string OperateType = Request["OperateType"].ToString(); if (OperateType.Equals("LoadDieClassTreeData")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(PlatForm_connectstr, false); sb.AppendFormat("[{0}]", ff.fillTreeView("select ID,Name,ParentID from DieClass where ParentID is null", new string[] { "id", "text" }, "ID", "ParentID")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); } else if (OperateType.Equals("EditNode")) { if (sqlExecute.sqlmanage.HasRecord(PlatForm_connectstr, "select * from DieClass where Name='" + Request["ClassName"].ToString() + "' and ID<>'" + Request["ID"] + "' ")) { Response.Write("{success:false,msg:'该模具类名已被占用!'}"); Response.End(); Response.Clear(); } else { string sql = ""; sql = "update DieClass set Name='" + Request["ClassName"] + "' where ID='" + Request["ID"] + "'"; if (sqlExecute.sqlmanage.ExecuteSQL(sql, PlatForm_connectstr)) { Response.Write("{success:true,msg:'模具类名修改成功!'}"); } else { Response.Write("{success:false,msg:'模具类名修改失败!'}"); } Response.End(); Response.Clear(); } } else if (OperateType.Equals("AddNode")) { if (sqlExecute.sqlmanage.HasRecord(PlatForm_connectstr, "select * from DieClass where Name='" + Request["ClassName"].ToString() + "' ")) { Response.Write("{success:false,msg:'该模具类名已存在!'}"); Response.End(); Response.Clear(); } else { string temp = ""; temp += "'" + Request["ClassName"] + "',"; temp += "'" + Request["ID"] + "'"; if (sqlExecute.sqlmanage.ExecuteSQL("insert into DieClass (Name,ParentID) values (" + temp + ")", PlatForm_connectstr)) { Response.Write("{success:true,msg:'模具类名添加成功!'}"); } else { Response.Write("{success:false,msg:'模具类名添加失败!'}"); } Response.End(); Response.Clear(); } } else if (OperateType.Equals("DeleteNode")) { if (sqlExecute.sqlmanage.ExecuteSQL("delete from DieClass where ID=" + Request["ID"], PlatForm_connectstr)) { Response.Write("模具类名删除成功!"); } else { Response.Write("模具类名删除失败!"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("MoveNode")) { string sql = ""; sql = "update DieClass set " + "ParentID='" + Request["TargetNodeID"] + "' where ID='" + Request["NodeID"] + "'"; if (sqlExecute.sqlmanage.ExecuteSQL(sql, PlatForm_connectstr)) { Response.Write("移动成功!"); } else { Response.Write("移动失败!"); } Response.End(); Response.Clear(); } } }
protected void Page_Load(object sender, EventArgs e) { string PlatForm_connectstr = Session["PlatForm_connectstr"].ToString(); if (Request["OperateType"] != null) { string OperateType = Request["OperateType"].ToString(); if (OperateType.Equals("TaskTemplate_TreeGrid_Data")) { string IdentityFilter = ""; string userType = Session["UserType"].ToString(); TreeFullJson.GetTopParent TNff = new TreeFullJson.GetTopParent(PlatForm_connectstr); if (userType.Equals("PlatFormUser")) { IdentityFilter = ""; } else if (userType.Equals("ENTUser")) { string IDs = string.Join(",", TNff.GetTopNodes("select TaskTemplateID,TaskTemplateParentID from TaskTemplate where CreatorID=-1 and CompanyID=" + Session["ENTID"].ToString(), "TaskTemplateID", "TaskTemplateParentID", "TaskTemplate").ToArray()); if (string.IsNullOrWhiteSpace(IDs)) { IdentityFilter = " and State=0 and Establish_Wiki=1 "; } else { IdentityFilter = " and State=0 and (Establish_Wiki=1 or TaskTemplateID in(" + IDs + "))"; } } else if (userType.Equals("ENTInnerUser")) { string IDs = string.Join(",", TNff.GetTopNodes("select TaskTemplateID,TaskTemplateParentID from TaskTemplate where CreatorID=" + Session["userID"].ToString() + " and CompanyID=" + Session["ENTID"].ToString(), "TaskTemplateID", "TaskTemplateParentID", "TaskTemplate").ToArray()); // IdentityFilter = " and (Establish_Wiki=1 or ( CompanyID=" + Session["ENTID"].ToString() + " and CreatorID=" + Session["userID"].ToString() + ") or TaskTemplateID in(" + IDs + "))"; if (string.IsNullOrWhiteSpace(IDs)) { IdentityFilter = " and State=0 and Establish_Wiki=1 "; } else { IdentityFilter = " and State=0 and (Establish_Wiki=1 or TaskTemplateID in(" + IDs + "))"; } } else { return; } StringBuilder sb = new StringBuilder(); TreeFullJson.TemplateTreeData ff = new TreeFullJson.TemplateTreeData(PlatForm_connectstr, true); sb.AppendFormat("[{0}]", ff.fillTreeView("select Coalesce(fieldLabel,Chinese) as DisplayName,LastEditTime,Establish_Wiki,UserInfor.userName as CreatorName,CompanyID,CreatorID,Coalesce(name,AttributeName) as name,allowBlank,TemplateStateName,blankText,regex,regexText,emptyText,width,height,Type,BidingStandardTaskID,State,TaskTemplateID,TaskTemplateParentID,TaskTemplateCreateDate,DicWordID,ServiceTree.StandardTaskName from TaskTemplate,ServiceTree,Attributes,TemplateState,UserInfor where TaskTemplate.BidingStandardTaskID*=ServiceTree.NodeId and TaskTemplate.CompanyID*=UserInfor.UserID and TaskTemplate.State*=TemplateState.TemplateStateID and TaskTemplate.DicWordID*=Attributes.AttributeID and TaskTemplateParentID is null " + IdentityFilter, new string[] { }, "TaskTemplateID", "TaskTemplateParentID", " TaskTemplate.DicWordID*=Attributes.AttributeID and TaskTemplate.CompanyID*=UserInfor.UserID and TaskTemplate.State*=TemplateState.TemplateStateID and TaskTemplate.BidingStandardTaskID*=ServiceTree.NodeId ")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); return; } else if (OperateType.Equals("TaskTemplate_Search")) { string IdentityFilter = ""; string userType = Session["UserType"].ToString(); TreeFullJson.GetTopParent TNff = new TreeFullJson.GetTopParent(PlatForm_connectstr); if (userType.Equals("PlatFormUser")) { IdentityFilter = ""; } else if (userType.Equals("ENTUser")) { string IDs = string.Join(",", TNff.GetTopNodes("select TaskTemplateID,TaskTemplateParentID from TaskTemplate where CreatorID=-1 and CompanyID=" + Session["ENTID"].ToString(), "TaskTemplateID", "TaskTemplateParentID", "TaskTemplate").ToArray()); if (string.IsNullOrWhiteSpace(IDs)) { IdentityFilter = " and State=0 and Establish_Wiki=1 "; } else { IdentityFilter = " and State=0 and (Establish_Wiki=1 or TaskTemplateID in(" + IDs + ")"; } } else if (userType.Equals("ENTInnerUser")) { string IDs = string.Join(",", TNff.GetTopNodes("select TaskTemplateID,TaskTemplateParentID from TaskTemplate where CreatorID=" + Session["userID"].ToString() + " and CompanyID=" + Session["ENTID"].ToString(), "TaskTemplateID", "TaskTemplateParentID", "TaskTemplate").ToArray()); if (string.IsNullOrWhiteSpace(IDs)) { IdentityFilter = " and State=0 and Establish_Wiki=1 "; } else { IdentityFilter = " and State=0 and (Establish_Wiki=1 or TaskTemplateID in(" + IDs + ")"; } } else { return; } StringBuilder sb = new StringBuilder(); TreeFullJson.TemplateTreeData ff = new TreeFullJson.TemplateTreeData(PlatForm_connectstr, true); if (Request["Name"].ToString().Equals("")) { sb.AppendFormat("[{0}]", ff.fillTreeView("select Coalesce(fieldLabel,Chinese) as DisplayName,LastEditTime,Establish_Wiki,UserInfor.userName as CreatorName,CompanyID,CreatorID,Coalesce(name,AttributeName) as name,allowBlank,TemplateStateName,blankText,regex,regexText,emptyText,width,height,Type,BidingStandardTaskID,State,TaskTemplateID,TaskTemplateParentID,TaskTemplateCreateDate,DicWordID,ServiceTree.StandardTaskName from TaskTemplate,ServiceTree,Attributes,TemplateState,UserInfor where TaskTemplate.BidingStandardTaskID*=ServiceTree.NodeId and TaskTemplate.CompanyID*=UserInfor.UserID and TaskTemplate.State*=TemplateState.TemplateStateID and TaskTemplate.DicWordID*=Attributes.AttributeID and TaskTemplateParentID is null" + IdentityFilter, new string[] { }, "TaskTemplateID", "TaskTemplateParentID", " TaskTemplate.DicWordID*=Attributes.AttributeID and TaskTemplate.CompanyID*=UserInfor.UserID and TaskTemplate.State*=TemplateState.TemplateStateID and TaskTemplate.BidingStandardTaskID*=ServiceTree.NodeId ")); } else { sb.AppendFormat("[{0}]", ff.fillTreeView("select Coalesce(fieldLabel,Chinese) as DisplayName,LastEditTime,Establish_Wiki,UserInfor.userName as CreatorName,CompanyID,CreatorID,Coalesce(name,AttributeName) as name,allowBlank,TemplateStateName,regex,blankText,regexText,emptyText,width,height,Type,BidingStandardTaskID,State,TaskTemplateID,TaskTemplateParentID,TaskTemplateCreateDate,DicWordID,ServiceTree.StandardTaskName from TaskTemplate,ServiceTree,Attributes,TemplateState,UserInfor where TaskTemplate.BidingStandardTaskID*=ServiceTree.NodeId and TaskTemplate.CompanyID*=UserInfor.UserID and TaskTemplate.State*=TemplateState.TemplateStateID and TaskTemplate.DicWordID*=Attributes.AttributeID and TaskTemplateParentID is null and fieldLabel like '%" + Request["Name"].ToString() + "%'" + IdentityFilter, new string[] { }, "TaskTemplateID", "TaskTemplateParentID", " TaskTemplate.DicWordID*=Attributes.AttributeID and TaskTemplate.CompanyID*=UserInfor.UserID and TaskTemplate.State*=TemplateState.TemplateStateID and TaskTemplate.BidingStandardTaskID*=ServiceTree.NodeId ")); } Response.Write(sb.ToString()); Response.End(); Response.Clear(); return; } else if (OperateType.Equals("StandardTaskTypeTree")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(PlatForm_connectstr, false); sb.AppendFormat("[{0}]", ff.fillTreeView("select NodeId,StandardTaskName,PNodeId from ServiceTree where PNodeId is null ", new string[] { "id", "text" }, "NodeId", "PNodeId")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); return; } else if (OperateType.Equals("AddElement")) { string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); string[] WordIDS = Request["WordIDS"].ToString().Split(','); bool flag = true; foreach (string s in WordIDS) { string temp1 = "width,"; string temp = ""; temp += "'" + Request["width"] + "',"; if (Request["AllowEmpty"].Equals("No")) { temp += "'" + Request["blankText"] + "',"; temp += "'0',"; temp1 += "blankText,allowBlank,"; } if (!string.IsNullOrWhiteSpace(Request["emptyText"])) { temp += "'" + Request["emptyText"] + "',"; temp1 += "emptyText,"; } if (Request["AllowRegex"].Equals("Yes")) { temp += "'" + HttpUtility.UrlEncode(Request["regex"]) + "',"; temp += "'" + Request["regexText"] + "',"; temp1 += "regex,regexText,"; } temp += "'" + time + "',"; temp += "'" + Request["ID"] + "',"; string userType = Session["UserType"].ToString(); if (userType.Equals("PlatFormUser")) { temp += "'-1',"; //用户ID temp += "'" + Session["userID"].ToString() + "',"; //企业ID } else if (userType.Equals("ENTUser")) { temp += "'-1',"; //用户ID temp += "'" + Session["userID"].ToString() + "',"; //企业ID } else if (userType.Equals("ENTInnerUser")) { temp += "'" + Session["userID"].ToString() + "',"; //用户ID temp += "'" + Session["ENTID"].ToString() + "',"; //企业ID } else { return; } temp += "'" + s + "'"; temp1 += "TaskTemplateCreateDate,TaskTemplateParentID,CreatorID,CompanyID,DicWordID"; if (!sqlExecute.sqlmanage.ExecuteSQL("insert into TaskTemplate (" + temp1 + ") values (" + temp + ")", PlatForm_connectstr)) { flag = false; } } if (flag) { Response.Write("{success:true,msg:'模板标签元素添加成功!',tr:'another inf'}"); } else { Response.Write("{success:false,msg:'模板标签元素添加失败!',tr:'another inf'}"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("EditElement")) { string sql = "update TaskTemplate set"; sql += " width='" + Request["width"] + "',"; if (!string.IsNullOrWhiteSpace(Request["emptyText"])) { sql += "emptyText='" + Request["emptyText"] + "',"; } else { sql += "emptyText=NULL,"; } if (Request["AllowEmpty"].Equals("No")) { sql += "allowBlank='0',"; sql += "blankText='" + Request["blankText"] + "',"; } else { sql += "allowBlank='1',"; sql += "blankText=NULL,"; } if (Request["AllowRegex"].Equals("Yes")) { sql += "regex='" + HttpUtility.UrlEncode(Request["regex"]) + "',"; sql += "regexText='" + Request["regexText"] + "',"; } else { sql += "regex=NULL,"; sql += "regexText=NULL,"; } sql += "LastEditTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',"; sql = sql.Remove(sql.ToString().LastIndexOf(','), 1); sql += " where TaskTemplateID='" + Request["ID"] + "'"; if (sqlExecute.sqlmanage.ExecuteSQL(sql, PlatForm_connectstr)) { Response.Write("{success:true,msg:'模板标签元素修改成功!',tr:'another inf'}"); } else { Response.Write("{success:false,msg:'模板标签元素修改失败!',tr:'another inf'}"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("MoveElement")) { string sql = "update TaskTemplate set TaskTemplateParentID='" + Request["TargetNodeID"].ToString() + "' where TaskTemplateID=" + Request["NodeID"].ToString(); if (sqlExecute.sqlmanage.ExecuteSQL(sql, PlatForm_connectstr)) { Response.Write("移动成功!"); } else { Response.Write("移动失败!"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("AddRow")) { if (sqlExecute.sqlmanage.HasRecord(PlatForm_connectstr, "select * from TaskTemplate where TaskTemplateParentID=" + Request["ID"].ToString() + " and fieldLabel='" + Request["RowName"].ToString() + "'")) { Response.Write("{success:false,msg:'行名重复!',tr:'another inf'}"); Response.End(); Response.Clear(); return; } else { string CompanyID = ""; string CreatorID = ""; string userType = Session["UserType"].ToString(); if (userType.Equals("PlatFormUser")) { CreatorID = "-1"; //用户ID CompanyID = Session["userID"].ToString(); //企业ID } else if (userType.Equals("ENTUser")) { CreatorID = "-1"; //用户ID CompanyID = Session["userID"].ToString(); //企业ID } else if (userType.Equals("ENTInnerUser")) { CreatorID = Session["userID"].ToString(); //用户ID CompanyID = Session["ENTID"].ToString(); //企业ID } else { return; } string sql1 = "insert into TaskTemplate (fieldLabel,TaskTemplateParentID,name,Type,CompanyID,CreatorID,TaskTemplateCreateDate) values ('" + Request["RowName"].ToString() + "','" + Request["ID"].ToString() + "','colum','R','" + CompanyID + "','" + CreatorID + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')"; if (sqlExecute.sqlmanage.ExecuteSQL(sql1, PlatForm_connectstr)) { Response.Write("{success:true,msg:'模板行添加成功!',tr:'another inf'}"); } else { Response.Write("{success:false,msg:'模板行添加失败!',tr:'another inf'}"); } Response.End(); Response.Clear(); } } else if (OperateType.Equals("EditRow")) { if (!sqlExecute.sqlmanage.HasRecord(PlatForm_connectstr, "select * from TaskTemplate where TaskTemplateParentID=" + Request["ParentID"].ToString() + "and TaskTemplateID<>" + Request["ID"] + " and fieldLabel='" + Request["RowName"].ToString() + "'")) { string sql = "update TaskTemplate set fieldLabel='" + Request["RowName"] + "',LastEditTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where TaskTemplateID='" + Request["ID"] + "'"; if (sqlExecute.sqlmanage.ExecuteSQL(sql, PlatForm_connectstr)) { Response.Write("{success:true,msg:'模板行修改成功!',tr:'another inf'}"); } else { Response.Write("{success:false,msg:'模板行修改失败!',tr:'another inf'}"); } } else { Response.Write("{success:false,msg:'行名重复,请检查行名!',tr:'another inf'}"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("AddMould")) { bool flag = true; if (sqlExecute.sqlmanage.HasRecord(PlatForm_connectstr, "select * from TaskTemplate where TaskTemplateParentID is null and fieldLabel='" + Request["MouldDisplayName"].ToString() + "'")) { flag = false; Response.Write("{success:false,msg:'该模板[名称]已存在!',tr:'another inf'}"); Response.End(); Response.Clear(); return; } if (sqlExecute.sqlmanage.HasRecord(PlatForm_connectstr, "select * from TaskTemplate where TaskTemplateParentID is null and name='" + Request["MouldName"].ToString() + "'")) { flag = false; Response.Write("{success:false,msg:'该模板[提交名]已存在!',tr:'another inf'}"); Response.End(); Response.Clear(); return; } if (flag) { string CompanyID = ""; string CreatorID = ""; string userType = Session["UserType"].ToString(); if (userType.Equals("PlatFormUser")) { CreatorID = "-1"; //用户ID CompanyID = Session["userID"].ToString(); //企业ID } else if (userType.Equals("ENTUser")) { CreatorID = "-1"; //用户ID CompanyID = Session["userID"].ToString(); //企业ID } else if (userType.Equals("ENTInnerUser")) { CreatorID = Session["userID"].ToString(); //用户ID CompanyID = Session["ENTID"].ToString(); //企业ID } else { return; } string sql = "insert into TaskTemplate (name,BidingStandardTaskID,fieldLabel,Type,State,CompanyID,CreatorID,TaskTemplateCreateDate) values ('" + Request["MouldName"].ToString() + "','" + Request["StandardTaskID"].ToString() + "','" + Request["MouldDisplayName"].ToString() + "','T','0','" + CompanyID + "','" + CreatorID + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')"; if (sqlExecute.sqlmanage.ExecuteSQL(sql, PlatForm_connectstr)) { Response.Write("{success:true,msg:'模板添加成功!',tr:'another inf'}"); } else { Response.Write("{success:false,msg:'模板添加失败!',tr:'another inf'}"); } Response.End(); Response.Clear(); } } else if (OperateType.Equals("EditMould")) { bool flag = true; if (sqlExecute.sqlmanage.HasRecord(PlatForm_connectstr, "select * from TaskTemplate where TaskTemplateID<>" + Request["ID"] + " and fieldLabel='" + Request["MouldDisplayName"].ToString() + "'")) { flag = false; Response.Write("{success:false,msg:'该模板[名称]已存在!',tr:'another inf'}"); Response.End(); Response.Clear(); return; } if (sqlExecute.sqlmanage.HasRecord(PlatForm_connectstr, "select * from TaskTemplate where TaskTemplateID<>" + Request["ID"] + " and name='" + Request["MouldName"].ToString() + "'")) { flag = false; Response.Write("{success:false,msg:'该模板[提交名]已存在!',tr:'another inf'}"); Response.End(); Response.Clear(); return; } if (flag) { string sql = "update TaskTemplate set name='" + Request["MouldName"] + "', fieldLabel='" + Request["MouldDisplayName"] + "', BidingStandardTaskID='" + Request["StandardTaskID"] + "', LastEditTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where TaskTemplateID='" + Request["ID"] + "'"; if (sqlExecute.sqlmanage.ExecuteSQL(sql, PlatForm_connectstr)) { Response.Write("{success:true,msg:'模板修改成功!',tr:'another inf'}"); } else { Response.Write("{success:false,msg:'模板修改失败!',tr:'another inf'}"); } Response.End(); Response.Clear(); } } else if (OperateType.Equals("DeleteNodes")) { SQLToTreeJson.TreeJson tj = new SQLToTreeJson.TreeJson(); string IDs = String.Join(",", tj.getChildID("TaskTemplate", PlatForm_connectstr, "TaskTemplateID", "TaskTemplateParentID", "select * from TaskTemplate where TaskTemplateID in(" + Request["IDs"].ToString() + ")")); if (sqlExecute.sqlmanage.ExecuteSQL("delete from TaskTemplate where TaskTemplateID in (" + IDs + ")", PlatForm_connectstr)) { Response.Write("删除成功!"); } else { Response.Write("删除失败!"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("CreateMould")) { string path = Server.MapPath("~/") + "\\TaskMould"; CreateTastMudole.TaskCreate sss = new CreateTastMudole.TaskCreate(Request["ID"].ToString()); if (sss.CreateTaskTemplate(path)) { sqlExecute.sqlmanage.ExecuteSQL("update TaskTemplate set state=2 where TaskTemplateID=" + Request["ID"].ToString(), PlatForm_connectstr); Response.Write("模板生成成功!"); } else { Response.Write("模板生成失败!"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("PromoteTemplate")) { if (sqlExecute.sqlmanage.ExecuteSQL("update TaskTemplate set state=4 where TaskTemplateID=" + Request["ID"].ToString(), PlatForm_connectstr)) { Response.Write("模板提升成功!"); } else { Response.Write("模板提升失败!"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("ConfirmFinish")) { if (sqlExecute.sqlmanage.ExecuteSQL("update TaskTemplate set state=1 where TaskTemplateID=" + Request["ID"].ToString(), PlatForm_connectstr)) { Response.Write("模板创建完成确认成功!"); } else { Response.Write("模板创建完成确认失败!"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("AbolishTemplate")) { if (sqlExecute.sqlmanage.ExecuteSQL("update TaskTemplate set state=5 where TaskTemplateID=" + Request["ID"].ToString(), PlatForm_connectstr)) { Response.Write("模板创建完成确认成功!"); } else { Response.Write("模板创建完成确认失败!"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("UseAgain")) { if (sqlExecute.sqlmanage.ExecuteSQL("update TaskTemplate set state=0 where TaskTemplateID=" + Request["ID"].ToString(), PlatForm_connectstr)) { Response.Write("模板创建完成确认成功!"); } else { Response.Write("模板创建完成确认失败!"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("NoEditable_Template")) { if (sqlExecute.sqlmanage.ExecuteSQL("update TaskTemplate set Establish_Wiki=2 where TaskTemplateID=" + Request["ID"].ToString(), PlatForm_connectstr)) { Response.Write("禁止编辑操作成功!"); } else { Response.Write("禁止编辑操作失败!"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("Use_Wiki")) { if (sqlExecute.sqlmanage.ExecuteSQL("update TaskTemplate set Establish_Wiki=1 where TaskTemplateID=" + Request["ID"].ToString(), PlatForm_connectstr)) { Response.Write("wiki启用成功!"); } else { Response.Write("wiki启用失败!"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("UnUse_Wiki")) { if (sqlExecute.sqlmanage.ExecuteSQL("update TaskTemplate set Establish_Wiki=0 where TaskTemplateID=" + Request["ID"].ToString(), PlatForm_connectstr)) { Response.Write("wiki禁用成功!"); } else { Response.Write("wiki禁用失败!"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("LoadTemplate")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(PlatForm_connectstr, true); sb.AppendFormat("[{0}]", ff.fillTreeView("select TaskTemplateID, Coalesce(fieldLabel,Chinese) as fieldLabel,TaskTemplateParentID,Type from TaskTemplate,Attributes where TaskTemplate.DicWordID*=Attributes.AttributeID and State=4 and TaskTemplateParentID is null and TaskTemplateID<>" + Request["CheckedTemPlateID"].ToString(), new string[] { "id", "text" }, "TaskTemplateID", "TaskTemplateParentID", " TaskTemplate.DicWordID*=Attributes.AttributeID ")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); } else if (OperateType.Equals("LoadTemplateByID")) { StringBuilder sb = new StringBuilder(); TreeFullJson.TreeFullJson ff = new TreeFullJson.TreeFullJson(PlatForm_connectstr, true); sb.AppendFormat("[{0}]", ff.fillTreeView("select TaskTemplateID, Coalesce(fieldLabel,Chinese) as fieldLabel,TaskTemplateParentID,Type from TaskTemplate,Attributes where TaskTemplate.DicWordID*=Attributes.AttributeID and TaskTemplateParentID is null and TaskTemplateID=" + Request["CheckedTemPlateID"].ToString(), new string[] { "id", "text" }, "TaskTemplateID", "TaskTemplateParentID", " TaskTemplate.DicWordID*=Attributes.AttributeID ")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); } else if (OperateType.Equals("InheritTemplates")) { string InheriteTemplateType = Request["InheriteTemplateType"].ToString(); string Type = Request["Type"].ToString(); InheritTemplate.InheritTemplate tt = new InheritTemplate.InheritTemplate(PlatForm_connectstr); bool flag = true; if (Type.Equals("T") && InheriteTemplateType.Equals("T")) { if (!CheckRow("select fieldLabel from TaskTemplate where TaskTemplateParentID=" + Request["TemplateID"].ToString(), "select fieldLabel from TaskTemplate where TaskTemplateParentID=" + Request["InheriteTemplateID"].ToString(), PlatForm_connectstr)) { Response.Write("{success:false,msg:'要继承的行名和现有行名重复!'}"); Response.End(); Response.Clear(); return; } if (!CheckAtt("select DicWordID from TaskTemplate where TaskTemplateParentID in ( select TaskTemplateID from TaskTemplate where TaskTemplateParentID=" + Request["TemplateID"].ToString() + ")", "select DicWordID from TaskTemplate where TaskTemplateParentID in ( select TaskTemplateID from TaskTemplate where TaskTemplateParentID=" + Request["InheriteTemplateID"].ToString() + ")", PlatForm_connectstr)) { Response.Write("{success:false,msg:'要继承的属性名和现有属性名重复!'}"); Response.End(); Response.Clear(); return; } flag = tt.InheritTemplateT(Request["TemplateID"].ToString(), Request["InheriteTemplateID"].ToString()); } else if (Type.Equals("T") && InheriteTemplateType.Equals("R")) { if (!CheckRow("select fieldLabel from TaskTemplate where TaskTemplateParentID=" + Request["TemplateID"].ToString(), "select fieldLabel from TaskTemplate where TaskTemplateID=" + Request["InheriteTemplateID"].ToString(), PlatForm_connectstr)) { Response.Write("{success:false,msg:'要继承的行名和现有行名重复!'}"); Response.End(); Response.Clear(); return; } if (!CheckAtt("select DicWordID from TaskTemplate where TaskTemplateParentID in ( select TaskTemplateID from TaskTemplate where TaskTemplateParentID=" + Request["TemplateID"].ToString() + ")", "select DicWordID from TaskTemplate where TaskTemplateParentID =" + Request["InheriteTemplateID"].ToString(), PlatForm_connectstr)) { Response.Write("{success:false,msg:'要继承的属性名和现有属性名重复!'}"); Response.End(); Response.Clear(); return; } flag = tt.InheritRow(Request["TemplateID"].ToString(), Request["InheriteTemplateID"].ToString()); } else if (Type.Equals("R") && InheriteTemplateType.Equals("R")) { if (!CheckAtt("select DicWordID from TaskTemplate where TaskTemplateParentID in ( select TaskTemplateID from TaskTemplate where TaskTemplateParentID in ( select TaskTemplateParentID from TaskTemplate where TaskTemplateID=" + Request["TemplateID"].ToString() + " ))", "select DicWordID from TaskTemplate where TaskTemplateParentID =" + Request["InheriteTemplateID"].ToString(), PlatForm_connectstr)) { Response.Write("{success:false,msg:'要继承的属性名和现有属性名重复!'}"); Response.End(); Response.Clear(); return; } flag = tt.InheritRow_Row(Request["TemplateID"].ToString(), Request["InheriteTemplateID"].ToString()); } else if (Type.Equals("R") && InheriteTemplateType.Equals("A")) { if (!CheckAtt("select DicWordID from TaskTemplate where TaskTemplateParentID in ( select TaskTemplateID from TaskTemplate where TaskTemplateParentID in ( select TaskTemplateParentID from TaskTemplate where TaskTemplateID=" + Request["TemplateID"].ToString() + " ))", "select DicWordID from TaskTemplate where TaskTemplateID =" + Request["InheriteTemplateID"].ToString(), PlatForm_connectstr)) { Response.Write("{success:false,msg:'要继承的属性名和现有属性名重复!'}"); Response.End(); Response.Clear(); return; } flag = tt.InheritAttribute(Request["TemplateID"].ToString(), Request["InheriteTemplateID"].ToString()); } else { Response.Write("{success:false,msg:'不能实现你所选的继承或出现继承出现错误!'}"); Response.End(); Response.Clear(); return; } if (flag) { Response.Write("{success:true,msg:'继承成功!'}"); } else { Response.Write("{success:false,msg:'继承失败!'}"); } Response.End(); Response.Clear(); return; } } }
protected void Page_Load(object sender, EventArgs e) { string connectstr = Session["connectstr"].ToString(); if (Request["OperateType"] != null) { string OperateType = Request["OperateType"].ToString(); 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,DeptList.部门名称 as Department,ProjList.项目名称 as ProjectName from ProjectTaskTree,EmployeeList E1,EmployeeList E2,ProjList,DeptList where ParentID is null and ProjectTaskTree.Creator=E1.人员ID and ProjectTaskTree.Chargor=E2.人员ID and ProjectTaskTree.ProjectID=ProjList.序号 and E2.归属部门=DeptList.部门编号 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.序号 and E2.归属部门=DeptList.部门编号 ")); Response.Write(sb.ToString()); Response.End(); Response.Clear(); } else if (OperateType.Equals("AddProjectTaskTreeNode")) { string sql1 = "insert into ProjectTaskTree (ParentID,Name,CreateDate,Creator,Chargor,ProjectID) values ('" + Request["ID"].ToString() + "','" + Request["Name"].ToString() + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + Session["userID"].ToString() + "','" + Request["Chargor"].ToString() + "','" + Request["ProjectID"].ToString() + "')"; if (sqlExecute.sqlmanage.ExecuteSQL(sql1, connectstr)) { Response.Write("{success:true,msg:'节点添加成功!',tr:'another inf'}"); } else { Response.Write("{success:false,msg:'节点行添加失败!',tr:'another inf'}"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("EditProjectTaskTreeNode")) { string sql = "update ProjectTaskTree set Name='" + Request["Name"].ToString() + "', Chargor='" + Request["Chargor"].ToString() + "' where ID='" + Request["ID"].ToString() + "'"; if (sqlExecute.sqlmanage.ExecuteSQL(sql, connectstr)) { Response.Write("{success:true,msg:'节点修改成功!',tr:'another inf'}"); } else { Response.Write("{success:true,msg:'节点修改失败!',tr:'another inf'}"); } Response.End(); Response.Clear(); } else if (OperateType.Equals("DeleteProjectTaskTreeNode")) { SQLToTreeJson.TreeJson tj = new SQLToTreeJson.TreeJson(); string IDs = String.Join(",", tj.getChildID("ProjectTaskTree", connectstr, "ID", "ParentID", "select * from ProjectTaskTree where ID in(" + Request["IDs"].ToString() + ")")); if (sqlExecute.sqlmanage.ExecuteSQL("delete from ProjectTaskTree where ID in (" + IDs + ")", connectstr)) { Response.Write("删除成功!"); } else { Response.Write("删除失败!"); } Response.End(); Response.Clear(); } } }