/// <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) { } }