Exemplo n.º 1
0
        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";
                Parameter[] pageparm =
                {
                    new Parameter(":DEFINEID",dal.GetValue(entity.DEFINEID)), //默认消息ID
                    new Parameter(":SYSTEMCODE",dal.GetValue(entity.SYSTEMCODE)), //系统代号
                    new Parameter(":MODELCODE",dal.GetValue(entity.MODELCODE)), //模块代码
                    new Parameter(":MESSAGEBODY",dal.GetValue(entity.MESSAGEBODY)), //消息体
                    new Parameter(":MESSAGEURL",dal.GetValue(entity.MESSAGEURL)), //消息链接
                    new Parameter(":RECEIVEPOSTID",dal.GetValue(entity.RECEIVEPOSTID)), //
                    new Parameter(":RECEIVEPOSTNAME",dal.GetValue(entity.RECEIVEPOSTNAME)), //
                    new Parameter(":RECEIVERUSERID",dal.GetValue(entity.RECEIVERUSERID)) ,//
                    new Parameter(":RECEIVERUSERNAME",dal.GetValue(entity.RECEIVERUSERNAME)), //
                    new Parameter(":RECEIVETYPE",dal.GetValue(entity.RECEIVETYPE)) //

                };
                dal.ExecuteSql(updSql, pageparm);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message, ex);
            }
        }
Exemplo n.º 2
0
 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);
     }
 }
Exemplo n.º 3
0
        //添加默认消息
        public bool AddFlowMsgDefine(T_WF_MESSAGEBODYDEFINE FlowMsg)
        {
            try
            {
                int result = 0;

                //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)";
            Parameter[] pageparm =
                {
                    new Parameter(":DEFINEID",GetValue(FlowMsg.DEFINEID)), //默认消息ID
                    new Parameter(":COMPANYID",GetValue(FlowMsg.COMPANYID)), //公司ID
                    new Parameter(":SYSTEMCODE",GetValue(FlowMsg.SYSTEMCODE)), //系统代号
                    new Parameter(":MODELCODE",GetValue(FlowMsg.MODELCODE)), //模块代码
                    new Parameter(":MESSAGEBODY",GetValue(FlowMsg.MESSAGEBODY)), //消息体
                    new Parameter(":MESSAGEURL",GetValue(FlowMsg.MESSAGEURL)), //消息链接
                    new Parameter(":MESSAGETYPE",GetValue(FlowMsg.MESSAGETYPE)), //消息类型
                    new Parameter(":CREATEDATE",GetValue(FlowMsg.CREATEDATE)), //创建日期
                    new Parameter(":CREATEUSERNAME",GetValue(FlowMsg.CREATEUSERNAME)), //创建人名称
                    new Parameter(":CREATEUSERID",GetValue(FlowMsg.CREATEUSERID)) //创建人

                };
            ParameterCollection pras = new ParameterCollection();
            foreach (var item in pageparm)
            {
                pras.Add(item);
            }
            result = dao.ExecuteNonQuery(insSql, System.Data.CommandType.Text, pras);
                return result > 0 ? true : false;
            }
            catch
            {
                return false;
            }
            finally
            {

            }
        }
Exemplo n.º 4
0
 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;
     }
 }
Exemplo n.º 5
0
        /// <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);
            }
        }
Exemplo n.º 6
0
 //删除默认消息
 public bool DeleteFlowMsgsDefine(T_WF_MESSAGEBODYDEFINE FlowMsgList)
 {
     return dal.DeleteFlowMsgsDefine(FlowMsgList);
 }
Exemplo n.º 7
0
 //修改默认消息
 public bool UpdateFlowMsgDefine(T_WF_MESSAGEBODYDEFINE FlowMsg)
 {
     return dal.UpdateFlowMsgDefine(FlowMsg);
 }
Exemplo n.º 8
0
 //添加默认消息
 public bool AddFlowMsgDefine(T_WF_MESSAGEBODYDEFINE FlowMsg)
 {
     return dal.AddFlowMsgDefine(FlowMsg);
 }
Exemplo n.º 9
0
 //引擎添加、修改方法
 public string FlowEventAll(T_WF_MESSAGEBODYDEFINE FlowMsg, List<T_WF_DOTASKRULE> ListFlowTrigger, List<T_FLOW_CUSTOMFLOWDEFINE> ListCuostomFlowsDefine, List<T_WF_TIMINGTRIGGERCONFIG> ListFlowsTrigger)
 {
     return FlowEventBll.FlowEventAll(FlowMsg, ListFlowTrigger, ListCuostomFlowsDefine, ListFlowsTrigger);
 }
