Beispiel #1
0
        public void AddDoTaskRuleDetail(T_WF_DOTASKRULEDETAIL Detail)
        {
            try
            {
              
                string insSql = "INSERT INTO T_WF_DOTASKRULEDETAIL (DOTASKRULEDETAILID,DOTASKRULEID,COMPANYID,SYSTEMCODE,SYSTEMNAME,MODELCODE,MODELNAME,WCFURL,FUNCTIONNAME,FUNCTIONPARAMTER,PAMETERSPLITCHAR,WCFBINDINGCONTRACT,MESSAGEBODY,LASTDAYS,APPLICATIONURL,RECEIVEUSER,RECEIVEUSERNAME,OWNERCOMPANYID,OWNERDEPARTMENTID,OWNERPOSTID,ISDEFAULTMSG,PROCESSFUNCLANGUAGE,ISOTHERSOURCE,OTHERSYSTEMCODE,OTHERMODELCODE,CREATEUSERNAME,CREATEUSERID,REMARK) VALUES (:DOTASKRULEDETAILID,:DOTASKRULEID,:COMPANYID,:SYSTEMCODE,:SYSTEMNAME,:MODELCODE,:MODELNAME,:WCFURL,:FUNCTIONNAME,:FUNCTIONPARAMTER,:PAMETERSPLITCHAR,:WCFBINDINGCONTRACT,:MESSAGEBODY,:LASTDAYS,:APPLICATIONURL,:RECEIVEUSER,:RECEIVEUSERNAME,:OWNERCOMPANYID,:OWNERDEPARTMENTID,:OWNERPOSTID,:ISDEFAULTMSG,:PROCESSFUNCLANGUAGE,:ISOTHERSOURCE,:OTHERSYSTEMCODE,:OTHERMODELCODE,:CREATEUSERNAME,:CREATEUSERID,:REMARK)";
                OracleParameter[] pageparm =
                {               
                    new OracleParameter(":DOTASKRULEDETAILID",OracleType.NVarChar,200), 
                    new OracleParameter(":DOTASKRULEID",OracleType.NVarChar,200), 
                    new OracleParameter(":COMPANYID",OracleType.NVarChar,100), 
                    new OracleParameter(":SYSTEMCODE",OracleType.NVarChar,100), 
                    new OracleParameter(":SYSTEMNAME",OracleType.NVarChar,100), 
                    new OracleParameter(":MODELCODE",OracleType.NVarChar,100), 
                    new OracleParameter(":MODELNAME",OracleType.NVarChar,100), 
                    new OracleParameter(":WCFURL",OracleType.NVarChar,400), 
                    new OracleParameter(":FUNCTIONNAME",OracleType.NVarChar,100), 
                    new OracleParameter(":FUNCTIONPARAMTER",OracleType.NVarChar,4000), 
                    new OracleParameter(":PAMETERSPLITCHAR",OracleType.NVarChar,200), 
                    new OracleParameter(":WCFBINDINGCONTRACT",OracleType.NVarChar,200), 
                    new OracleParameter(":MESSAGEBODY",OracleType.NVarChar,800), 
                    new OracleParameter(":LASTDAYS",OracleType.Number,22), 
                    new OracleParameter(":APPLICATIONURL",OracleType.NClob), 
                    new OracleParameter(":RECEIVEUSER",OracleType.NVarChar,200), 
                    new OracleParameter(":RECEIVEUSERNAME",OracleType.NVarChar,200), 
                    new OracleParameter(":OWNERCOMPANYID",OracleType.NVarChar,200), 
                    new OracleParameter(":OWNERDEPARTMENTID",OracleType.NVarChar,200), 
                    new OracleParameter(":OWNERPOSTID",OracleType.NVarChar,200), 
                    new OracleParameter(":ISDEFAULTMSG",OracleType.Number,22), 
                    new OracleParameter(":PROCESSFUNCLANGUAGE",OracleType.NVarChar,200), 
                    new OracleParameter(":ISOTHERSOURCE",OracleType.NVarChar,200), 
                    new OracleParameter(":OTHERSYSTEMCODE",OracleType.NVarChar,200), 
                    new OracleParameter(":OTHERMODELCODE",OracleType.NVarChar,200), 
                    new OracleParameter(":CREATEUSERNAME",OracleType.NVarChar,100), 
                    new OracleParameter(":CREATEUSERID",OracleType.NVarChar,100), 
                    new OracleParameter(":REMARK",OracleType.NVarChar,400) 

                };
                pageparm[0].Value = GetValue(Detail.DOTASKRULEDETAILID);//待办规则明细ID
                pageparm[1].Value = GetValue(Detail.DOTASKRULEID);//待办规则主表ID
                pageparm[2].Value = GetValue(Detail.COMPANYID);//公司ID
                pageparm[3].Value = GetValue(Detail.SYSTEMCODE);//系统代码
                pageparm[4].Value = GetValue(Detail.SYSTEMNAME);//系统名称
                pageparm[5].Value = GetValue(Detail.MODELCODE);//模块代码
                pageparm[6].Value = GetValue(Detail.MODELNAME);//模块名称
                pageparm[7].Value = GetValue(Detail.WCFURL);//WCF的URL
                pageparm[8].Value = GetValue(Detail.FUNCTIONNAME);//所调方法名称
                pageparm[9].Value = GetValue(Detail.FUNCTIONPARAMTER);//方法参数
                pageparm[10].Value = GetValue(Detail.PAMETERSPLITCHAR);//参数分解符
                pageparm[11].Value = GetValue(Detail.WCFBINDINGCONTRACT);//WCF绑定的契约
                pageparm[12].Value = GetValue(Detail.MESSAGEBODY);//消息体
                pageparm[13].Value = GetValue(Detail.LASTDAYS);//可处理日期(剩余天数)
                pageparm[14].Value = GetValue(Detail.APPLICATIONURL);//应用URL
                pageparm[15].Value = GetValue(Detail.RECEIVEUSER);//接收用户
                pageparm[16].Value = GetValue(Detail.RECEIVEUSERNAME);//接收用户名
                pageparm[17].Value = GetValue(Detail.OWNERCOMPANYID);//所属公司ID
                pageparm[18].Value = GetValue(Detail.OWNERDEPARTMENTID);//所属部门ID
                pageparm[19].Value = GetValue(Detail.OWNERPOSTID);//所属岗位ID
                pageparm[20].Value = GetValue(Detail.ISDEFAULTMSG);//是否缺省消息
                pageparm[21].Value = GetValue(Detail.PROCESSFUNCLANGUAGE);//处理功能语言
                pageparm[22].Value = GetValue(Detail.ISOTHERSOURCE);//是否其它来源
                pageparm[23].Value = GetValue(Detail.OTHERSYSTEMCODE);//其它系统代码
                pageparm[24].Value = GetValue(Detail.OTHERMODELCODE);//其它系统模块
                pageparm[25].Value = GetValue(Detail.CREATEUSERNAME);//创建人
                pageparm[26].Value = GetValue(Detail.CREATEUSERID);//创建人ID
                pageparm[27].Value = GetValue(Detail.REMARK);//备注
                dal.ExecuteSql(insSql, pageparm);

            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message, ex);
            }
        }
