//显示数据，树形
public ActionResult GetModels(ACEPagination pagination, string keyword)
{
try
{
var pagedData = IdalCommon.IareaEx.getEntityList();
//PagedData<area> pagedData = IdalCommon.IareaEx.GetPageData(pagination, keyword);
// var data = pageData.DataList;
if (!string.IsNullOrEmpty(keyword))
{
if (IdalCommon.IareaEx.changeParse(keyword))
{
pagedData = TreeJson.TreeWhere(pagedData, a => a.encode.Contains(keyword), a => a.id.ToString(), a => a.parentid.ToString());
}
else
{
pagedData = TreeJson.TreeWhere(pagedData, a => a.fullname.Contains(keyword), a => a.id.ToString(), a => a.parentid.ToString());
}
}
List <DataTableTree> ret = new List <DataTableTree>(); //构建区域树
DataTableTree.AppendChildren(pagedData, ref ret, null, 0, a => a.id.ToString(), a => a.parentid); //将id、parentid需转化成string型
return(this.SuccessData(ret));
}
catch (Exception)
{
return(this.FailedMsg("显示出错"));
}
}
protected void Page_Load(object sender, EventArgs e)
{
int start = 0;
int limit = 10;
string sql;
string getcountSql;
// 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();
Session["PlatForm_connectstr"] = PlatForm_connectstr;
if (Request["OperateType"] == null || Request["OperateType"].ToString().Equals("LoadAllTopic"))
{
sql = "select top " + limit + " Forum_Topic.*,UserInfor.userName as CreatorName,TaskTemplate.fieldLabel as TemplateName " +
" from Forum_Topic,UserInfor,TaskTemplate where ID not in (select top " + start
+ " ID from Forum_Topic) and Forum_Topic.CompanyID *=UserInfor.UserID and Forum_Topic.TemplateID*=TaskTemplate.TaskTemplateID order by CreateTime desc";
getcountSql = "select ID from Forum_Topic ";
Response.Write(GetTopicData(sql, getcountSql, PlatForm_connectstr));
Response.End();
Response.Clear();
}
else if (Request["OperateType"].ToString().Equals("LoadTopicByTempalte"))
{
string[] childIDs = new TreeJson().getChildID("TaskTemplate", PlatForm_connectstr, "TaskTemplateID", "TaskTemplateParentID", "select TaskTemplateID,TaskTemplateParentID from TaskTemplate where TaskTemplateID=" + Request["TempalteID"].ToString());
sql = "select Forum_Topic.*,UserInfor.userName as CreatorName,TaskTemplate.fieldLabel as TemplateName " +
" from Forum_Topic,UserInfor,TaskTemplate where Forum_Topic.CompanyID *=UserInfor.UserID and Forum_Topic.TemplateID*=TaskTemplate.TaskTemplateID and TemplateID in (" + string.Join(",", childIDs) + ") order by CreateTime desc";
getcountSql = "select ID from Forum_Topic where TemplateID in (" + string.Join(",", childIDs) + ") ";
Response.Write(GetTopicData(sql, getcountSql, PlatForm_connectstr));
Response.End();
Response.Clear();
}
}
/// <summary>
/// 查看数据
/// </summary>
/// <param name="keyword">搜索框关键词</param>
/// <returns></returns>
public ActionResult GetModels(ACEPagination pagination, string keyword)
{
try
{
//resourceEx reex = new resourceEx();
//分页代码
//return this.SuccessData(IdalCommon.IresourceEx.GetTreePageData(pagination, keyword));
#region
var pagedData = IdalCommon.IresourceEx.getEntityList();
if (!string.IsNullOrEmpty(keyword))
{
pagedData = TreeJson.TreeWhere(pagedData, a => a.resourcename.Contains(keyword), a => a.id.ToString(), a => a.resourceowner);
}
List <DataTableTree> ret = new List <DataTableTree>();
DataTableTree.AppendChildren(pagedData, ref ret, null, 0, a => a.id.ToString(), a => a.resourceowner);
return(this.SuccessData(ret));
#endregion
}
catch (Exception)
{
return(this.FailedMsg("出错！"));
}
}
/// <summary>
/// 组树的加载
/// </summary>
/// <param name="userId">用户id</param>
/// <returns></returns>
public ActionResult GetPermissionGroupTree(string userId)
{
//所有的组
var groupData = IdalCommon.IgroupEx.getEntityList();
//此用户拥有的所有的组
var authorizeData = new List <group>();
if (!string.IsNullOrEmpty(userId))
{
//获取这个用户所有的组
authorizeData = IdalCommon.IuserGroupEx.getGroupList(int.Parse(userId));//this.CreateService<IRoleAuthorizeAppService>().GetList(roleId);
}
var treeList = new List <ACETreeEntity>();
foreach (group r in groupData)
{
ACETreeEntity tree = new ACETreeEntity();
bool hasChildren = groupData.Any(a => a.id == r.id);
tree.id = r.id;
tree.Text = r.groupname;
// tree.Value = r.EnCode;
tree.ParentId = null;
tree.Isexpand = false;
tree.Complete = true;
tree.Showcheck = true;
tree.Checkstate = authorizeData.Count(t => t.id == r.id);
tree.HasChildren = hasChildren;
//tree.Img = r.Icon == "" ? "" : r.Icon;
treeList.Add(tree);
}
return(Content(TreeJson.ConvertToJson(treeList)));
}
/// <summary>
/// 动作树的加载
/// </summary>
/// <param name="roleId">角色id</param>
/// <returns></returns>
public ActionResult GetPermissionActionTree(string roleId)
{
//所有的动作
var actionData = IdalCommon.IactionEx.getEntityList();
//此角色拥有的所有的资源
var authorizeData = new List <action>();
if (!string.IsNullOrEmpty(roleId))
{
//获取这个角色所有的资源
authorizeData = IdalCommon.IroleActionEx.getRoleAllAction(int.Parse(roleId));//this.CreateService<IRoleAuthorizeAppService>().GetList(roleId);
}
var treeList = new List <ACETreeEntity>();
foreach (action r in actionData)
{
ACETreeEntity tree = new ACETreeEntity();
bool hasChildren = actionData.Any(a => a.actionowner == r.id.ToString());
tree.id = r.id;
tree.Text = r.actionname;
// tree.Value = r.EnCode;
tree.ParentId = null;
tree.Isexpand = true;
tree.Complete = true;
tree.Showcheck = true;
tree.Checkstate = authorizeData.Count(t => t.id == r.id);
tree.HasChildren = hasChildren;
//tree.Img = r.Icon == "" ? "" : r.Icon;
treeList.Add(tree);
}
return(Content(TreeJson.ConvertToJson(treeList)));
}
protected void Page_Load(object sender, EventArgs e)
{
connectstr = Session["connectstr"].ToString();
string PlatForm_connectstr = Session["PlatForm_connectstr"].ToString();
if (connectstr != "")
{
string sss = "select * from ProjectTaskTree where Creator=" + Session["userID"].ToString() + " or Chargor=" + Session["userID"].ToString();
string[] childIDs = new TreeJson().getChildID("ProjectTaskTree", connectstr, "ID", "ParentID", sss);
string IDs = string.Join(",", childIDs);
if (!string.IsNullOrEmpty(Request["limit"]))
{
limit = int.Parse(Request["limit"]);
}
if (!string.IsNullOrEmpty(Request["start"]))
{
start = int.Parse(Request["start"]);
}
if (string.IsNullOrEmpty(Request["OperateType"]))//如果没有传来的projectname的值就显示所有文档EmployeeList
{
sql = "Set ARITHABORT ON select top " + limit +
" TaskList.*,TaskState.TaskStateName,TaskDetailInf.value('(/Task/@StandardTaskID)[1]','int') as TaskTemplateID,TaskDetailInf.value('(//TaskName)[1]','varchar(50)') as TaskName,EmployeeList.人员名称 as CreatorName,P1.Name as ProjectName,P2.Name as PrjTaskTreeName from TaskList,TaskState,EmployeeList,ProjectTaskTree P1,ProjectTaskTree P2 where TaskID not in (select top " + start
+ " TaskID from TaskList where BelongProjectTreeNode in (" + IDs + ") and TaskState=0 order by TaskCreateDate ) and TaskState=0 and TaskList.TaskState= TaskState.TaskStateID and TaskList.TaskCreator=EmployeeList.人员ID and TaskList.BelongProject=P1.ID and TaskList.BelongProjectTreeNode=P2.ID and TaskList.BelongProjectTreeNode in (" + IDs + ") order by TaskCreateDate";
getcountSql = "select TaskID from TaskList where BelongProjectTreeNode in (" + IDs + ") and TaskState=0";
}
else
{
TreeJson ss = new TreeJson();
string filter = "";
if (Request["StandardTaskID"] != null && !Request["StandardTaskID"].ToString().Equals(""))
{
string[] tempIDs = ss.getChildID("StandardTask", PlatForm_connectstr, "StandardTaskID", "StandardTaskParentID", "select StandardTaskID from StandardTask where StandardTaskID=" + Request["StandardTaskID"].ToString());
filter += " and TaskDetailInf.value('(/Task/@StandardTaskID)[1]','int') in (" + string.Join(",", tempIDs) + ")";
}
if (Request["ProjectTaskID"] != null && !Request["ProjectTaskID"].ToString().Equals(""))
{
string[] tempIDs = ss.getChildID("ProjectTaskTree", connectstr, "ID", "ParentID", "select ID from ProjectTaskTree where ID=" + Request["ProjectTaskID"].ToString());
filter += " and BelongProjectTreeNode in (" + string.Join(",", tempIDs) + ")";
}
if (Request["TaskName"] != null && !Request["TaskName"].ToString().Equals(""))
{
filter += " and TaskDetailInf.value('(//TaskName)[1]','varchar(50)') like '%" + Request["TaskName"].ToString().Trim() + "%'";
}
sql = "Set ARITHABORT ON select " +
" TaskList.*,TaskState.TaskStateName,TaskDetailInf.value('(/Task/@StandardTaskID)[1]','int') as TaskTemplateID,TaskDetailInf.value('(//TaskName)[1]','varchar(50)') as TaskName,EmployeeList.人员名称 as CreatorName,P1.Name as ProjectName,P2.Name as PrjTaskTreeName " +
" from TaskList,EmployeeList,TaskState,ProjectTaskTree P1,ProjectTaskTree P2 where TaskList.TaskState= TaskState.TaskStateID and TaskList.TaskCreator=EmployeeList.人员ID and TaskList.BelongProject=P1.ID and TaskList.BelongProjectTreeNode=P2.ID and TaskList.BelongProjectTreeNode in (" + IDs + ") " + filter + " order by TaskCreateDate";
getcountSql = "Set ARITHABORT ON select TaskID from TaskList where BelongProjectTreeNode in (" + IDs + ") and TaskState=0 " + filter;
}
SQLToJson.ReaderSQLToJson.SetCount(getcountSql, connectstr);
Response.Write(GetJsonStr(sql));
Response.End();
Response.Clear();
}
}
protected void Page_Load(object sender, EventArgs e)
{
connectstr = Session["connectstr"].ToString();
string PlatForm_connectstr = Session["PlatForm_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["OperateType"]))//如果没有传来的projectname的值就显示所有文档EmployeeList
{
sql = "select top " + limit +
" ApplyForService.*,UserInfor.userName,TaskDetailInf.value('(//TaskName)[1]','varchar(50)') as TaskName,ServResource.资源名称 as ServiceName from ApplyForService,UserInfor,TaskList,ServResource where ID not in (select top " + start
+ " ID from ApplyForService) and ApplyForService.ApplicantEntID*=UserInfor.UserID and ApplyForService.TaskID*=TaskList.ID and ApplyForService.ServiceID*=ServResource.资源编号";
getcountSql = "select ID from ApplyForService";
}
else if (Request["OperateType"].Equals("search"))
{
TreeJson ss = new TreeJson();
string filter = "";
if (Request["StandardTaskID"] != null && !Request["StandardTaskID"].ToString().Equals(""))
{
string[] tempIDs = ss.getChildID("StandardTask", PlatForm_connectstr, "StandardTaskID", "StandardTaskParentID", "select StandardTaskID from StandardTask where StandardTaskID=" + Request["StandardTaskID"].ToString());
filter += " and TaskDetailInf.value('(/Task/@StandardTaskID)[1]','int') in (" + string.Join(",", tempIDs) + ")";
}
if (Request["ProjectTaskID"] != null && !Request["ProjectTaskID"].ToString().Equals(""))
{
string[] tempIDs = ss.getChildID("ProjectTaskTree", connectstr, "ID", "ParentID", "select ID from ProjectTaskTree where ID=" + Request["ProjectTaskID"].ToString());
filter += " and BelongProjectTreeNode in (" + string.Join(",", tempIDs) + ")";
}
if (Request["TaskName"] != null && !Request["TaskName"].ToString().Equals(""))
{
filter += " and TaskDetailInf.value('(//TaskName)[1]','varchar(50)') like '%" + Request["TaskName"].ToString().Trim() + "%'";
}
sql = "Set ARITHABORT ON select " +
" TaskList.*,TaskState.TaskStateName,TaskDetailInf.value('(/Task/@StandardTaskID)[1]','int') as TaskTemplateID,TaskDetailInf.value('(//TaskName)[1]','varchar(50)') as TaskName,EmployeeList.人员名称 as CreatorName,P1.Name as ProjectName,P2.Name as PrjTaskTreeName " +
" from TaskList,EmployeeList,TaskState,ProjectTaskTree P1,ProjectTaskTree P2 where TaskList.TaskState= TaskState.TaskStateID and TaskList.TaskCreator=EmployeeList.人员ID and TaskList.BelongProject=P1.ID and TaskList.BelongProjectTreeNode=P2.ID " + filter;
getcountSql = "Set ARITHABORT ON select TaskID from TaskList where TaskID >-1 " + filter;
}
SQLToJson.ReaderSQLToJson.SetCount(getcountSql, connectstr);
Response.Write(GetJsonStr(sql));
Response.End();
Response.Clear();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//connectstr = Session["connectstr"].ToString();
string PlatForm_connectstr = Session["PlatForm_connectstr"].ToString();
if (PlatForm_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["OperateType"]))//如果没有传来的projectname的值就显示所有文档EmployeeList
{
string filter = " Type ='任务' ";
sql = "Set ARITHABORT ON select top " + limit +
" TaskList.*,WorkFlow.WorkFlowName,TaskState.TaskStateName,TaskName,ServiceTree.StandardTaskName,UserInfor.userName as EntName from TaskList,WorkFlow,TaskState,UserInfor,ServiceTree where TaskList.ID not in (select top " + start
+ " ID from TaskList where " + filter + ") and TaskList.WorkFlowID*=WorkFlow.ID and TaskList.TaskState*= TaskState.TaskStateID and TaskList.Publisher*=UserInfor.UserID and TaskDetailInf.value('(/Task/@StandardTaskID)[1]','int')*=ServiceTree.NodeId and" + filter;
getcountSql = "select ID from TaskList where " + filter;
}
else if (Request["OperateType"].Equals("search"))
{
string filter = " and Type ='任务' ";
if (Request["StandardTaskID"] != null && !Request["StandardTaskID"].ToString().Equals(""))
{
TreeJson ss = new TreeJson();
string[] tempIDs = ss.getChildID("ServiceTree", PlatForm_connectstr, "NodeId", "PNodeId", "select NodeId,PNodeId from ServiceTree where NodeId=" + Request["StandardTaskID"].ToString());
filter += " and TaskDetailInf.value('(/Task/@StandardTaskID)[1]','int') in (" + string.Join(",", tempIDs) + ")";
}
if (Request["TaskName"] != null && !Request["TaskName"].ToString().Equals(""))
{
filter += " and TaskName like '%" + Request["TaskName"].ToString() + "%'";
}
if (Request["TaskEnt"] != null && !Request["TaskEnt"].ToString().Equals(""))
{
filter += " and TaskList.Publisher in ( select UserID from UserInfor where userName like '%" + Request["TaskEnt"].ToString() + "%' )";
}
sql = "Set ARITHABORT ON select top " + limit +
" TaskList.*,WorkFlow.WorkFlowName,TaskState.TaskStateName,TaskName,ServiceTree.StandardTaskName,UserInfor.userName as EntName from TaskList,WorkFlow,TaskState,UserInfor,ServiceTree where TaskList.ID not in (select top " + start
+ " ID from TaskList where ID >-1 " + filter + " order by ID ) and TaskList.WorkFlowID*=WorkFlow.ID and TaskList.TaskState*= TaskState.TaskStateID and TaskList.Publisher*=UserInfor.UserID and TaskDetailInf.value('(/Task/@StandardTaskID)[1]','int')*=ServiceTree.NodeId " + filter + " order by TaskList.ID";
getcountSql = " select ID from TaskList where ID >-1 " + filter;
}
SQLToJson.ReaderSQLToJson.SetCount(getcountSql, PlatForm_connectstr);
Response.Write(GetJsonStr(sql, PlatForm_connectstr));
Response.End();
Response.Clear();
}
}
protected void GetWestTreeJson()
{
String ResID = Request.QueryString["ResID"];
// String UserID = Request.QueryString["UserID"];
string str = "[]";
if (ResID != "" && ResID != null)
{
str = TreeJson.GetJson(ResID, CurrentUser);
}
Response.Write(str);
}
/// <summary>
/// 显示页面
/// </summary>
/// <returns></returns>
//public override ActionResult Index()
//{
// return View();
//}
public override ActionResult Index()
{
var data = IdalCommon.IareaEx.getEntityList();
var treeList = new List <TreeSelectModel>();
foreach (area item in data)
{
TreeSelectModel treeModel = new TreeSelectModel();
treeModel.id = item.id.ToString();
treeModel.text = item.fullname;
treeModel.parentId = item.parentid;
treeList.Add(treeModel);
}
this.ViewBag.AreaString = TreeJson.ConvertToJson(treeList);
string strjson = TreeJson.ConvertToJson(treeList);
return(View());
}
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();
}
}
}
/// <summary>
/// 显示页面BootstrapTemplate
/// </summary>
/// <returns></returns>
//public override ActionResult Index()
//{
// return View();
//}
/// <summary>
/// 显示页面ACE(页面视图入口)
/// </summary>
/// <returns></returns>
public override ActionResult Index()
{
var data = IdalCommon.IresourceEx.getEntityList();
var treeList = new List <TreeSelectModel>();
//菜单下拉集合
List <SelectOption> resourceList = SelectOption.CreateList(IdalCommon.IresourceEx.getEntityList(), "id", "resourcename");
this.ViewBag.MenusList = resourceList;
this.ViewBag.MenusListString = Athena.common.Util.Json.ToJson(resourceList);
foreach (resource item in data)
{
TreeSelectModel treeModel = new TreeSelectModel();
treeModel.id = item.id.ToString();
treeModel.text = item.resourcename;
treeModel.parentId = item.resourceowner;
treeList.Add(treeModel);
}
this.ViewBag.Menus = TreeJson.ConvertToJson(treeList);//数据json格式数据
// this.ViewBag.padata = TreeJson.PageConvertToJson(this.SuccessDatajson(ret));//分页格式数据
return(View());
}
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;
}
}
}
/// <summary>
/// 获取案件目录
/// </summary>
/// <param name="Request"></param>
/// <param name="isAll">是否获取所有目录，false为只有已分配的</param>
/// <param name="isChecked">是否默认选中</param>
/// <returns></returns>
public string GetMlTreeEx(System.Web.HttpRequest Request, bool isAll, bool isChecked)
{
string bmsah = HttpUtility.UrlDecode(HttpUtility.UrlDecode(Request.Form["bmsah"]));
string parneid = Request["pid"];
string ischecked = Request["ischecked"];
string yjxh = Request["yjxh"] ?? "";
string sfsm = Request.Form["wjtype"];
string strMlWhere = " and SFSC='N'";
string where = " and level < 3";
string withWhere = " and FMLBH is null";
object[] values = new object[2];
if (!string.IsNullOrEmpty(bmsah))
{
strMlWhere += " and BMSAH=:BMSAH";
values[0] = bmsah;
}
//判断存在父级编码
if (!string.IsNullOrEmpty(parneid))
{
withWhere = " and FMLBH =:FMLBH";
values[1] = parneid;
}
if (!string.IsNullOrEmpty(sfsm) && sfsm == "N")
{
withWhere += " and SFSM='N'";
}
EDRS.BLL.YX_DZJZ_JZML bll = new EDRS.BLL.YX_DZJZ_JZML(Request);
DataSet ds = bll.GetListByTreeEx(strMlWhere, where, withWhere, true, StringPlus.ReplaceSingle(yjxh), isAll, values);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0].Copy();
dt.Columns["MLBH"].ColumnName = "ID";
dt.Columns["FMLBH"].ColumnName = "PARENTID";
dt.Columns["MLXSMC"].ColumnName = "NAME";
if (isChecked)
{
dt.Columns["ISEXIST"].ColumnName = "ischecked";
}
dt.Columns.Add("icon");
foreach (DataRow dr in dt.Rows)
{
switch (int.Parse(dr["MLLX"].ToString()))
{
case 1:
dr["icon"] = "jicon";
break;
case 2:
dr["icon"] = "mlicon";
break;
case 3:
dr["icon"] = "yicon";
break;
case 4:
dr["icon"] = "wjicon";
break;
}
if (dr["wjxhjl"] != null && dr["wjxhjl"].ToString() != "")
{
dr["ischecked"] = 1;
}
else
{
dr["ischecked"] = DBNull.Value;
}
}
Dictionary <string, string> styleValues = new Dictionary <string, string>();
styleValues.Add("Y", "color:blue;");
string json = new TreeJson(dt, "ID", "NAME", "PARENTID", "", "", parneid ?? "", true, true, "SFSM", styleValues, (ischecked == "true" ? true : false)).ResultJson.ToString();
return(json);
}
return(ReturnString.JsonToString(Prompt.error, "未找到相关目录！", null));
}
protected void Page_Load(object sender, EventArgs e)
{
connectstr = Session["connectstr"].ToString();
string PlatForm_connectstr = Session["PlatForm_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"]);
}
string Myfilter = "";
string[] tempIDs = new TreeJson().getChildID("ProjectTaskTree", connectstr, "ID", "ParentID", "select ID,ParentID from ProjectTaskTree where ParentID is null and Chargor=" + Session["userID"].ToString());
if (tempIDs.Length < 1)
{
Response.Write("");
Response.End();
return;
}
else
{
Myfilter = "Task_Service.TaskID in ( select TaskList.TaskID from TaskList where BelongProjectTreeNode in (" + string.Join(",", tempIDs) + ")) ";
}
if (string.IsNullOrEmpty(Request["OperateType"]))//如果没有传来的projectname的值就显示所有文档EmployeeList
{
sql = " select top " + limit +
" Task_Service.*,PrjTaskName.TaskName,PrjTaskName.TaskDetailInf from Task_Service,PrjTaskName where Task_Service.ID not in (select top " + start
+ " ID from Task_Service where " + Myfilter + " and Flag=7 ) and Task_Service.TaskID*=PrjTaskName.PTaskID and Flag=7 and " + Myfilter;
getcountSql = "select Task_Service.ID from Task_Service where Flag=7 and " + Myfilter;
}
else if (Request["OperateType"].Equals("search"))
{
string filter = " and BelongProjectTreeNode in ( select ID from ProjectTaskTree where Name like '%" + Request["TaskName"].ToString().Trim() + "%')";
sql = "Set ARITHABORT ON select top " + limit +
" 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 TaskID not in (select top " + start
+ " TaskID from TaskList where TaskID >-1 " + filter + " order by TaskID) and TaskList.TaskState*= TaskState.TaskStateID and TaskList.TypeID*=TaskType.TypeID and TaskList.WorkFlowID*=workflow.ID and P2.Chargor=EmployeeList.人员ID and TaskList.BelongProject=P1.ID and TaskList.BelongProjectTreeNode=P2.ID and P2.ProjectID=ProjList.序号 " + filter + " order by TaskID";
getcountSql = "Set ARITHABORT ON select TaskID from TaskList where TaskID >-1 " + filter;
}
//else if (Request["taskOperaType"].Equals("TaskSearch"))
//{
// string s = " ID,State,Project,Task.value('(/Task/@name)[1]','varchar(50)') as 任务名," +
// "Task.value('(//Creator)[1]','varchar(50)') as 任务创建人," +
// "Task.value('(//Batch)[1]','varchar(50)') as 批量," +
// "Task.value('(//ReleaseTime)[1]','varchar(50)') as 任务释放时间," +
// "Task.value('(//PlanEndTime)[1]','varchar(50)') as 任务计划结束时间," +
// "Task.value('(//Description)[1]','varchar(500)') as 任务描述," +
// "Task.value('(//Accuracy)[1]','varchar(50)') as 精度";
// sql = "Set ARITHABORT ON select " + s + " from TaskList where Task.value('(/Task/@name)[1]','varchar(50)')='" + Request["taskName"] + "'";
// getcountSql = "Set ARITHABORT ON select " + s + " from TaskList where Task.value('(/Task/@name)[1]','varchar(50)')='" + Request["taskName"] + "'";
//}
SQLToJson.ReaderSQLToJson.SetCount(getcountSql, connectstr);
Response.Write(GetJsonStr(sql));
Response.End();
Response.Clear();
}
}
protected void Page_Load(object sender, EventArgs e)
{
connectstr = Session["connectstr"].ToString();
string PlatForm_connectstr = Session["PlatForm_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["OperateType"]))//如果没有传来的projectname的值就显示所有文档EmployeeList
{
sql = "Set ARITHABORT ON select top " + limit +
" TaskList.*,workflow.name as WorkFlowName,TaskState.TaskStateName,TaskDetailInf.value('(/Task/@StandardTaskID)[1]','int') as TaskTemplateID,EmployeeList.人员名称 as CreatorName,P1.Name as ProjectName,P2.Name as PrjTaskTreeName,P2.Chargor as TaskCreator from TaskList,workflow,TaskState,EmployeeList,ProjectTaskTree P1,ProjectTaskTree P2 where TaskID not in (select top " + start
+ " TaskID from TaskList) and TaskList.WorkFlowID*=workflow.ID and TaskList.TaskState*= TaskState.TaskStateID and P2.Chargor=EmployeeList.人员ID and TaskList.BelongProject=P1.ID and TaskList.BelongProjectTreeNode=P2.ID";
getcountSql = "select TaskID from TaskList";
}
else if (Request["OperateType"].Equals("search"))
{
string filter = "";
if (Request["StandardTaskID"] != null && !Request["StandardTaskID"].ToString().Equals("") && !string.IsNullOrWhiteSpace(Request["StandardTaskID"].ToString()))
{
TreeJson ss = new TreeJson();
string[] tempIDs = ss.getChildID("ServiceTree", PlatForm_connectstr, "NodeId", "PNodeId", "select NodeId,PNodeId from ServiceTree where NodeId=" + Request["StandardTaskID"].ToString());
filter += " and TaskDetailInf.value('(/Task/@StandardTaskID)[1]','int') in (" + string.Join(",", tempIDs) + ")";
}
if (Request["ProjectTaskID"] != null && !Request["ProjectTaskID"].ToString().Equals("") && !string.IsNullOrWhiteSpace(Request["ProjectTaskID"].ToString()))
{
TreeJson ss = new TreeJson();
string[] tempIDs = ss.getChildID("ProjectTaskTree", connectstr, "ID", "ParentID", "select ID from ProjectTaskTree where ID=" + Request["ProjectTaskID"].ToString());
filter += " and BelongProjectTreeNode in (" + string.Join(",", tempIDs) + ")";
}
if (Request["TaskName"] != null && !Request["TaskName"].ToString().Equals("") && !string.IsNullOrWhiteSpace(Request["TaskName"].ToString()))
{
filter += " and BelongProjectTreeNode in ( select ID from ProjectTaskTree where Name like '%" + Request["TaskName"].ToString().Trim() + "%')";
}
sql = "Set ARITHABORT ON select top " + limit +
" TaskList.*,workflow.name as WorkFlowName,TaskState.TaskStateName,TaskDetailInf.value('(/Task/@StandardTaskID)[1]','int') as TaskTemplateID,EmployeeList.人员名称 as CreatorName,P1.Name as ProjectName,P2.Name as PrjTaskTreeName,P2.Chargor as TaskCreator from TaskList,workflow,TaskState,EmployeeList,ProjectTaskTree P1,ProjectTaskTree P2 where TaskID not in (select top " + start
+ " TaskID from TaskList where TaskID >-1 " + filter + " order by TaskID ) and TaskList.WorkFlowID*=workflow.ID and TaskList.TaskState*= TaskState.TaskStateID and P2.Chargor=EmployeeList.人员ID and TaskList.BelongProject=P1.ID and TaskList.BelongProjectTreeNode=P2.ID " + filter + " order by TaskID ";
getcountSql = " select TaskID from TaskList where TaskID >-1 " + filter;
}
else if (Request["OperateType"].Equals("LoadtaskByPrjTree"))
{
string sss = "select * from ProjectTaskTree where ID=" + Request["ProjectTaskID"];
string[] childIDs = new TreeJson().getChildID("ProjectTaskTree", connectstr, "ID", "ParentID", sss);
if (childIDs != null)
{
string TaskID = String.Join(",", childIDs);
string filter = "and BelongProjectTreeNode in (" + TaskID + ") ";
sql = "Set ARITHABORT ON select top " + limit +
" TaskList.*,workflow.name as WorkFlowName,TaskState.TaskStateName,TaskDetailInf.value('(/Task/@StandardTaskID)[1]','int') as TaskTemplateID,EmployeeList.人员名称 as CreatorName,P1.Name as ProjectName,P2.Name as PrjTaskTreeName,P2.Chargor as TaskCreator from TaskList,workflow,TaskState,EmployeeList,ProjectTaskTree P1,ProjectTaskTree P2 where TaskID not in (select top " + start
+ " TaskID from TaskList where TaskID >-1 " + filter + " order by TaskID) and TaskList.WorkFlowID*=workflow.ID and TaskList.TaskState*= TaskState.TaskStateID and P2.Chargor=EmployeeList.人员ID and TaskList.BelongProject=P1.ID and TaskList.BelongProjectTreeNode=P2.ID " + filter + " order by TaskID ";
getcountSql = "Set ARITHABORT ON select TaskID from TaskList where TaskID >-1 " + filter;
}
}
//else if (Request["taskOperaType"].Equals("TaskSearch"))
//{
// string s = " ID,State,Project,Task.value('(/Task/@name)[1]','varchar(50)') as 任务名," +
// "Task.value('(//Creator)[1]','varchar(50)') as 任务创建人," +
// "Task.value('(//Batch)[1]','varchar(50)') as 批量," +
// "Task.value('(//ReleaseTime)[1]','varchar(50)') as 任务释放时间," +
// "Task.value('(//PlanEndTime)[1]','varchar(50)') as 任务计划结束时间," +
// "Task.value('(//Description)[1]','varchar(500)') as 任务描述," +
// "Task.value('(//Accuracy)[1]','varchar(50)') as 精度";
// sql = "Set ARITHABORT ON select " + s + " from TaskList where Task.value('(/Task/@name)[1]','varchar(50)')='" + Request["taskName"] + "'";
// getcountSql = "Set ARITHABORT ON select " + s + " from TaskList where Task.value('(/Task/@name)[1]','varchar(50)')='" + Request["taskName"] + "'";
//}
SQLToJson.ReaderSQLToJson.SetCount(getcountSql, connectstr);
Response.Write(GetJsonStr(sql));
Response.End();
Response.Clear();
}
}
