/// <summary>
/// 记录接口调用数据库日志
/// </summary>
public static void WriteCallInterfaceLog_DB(String IP, String SPID, String InterfaceName, String InParameters, String OutParameters, Int32 CallResult, String ErrMsg)
{
try
{
//判断是否启用数据库记录日志功能
Boolean enabled = ConstHelper.DefaultInstance.DBLogEnabled;
if (!enabled)
{
return;
}
//获取不写数据库日志的接口
String outInerfaceList = ConstHelper.DefaultInstance.UnWriteDBLogInterface;
if (("," + outInerfaceList + ",").IndexOf("," + InterfaceName + ",") >= 0)
{
return;
}
CallInterfaceLog entity = new CallInterfaceLog();
entity.IP = IP;
entity.SPID = SPID;
entity.InterfaceName = InterfaceName;
entity.InParameters = InParameters;
entity.OutParameters = OutParameters;
entity.CallResult = CallResult.ToString();
entity.ErrMsg = ErrMsg;
entity.CreateTime = DateTime.Now;
CallInterfaceLogBO.InsertLog(entity);
}
catch (Exception ex)
{
}
}
/// <summary>
/// 插入一条日志
/// </summary>
/// <param name="entity"></param>
public static void InsertLog(CallInterfaceLog entity)
{
try
{
using (SqlCommand cmd = new SqlCommand("up_Customer_V3_Interface_WriteCallInterfaceLog"))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parIP = new SqlParameter("@IP", entity.IP);
cmd.Parameters.Add(parIP);
SqlParameter parSPID = new SqlParameter("@SPID", entity.SPID);
cmd.Parameters.Add(parSPID);
SqlParameter parInterfaceName = new SqlParameter("@InterfaceName", entity.InterfaceName);
cmd.Parameters.Add(parInterfaceName);
SqlParameter parInParameters = new SqlParameter("@InParameters", entity.InParameters.Replace("\'", "\"")); //处理单引号，单引号在sql插入中会报错
cmd.Parameters.Add(parInParameters);
SqlParameter parOutParameters = new SqlParameter("@OutParameters", entity.OutParameters.Replace("\'", "\""));
cmd.Parameters.Add(parOutParameters);
SqlParameter parCallResult = new SqlParameter("@CallResult", entity.CallResult);
cmd.Parameters.Add(parCallResult);
SqlParameter parErrMsg = new SqlParameter("@ErrMsg", entity.ErrMsg.Replace("\'", "\""));
cmd.Parameters.Add(parErrMsg);
DBUtility.Execute(cmd, DBUtility.BestToneCenterConStr);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// ��¼�ӿڵ������ݿ���־
/// </summary>
public static void WriteCallInterfaceLog_DB(String IP,String SPID, String InterfaceName, String InParameters, String OutParameters, Int32 CallResult, String ErrMsg)
{
try
{
//�ж��Ƿ��������ݿ��¼��־����
Boolean enabled = ConstHelper.DefaultInstance.DBLogEnabled;
if (!enabled)
return;
//��ȡ��д���ݿ���־�Ľӿ�
String outInerfaceList = ConstHelper.DefaultInstance.UnWriteDBLogInterface;
if (("," + outInerfaceList + ",").IndexOf("," + InterfaceName + ",") >= 0)
return;
CallInterfaceLog entity = new CallInterfaceLog();
entity.IP = IP;
entity.SPID = SPID;
entity.InterfaceName = InterfaceName;
entity.InParameters = InParameters;
entity.OutParameters = OutParameters;
entity.CallResult = CallResult.ToString();
entity.ErrMsg = ErrMsg;
entity.CreateTime = DateTime.Now;
CallInterfaceLogBO.InsertLog(entity);
}
catch (Exception ex)
{
}
}