Beispiel #2
0
        public void EditDoTaskRuleDetail(T_WF_DOTASKRULEDETAIL Detail)
        {
            try
            {
                //string sql = "Update T_WF_DOTASKRULEDETAIL set DOTASKRULEID='" + Detail.DOTASKRULEID + "',COMPANYID='" + Detail.COMPANYID + "',"
                //        + " SYSTEMCODE='" + Detail.SYSTEMCODE + "',SYSTEMNAME='" + Detail.SYSTEMNAME + "',MODELCODE='" + Detail.MODELCODE + "',MODELNAME='" + Detail.MODELNAME + "',"
                //        + " WCFURL='" + Detail.WCFURL + "',FUNCTIONNAME='" + Detail.FUNCTIONNAME + "',FUNCTIONPARAMTER='" + Detail.FUNCTIONPARAMTER + "',PAMETERSPLITCHAR='" + Detail.PAMETERSPLITCHAR + "',"
                //        + " WCFBINDINGCONTRACT='" + Detail.WCFBINDINGCONTRACT + "',MESSAGEBODY='" + Detail.MESSAGEBODY + "',LASTDAYS='" + Detail.LASTDAYS + "',APPLICATIONURL='" + Detail.APPLICATIONURL + "',"
                //        + " RECEIVEUSER='******',RECEIVEUSERNAME='******',OWNERCOMPANYID='" + Detail.OWNERCOMPANYID + "',OWNERDEPARTMENTID='" + Detail.OWNERDEPARTMENTID + "',"
                //        + " OWNERPOSTID='" + Detail.OWNERPOSTID + "',ISDEFAULTMSG='" + Detail.ISDEFAULTMSG + "',PROCESSFUNCLANGUAGE='" + Detail.PROCESSFUNCLANGUAGE + "',ISOTHERSOURCE='" + Detail.ISOTHERSOURCE + "',"
                //        + " OTHERSYSTEMCODE='" + Detail.OTHERSYSTEMCODE + "', OTHERMODELCODE='" + Detail.OTHERMODELCODE + "',REMARK='" + Detail.REMARK + "' where DOTASKRULEDETAILID ='" + Detail.DOTASKRULEDETAILID + "'";


                //dal.ExecuteSql(sql);

                string updSql = "UPDATE T_WF_DOTASKRULEDETAIL SET DOTASKRULEID=:DOTASKRULEID,COMPANYID=:COMPANYID,SYSTEMCODE=:SYSTEMCODE,SYSTEMNAME=:SYSTEMNAME,MODELCODE=:MODELCODE,MODELNAME=:MODELNAME,WCFURL=:WCFURL,FUNCTIONNAME=:FUNCTIONNAME,FUNCTIONPARAMTER=:FUNCTIONPARAMTER,PAMETERSPLITCHAR=:PAMETERSPLITCHAR,WCFBINDINGCONTRACT=:WCFBINDINGCONTRACT,MESSAGEBODY=:MESSAGEBODY,LASTDAYS=:LASTDAYS,APPLICATIONURL=:APPLICATIONURL,RECEIVEUSER=:RECEIVEUSER,RECEIVEUSERNAME=:RECEIVEUSERNAME,OWNERCOMPANYID=:OWNERCOMPANYID,OWNERDEPARTMENTID=:OWNERDEPARTMENTID,OWNERPOSTID=:OWNERPOSTID,ISDEFAULTMSG=:ISDEFAULTMSG,PROCESSFUNCLANGUAGE=:PROCESSFUNCLANGUAGE,ISOTHERSOURCE=:ISOTHERSOURCE,OTHERSYSTEMCODE=:OTHERSYSTEMCODE,OTHERMODELCODE=:OTHERMODELCODE,REMARK=:REMARK WHERE   DOTASKRULEDETAILID=:DOTASKRULEDETAILID";
                OracleParameter[] pageparm =
                {               
                    new OracleParameter(":DOTASKRULEDETAILID",OracleType.NVarChar,200), 
                    new OracleParameter(":DOTASKRULEID",OracleType.NVarChar,200), 
                    new OracleParameter(":COMPANYID",OracleType.NVarChar,100), 
                    new OracleParameter(":SYSTEMCODE",OracleType.NVarChar,100), 
                    new OracleParameter(":SYSTEMNAME",OracleType.NVarChar,100), 
                    new OracleParameter(":MODELCODE",OracleType.NVarChar,100), 
                    new OracleParameter(":MODELNAME",OracleType.NVarChar,100), 
                    new OracleParameter(":WCFURL",OracleType.NVarChar,400), 
                    new OracleParameter(":FUNCTIONNAME",OracleType.NVarChar,100), 
                    new OracleParameter(":FUNCTIONPARAMTER",OracleType.NVarChar,4000), 
                    new OracleParameter(":PAMETERSPLITCHAR",OracleType.NVarChar,200), 
                    new OracleParameter(":WCFBINDINGCONTRACT",OracleType.NVarChar,200), 
                    new OracleParameter(":MESSAGEBODY",OracleType.NVarChar,800), 
                    new OracleParameter(":LASTDAYS",OracleType.Number,22), 
                    new OracleParameter(":APPLICATIONURL",OracleType.NClob), 
                    new OracleParameter(":RECEIVEUSER",OracleType.NVarChar,200), 
                    new OracleParameter(":RECEIVEUSERNAME",OracleType.NVarChar,200), 
                    new OracleParameter(":OWNERCOMPANYID",OracleType.NVarChar,200), 
                    new OracleParameter(":OWNERDEPARTMENTID",OracleType.NVarChar,200), 
                    new OracleParameter(":OWNERPOSTID",OracleType.NVarChar,200), 
                    new OracleParameter(":ISDEFAULTMSG",OracleType.Number,22), 
                    new OracleParameter(":PROCESSFUNCLANGUAGE",OracleType.NVarChar,200), 
                    new OracleParameter(":ISOTHERSOURCE",OracleType.NVarChar,200), 
                    new OracleParameter(":OTHERSYSTEMCODE",OracleType.NVarChar,200), 
                    new OracleParameter(":OTHERMODELCODE",OracleType.NVarChar,200), 
                    new OracleParameter(":REMARK",OracleType.NVarChar,400) 

                };
                pageparm[0].Value = GetValue(Detail.DOTASKRULEDETAILID);//待办规则明细ID
                pageparm[1].Value = GetValue(Detail.DOTASKRULEID);//待办规则主表ID
                pageparm[2].Value = GetValue(Detail.COMPANYID);//公司ID
                pageparm[3].Value = GetValue(Detail.SYSTEMCODE);//系统代码
                pageparm[4].Value = GetValue(Detail.SYSTEMNAME);//系统名称
                pageparm[5].Value = GetValue(Detail.MODELCODE);//模块代码
                pageparm[6].Value = GetValue(Detail.MODELNAME);//模块名称
                pageparm[7].Value = GetValue(Detail.WCFURL);//WCF的URL
                pageparm[8].Value = GetValue(Detail.FUNCTIONNAME);//所调方法名称
                pageparm[9].Value = GetValue(Detail.FUNCTIONPARAMTER);//方法参数
                pageparm[10].Value = GetValue(Detail.PAMETERSPLITCHAR);//参数分解符
                pageparm[11].Value = GetValue(Detail.WCFBINDINGCONTRACT);//WCF绑定的契约
                pageparm[12].Value = GetValue(Detail.MESSAGEBODY);//消息体
                pageparm[13].Value = GetValue(Detail.LASTDAYS);//可处理日期(剩余天数)
                pageparm[14].Value = string.IsNullOrEmpty(Detail.APPLICATIONURL) ? " " : GetValue(Detail.APPLICATIONURL);//应用URL
                pageparm[15].Value = GetValue(Detail.RECEIVEUSER);//接收用户
                pageparm[16].Value = GetValue(Detail.RECEIVEUSERNAME);//接收用户名
                pageparm[17].Value = GetValue(Detail.OWNERCOMPANYID);//所属公司ID
                pageparm[18].Value = GetValue(Detail.OWNERDEPARTMENTID);//所属部门ID
                pageparm[19].Value = GetValue(Detail.OWNERPOSTID);//所属岗位ID
                pageparm[20].Value = GetValue(Detail.ISDEFAULTMSG);//是否缺省消息
                pageparm[21].Value = GetValue(Detail.PROCESSFUNCLANGUAGE);//处理功能语言
                pageparm[22].Value = GetValue(Detail.ISOTHERSOURCE);//是否其它来源
                pageparm[23].Value = GetValue(Detail.OTHERSYSTEMCODE);//其它系统代码
                pageparm[24].Value = GetValue(Detail.OTHERMODELCODE);//其它系统模块
                pageparm[25].Value = GetValue(Detail.REMARK);//备注
                dal.ExecuteSql(updSql, pageparm);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message, ex);
            }
        }
Beispiel #3
0
 public string EditDoTaskRuleDetail(T_WF_DOTASKRULEDETAIL Detail)
 {
     try
     {
         doTaskbll.EditDoTaskRuleDetail(Detail);
         return "1";
     }
     catch (Exception ex)
     {
         return ex.Message;
     }
 }