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