protected void Page_Load(object sender, EventArgs e) { connectstr = Session["connectstr"].ToString(); string userID = Session["userID"].ToString(); if (connectstr != "") { TreeFullJson.GetTopParent ProjectNode = new TreeFullJson.GetTopParent(connectstr); // ArrayList ProjectNodeIDs = ProjectNode.GetTopNodes("select ID,ParentID from ProjectTaskTree where Creator=" + userID + " or Chargor=" + userID, "ID", "ParentID", "ProjectTaskTree"); //string projectIDs= string.Join(",", ProjectNodeIDs); // 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["prjOperaType"]))//如果没有传来的projectname的值就显示所有文档EmployeeList { 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) and ProjList.项目负责人*=E1.人员ID and ProjList.项目创建人*=E2.人员ID and ProjList.项目类型*=ProjectType.TypeID and ProjList.项目状态*=ProjectState.StateID "; getcountSql = "select 序号 from ProjList"; } else if (Request["prjOperaType"].Equals("search")) { string filter = ""; if (Request["PrjName"] != null && !Request["PrjName"].ToString().Equals("")) { filter += " and 项目名称 like '%" + Request["PrjName"].ToString().Trim() + "%'"; } if (Request["PrjCustomer"] != null && !Request["PrjCustomer"].ToString().Equals("")) { filter += " and 项目客户名称 like '%" + Request["PrjCustomer"].ToString().Trim() + "%'"; } if (Request["PrjState"] != null && !Request["PrjState"].ToString().Equals("")) { filter += " and 项目状态='" + Request["PrjState"].ToString().Trim() + "'"; } if (Request["PrjDutyPeople"] != null && !Request["PrjDutyPeople"].ToString().Equals("")) { filter += " and 项目负责人='" + Request["PrjDutyPeople"].ToString().Trim() + "'"; } if (Request["PrjType"] != null && !Request["PrjType"].ToString().Equals("")) { filter += " and 项目类型='" + Request["PrjType"].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 { //sql = "select top " + limit + " 人员编号,人员名称,性别,出生年月,学历,移动电话,固定电话,Email,QQ号,通讯地址,进厂日期,归属部门,归属角色,第二角色,档案号,培训情况,密码,所属工作组" + // " from EmployeeList where 人员编号 not in (select top " + start // + " 人员编号 from EmployeeList) and 归属角色='" + roletype + "'"; //getcountSql = "select 人员编号" + " from EmployeeList where 归属角色='" + roletype + "')"; } //context.Response.ContentType = "text/plain"; //context.Response.Write("Hello World"); 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("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; } } }