protected override void UpdateSettingCore(NotifyConfigItem item)
{
if (item == null || string.IsNullOrWhiteSpace(item.db_connstring))
{
mDbAccess = null;
mProc = null;
mArgs = null;
}
else
{
mDbAccess = new ODPDataAccess(Common.CustomDecode(item.db_connstring));
mProc = item.db_proc;
if (!ParseArgs4KeyValuePairs(item.args, out mArgs))
{
mArgs = null;
}
}
}
internal override bool ExecuteCore(string uid, string uname, string url, string system, string maincode, string mainid,
string subject, string creatorId, string creatorName)
{
ODPDataAccess dbAccess = mDbAccess;
if (dbAccess != null && !string.IsNullOrWhiteSpace(mProc))
{
OracleParameter[] parms = null;
Dictionary <string, string> dictArgs = mArgs;
if (dictArgs != null && dictArgs.Count > 0)
{
parms = new OracleParameter[dictArgs.Count];
int index = 0;
foreach (KeyValuePair <string, string> item in dictArgs)
{
parms[index] = new OracleParameter(item.Key, OracleDbType.Varchar2);
parms[index].Value = GetArgDbValue(item.Value, uid, uname, url, system,
maincode, mainid, subject, creatorId, creatorName);
index++;
}
}
//parms = new OracleParameter[]
//{
// new OracleParameter("user_in", OracleDbType.Varchar2),
// new OracleParameter("url_in", OracleDbType.Varchar2),
// new OracleParameter("system_in", OracleDbType.Varchar2),
// new OracleParameter("maincode_in", OracleDbType.Varchar2),
// new OracleParameter("mainid_in", OracleDbType.Varchar2),
// new OracleParameter("subject_in", OracleDbType.Varchar2),
// new OracleParameter("senduser_in", OracleDbType.Varchar2),
//};
//parms[0].Value = user;
//parms[1].Value = url;
//parms[2].Value = system;
//parms[3].Value = maincode;
//parms[4].Value = mainid;
//parms[5].Value = title;
//if (string.IsNullOrWhiteSpace(createUser))
// parms[6].Value = DBNull.Value;
//else
// parms[6].Value = createUser;
try
{
dbAccess.ExecuteNonQuery(mProc, parms, System.Data.CommandType.StoredProcedure);
}
catch (Exception ex)
{
Common.Logger.Warn($"调用存储过程出错:{ex.Message}[参数个数:{parms.Length}]");
throw;
}
return(true);
}
return(false);
#region Proc.ZLHIS
/*
* Create Or Replace Procedure Zltools.Zldiscussiongroup_Update
* (
* Sysname_In In Zltools.Zldiscussiongroup. Sysname%Type,
* Objecttype_In In Zltools.Zldiscussiongroup. Objecttype%Type,
* Objectid_In In Zltools.Zldiscussiongroup. Objectid%Type,
* User_In In Zltools.Zldiscussiongroup.Username%Type,
* Tilename_In In Zltools.Zldiscussiongroup.Tilename%Type := Null,
* Url_In In Zltools.Zldiscussiongroup.Tilename%Type := Null,
* Senduser_In In Zltools.Zldiscussiongroup.Senduser%Type := Null
* ) Is
*/
#endregion
}
public void Init()
{
this.da = new OracleDB();
}
