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); } }
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); } }
public string EditDoTaskRuleDetail(T_WF_DOTASKRULEDETAIL Detail) { try { doTaskbll.EditDoTaskRuleDetail(Detail); return "1"; } catch (Exception ex) { return ex.Message; } }