Exemplo n.º 10
0
        /// <summary>
        /// 获取默认消息
        /// </summary>
        /// <param name="strSystemCode"></param>
        /// <param name="strModelCode"></param>
        /// <param name="strCompanyID"></param>
        /// <param name="strMessageType"></param>
        /// <returns></returns>
        public List<T_WF_MESSAGEBODYDEFINE> GetMessageBodyDefine(string strSystemCode, string strModelCode, string strCompanyID, int messageType)
        {
            List<T_WF_MESSAGEBODYDEFINE> list = new List<T_WF_MESSAGEBODYDEFINE>();
            try
            {
                string sql = "SELECT * FROM T_WF_MESSAGEBODYDEFINE WHERE SYSTEMCODE='" + strSystemCode + "'AND MODELCODE='" + strModelCode + "'";
                if (!string.IsNullOrEmpty(strCompanyID))
                {
                    sql += " AND COMPANYID='" + strCompanyID + "'";
                }
                if (messageType >= 0)
                {
                    sql += " AND MESSAGETYPE=" + messageType + "";
                }
                dao.Open();
                DataTable dt = dao.GetDataTable(sql);
                if (dt != null && dt.Rows.Count > 0)
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        T_WF_MESSAGEBODYDEFINE MsgDefine = new T_WF_MESSAGEBODYDEFINE();
                        MsgDefine.SYSTEMCODE = string.Concat(dr["SYSTEMCODE"]);
                        MsgDefine.MODELCODE = string.Concat(dr["MODELCODE"]);
                        MsgDefine.MESSAGEBODY = string.Concat(dr["MESSAGEBODY"]);
                        MsgDefine.MESSAGEURL = string.Concat(dr["MESSAGEURL"]);
                        MsgDefine.RECEIVEPOSTID = string.Concat(dr["RECEIVEPOSTID"]);
                        MsgDefine.RECEIVERUSERID = string.Concat(dr["RECEIVERUSERID"]);
                        MsgDefine.RECEIVETYPE = int.Parse(dr["RECEIVETYPE"].ToString());
                        list.Add(MsgDefine);
                    }
                }
                return list;
            }
            catch (Exception ex)
            {
                LogHelper.WriteLog(this, "GetMessageBodyDefine()", "获取默认消息", ex);
                return null;
            }
            finally
            {
                dao.Close();
            }

        }
Exemplo n.º 11
0
        //删除默认消息
        public bool DeleteFlowMsgsDefine(T_WF_MESSAGEBODYDEFINE FlowMsglList)
        {
            try
            {
                int result = 0;

                dao.BeginTransaction();
                string Sql = "delete from T_WF_MESSAGEBODYDEFINE "
                                + "where DEFINEID = '" + FlowMsglList.DEFINEID + "' ";
                result = dao.ExecuteNonQuery(Sql);
                if (result == 0)
                {
                    dao.Rollback();
                    return false;
                }
                dao.Commit();
                return result > 0 ? true : false;
            }
            catch
            {
                dao.Rollback();
                return false;
            }
            finally
            {

            }
        }
Exemplo n.º 12
0
        //修改默认消息
        public bool UpdateFlowMsgDefine(T_WF_MESSAGEBODYDEFINE FlowMsg)
        {
            try
            {
                int result = 0;

                //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";
            Parameter[] pageparm =
                {
                    new Parameter(":DEFINEID",GetValue(FlowMsg.DEFINEID)), //默认消息ID
                    new Parameter(":SYSTEMCODE",GetValue(FlowMsg.SYSTEMCODE)), //系统代号
                    new Parameter(":MODELCODE",GetValue(FlowMsg.MODELCODE)), //模块代码
                    new Parameter(":MESSAGEBODY",GetValue(FlowMsg.MESSAGEBODY)), //消息体
                    new Parameter(":MESSAGEURL",GetValue(FlowMsg.MESSAGEURL)) //消息链接

                };
            ParameterCollection pras = new ParameterCollection();
            foreach (var item in pageparm)
            {
                pras.Add(item);
            }
            result = dao.ExecuteNonQuery(updSql, System.Data.CommandType.Text, pras);
                return result > 0 ? true : false;
            }
            catch
            {
                return false;
            }
            finally
            {

            }
        }
Exemplo n.º 13
0
        //引擎添加、修改方法
        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 + "' ";

                    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 + "' ";

                        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 + "' ";

                        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 + "' ";

                        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.Rollback();
                        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.Rollback();
                        //    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.Rollback();
                            //    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.Rollback();
                            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.Rollback();
                            return "定时触发定义保存失败!";
                        }
                        string Sqlger = "delete from T_WF_TIMINGTRIGGERACTIVITY "
                                                           + "where TIMINGCONFIGID = '" + itemter.TIMINGCONFIGID + "' ";
                        result = dao.ExecuteNonQuery(Sqlger);
                        //if (result == 0)
                        //{
                        //    dao.Rollback();
                        //    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.Rollback();
                        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.Rollback();
                                    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.Rollback();
                            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.Rollback();
                            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.Rollback();
                            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.Rollback();
                            return "定时触发定义保存失败!";
                        }
                    }
                }
                #endregion
                dao.Commit();
                return "保存成功!";
            }
            catch
            {
                dao.Rollback();
                return "保存失败!";
            }
            finally
            {

            }
        }