public void EditDefaultMessage(T_WF_MESSAGEBODYDEFINE entity)
{
try
{
string updSql = @"UPDATE T_WF_MESSAGEBODYDEFINE SET SYSTEMCODE=:SYSTEMCODE,MODELCODE=:MODELCODE,MESSAGEBODY=:MESSAGEBODY,
MESSAGEURL=:MESSAGEURL,RECEIVEPOSTID=:RECEIVEPOSTID,RECEIVEPOSTNAME=:RECEIVEPOSTNAME,RECEIVERUSERID=:RECEIVERUSERID,RECEIVERUSERNAME=:RECEIVERUSERNAME,RECEIVETYPE=:RECEIVETYPE
WHERE DEFINEID=:DEFINEID";
OracleParameter[] pageparm =
{
new OracleParameter(":DEFINEID", dal.GetValue(entity.DEFINEID)), //默认消息ID
new OracleParameter(":SYSTEMCODE", dal.GetValue(entity.SYSTEMCODE)), //系统代号
new OracleParameter(":MODELCODE", dal.GetValue(entity.MODELCODE)), //模块代码
new OracleParameter(":MESSAGEBODY", dal.GetValue(entity.MESSAGEBODY)), //消息体
new OracleParameter(":MESSAGEURL", dal.GetValue(entity.MESSAGEURL)), //消息链接
new OracleParameter(":RECEIVEPOSTID", dal.GetValue(entity.RECEIVEPOSTID)), //
new OracleParameter(":RECEIVEPOSTNAME", dal.GetValue(entity.RECEIVEPOSTNAME)), //
new OracleParameter(":RECEIVERUSERID", dal.GetValue(entity.RECEIVERUSERID)), //
new OracleParameter(":RECEIVERUSERNAME", dal.GetValue(entity.RECEIVERUSERNAME)), //
new OracleParameter(":RECEIVETYPE", dal.GetValue(entity.RECEIVETYPE)) //
};
dal.ExecuteSql(updSql, pageparm);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
//删除默认消息
public bool DeleteFlowMsgsDefine(T_WF_MESSAGEBODYDEFINE FlowMsglList)
{
try
{
int result = 0;
dao.Open();
dao.BeginTransaction();
string Sql = "delete from T_WF_MESSAGEBODYDEFINE "
+ "where DEFINEID = '" + FlowMsglList.DEFINEID + "' ";
result = dao.ExecuteNonQuery(Sql);
if (result == 0)
{
dao.RollbackTransaction();
return(false);
}
dao.CommitTransaction();
return(result > 0 ? true : false);
}
catch
{
dao.RollbackTransaction();
return(false);
}
finally
{
dao.Close();
}
}
private void BindRoleUser(T_WF_MESSAGEBODYDEFINE entity, bool mark)
{
if (!mark)
{
string[] postarrID = entity.RECEIVEPOSTID.Split(',');
string[] postarrName = entity.RECEIVEPOSTNAME.Split(',');
OrgObjPost = new List <SaaS.FrameworkUI.OrganizationControl.ExtOrgObj>();
for (int i = 0; i < postarrID.Length; i++)
{
OrgObjPost.Add(new SaaS.FrameworkUI.OrganizationControl.ExtOrgObj()
{
ObjectID = postarrID[i], ObjectName = postarrName[i]
});
}
}
else
{
string[] userID = entity.RECEIVERUSERID.Split(',');
string[] userName = entity.RECEIVERUSERNAME.Split(',');
OrgObj = new List <SaaS.FrameworkUI.OrganizationControl.ExtOrgObj>();
for (int i = 0; i < userID.Length; i++)
{
OrgObj.Add(new SaaS.FrameworkUI.OrganizationControl.ExtOrgObj()
{
ObjectID = userID[i], ObjectName = userName[i]
});
}
}
}
public bool ExistsDefaultMessage(T_WF_MESSAGEBODYDEFINE entity)
{
try
{
string sql = "select DEFINEID from T_WF_MESSAGEBODYDEFINE where SYSTEMCODE='" + entity.SYSTEMCODE + "' and MODELCODE='" + entity.MODELCODE + "' and COMPANYID='" + entity.COMPANYID + "' and DEFINEID!='" + entity.DEFINEID + "'";
if (dal.GetDataTable(sql).Rows.Count > 0)
{
return(false);
}
return(true);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public string EditDefaultMessge(T_WF_MESSAGEBODYDEFINE entity)
{
try
{
if (messagebll.ExistsDefaultMessage(entity))
{
messagebll.EditDefaultMessage(entity);
return("1");
}
else
{
return("2");
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
private void btnDelect_Click(object sender, RoutedEventArgs e)
{
if (DataGridDefaultMessage.SelectedItems.Count == 1)
{
pBar.Start();
string Result = "";
ComfirmWindow com = new ComfirmWindow();
com.OnSelectionBoxClosed += (obj, result) =>
{
T_WF_MESSAGEBODYDEFINE ent = DataGridDefaultMessage.SelectedItem as T_WF_MESSAGEBODYDEFINE;
messageClient.DeleteDefaultMessgeAsync(ent.DEFINEID);
};
com.SelectionBox("删除确定", "你确定删除选中信息吗？", ComfirmWindow.titlename, Result);
}
else
{
//MessageBox.Show("请先选择一条需要删除的记录!");
ComfirmWindow.ConfirmationBox("提示信息", "请先选择一条需要删除的记录", "确定");
}
}
//添加默认消息
public bool AddFlowMsgDefine(T_WF_MESSAGEBODYDEFINE FlowMsg)
{
try
{
int result = 0;
dao.Open();
//string sql = "insert into T_WF_MESSAGEBODYDEFINE(DEFINEID, SYSTEMCODE, MODELCODE, MESSAGEBODY, MESSAGEURL, CREATEDATE,COMPANYID,CREATEUSERNAME,CREATEUSERID,MESSAGETYPE)"
// + "values('" + FlowMsg.DEFINEID + "','" + FlowMsg.SYSTEMCODE + "','" + FlowMsg.MODELCODE + "',"
// + "'" + FlowMsg.MESSAGEBODY + "','" + FlowMsg.MESSAGEURL + "',to_date('" + FlowMsg.CREATEDATE + "','yyyy-mm-dd hh24:mi:ss'),"
// + "'" + FlowMsg.COMPANYID + "','" + FlowMsg.CREATEUSERNAME + "','" + FlowMsg.CREATEUSERID + "','" + FlowMsg.MESSAGETYPE + "')";
//result = dao.ExecuteNonQuery(sql);
string insSql = "INSERT INTO T_WF_MESSAGEBODYDEFINE (DEFINEID,COMPANYID,SYSTEMCODE,MODELCODE,MESSAGEBODY,MESSAGEURL,MESSAGETYPE,CREATEDATE,CREATEUSERNAME,CREATEUSERID) VALUES (:DEFINEID,:COMPANYID,:SYSTEMCODE,:MODELCODE,:MESSAGEBODY,:MESSAGEURL,:MESSAGETYPE,:CREATEDATE,:CREATEUSERNAME,:CREATEUSERID)";
OracleParameter[] pageparm =
{
new OracleParameter(":DEFINEID", GetValue(FlowMsg.DEFINEID)), //默认消息ID
new OracleParameter(":COMPANYID", GetValue(FlowMsg.COMPANYID)), //公司ID
new OracleParameter(":SYSTEMCODE", GetValue(FlowMsg.SYSTEMCODE)), //系统代号
new OracleParameter(":MODELCODE", GetValue(FlowMsg.MODELCODE)), //模块代码
new OracleParameter(":MESSAGEBODY", GetValue(FlowMsg.MESSAGEBODY)), //消息体
new OracleParameter(":MESSAGEURL", GetValue(FlowMsg.MESSAGEURL)), //消息链接
new OracleParameter(":MESSAGETYPE", GetValue(FlowMsg.MESSAGETYPE)), //消息类型
new OracleParameter(":CREATEDATE", GetValue(FlowMsg.CREATEDATE)), //创建日期
new OracleParameter(":CREATEUSERNAME", GetValue(FlowMsg.CREATEUSERNAME)), //创建人名称
new OracleParameter(":CREATEUSERID", GetValue(FlowMsg.CREATEUSERID)) //创建人
};
result = dao.ExecuteNonQuery(insSql, System.Data.CommandType.Text, pageparm);
return(result > 0 ? true : false);
}
catch
{
return(false);
}
finally
{
dao.Close();
}
}
/// <summary>
/// 新增默认消息
/// </summary>
/// <param name="entity"></param>
public void AddDefaultMessage(T_WF_MESSAGEBODYDEFINE entity)
{
try
{
if (string.IsNullOrWhiteSpace(entity.DEFINEID))
{
entity.DEFINEID = Guid.NewGuid().ToString();
}
string insSql = @"INSERT INTO T_WF_MESSAGEBODYDEFINE (DEFINEID,COMPANYID,SYSTEMCODE,MODELCODE,MESSAGEBODY,MESSAGEURL,MESSAGETYPE,
RECEIVEPOSTID,RECEIVEPOSTNAME,RECEIVERUSERID,RECEIVERUSERNAME,RECEIVETYPE,CREATEDATE,
CREATEUSERNAME,CREATEUSERID) VALUES (:DEFINEID,:COMPANYID,:SYSTEMCODE,:MODELCODE,:MESSAGEBODY,:MESSAGEURL,:MESSAGETYPE,
:RECEIVEPOSTID,:RECEIVEPOSTNAME,:RECEIVERUSERID,:RECEIVERUSERNAME,:RECEIVETYPE,:CREATEDATE,:CREATEUSERNAME,:CREATEUSERID)";
OracleParameter[] pageparm =
{
new OracleParameter(":DEFINEID", dal.GetValue(entity.DEFINEID)), //默认消息ID
new OracleParameter(":COMPANYID", dal.GetValue(entity.COMPANYID)), //公司ID
new OracleParameter(":SYSTEMCODE", dal.GetValue(entity.SYSTEMCODE)), //系统代号
new OracleParameter(":MODELCODE", dal.GetValue(entity.MODELCODE)), //模块代码
new OracleParameter(":MESSAGEBODY", dal.GetValue(entity.MESSAGEBODY)), //消息体
new OracleParameter(":MESSAGEURL", dal.GetValue(entity.MESSAGEURL)), //消息链接
new OracleParameter(":MESSAGETYPE", dal.GetValue(entity.MESSAGETYPE)), //消息类型
new OracleParameter(":RECEIVEPOSTID", dal.GetValue(entity.RECEIVEPOSTID)), //
new OracleParameter(":RECEIVEPOSTNAME", dal.GetValue(entity.RECEIVEPOSTNAME)), //
new OracleParameter(":RECEIVERUSERID", dal.GetValue(entity.RECEIVERUSERID)), //
new OracleParameter(":RECEIVERUSERNAME", dal.GetValue(entity.RECEIVERUSERNAME)), //
new OracleParameter(":RECEIVETYPE", dal.GetValue(entity.RECEIVETYPE)), //
new OracleParameter(":CREATEDATE", dal.GetValue(DateTime.Now)), //创建日期
new OracleParameter(":CREATEUSERNAME", dal.GetValue(entity.CREATEUSERNAME)), //创建人名称
new OracleParameter(":CREATEUSERID", dal.GetValue(entity.CREATEUSERID)) //创建人
};
dal.ExecuteSql(insSql, pageparm);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
//修改默认消息
public bool UpdateFlowMsgDefine(T_WF_MESSAGEBODYDEFINE FlowMsg)
{
try
{
int result = 0;
dao.Open();
//string sql = "update T_WF_MESSAGEBODYDEFINE set "
// + "SYSTEMCODE = '" + FlowMsg.SYSTEMCODE + "', "
// + "MODELCODE = '" + FlowMsg.MODELCODE + "', "
// + "MESSAGEBODY = '" + FlowMsg.MESSAGEBODY + "',"
// + "MESSAGEURL = '" + FlowMsg.MESSAGEURL + "' "
// + "where DEFINEID = '" + FlowMsg.DEFINEID + "' ";
//result = dao.ExecuteNonQuery(sql);
string updSql = "UPDATE T_WF_MESSAGEBODYDEFINE SET SYSTEMCODE=:SYSTEMCODE,MODELCODE=:MODELCODE,MESSAGEBODY=:MESSAGEBODY,MESSAGEURL=:MESSAGEURL WHERE DEFINEID=:DEFINEID";
OracleParameter[] pageparm =
{
new OracleParameter(":DEFINEID", GetValue(FlowMsg.DEFINEID)), //默认消息ID
new OracleParameter(":SYSTEMCODE", GetValue(FlowMsg.SYSTEMCODE)), //系统代号
new OracleParameter(":MODELCODE", GetValue(FlowMsg.MODELCODE)), //模块代码
new OracleParameter(":MESSAGEBODY", GetValue(FlowMsg.MESSAGEBODY)), //消息体
new OracleParameter(":MESSAGEURL", GetValue(FlowMsg.MESSAGEURL)) //消息链接
};
result = dao.ExecuteNonQuery(updSql, System.Data.CommandType.Text, pageparm);
return(result > 0 ? true : false);
}
catch
{
return(false);
}
finally
{
dao.Close();
}
}
private void BindRoleUser(T_WF_MESSAGEBODYDEFINE entity, bool mark)
{
if (!mark)
{
string[] postarrID = entity.RECEIVEPOSTID.Split(',');
string[] postarrName = entity.RECEIVEPOSTNAME.Split(',');
OrgObjPost = new List<SaaS.FrameworkUI.OrganizationControl.ExtOrgObj>();
for (int i = 0; i < postarrID.Length; i++)
{
OrgObjPost.Add(new SaaS.FrameworkUI.OrganizationControl.ExtOrgObj() { ObjectID = postarrID[i], ObjectName = postarrName[i] });
}
}
else
{
string[] userID = entity.RECEIVERUSERID.Split(',');
string[] userName = entity.RECEIVERUSERNAME.Split(',');
OrgObj = new List<SaaS.FrameworkUI.OrganizationControl.ExtOrgObj>();
for (int i = 0; i < userID.Length; i++)
{
OrgObj.Add(new SaaS.FrameworkUI.OrganizationControl.ExtOrgObj() { ObjectID = userID[i], ObjectName = userName[i] });
}
}
}
//删除默认消息
public bool DeleteFlowMsgsDefine(T_WF_MESSAGEBODYDEFINE FlowMsgList)
{
return(dal.DeleteFlowMsgsDefine(FlowMsgList));
}
//修改默认消息
public bool UpdateFlowMsgDefine(T_WF_MESSAGEBODYDEFINE FlowMsg)
{
return(dal.UpdateFlowMsgDefine(FlowMsg));
}
//添加默认消息
public bool AddFlowMsgDefine(T_WF_MESSAGEBODYDEFINE FlowMsg)
{
return(dal.AddFlowMsgDefine(FlowMsg));
}
//引擎添加、修改方法
public string FlowEventAll(T_WF_MESSAGEBODYDEFINE FlowMsg, List <T_WF_DOTASKRULE> ListFlowProecss, List <T_FLOW_CUSTOMFLOWDEFINE> ListCuostomFlowsDefine, List <T_WF_TIMINGTRIGGERCONFIG> ListFlowTrigger)
{
return(dal.FlowEventAll(FlowMsg, ListFlowProecss, ListCuostomFlowsDefine, ListFlowTrigger));
}
//引擎添加、修改方法
public string FlowEventAll(T_WF_MESSAGEBODYDEFINE FlowMsg, List <T_WF_DOTASKRULE> ListFlowProecss, List <T_FLOW_CUSTOMFLOWDEFINE> ListCuostomFlowsDefine, List <T_WF_TIMINGTRIGGERCONFIG> ListFlowTrigger)
{
try
{
int result = 0;
string DelectFlowMsg = string.Empty; //
List <T_WF_DOTASKRULEDETAIL> DelectProecss = new List <T_WF_DOTASKRULEDETAIL>(); //
List <T_FLOW_CUSTOMFLOWDEFINE> Delectcustom = new List <T_FLOW_CUSTOMFLOWDEFINE>(); //
List <T_WF_TIMINGTRIGGERCONFIG> Delecttrigger = new List <T_WF_TIMINGTRIGGERCONFIG>(); //
List <T_WF_DOTASKRULEDETAIL> NotDelectProecss = new List <T_WF_DOTASKRULEDETAIL>(); //
List <T_WF_DOTASKRULE> DotaskRuid = new List <T_WF_DOTASKRULE>(); //
List <T_WF_DOTASKRULE> DotaskRuids = new List <T_WF_DOTASKRULE>(); //
#region 查询数据
//查询所有存在的数据
if (FlowMsg != null) //消息定义
{
string sql = "select * from T_WF_MESSAGEBODYDEFINE "
+ "where DEFINEID = '" + FlowMsg.DEFINEID + "' ";
dao.Open();
DataTable dtFlowMsg = dao.GetDataTable(sql);
var itemes = ToList <T_WF_MESSAGEBODYDEFINE>(dtFlowMsg).AsQueryable();
if (itemes.ToList().Count() > 0)
{
DelectFlowMsg = itemes.FirstOrDefault().DEFINEID;
}
}
if (ListFlowProecss != null) // 默认规则
{
DotaskRuid.Clear();
foreach (var items in ListFlowProecss)
{
string sqlp = "select * from T_WF_DOTASKRULEDETAIL "
+ "where DOTASKRULEDETAILID ='" + items.DOTASKRULEDETAIL.DOTASKRULEDETAILID + "' ";
dao.Open();
DataTable dtFlowProecss = dao.GetDataTable(sqlp);
var ipross = ToList <T_WF_DOTASKRULEDETAIL>(dtFlowProecss).AsQueryable();
if (ipross.ToList().Count() > 0)
{
DelectProecss.Add(items.DOTASKRULEDETAIL);
}
string sqlcec = "select * from T_WF_DOTASKRULE "
+ "where SYSTEMCODE = '" + items.SYSTEMCODE + "' and MODELCODE = '" + items.MODELCODE + "' and TRIGGERORDERSTATUS = " + items.TRIGGERORDERSTATUS + " and COMPANYID = '" + items.COMPANYID + "'";
DataTable dtCuostomFlowsDefinees = dao.GetDataTable(sqlcec);
var iCuostomes = ToList <T_WF_DOTASKRULE>(dtCuostomFlowsDefinees);
if (iCuostomes.ToList().Count() == 1)
{
if (ipross.ToList().Count() > 0)
{
if (DotaskRuid.Where(p => p.DOTASKRULEID == iCuostomes.FirstOrDefault().DOTASKRULEID).Count() == 0)
{
DotaskRuid.Add(iCuostomes[0]);
}
}
else if (ipross.ToList().Count() == 0)
{
DotaskRuids.Add(iCuostomes[0]);
}
}
else if (iCuostomes.ToList().Count() == 0)
{
NotDelectProecss.Add(items.DOTASKRULEDETAIL);
}
}
}
if (ListCuostomFlowsDefine != null) //自动发起流程
{
foreach (var itemsc in ListCuostomFlowsDefine)
{
string sqlc = "select * from T_FLOW_CUSTOMFLOWDEFINE "
+ "where PROCESSID = '" + itemsc.PROCESSID + "' ";
dao.Open();
DataTable dtCuostomFlowsDefine = dao.GetDataTable(sqlc);
var iCuostom = ToList <T_FLOW_CUSTOMFLOWDEFINE>(dtCuostomFlowsDefine).AsQueryable();
if (iCuostom.ToList().Count() > 0)
{
Delectcustom.Add(itemsc);
}
}
}
if (ListFlowTrigger != null) //定时触发
{
foreach (var itemst in ListFlowTrigger)
{
string sqlc = "select * from T_WF_TIMINGTRIGGERCONFIG "
+ "where TIMINGCONFIGID = '" + itemst.TIMINGCONFIGID + "' ";
dao.Open();
DataTable dtFlowTrigger = dao.GetDataTable(sqlc);
var iTrigger = ToList <T_WF_TIMINGTRIGGERCONFIG>(dtFlowTrigger).AsQueryable();
if (iTrigger.ToList().Count() > 0)
{
Delecttrigger.Add(itemst);
}
}
}
#endregion
#region 除数据
//删除数据
dao.BeginTransaction();
if (DelectFlowMsg != "")
{
string Sql = "delete from T_WF_MESSAGEBODYDEFINE "
+ "where DEFINEID = '" + DelectFlowMsg + "' ";
result = dao.ExecuteNonQuery(Sql);
if (result == 0) //消息删除
{
dao.RollbackTransaction();
return("消息定义保存失败！");
}
}
if (DelectProecss.Count() > 0 || DotaskRuid.Count() > 0)
{
foreach (var itempr in DelectProecss) //默认规则
{
string Sqlpr = "delete from T_WF_DOTASKRULEDETAIL "
+ "where DOTASKRULEID = '" + itempr.DOTASKRULEID + "' ";
result = dao.ExecuteNonQuery(Sqlpr);
//if (result == 0)
//{
// dao.RollbackTransaction();
// return "默认规则保存失败!";
//}
if (DotaskRuid.Where(p => p.DOTASKRULEID == itempr.DOTASKRULEID).Count() > 0)
{
string Sqlfl = "delete from T_WF_DOTASKRULE "
+ "where DOTASKRULEID = '" + itempr.DOTASKRULEID + "' ";
result = dao.ExecuteNonQuery(Sqlfl);
//if (result == 0)
//{
// dao.RollbackTransaction();
// return "默认规则保存失败!";
//}
}
}
}
if (Delectcustom.Count() > 0)
{
foreach (var itemctm in Delectcustom) //自动发起流程
{
string Sqlctm = "delete from T_FLOW_CUSTOMFLOWDEFINE "
+ "where PROCESSID = '" + itemctm.PROCESSID + "' ";
result = dao.ExecuteNonQuery(Sqlctm);
if (result == 0)
{
dao.RollbackTransaction();
return("自动发起流程保存失败!");
}
}
}
if (Delecttrigger.Count() > 0)
{
foreach (var itemter in Delecttrigger) //定时触发
{
string Sqlter = "delete from T_WF_TIMINGTRIGGERCONFIG "
+ "where TIMINGCONFIGID = '" + itemter.TIMINGCONFIGID + "' ";
result = dao.ExecuteNonQuery(Sqlter);
if (result == 0)
{
dao.RollbackTransaction();
return("定时触发定义保存失败!");
}
string Sqlger = "delete from T_WF_TIMINGTRIGGERACTIVITY "
+ "where TIMINGCONFIGID = '" + itemter.TIMINGCONFIGID + "' ";
result = dao.ExecuteNonQuery(Sqlger);
//if (result == 0)
//{
// dao.RollbackTransaction();
// return "定时触发定义保存失败!";
//}
}
}
#endregion
#region 添加数据
if (FlowMsg != null)
{
string SqlAmsg = "insert into T_WF_MESSAGEBODYDEFINE(DEFINEID, SYSTEMCODE, MODELCODE, MESSAGEBODY, MESSAGEURL, CREATEDATE,COMPANYID,CREATEUSERNAME,CREATEUSERID,MESSAGETYPE)"
+ "values('" + FlowMsg.DEFINEID + "','" + FlowMsg.SYSTEMCODE + "','" + FlowMsg.MODELCODE + "',"
+ "'" + FlowMsg.MESSAGEBODY + "','" + FlowMsg.MESSAGEURL + "',to_date('" + FlowMsg.CREATEDATE + "','yyyy-mm-dd hh24:mi:ss'),"
+ "'" + FlowMsg.COMPANYID + "','" + FlowMsg.CREATEUSERNAME + "','" + FlowMsg.CREATEUSERID + "','" + FlowMsg.MESSAGETYPE + "')";
result = dao.ExecuteNonQuery(SqlAmsg); //消息定义
if (result == 0) //消息删除
{
dao.RollbackTransaction();
return("消息定义保存失败！");
}
}
if (ListFlowProecss != null)
{
List <string> triggerID = new List <string>();
foreach (var FlowTrigger in ListFlowProecss) //触发规则
{
string DotaskRuleID = string.Empty;
bool rueslt = false; //判断是否要添加主表
if (DotaskRuid.Where(p => p.SYSTEMCODE == FlowTrigger.SYSTEMCODE && p.MODELCODE == FlowTrigger.MODELCODE && p.TRIGGERORDERSTATUS == FlowTrigger.TRIGGERORDERSTATUS).Count() > 0)
{
rueslt = true;
DotaskRuleID = DotaskRuid.Where(p => p.SYSTEMCODE == FlowTrigger.SYSTEMCODE && p.MODELCODE == FlowTrigger.MODELCODE && p.TRIGGERORDERSTATUS == FlowTrigger.TRIGGERORDERSTATUS).FirstOrDefault().DOTASKRULEID;
}
else if (DotaskRuids.Where(p => p.SYSTEMCODE == FlowTrigger.SYSTEMCODE && p.MODELCODE == FlowTrigger.MODELCODE && p.TRIGGERORDERSTATUS == FlowTrigger.TRIGGERORDERSTATUS).Count() > 0)
{
rueslt = false;
DotaskRuleID = DotaskRuids.Where(p => p.SYSTEMCODE == FlowTrigger.SYSTEMCODE && p.MODELCODE == FlowTrigger.MODELCODE && p.TRIGGERORDERSTATUS == FlowTrigger.TRIGGERORDERSTATUS).FirstOrDefault().DOTASKRULEID;
}
else
{
if (NotDelectProecss.Where(p => p.DOTASKRULEDETAILID == FlowTrigger.DOTASKRULEDETAIL.DOTASKRULEDETAILID).Count() > 0)
{
rueslt = true;
DotaskRuleID = FlowTrigger.DOTASKRULEID;
}
else
{
rueslt = false;
DotaskRuleID = FlowTrigger.DOTASKRULEID;
}
}
if (rueslt == true)
{
if (triggerID.Where(p => p == DotaskRuleID).Count() == 0)
{
triggerID.Add(DotaskRuleID);
string sqlAger = "insert into T_WF_DOTASKRULE(DOTASKRULEID ,COMPANYID, SYSTEMCODE,SYSTEMNAME ,MODELCODE ,MODELNAME ,TRIGGERORDERSTATUS ,CREATEDATETIME)values("
+ " '" + DotaskRuleID + "','" + FlowTrigger.COMPANYID + "',"
+ " '" + FlowTrigger.SYSTEMCODE + "','" + FlowTrigger.SYSTEMNAME + "','" + FlowTrigger.MODELCODE + "',"
+ " '" + FlowTrigger.MODELNAME + "','" + FlowTrigger.TRIGGERORDERSTATUS + "',to_date('" + FlowTrigger.CREATEDATETIME + "','yyyy-mm-dd hh24:mi:ss'))";
result = dao.ExecuteNonQuery(sqlAger);
if (result == 0)
{
dao.RollbackTransaction();
return("默认规则保存失败!");
}
}
}
string sqlAter = "insert into T_WF_DOTASKRULEDETAIL(DOTASKRULEDETAILID, DOTASKRULEID , COMPANYID , SYSTEMCODE,SYSTEMNAME ,MODELCODE ,MODELNAME ,WCFURL ,FUNCTIONNAME ,"
+ " FUNCTIONPARAMTER ,PAMETERSPLITCHAR ,WCFBINDINGCONTRACT ,MESSAGEBODY ,LASTDAYS ,CREATEDATETIME ,"
+ " APPLICATIONURL ,RECEIVEUSER ,RECEIVEUSERNAME ,OWNERCOMPANYID ,OWNERDEPARTMENTID ,OWNERPOSTID ,ISDEFAULTMSG ,"
+ " PROCESSFUNCLANGUAGE ,ISOTHERSOURCE ,OTHERSYSTEMCODE ,OTHERMODELCODE,REMARK,CREATEUSERID,CREATEUSERNAME,TRIGGERORDERSTATUS)values("
+ " '" + FlowTrigger.DOTASKRULEDETAIL.DOTASKRULEDETAILID + "','" + DotaskRuleID + "','" + FlowTrigger.DOTASKRULEDETAIL.COMPANYID + "',"
+ " '" + FlowTrigger.DOTASKRULEDETAIL.SYSTEMCODE + "','" + FlowTrigger.DOTASKRULEDETAIL.SYSTEMNAME + "','" + FlowTrigger.DOTASKRULEDETAIL.MODELCODE + "',"
+ " '" + FlowTrigger.DOTASKRULEDETAIL.MODELNAME + "','" + FlowTrigger.DOTASKRULEDETAIL.WCFURL + "','" + FlowTrigger.DOTASKRULEDETAIL.FUNCTIONNAME + "',"
+ " '" + FlowTrigger.DOTASKRULEDETAIL.FUNCTIONPARAMTER + "','" + FlowTrigger.DOTASKRULEDETAIL.PAMETERSPLITCHAR + "','" + FlowTrigger.DOTASKRULEDETAIL.WCFBINDINGCONTRACT + "',"
+ " '" + FlowTrigger.DOTASKRULEDETAIL.MESSAGEBODY + "','" + FlowTrigger.DOTASKRULEDETAIL.LASTDAYS + "',to_date('" + FlowTrigger.DOTASKRULEDETAIL.CREATEDATETIME + "','yyyy-mm-dd hh24:mi:ss'),"
+ " '" + FlowTrigger.DOTASKRULEDETAIL.APPLICATIONURL + "','" + FlowTrigger.DOTASKRULEDETAIL.RECEIVEUSER + "',"
+ " '" + FlowTrigger.DOTASKRULEDETAIL.RECEIVEUSERNAME + "','" + FlowTrigger.DOTASKRULEDETAIL.OWNERCOMPANYID + "','" + FlowTrigger.DOTASKRULEDETAIL.OWNERDEPARTMENTID + "',"
+ " '" + FlowTrigger.DOTASKRULEDETAIL.OWNERPOSTID + "','" + FlowTrigger.DOTASKRULEDETAIL.ISDEFAULTMSG + "',"
+ " '" + FlowTrigger.DOTASKRULEDETAIL.PROCESSFUNCLANGUAGE + "','" + FlowTrigger.DOTASKRULEDETAIL.ISOTHERSOURCE + "',"
+ " '" + FlowTrigger.DOTASKRULEDETAIL.OTHERSYSTEMCODE + "','" + FlowTrigger.DOTASKRULEDETAIL.OTHERMODELCODE + "','" + FlowTrigger.DOTASKRULEDETAIL.REMARK + "', "
+ " '" + FlowTrigger.DOTASKRULEDETAIL.CREATEUSERID + "','" + FlowTrigger.DOTASKRULEDETAIL.CREATEUSERNAME + "','" + FlowTrigger.TRIGGERORDERSTATUS + "')";
result = dao.ExecuteNonQuery(sqlAter);
if (result == 0)
{
dao.RollbackTransaction();
return("默认规则保存失败!");
}
}
}
if (ListCuostomFlowsDefine != null)
{
foreach (var CuostomFlow in ListCuostomFlowsDefine) //自动发起流程
{
string sqlAcow = "insert into T_FLOW_CUSTOMFLOWDEFINE(PROCESSID, COMPANYCODE, SYSTEMCODE, SYSTEMNAME,MODELCODE,MODELNAME,FUNCTIONNAME,FUNCTIONDES,"
+ " PROCESSWCFURL,PROCESSFUNCNAME,PROCESSFUNCPAMETER,PAMETERSPLITCHAR,WCFBINDINGCONTRACT,MESSAGEBODY,MSGLINKURL,RECEIVEUSER,RECEIVEUSERNAME,"
+ " OWNERCOMPANYID,OWNERDEPARTMENTID,OWNERPOSTID,CREATEDATE,CREATETIME,CREATEUSERNAME,CREATEUSERID)values("
+ " '" + CuostomFlow.PROCESSID + "','" + CuostomFlow.COMPANYCODE + "','" + CuostomFlow.SYSTEMCODE + "',"
+ " '" + CuostomFlow.SYSTEMNAME + "','" + CuostomFlow.MODELCODE + "','" + CuostomFlow.MODELNAME + "',"
+ " '" + CuostomFlow.FUNCTIONNAME + "','" + CuostomFlow.FUNCTIONDES + "','" + CuostomFlow.PROCESSWCFURL + "',"
+ " '" + CuostomFlow.PROCESSFUNCNAME + "','" + CuostomFlow.PROCESSFUNCPAMETER + "','" + CuostomFlow.PAMETERSPLITCHAR + "',"
+ " '" + CuostomFlow.WCFBINDINGCONTRACT + "','" + CuostomFlow.MESSAGEBODY + "','" + CuostomFlow.MSGLINKURL + "',"
+ " '" + CuostomFlow.RECEIVEUSER + "','" + CuostomFlow.RECEIVEUSERNAME + "','" + CuostomFlow.OWNERCOMPANYID + "',"
+ " '" + CuostomFlow.OWNERDEPARTMENTID + "','" + CuostomFlow.OWNERPOSTID + "','" + CuostomFlow.CREATEDATE + "',"
+ " '" + CuostomFlow.CREATETIME + "','" + CuostomFlow.CREATEUSERNAME + "','" + CuostomFlow.CREATEUSERID + "')";
result = dao.ExecuteNonQuery(sqlAcow);
if (result == 0)
{
dao.RollbackTransaction();
return("自动发起流程保存失败!");
}
}
}
if (ListFlowTrigger != null)
{
foreach (var FlowTrigger in ListFlowTrigger) //定时触发
{
string sqlAtger = "insert into T_WF_TIMINGTRIGGERCONFIG(TIMINGCONFIGID, COMPANYID, SYSTEMCODE, SYSTEMNAME, MODELCODE, MODELNAME, TRIGGERACTIVITYTYPE,TRIGGERTIME,TRIGGERROUND,WCFURL,FUNCTIONNAME,"
+ " FUNCTIONPARAMTER,PAMETERSPLITCHAR,WCFBINDINGCONTRACT,RECEIVERUSERID,RECEIVEROLE,RECEIVERNAME,MESSAGEBODY,MESSAGEURL,TRIGGERSTATUS,TRIGGERTYPE,TRIGGERDESCRIPTION, "
+ " CONTRACTTYPE,CREATEDATETIME,CREATEUSERID,CREATEUSERNAME,REMARK,TRIGGERNAME)values("
+ " '" + FlowTrigger.TIMINGCONFIGID + "','" + FlowTrigger.COMPANYID + "','" + FlowTrigger.SYSTEMCODE + "',"
+ " '" + FlowTrigger.SYSTEMNAME + "','" + FlowTrigger.MODELCODE + "','" + FlowTrigger.MODELNAME + "',"
+ " " + FlowTrigger.TRIGGERACTIVITYTYPE + ",to_date('" + FlowTrigger.TRIGGERTIME + "','yyyy-mm-dd hh24:mi:ss')," + FlowTrigger.TRIGGERROUND + ","
+ " '" + FlowTrigger.WCFURL + "','" + FlowTrigger.FUNCTIONNAME + "','" + FlowTrigger.FUNCTIONPARAMTER + "',"
+ " '" + FlowTrigger.PAMETERSPLITCHAR + "','" + FlowTrigger.WCFBINDINGCONTRACT + "','" + FlowTrigger.RECEIVERUSERID + "',"
+ " '" + FlowTrigger.RECEIVEROLE + "','" + FlowTrigger.RECEIVERNAME + "','" + FlowTrigger.MESSAGEBODY + "',"
+ " '" + FlowTrigger.MESSAGEURL + "'," + FlowTrigger.TRIGGERSTATUS + ",'" + FlowTrigger.TRIGGERTYPE + "',"
+ " '" + FlowTrigger.TRIGGERDESCRIPTION + "','" + FlowTrigger.CONTRACTTYPE + "',to_date('" + FlowTrigger.CREATEDATETIME + "','yyyy-mm-dd hh24:mi:ss'),"
+ " '" + FlowTrigger.CREATEUSERID + "','" + FlowTrigger.CREATEUSERNAME + "','" + FlowTrigger.REMARK + "', "
+ " '" + FlowTrigger.TRIGGERNAME + "')";
result = dao.ExecuteNonQuery(sqlAtger);
if (result == 0)
{
dao.RollbackTransaction();
return("定时触发定义保存失败!");
}
string sqlAtgger = "insert into T_WF_TIMINGTRIGGERACTIVITY(TIMINGCONFIGID, COMPANYID, SYSTEMCODE, SYSTEMNAME, MODELCODE, MODELNAME, TRIGGERACTIVITYTYPE,TRIGGERTIME,TRIGGERROUND,WCFURL,FUNCTIONNAME,"
+ " FUNCTIONPARAMTER,PAMETERSPLITCHAR,WCFBINDINGCONTRACT,RECEIVERUSERID,RECEIVEROLE,RECEIVERNAME,MESSAGEBODY,MESSAGEURL,TRIGGERSTATUS,TRIGGERTYPE,TRIGGERDESCRIPTION, "
+ " CONTRACTTYPE,CREATEDATETIME,CREATEUSERID,CREATEUSERNAME,REMARK,TRIGGERNAME,TRIGGERID)values("
+ " '" + FlowTrigger.TIMINGCONFIGID + "','" + FlowTrigger.COMPANYID + "','" + FlowTrigger.SYSTEMCODE + "',"
+ " '" + FlowTrigger.SYSTEMNAME + "','" + FlowTrigger.MODELCODE + "','" + FlowTrigger.MODELNAME + "',"
+ " " + FlowTrigger.TRIGGERACTIVITYTYPE + ",to_date('" + FlowTrigger.TRIGGERTIME + "','yyyy-mm-dd hh24:mi:ss')," + FlowTrigger.TRIGGERROUND + ","
+ " '" + FlowTrigger.WCFURL + "','" + FlowTrigger.FUNCTIONNAME + "','" + FlowTrigger.FUNCTIONPARAMTER + "',"
+ " '" + FlowTrigger.PAMETERSPLITCHAR + "','" + FlowTrigger.WCFBINDINGCONTRACT + "','" + FlowTrigger.RECEIVERUSERID + "',"
+ " '" + FlowTrigger.RECEIVEROLE + "','" + FlowTrigger.RECEIVERNAME + "','" + FlowTrigger.MESSAGEBODY + "',"
+ " '" + FlowTrigger.MESSAGEURL + "'," + FlowTrigger.TRIGGERSTATUS + ",'" + FlowTrigger.TRIGGERTYPE + "',"
+ " '" + FlowTrigger.TRIGGERDESCRIPTION + "','" + FlowTrigger.CONTRACTTYPE + "',to_date('" + FlowTrigger.CREATEDATETIME + "','yyyy-mm-dd hh24:mi:ss'),"
+ " '" + FlowTrigger.CREATEUSERID + "','" + FlowTrigger.CREATEUSERNAME + "','" + FlowTrigger.REMARK + "', "
+ " '" + FlowTrigger.TRIGGERNAME + "', '" + Guid.NewGuid() + "')";
result = dao.ExecuteNonQuery(sqlAtgger);
if (result == 0)
{
dao.RollbackTransaction();
return("定时触发定义保存失败!");
}
}
}
#endregion
dao.CommitTransaction();
return("保存成功!");
}
catch
{
dao.RollbackTransaction();
return("保存失败!");
}
finally
{
dao.Close();
}
}
