using System; using System.Data; using System.Text; using System.Web; using BP.DA; using BP.Sys; using BP.Web; using BP.En; using BP.WF.Template; using BP.Difference; namespace BP.WF.HttpHandler { /// /// 抄送处理类 /// public class WF_MyCC : DirectoryPageBase { /// /// 抄送处理类 /// public WF_MyCC() { } #region 运行变量 /// /// 从节点. /// public string FromNode { get { return this.GetRequestVal("FromNode"); } } /// /// 是否抄送 /// public bool IsCC { get { string str = this.GetRequestVal("Paras"); if (DataType.IsNullOrEmpty(str) == false) { string myps = str; if (myps.Contains("IsCC=1") == true) return true; } str = this.GetRequestVal("AtPara"); if (DataType.IsNullOrEmpty(str) == false) { if (str.Contains("IsCC=1") == true) return true; } return false; } } /// /// 轨迹ID /// public string TrackID { get { return this.GetRequestVal("TrackeID"); } } /// /// 到达的节点ID /// public int ToNode { get { return this.GetRequestValInt("ToNode"); } } private int _FK_Node = 0; /// /// 当前的 NodeID ,在开始时间,nodeID,是地一个,流程的开始节点ID. /// public new int FK_Node { get { string fk_nodeReq = this.GetRequestVal("FK_Node"); //this.Request.Form["FK_Node"]; if (DataType.IsNullOrEmpty(fk_nodeReq)) fk_nodeReq = this.GetRequestVal("NodeID");// this.Request.Form["NodeID"]; if (DataType.IsNullOrEmpty(fk_nodeReq) == false) return int.Parse(fk_nodeReq); if (_FK_Node == 0) { if (this.WorkID != 0) { Paras ps = new Paras(); ps.SQL = "SELECT FK_Node FROM WF_GenerWorkFlow WHERE WorkID=" + BP.Difference.SystemConfig.AppCenterDBVarStr + "WorkID"; ps.Add("WorkID", this.WorkID); _FK_Node = DBAccess.RunSQLReturnValInt(ps, 0); } else { _FK_Node = int.Parse(this.FK_Flow + "01"); } } return _FK_Node; } } private string _width = ""; /// /// 表单宽度 /// public string Width { get { return _width; } set { _width = value; } } private string _height = ""; /// /// 表单高度 /// public string Height { get { return _height; } set { _height = value; } } public string _btnWord = ""; public string BtnWord { get { return _btnWord; } set { _btnWord = value; } } private GenerWorkFlow _HisGenerWorkFlow = null; public GenerWorkFlow HisGenerWorkFlow { get { if (_HisGenerWorkFlow == null) _HisGenerWorkFlow = new GenerWorkFlow(this.WorkID); return _HisGenerWorkFlow; } } private Node _currNode = null; public Node currND { get { if (_currNode == null) _currNode = new Node(this.FK_Node); return _currNode; } } private Flow _currFlow = null; public Flow currFlow { get { if (_currFlow == null) _currFlow = new Flow(this.FK_Flow); return _currFlow; } } /// /// 定义跟路径 /// public string appPath = "/"; //杨玉慧 public string DoType1 { get { return HttpContextHelper.RequestParams("DoType1"); } } #endregion public string Focus() { BP.WF.Dev2Interface.Flow_Focus(this.WorkID); return "设置成功."; } /// /// 加载前置导航数据 /// /// public string StartGuide_Init() { string josnData = ""; //流程编号 string fk_flow = this.GetRequestVal("FK_Flow"); //查询的关键字 string skey = this.GetRequestVal("Keys"); try { //获取流程实例 Flow fl = new Flow(fk_flow); //获取设置的前置导航的sql string sql = fl.StartGuidePara2; //判断是否有查询条件 if ( !DataType.IsNullOrEmpty(skey)) { sql = fl.StartGuidePara1; sql = sql.Replace("@Key", skey); } sql = sql.Replace("~", "'"); //替换约定参数 sql = sql.Replace("@WebUser.No", WebUser.No); sql = sql.Replace("@WebUser.Name", WebUser.Name); sql = sql.Replace("@WebUser.FK_Dept", WebUser.FK_Dept); sql = sql.Replace("@WebUser.FK_DeptName", WebUser.FK_DeptName); sql = sql.Replace("@WebUser.OrgNo", WebUser.OrgNo); if (sql.Contains("@") == true) { foreach (string key in HttpContextHelper.RequestParamKeys) { sql = sql.Replace("@" + key, this.GetRequestVal(key)); } foreach (string key in HttpContextHelper.RequestParamKeys) { sql = sql.Replace("@" + key, this.GetRequestVal(key)); } } //获取数据 DataTable dt = DBAccess.RunSQLReturnTable(sql); //判断前置导航的类型 switch (fl.StartGuideWay) { case StartGuideWay.BySQLOne: case StartGuideWay.BySystemUrlOneEntity: josnData = BP.Tools.Json.ToJson(dt); break; case StartGuideWay.BySQLMulti: josnData = BP.Tools.Json.ToJson(dt); break; default: break; } return josnData; } catch (Exception ex) { return "err@:" + ex.Message.ToString(); } } /// /// 设置确认的状态 /// /// public string MyCC_Make_CheckOver() { return "执行成功."; } /// /// 初始化(处理分发) /// /// public string MyCC_Init() { //手动启动子流程的标志 0父子流程 1 同级子流程. string isStartSameLevelFlow = this.GetRequestVal("IsStartSameLevelFlow"); GenerWorkFlow gwf = new GenerWorkFlow(this.WorkID); // 打开抄送给我的数据,都把它设置读取状态. CCLists ccs = new CCLists(); ccs.Retrieve(CCListAttr.WorkID, this.WorkID, CCListAttr.CCTo, WebUser.No); foreach (CCList item in ccs) { if (item.HisSta == CCSta.UnRead) BP.WF.Dev2Interface.Node_CC_SetRead(item.MyPK); } //当前工作. Work currWK = this.currND.HisWork; #region 处理表单类型. if (this.currND.HisFormType == NodeFormType.SheetTree || this.currND.HisFormType == NodeFormType.SheetAutoTree || this.currFlow.FlowDevModel == FlowDevModel.FrmTree) { if (this.currND.IsStartNode) { /*如果是开始节点, 先检查是否启用了流程限制。*/ if (BP.WF.Glo.CheckIsCanStartFlow_InitStartFlow(this.currFlow) == false) { /* 如果启用了限制就把信息提示出来. */ string msg = BP.WF.Glo.DealExp(this.currFlow.StartLimitAlert, currWK, null); return "err@" + msg; } } #region 开始组合url. string toUrl = ""; if (this.IsMobile == true) { if (gwf.Paras_Frms.Equals("") == false) toUrl = "MyCCGener.htm?WorkID=" + this.WorkID + "&FK_Flow=" + this.FK_Flow + "&UserNo=" + WebUser.No + "&FID=" + this.FID + "&Token=" + WebUser.Token + "&PFlowNo=" + gwf.PFlowNo + "&PNodeID=" + gwf.PNodeID + "&PWorkID=" + gwf.PWorkID + "&Frms=" + gwf.Paras_Frms; else toUrl = "MyCCGener.htm?WorkID=" + this.WorkID + "&FK_Flow=" + this.FK_Flow + "&UserNo=" + WebUser.No + "&FID=" + this.FID + "&Token=" + WebUser.Token + "&PFlowNo=" + gwf.PFlowNo + "&PNodeID=" + gwf.PNodeID + "&PWorkID=" + gwf.PWorkID; } else { if (gwf.Paras_Frms.Equals("") == false) toUrl = "MyCCTree.htm?WorkID=" + this.WorkID + "&FK_Flow=" + this.FK_Flow + "&UserNo=" + WebUser.No + "&FID=" + this.FID + "&Token=" + WebUser.Token + "&PFlowNo=" + gwf.PFlowNo + "&PNodeID=" + gwf.PNodeID + "&PWorkID=" + gwf.PWorkID + "&Frms=" + gwf.Paras_Frms; else toUrl = "MyCCTree.htm?WorkID=" + this.WorkID + "&FK_Flow=" + this.FK_Flow + "&UserNo=" + WebUser.No + "&FID=" + this.FID + "&Token=" + WebUser.Token + "&PFlowNo=" + gwf.PFlowNo + "&PNodeID=" + gwf.PNodeID + "&PWorkID=" + gwf.PWorkID; } string[] strs = this.RequestParas.Split('&'); foreach (string str in strs) { if (toUrl.Contains(str) == true) continue; if (str.Contains("DoType=") == true) continue; if (str.Contains("DoMethod=") == true) continue; if (str.Contains("HttpHandlerName=") == true) continue; if (str.Contains("IsLoadData=") == true) continue; if (str.Contains("IsCheckGuide=") == true) continue; toUrl += "&" + str; } foreach (string key in HttpContextHelper.RequestParamKeys) { if (toUrl.Contains(key + "=") == true) continue; toUrl += "&" + key + "=" + HttpContextHelper.RequestParams(key); } #endregion 开始组合url. //SDK表单上服务器地址,应用到使用ccflow的时候使用的是sdk表单,该表单会存储在其他的服务器上,珠海驰骋提出. toUrl = toUrl.Replace("@SDKFromServHost", BP.Difference.SystemConfig.AppSettings["SDKFromServHost"]); //增加fk_node if (toUrl.Contains("&FK_Node=") == false) toUrl += "&FK_Node=" + this.currND.NodeID; //如果是开始节点. if (currND.IsStartNode == true) { if (toUrl.Contains("PrjNo") == true && toUrl.Contains("PrjName") == true) { string sql = "UPDATE " + currWK.EnMap.PhysicsTable + " SET PrjNo='" + this.GetRequestVal("PrjNo") + "', PrjName='" + this.GetRequestVal("PrjName") + "' WHERE OID=" + this.WorkID; DBAccess.RunSQL(sql); } } return "url@" + toUrl; } if (this.currND.HisFormType == NodeFormType.SDKForm || this.currFlow.FlowDevModel == FlowDevModel.SDKFrmWorkID || this.currFlow.FlowDevModel == FlowDevModel.SDKFrmSelfPK) { if (this.WorkID == 0) { currWK = this.currFlow.NewWork(); this.WorkID = currWK.OID; } string url = currND.FormUrl; if (DataType.IsNullOrEmpty(url)) { return "err@设置读取状流程设计错误态错误,没有设置表单url."; } //处理连接. url = this.MyCC_Init_DealUrl(currND, currWK); //sdk表单就让其跳转. return "url@" + url; } #endregion 处理表单类型. //求出当前节点frm的类型. NodeFormType frmtype = this.currND.HisFormType; if (frmtype != NodeFormType.RefOneFrmTree) { currND.WorkID = this.WorkID; //为获取表单ID ( NodeFrmID )提供参数. if (this.currND.NodeFrmID.Contains(this.currND.NodeID.ToString()) == false) { /*如果当前节点引用的其他节点的表单.*/ string nodeFrmID = currND.NodeFrmID; string refNodeID = nodeFrmID.Replace("ND", ""); BP.WF.Node nd = new Node(int.Parse(refNodeID)); //表单类型. frmtype = nd.HisFormType; } } #region 内置表单类型的判断. /*如果是傻瓜表单,就转到傻瓜表单的解析执行器上,为软通动力改造。*/ if (this.WorkID == 0) { currWK = this.currFlow.NewWork(); this.WorkID = currWK.OID; } if (frmtype == NodeFormType.FoolTruck) { /*如果是傻瓜表单,就转到傻瓜表单的解析执行器上,为软通动力改造。*/ if (this.WorkID == 0) { currWK = this.currFlow.NewWork(); this.WorkID = currWK.OID; } //string url = "MyCCFoolTruck.htm"; string url = "MyCCGener.htm"; //处理连接. url = this.MyCC_Init_DealUrl(currND, currWK, url); return "url@" + url; } if (frmtype == NodeFormType.WebOffice) { /*如果是公文表单,就转到公文表单的解析执行器上,为软通动力改造。*/ if (this.WorkID == 0) { currWK = this.currFlow.NewWork(); this.WorkID = currWK.OID; } //string url = "MyCCFoolTruck.htm"; string url = "MyCCWebOffice.htm"; //处理连接. url = this.MyCC_Init_DealUrl(currND, currWK, url); return "url@" + url; } if (frmtype == NodeFormType.FoolForm && this.IsMobile == false) { /*如果是傻瓜表单,就转到傻瓜表单的解析执行器上。*/ if (this.WorkID == 0) { currWK = this.currFlow.NewWork(); this.WorkID = currWK.OID; } string url = "MyCCGener.htm"; if (this.IsMobile) url = "MyCCGener.htm"; //处理连接. url = this.MyCC_Init_DealUrl(currND, currWK, url); url = url.Replace("DoType=MyCC_Init&", ""); url = url.Replace("&DoWhat=StartClassic", ""); return "url@" + url; } //自定义表单 if ((frmtype == NodeFormType.SelfForm || this.currFlow.FlowDevModel == FlowDevModel.SelfFrm) && this.IsMobile == false) { if (this.WorkID == 0) { currWK = this.currFlow.NewWork(); this.WorkID = currWK.OID; } string url = "MyCCSelfForm.htm"; //处理连接. url = this.MyCC_Init_DealUrl(currND, currWK, url); url = url.Replace("DoType=MyCC_Init&", ""); url = url.Replace("&DoWhat=StartClassic", ""); return "url@" + url; } #endregion 内置表单类型的判断. string myurl = "MyCCGener.htm"; //处理连接. myurl = this.MyCC_Init_DealUrl(currND, currWK, myurl); myurl = myurl.Replace("DoType=MyCC_Init&", ""); myurl = myurl.Replace("&DoWhat=StartClassic", ""); return "url@" + myurl; } private string MyCC_Init_DealUrl(BP.WF.Node currND, Work currWK, string url = null) { if (url == null) url = currND.FormUrl; string urlExt = this.RequestParas; //防止查询不到. urlExt = urlExt.Replace("?WorkID=", "&WorkID="); if (urlExt.Contains("&WorkID") == false) { urlExt += "&WorkID=" + this.WorkID; } else { urlExt = urlExt.Replace("&WorkID=0", "&WorkID=" + this.WorkID); urlExt = urlExt.Replace("&WorkID=&", "&WorkID=" + this.WorkID + "&"); } //SDK表单上服务器地址,应用到使用ccflow的时候使用的是sdk表单,该表单会存储在其他的服务器上,珠海驰骋提出. url = url.Replace("@SDKFromServHost", BP.Difference.SystemConfig.AppSettings["SDKFromServHost"]); if (urlExt.Contains("&NodeID") == false) urlExt += "&NodeID=" + currND.NodeID; if (urlExt.Contains("FK_Node") == false) urlExt += "&FK_Node=" + currND.NodeID; if (urlExt.Contains("&FID") == false && currWK != null) urlExt += "&FID=" + this.FID; if (urlExt.Contains("&UserNo") == false) urlExt += "&UserNo=" + HttpUtility.UrlEncode(WebUser.No); if (urlExt.Contains("&Token") == false) urlExt += "&Token=" + WebUser.Token; if (url.Contains("?") == true) url += "&" + urlExt; else url += "?" + urlExt; foreach (string str in HttpContextHelper.RequestParamKeys) { if (DataType.IsNullOrEmpty(str) == true) continue; if (url.Contains(str + "=") == true) continue; url += "&" + str + "=" + this.GetRequestVal(str); } url = url.Replace("?&", "?"); url = url.Replace("&&", "&"); return url; } /// /// 工具栏 /// /// public string InitToolBar() { DataTable dt = new DataTable("ToolBar"); dt.Columns.Add("No"); dt.Columns.Add("Name"); dt.Columns.Add("Oper"); BtnLab btnLab = new BtnLab(this.FK_Node); string tKey = DateTime.Now.ToString("MM-dd-hh:mm:ss"); string toolbar = ""; bool isMobile = this.GetRequestValBoolen("IsMobile"); try { CCList list = new CCList(); bool isCheckOver = list.IsExit(CCListAttr.WorkID, this.WorkID, CCListAttr.CCTo, WebUser.No,CCListAttr.Sta,(int)CCSta.CheckOver); DataRow dr = dt.NewRow(); //if (isMobile == false) //{ // if (isCheckOver == true) // { // dr["No"] = "Close"; // dr["Name"] = "关闭"; // dr["Oper"] = "CloseWindow();"; // } // else // { // dr["No"] = "ReadAndClose"; // dr["Name"] = "阅件完毕"; // dr["Oper"] = "ReadAndClose();"; // } // dt.Rows.Add(dr); //} if (btnLab.GetValBooleanByKey(BtnAttr.ShowParentFormEnableMyCC) && this.PWorkID != 0) { /*如果要查看父流程.*/ dr = dt.NewRow(); dr["No"] = "ParentForm"; dr["Name"] = btnLab.ShowParentFormLab; dr["Oper"] = ""; dt.Rows.Add(dr); } if (btnLab.GetValBooleanByKey(BtnAttr.TrackEnableMyCC)) { dr = dt.NewRow(); dr["No"] = "Track"; dr["Name"] = btnLab.TrackLab; dr["Oper"] = ""; dt.Rows.Add(dr); } #region 加载流程抄送 - 按钮 /* 打包下载zip */ if (btnLab.PrintZipMyCC == true) { dr = dt.NewRow(); dr["No"] = "PackUp_zip"; dr["Name"] = btnLab.PrintZipLab; dr["Oper"] = ""; dt.Rows.Add(dr); } /* 打包下载html */ if (btnLab.PrintHtmlMyCC == true) { dr = dt.NewRow(); dr["No"] = "PackUp_html"; dr["Name"] = btnLab.PrintHtmlLab; dr["Oper"] = ""; dt.Rows.Add(dr); } /* 打包下载pdf */ if (btnLab.PrintPDFMyCC == true) { dr = dt.NewRow(); dr["No"] = "PackUp_pdf"; dr["Name"] = btnLab.PrintPDFLab; dr["Oper"] = ""; dt.Rows.Add(dr); } if (btnLab.FrmDBVerMyCC == true) { dr = dt.NewRow(); dr["No"] = "FrmDBVer"; dr["Name"] = btnLab.FrmDBVerLab; dr["Oper"] = "FrmDBVer_Init()"; dt.Rows.Add(dr); } //数据批阅 if (btnLab.FrmDBRemarkEnable != 0) { dr = dt.NewRow(); dr["No"] = "FrmDBRemark"; dr["Name"] = btnLab.FrmDBRemarkLab; dr["Oper"] = "FrmDBRemark(" + btnLab.FrmDBRemarkEnable + ")"; dt.Rows.Add(dr); } /* 公文标签 */ if (btnLab.OfficeBtnEnable == true && btnLab.OfficeBtnLocal == 0) { dr = dt.NewRow(); dr["No"] = "DocWord"; dr["Name"] = btnLab.OfficeBtnLab; dr["Oper"] = ""; dt.Rows.Add(dr); } #endregion #region 加载自定义的button. BP.WF.Template.NodeToolbars bars = new NodeToolbars(); bars.Retrieve(NodeToolbarAttr.FK_Node, this.FK_Node, NodeToolbarAttr.IsMyCC, 1, NodeToolbarAttr.Idx); foreach (NodeToolbar bar in bars) { if (bar.ExcType == 1 || (!DataType.IsNullOrEmpty(bar.Target) == false && bar.Target.ToLower() == "javascript")) { dr = dt.NewRow(); dr["No"] = "NodeToolBar"; dr["Name"] = bar.Title; dr["Oper"] = bar.Url; dt.Rows.Add(dr); } else { string urlr3 = bar.Url + "&FK_Node=" + this.FK_Node + "&FID=" + this.FID + "&WorkID=" + this.WorkID + "&FK_Flow=" + this.FK_Flow + "&s=" + tKey; dr = dt.NewRow(); dr["No"] = "NodeToolBar"; dr["Name"] = bar.Title; dr["Oper"] = "WinOpen('" + urlr3 + "')"; dt.Rows.Add(dr); } } #endregion //加载自定义的button. } catch (Exception ex) { BP.DA.Log.DebugWriteError(ex); toolbar = "err@" + ex.Message; } return BP.Tools.Json.ToJson(dt); } public string MyCCSelfForm_Init() { return this.GenerWorkNode(); } #region 表单树操作 /// /// 获取表单树数据 /// /// public string FlowFormTree_Init() { BP.WF.Template.FlowFormTrees appFlowFormTree = new FlowFormTrees(); //add root BP.WF.Template.FlowFormTree root = new BP.WF.Template.FlowFormTree(); root.No = "1"; root.ParentNo = "0"; root.Name = "目录"; root.NodeType = "root"; appFlowFormTree.AddEntity(root); #region 添加表单及文件夹 //节点表单 BP.WF.Node nd = new BP.WF.Node(this.FK_Node); FrmNodes frmNodes = new FrmNodes(); frmNodes.Retrieve(FrmNodeAttr.FK_Node, this.FK_Node, FrmNodeAttr.Idx); //所有表单集合. 为了优化效率,这部分重置了一下. MapDatas mds = new MapDatas(); if (frmNodes.Count <= 3) { foreach (FrmNode fn in frmNodes) { MapData md = new MapData(fn.FK_Frm); mds.AddEntity(md); } } else { mds.RetrieveInSQL("SELECT FK_Frm FROM WF_FrmNode WHERE FK_Node=" + this.FK_Node); } string frms = HttpContextHelper.RequestParams("Frms"); GenerWorkFlow gwf = new GenerWorkFlow(this.WorkID); if (DataType.IsNullOrEmpty(frms) == true) { frms = gwf.Paras_Frms; } else { gwf.Paras_Frms = frms; gwf.Update(); } foreach (FrmNode frmNode in frmNodes) { #region 增加判断是否启用规则. switch (frmNode.FrmEnableRole) { case FrmEnableRole.Allways: break; case FrmEnableRole.WhenHaveData: //判断是否有数据. MapData md = mds.GetEntityByKey(frmNode.FK_Frm) as MapData; if (md == null) continue; Int64 pk = this.WorkID; switch (frmNode.WhoIsPK) { case WhoIsPK.FID: pk = this.FID; break; case WhoIsPK.PWorkID: pk = this.PWorkID; break; case WhoIsPK.CWorkID: pk = this.CWorkID; break; case WhoIsPK.OID: default: pk = this.WorkID; break; } if (DBAccess.RunSQLReturnValInt("SELECT COUNT(*) as Num FROM " + md.PTable + " WHERE OID=" + pk) == 0) continue; break; case FrmEnableRole.WhenHaveFrmPara: //判断是否有参数. frms = frms.Trim(); frms = frms.Replace(" ", ""); frms = frms.Replace(" ", ""); if (DataType.IsNullOrEmpty(frms) == true) { continue; //return "err@当前表单设置为仅有参数的时候启用,但是没有传递来参数."; } if (frms.Contains(",") == false) { if (frms != frmNode.FK_Frm) continue; } if (frms.Contains(",") == true) { if (frms.Contains(frmNode.FK_Frm + ",") == false) continue; } break; case FrmEnableRole.ByFrmFields: throw new Exception("@这种类型的判断,ByFrmFields 还没有完成。"); case FrmEnableRole.BySQL: // 按照SQL的方式. string mysql = frmNode.FrmEnableExp.Clone() as string; if (DataType.IsNullOrEmpty(mysql) == true) { MapData FrmMd = new MapData(frmNode.FK_Frm); return "err@表单" + frmNode.FK_Frm + ",[" + FrmMd.Name + "]在节点[" + frmNode.FK_Node + "]启用方式按照sql启用但是您没有给他设置sql表达式."; } mysql = mysql.Replace("@OID", this.WorkID.ToString()); mysql = mysql.Replace("@WorkID", this.WorkID.ToString()); mysql = mysql.Replace("@NodeID", this.FK_Node.ToString()); mysql = mysql.Replace("@FK_Node", this.FK_Node.ToString()); mysql = mysql.Replace("@FK_Flow", this.FK_Flow); mysql = mysql.Replace("@WebUser.No", WebUser.No); mysql = mysql.Replace("@WebUser.Name", WebUser.Name); mysql = mysql.Replace("@WebUser.FK_Dept", WebUser.FK_Dept); //替换特殊字符. mysql = mysql.Replace("~", "'"); if (DBAccess.RunSQLReturnValFloat(mysql) <= 0) continue; break; case FrmEnableRole.ByStation: string exp = frmNode.FrmEnableExp.Clone() as string; string Sql = "SELECT FK_Station FROM Port_DeptEmpStation where FK_Emp='" + WebUser.No + "'"; string station = DBAccess.RunSQLReturnString(Sql); if (DataType.IsNullOrEmpty(station) == true) continue; string[] stations = station.Split(';'); bool isExit = false; foreach (string s in stations) { if (exp.Contains(s) == true) { isExit = true; break; } } if (isExit == false) continue; break; case FrmEnableRole.ByDept: exp = frmNode.FrmEnableExp.Clone() as string; Sql = "SELECT FK_Dept FROM Port_DeptEmp where FK_Emp='" + WebUser.No + "'"; string dept = DBAccess.RunSQLReturnString(Sql); if (DataType.IsNullOrEmpty(dept) == true) continue; string[] deptStrs = dept.Split(';'); isExit = false; foreach (string s in deptStrs) { if (exp.Contains(s) == true) { isExit = true; break; } } if (isExit == false) continue; break; case FrmEnableRole.Disable: // 如果禁用了,就continue出去.. continue; default: throw new Exception("@没有判断的规则." + frmNode.FrmEnableRole); } #endregion #region 检查是否有没有目录的表单? bool isHave = false; foreach (MapData md in mds) { if (md.FK_FormTree == "") { isHave = true; break; } } string treeNo = "0"; if (isHave && mds.Count == 1) { treeNo = "00"; } else if (isHave == true) { foreach (MapData md in mds) { if (md.FK_FormTree != "") { treeNo = md.FK_FormTree; break; } } } #endregion 检查是否有没有目录的表单? foreach (MapData md in mds) { if (frmNode.FK_Frm != md.No) continue; if (md.FK_FormTree == "") md.FK_FormTree = treeNo; //给他增加目录. if (appFlowFormTree.Contains("Name", md.FK_FormTreeText) == false) { BP.WF.Template.FlowFormTree nodeFolder = new BP.WF.Template.FlowFormTree(); nodeFolder.No = md.FK_FormTree; nodeFolder.ParentNo = "1"; nodeFolder.Name = md.FK_FormTreeText; nodeFolder.NodeType = "folder"; appFlowFormTree.AddEntity(nodeFolder); } //检查必填项. bool IsNotNull = false; FrmFields formFields = new FrmFields(); QueryObject obj = new QueryObject(formFields); obj.AddWhere(FrmFieldAttr.FK_Node, this.FK_Node); obj.addAnd(); obj.AddWhere(FrmFieldAttr.FK_MapData, md.No); obj.addAnd(); obj.AddWhere(FrmFieldAttr.IsNotNull, 1); obj.DoQuery(); if (formFields != null && formFields.Count > 0) IsNotNull = true; BP.WF.Template.FlowFormTree nodeForm = new BP.WF.Template.FlowFormTree(); nodeForm.No = md.No; nodeForm.ParentNo = md.FK_FormTree; //设置他的表单显示名字. 2019.09.30 string frmName = md.Name; Entity fn = frmNodes.GetEntityByKey(FrmNodeAttr.FK_Frm, md.No); if (fn != null) { string str = fn.GetValStrByKey(FrmNodeAttr.FrmNameShow); if (DataType.IsNullOrEmpty(str) == false) frmName = str; } nodeForm.Name = frmName; nodeForm.NodeType = IsNotNull ? "form|1" : "form|0"; nodeForm.IsEdit = frmNode.IsEditInt.ToString();// Convert.ToString(Convert.ToInt32(frmNode.IsEdit)); nodeForm.IsCloseEtcFrm = frmNode.IsCloseEtcFrmInt.ToString(); appFlowFormTree.AddEntity(nodeForm); break; } } #endregion //扩展工具,显示位置为表单树类型. //增加到数据结构上去. TansEntitiesToGenerTree(appFlowFormTree, root.No, ""); return appendMenus.ToString(); } /// /// 将实体转为树形 /// /// /// /// StringBuilder appendMenus = new StringBuilder(); StringBuilder appendMenuSb = new StringBuilder(); public void TansEntitiesToGenerTree(Entities ens, string rootNo, string checkIds) { EntityTree root = ens.GetEntityByKey(rootNo) as EntityTree; if (root == null) throw new Exception("@没有找到rootNo=" + rootNo + "的entity."); appendMenus.Append("[{"); appendMenus.Append("\"id\":\"" + rootNo + "\""); appendMenus.Append(",\"text\":\"" + root.Name + "\""); //attributes BP.WF.Template.FlowFormTree formTree = root as BP.WF.Template.FlowFormTree; if (formTree != null) { string url = formTree.Url == null ? "" : formTree.Url; url = url.Replace("/", "|"); appendMenus.Append(",\"attributes\":{\"NodeType\":\"" + formTree.NodeType + "\",\"IsEdit\":\"" + formTree.IsEdit + "\",\"IsCloseEtcFrm\":\"" + formTree.IsCloseEtcFrm + "\",\"Url\":\"" + url + "\"}"); } appendMenus.Append(",iconCls:\"icon-Wave\""); // 增加它的子级. appendMenus.Append(",\"children\":"); AddChildren(root, ens, checkIds); appendMenus.Append(appendMenuSb); appendMenus.Append("}]"); } private void AddChildren(EntityTree parentEn, Entities ens, string checkIds) { appendMenus.Append(appendMenuSb); appendMenuSb.Clear(); appendMenuSb.Append("["); foreach (EntityTree item in ens) { if (item.ParentNo != parentEn.No) continue; if (checkIds.Contains("," + item.No + ",")) appendMenuSb.Append("{\"id\":\"" + item.No + "\",\"text\":\"" + item.Name + "\",\"checked\":true"); else appendMenuSb.Append("{\"id\":\"" + item.No + "\",\"text\":\"" + item.Name + "\",\"checked\":false"); //attributes BP.WF.Template.FlowFormTree formTree = item as BP.WF.Template.FlowFormTree; if (formTree != null) { string url = formTree.Url == null ? "" : formTree.Url; string ico = "icon-tree_folder"; if (BP.Difference.SystemConfig.SysNo == "YYT") { ico = "icon-boat_16"; } url = url.Replace("/", "|"); appendMenuSb.Append(",\"attributes\":{\"NodeType\":\"" + formTree.NodeType + "\",\"IsEdit\":\"" + formTree.IsEdit + "\",\"IsCloseEtcFrm\":\"" + formTree.IsCloseEtcFrm + "\",\"Url\":\"" + url + "\"}"); //图标 if (formTree.NodeType == "form|0") { ico = "form0"; if (BP.Difference.SystemConfig.SysNo == "YYT") { ico = "icon-Wave"; } } if (formTree.NodeType == "form|1") { ico = "form1"; if (BP.Difference.SystemConfig.SysNo == "YYT") { ico = "icon-Shark_20"; } } if (formTree.NodeType.Contains("tools")) { ico = "icon-4"; if (BP.Difference.SystemConfig.SysNo == "YYT") { ico = "icon-Wave"; } } appendMenuSb.Append(",iconCls:\""); appendMenuSb.Append(ico); appendMenuSb.Append("\""); } // 增加它的子级. appendMenuSb.Append(",\"children\":"); AddChildren(item, ens, checkIds); appendMenuSb.Append("},"); } if (appendMenuSb.Length > 1) appendMenuSb = appendMenuSb.Remove(appendMenuSb.Length - 1, 1); appendMenuSb.Append("]"); appendMenus.Append(appendMenuSb); appendMenuSb.Clear(); } #endregion /// /// 产生一个工作节点 /// /// public string GenerWorkNode() { WF_MyView myView = new WF_MyView(); return myView.GenerWorkNode(); } } }