/// <summary>
/// 树的实体包含了No,Name,ParentNo,Idx 必须的属性(字段),它是树结构的描述.
/// </summary>
public void EnttiyTree()
{
//创建父节点, 父节点的编号必须为1 ,父节点的ParentNo 必须是 0.
FlowSort en = new FlowSort("1");
en.Name = "根目录";
//创建子目录节点.
FlowSort subEn = (FlowSort)en.DoCreateSubNode();
subEn.Name = "行政类";
subEn.Update();
//创建子目录的评级节点.
FlowSort sameLevelSubEn = (FlowSort)subEn.DoCreateSameLevelNode();
sameLevelSubEn.Name = "业务类";
sameLevelSubEn.Update();
//创建子目录的下一级节点1.
FlowSort sameLevelSubSubEn = (FlowSort)subEn.DoCreateSameLevelNode();
sameLevelSubSubEn.Name = "日常办公";
sameLevelSubSubEn.Update();
//创建子目录的下一级节点1.
FlowSort sameLevelSubSubEn2 = (FlowSort)subEn.DoCreateSameLevelNode();
sameLevelSubSubEn2.Name = "人力资源";
sameLevelSubSubEn2.Update();
/**
* 根目录
* 行政类
* 日常办公
* 人力资源
* 业务类
*
*/
}
public string Do(string doWhat, string para1, bool isLogin)
{
// 如果admin账户登陆时有错误发生，则返回错误信息
var result = LetAdminLogin("CH", isLogin);
if (string.IsNullOrEmpty(result) == false)
{
return(result);
}
switch (doWhat)
{
case "GenerFlowTemplete":
Flow temp = new BP.WF.Flow(para1);
return(null);
case "GetFlowSorts": //获取所有流程类型
DataTable dtSorts = null;
try
{
dtSorts = BP.DA.DBAccess.RunSQLReturnTable("SELECT no,name FROM WF_FlowSort");
}
catch (Exception ex)
{
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = ex.Message }));
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = true, msg = string.Empty, data = dtSorts.Rows.Cast <DataRow>().Select(dr => new { Key = dr["no"].ToString(), Value = dr["name"].ToString() }) }));
case "NewSameLevelFrmSort": //创建同级别的 表单树 目录.
SysFormTree frmSort = null;
try
{
var para = para1.Split(',');
frmSort = new SysFormTree(para[0]);
string sameNodeNo = frmSort.DoCreateSameLevelNode().No;
frmSort = new SysFormTree(sameNodeNo);
frmSort.Name = para[1];
frmSort.Update();
return(null);
}
catch (Exception ex)
{
return("Do Method NewFormSort Branch has a error , para:\t" + para1 + ex.Message);
}
case "NewSubLevelFrmSort": //创建子级别的 表单树 目录.
SysFormTree frmSortSub = null;
try
{
var para = para1.Split(',');
frmSortSub = new SysFormTree(para[0]);
string sameNodeNo = frmSortSub.DoCreateSubNode().No;
frmSortSub = new SysFormTree(sameNodeNo);
frmSortSub.Name = para[1];
frmSortSub.Update();
return(null);
}
catch (Exception ex)
{
return("Do Method NewSubLevelFrmSort Branch has a error , para:\t" + para1 + ex.Message);
}
case "NewSameLevelFlowSort": //创建同级别的 流程树 目录.
FlowSort fs = null;
try
{
var para = para1.Split(',');
fs = new FlowSort(para[0]);
string sameNodeNo = fs.DoCreateSameLevelNode().No;
fs = new FlowSort(sameNodeNo);
fs.Name = para[1];
fs.Update();
return
(Newtonsoft.Json.JsonConvert.SerializeObject(
new { success = true, msg = string.Empty, data = fs.No }));
}
catch (Exception ex)
{
BP.DA.Log.DefaultLogWriteLineError("Do Method NewSameLevelFlowSort Branch has a error , para:\t" + para1 + ex.Message);
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = ex.Message }));
}
case "NewSubFlowSort": //创建子级别的 表单树 目录.
try
{
var para = para1.Split(',');
FlowSort fsSub = new FlowSort(para[0]);
string subNodeNo = fsSub.DoCreateSubNode().No;
FlowSort subFlowSort = new FlowSort(subNodeNo);
subFlowSort.Name = para[1];
subFlowSort.Update();
return
(Newtonsoft.Json.JsonConvert.SerializeObject(
new { success = true, msg = string.Empty, data = subFlowSort.No }));
}
catch (Exception ex)
{
BP.DA.Log.DefaultLogWriteLineError("Do Method NewSubFlowSort Branch has a error , para:\t" + ex.Message);
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = ex.Message }));
}
case "EditFlowSort": //编辑表单树.
try
{
var para = para1.Split(',');
fs = new FlowSort(para[0]);
fs.Name = para[1];
fs.Save();
return
(Newtonsoft.Json.JsonConvert.SerializeObject(
new { success = true, msg = string.Empty, data = fs.No }));
}
catch (Exception ex)
{
BP.DA.Log.DefaultLogWriteLineError("Do Method EditFlowSort Branch has a error , para:\t" + para1 + ex.Message);
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = ex.Message }));
}
case "NewFlow": //创建新流程.
Flow fl = new Flow();
try
{
string[] ps = para1.Split(',');
if (ps.Length != 5)
{
throw new Exception("@创建流程参数错误");
}
string fk_floSort = ps[0]; //类别编号.
string flowName = ps[1]; // 流程名称.
DataStoreModel dataSaveModel = (DataStoreModel)int.Parse(ps[2]); //数据保存方式。
string pTable = ps[3]; // 物理表名。
string FlowMark = ps[4]; // 流程标记.
fl.DoNewFlow(fk_floSort, flowName, dataSaveModel, pTable, FlowMark);
return
(Newtonsoft.Json.JsonConvert.SerializeObject(
new { success = true, msg = string.Empty, data = new { no = fl.No, name = fl.Name } }));
}
catch (Exception ex)
{
BP.DA.Log.DefaultLogWriteLineError("Do Method NewFlow Branch has a error , para:\t" + para1 + ex.Message);
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = ex.Message }));
}
case "DelFlow": //删除流程.
try
{
return
(Newtonsoft.Json.JsonConvert.SerializeObject(
new { success = true, msg = WorkflowDefintionManager.DeleteFlowTemplete(para1) }));
}
catch (Exception ex)
{
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = ex.Message }));
}
case "DelFlowSort":
try
{
FlowSort delfs = new FlowSort();
delfs.No = para1;
delfs.Delete();
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = true }));
}
catch (Exception ex)
{
BP.DA.Log.DefaultLogWriteLineError("Do Method DelFlowSort Branch has a error , para:\t" + para1 + ex.Message);
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = ex.Message }));
}
case "DelNode":
try
{
if (!string.IsNullOrEmpty(para1))
{
BP.WF.Node delNode = new BP.WF.Node(int.Parse(para1));
delNode.Delete();
}
else
{
throw new Exception("@参数错误:" + para1);
}
}
catch (Exception ex)
{
return("err:" + ex.Message);
}
return(null);
case "GetSettings":
return(SystemConfig.AppSettings[para1]);
case "SaveFlowFrm": //保存独立表单.
Entity en = null;
try
{
AtPara ap = new AtPara(para1);
string enName = ap.GetValStrByKey("EnName");
string pk = ap.GetValStrByKey("PKVal");
en = ClassFactory.GetEn(enName);
en.ResetDefaultVal();
if (en == null)
{
throw new Exception("无效的类名:" + enName);
}
if (string.IsNullOrEmpty(pk) == false)
{
en.PKVal = pk;
en.RetrieveFromDBSources();
}
foreach (string key in ap.HisHT.Keys)
{
if (key == "PKVal")
{
continue;
}
en.SetValByKey(key, ap.HisHT[key].ToString().Replace('^', '@'));
}
en.Save();
return(en.PKVal as string);
}
catch (Exception ex)
{
if (en != null)
{
en.CheckPhysicsTable();
}
return("Error:" + ex.Message);
}
case "ChangeNodeType":
var p = para1.Split(',');
try
{
if (p.Length != 3)
{
throw new Exception("@修改节点类型参数错误");
}
//var sql = "UPDATE WF_Node SET Icon='{0}' WHERE FK_Flow='{1}' AND NodeID='{2}'";
var sql = "UPDATE WF_Node SET RunModel={0} WHERE FK_Flow='{1}' AND NodeID={2}";
DBAccess.RunSQL(string.Format(sql, p[0], p[1], p[2]));
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = true }));
}
catch (Exception ex)
{
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = ex.Message }));
}
case "ChangeNodeIcon":
p = para1.Split(',');
try
{
if (p.Length != 3)
{
throw new Exception("@修改节点图标参数错误");
}
var sql = "UPDATE WF_Node SET Icon='{0}' WHERE FK_Flow='{1}' AND NodeID={2}";
DBAccess.RunSQL(string.Format(sql, p[0], p[1], p[2]));
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = true }));
}
catch (Exception ex)
{
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = ex.Message }));
}
default:
throw new Exception("@没有约定的执行标记:" + doWhat);
}
}
/// <summary>
/// 树节点管理
/// </summary>
public string Do()
{
string doWhat = getUTF8ToString("doWhat");
string para1 = getUTF8ToString("para1");
// 如果admin账户登陆时有错误发生，则返回错误信息
var result = LetAdminLogin("CH", true);
if (string.IsNullOrEmpty(result) == false)
{
return(result);
}
switch (doWhat)
{
case "GetFlowSorts": //获取所有流程类型
try
{
FlowSorts flowSorts = new FlowSorts();
flowSorts.RetrieveAll(FlowSortAttr.Idx);
return(BP.Tools.Entitis2Json.ConvertEntitis2GenerTree(flowSorts, "0"));
}
catch (Exception ex)
{
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = ex.Message }));
}
case "NewSameLevelFrmSort": //创建同级别的 表单树 目录.
SysFormTree frmSort = null;
try
{
var para = para1.Split(',');
frmSort = new SysFormTree(para[0]);
string sameNodeNo = frmSort.DoCreateSameLevelNode().No;
frmSort = new SysFormTree(sameNodeNo);
frmSort.Name = para[1];
frmSort.Update();
return(null);
}
catch (Exception ex)
{
return("Do Method NewFormSort Branch has a error , para:\t" + para1 + ex.Message);
}
case "NewSubLevelFrmSort": //创建子级别的 表单树 目录.
SysFormTree frmSortSub = null;
try
{
var para = para1.Split(',');
frmSortSub = new SysFormTree(para[0]);
string sameNodeNo = frmSortSub.DoCreateSubNode().No;
frmSortSub = new SysFormTree(sameNodeNo);
frmSortSub.Name = para[1];
frmSortSub.Update();
return(null);
}
catch (Exception ex)
{
return("Do Method NewSubLevelFrmSort Branch has a error , para:\t" + para1 + ex.Message);
}
case "NewSameLevelFlowSort": //创建同级别的 流程树 目录.
FlowSort fs = null;
try
{
var para = para1.Split(',');
fs = new FlowSort(para[0].Replace("F", "")); //传入的编号多出F符号，需要替换掉
string sameNodeNo = fs.DoCreateSameLevelNode().No;
fs = new FlowSort(sameNodeNo);
fs.Name = para[1];
fs.Update();
return
(Newtonsoft.Json.JsonConvert.SerializeObject(
new { success = true, msg = string.Empty, data = "F" + fs.No }));
}
catch (Exception ex)
{
BP.DA.Log.DefaultLogWriteLineError("Do Method NewSameLevelFlowSort Branch has a error , para:\t" + para1 + ex.Message);
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = ex.Message }));
}
case "NewSubFlowSort": //创建子级别的 流程树 目录.
try
{
var para = para1.Split(',');
FlowSort fsSub = new FlowSort(para[0].Replace("F", ""));//传入的编号多出F符号，需要替换掉
string subNodeNo = fsSub.DoCreateSubNode().No;
FlowSort subFlowSort = new FlowSort(subNodeNo);
subFlowSort.Name = para[1];
subFlowSort.Update();
return
(Newtonsoft.Json.JsonConvert.SerializeObject(
new { success = true, msg = string.Empty, data = "F" + subFlowSort.No }));
}
catch (Exception ex)
{
BP.DA.Log.DefaultLogWriteLineError("Do Method NewSubFlowSort Branch has a error , para:\t" + ex.Message);
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = ex.Message }));
}
case "EditFlowSort": //编辑表单树.
try
{
var para = para1.Split(',');
fs = new FlowSort(para[0].Replace("F", ""));//传入的编号多出F符号，需要替换掉
fs.Name = para[1];
fs.Save();
return
(Newtonsoft.Json.JsonConvert.SerializeObject(
new { success = true, msg = string.Empty, data = fs.No }));
}
catch (Exception ex)
{
BP.DA.Log.DefaultLogWriteLineError("Do Method EditFlowSort Branch has a error , para:\t" + para1 + ex.Message);
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = ex.Message }));
}
case "NewFlow": //创建新流程.
try
{
string[] ps = para1.Split(',');
if (ps.Length != 6)
{
throw new Exception("@创建流程参数错误");
}
string fk_floSort = ps[0]; //类别编号.
fk_floSort = fk_floSort.Replace("F", ""); //传入的编号多出F符号，需要替换掉
string flowName = ps[1]; // 流程名称.
DataStoreModel dataSaveModel = (DataStoreModel)int.Parse(ps[2]); //数据保存方式。
string pTable = ps[3]; // 物理表名。
string flowMark = ps[4]; // 流程标记.
string flowVer = ps[5]; // 流程版本
string FK_Flow = BP.BPMN.Glo.NewFlow(fk_floSort, flowName, dataSaveModel, pTable, flowMark, flowVer);
return
(Newtonsoft.Json.JsonConvert.SerializeObject(
new { success = true, msg = string.Empty, data = new { no = FK_Flow, name = flowName } }));
}
catch (Exception ex)
{
BP.DA.Log.DefaultLogWriteLineError("Do Method NewFlow Branch has a error , para:\t" + para1 + ex.Message);
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = ex.Message }));
}
case "DelFlow": //删除流程.
try
{
return(Newtonsoft.Json.JsonConvert.SerializeObject(
new { success = true, msg = WorkflowDefintionManager.DeleteFlowTemplete(para1) }));
}
catch (Exception ex)
{
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = ex.Message }));
}
case "DelFlowSort":
try
{
string FK_FlowSort = para1.Replace("F", "");
string forceDel = getUTF8ToString("force");
FlowSort delfs = new FlowSort();
delfs.No = FK_FlowSort;
//强制删除，不需判断是否含有子项。
if (forceDel == "true")
{
delfs.DeleteFlowSortSubNode_Force();
delfs.Delete();
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = true, reason = "" }));
}
//判断是否包含子类别
if (delfs.HisSubFlowSorts != null && delfs.HisSubFlowSorts.Count > 0)
{
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, reason = "havesubsorts", msg = "此类别下包含子类别。" }));
}
//判断是否包含工作流程
if (delfs.HisFlows != null && delfs.HisFlows.Count > 0)
{
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, reason = "haveflows", msg = "此类别下包含流程。" }));
}
//执行删除
delfs.Delete();
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = true, reason = "" }));
}
catch (Exception ex)
{
BP.DA.Log.DefaultLogWriteLineError("Do Method DelFlowSort Branch has a error , para:\t" + para1 + ex.Message);
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = ex.Message }));
}
case "DelNode":
try
{
if (!string.IsNullOrEmpty(para1))
{
BP.WF.Node delNode = new BP.WF.Node(int.Parse(para1));
delNode.Delete();
}
else
{
throw new Exception("@参数错误:" + para1);
}
}
catch (Exception ex)
{
return("err:" + ex.Message);
}
return(null);
case "SetBUnit":
try
{
if (!string.IsNullOrEmpty(para1))
{
BP.WF.Node nd = new BP.WF.Node(int.Parse(para1));
nd.IsTask = !nd.IsBUnit;
nd.Update();
}
else
{
throw new Exception("@参数错误:" + para1);
}
}
catch (Exception ex)
{
return("err:" + ex.Message);
}
return(null);
case "GetSettings":
return(SystemConfig.AppSettings[para1]);
case "SaveFlowFrm": //保存流程表单.
Entity en = null;
try
{
AtPara ap = new AtPara(para1);
string enName = ap.GetValStrByKey("EnName");
string pk = ap.GetValStrByKey("PKVal");
en = ClassFactory.GetEn(enName);
en.ResetDefaultVal();
if (en == null)
{
throw new Exception("无效的类名:" + enName);
}
if (string.IsNullOrEmpty(pk) == false)
{
en.PKVal = pk;
en.RetrieveFromDBSources();
}
foreach (string key in ap.HisHT.Keys)
{
if (key == "PKVal")
{
continue;
}
en.SetValByKey(key, ap.HisHT[key].ToString().Replace('^', '@'));
}
en.Save();
return(en.PKVal as string);
}
catch (Exception ex)
{
if (en != null)
{
en.CheckPhysicsTable();
}
return("Error:" + ex.Message);
}
case "ChangeNodeType":
var p = para1.Split(',');
try
{
if (p.Length != 3)
{
throw new Exception("@修改节点类型参数错误");
}
//var sql = "UPDATE WF_Node SET Icon='{0}' WHERE FK_Flow='{1}' AND NodeID='{2}'";
var sql = "UPDATE WF_Node SET RunModel={0} WHERE FK_Flow='{1}' AND NodeID={2}";
DBAccess.RunSQL(string.Format(sql, p[0], p[1], p[2]));
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = true }));
}
catch (Exception ex)
{
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = ex.Message }));
}
case "ChangeNodeIcon":
p = para1.Split(',');
try
{
if (p.Length != 3)
{
throw new Exception("@修改节点图标参数错误");
}
var sql = "UPDATE WF_Node SET Icon='{0}' WHERE FK_Flow='{1}' AND NodeID={2}";
DBAccess.RunSQL(string.Format(sql, p[0], p[1], p[2]));
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = true }));
}
catch (Exception ex)
{
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { success = false, msg = ex.Message }));
}
default:
throw new Exception("@没有约定的执行标记:" + doWhat);
}
}