/// <summary>
/// 获取日志数量列表
/// </summary>
public int GetLogsCount(LogQueryInfo queryInfo)
{
Hashtable htQueryInfo = new Hashtable();
htQueryInfo.Add("LogId", queryInfo.log_id);
htQueryInfo.Add("BizId", queryInfo.biz_id);
htQueryInfo.Add("BizName", queryInfo.biz_name);
htQueryInfo.Add("LogTypeId", queryInfo.log_type_id);
htQueryInfo.Add("LogCode", queryInfo.log_code);
htQueryInfo.Add("LogBody", queryInfo.log_body);
htQueryInfo.Add("CreateTimeBegin", queryInfo.create_time_begin);
htQueryInfo.Add("CreateTimeEnd", queryInfo.create_time_end);
htQueryInfo.Add("CreateUserId", queryInfo.create_user_id);
htQueryInfo.Add("ModifyTimeBegin", queryInfo.modify_time_begin);
htQueryInfo.Add("ModifyTimeEnd", queryInfo.modify_time_end);
htQueryInfo.Add("ModifyUserId", queryInfo.modify_user_id);
htQueryInfo.Add("CustomerCode", queryInfo.customer_code);
htQueryInfo.Add("CustomerId", queryInfo.customer_id);
htQueryInfo.Add("UnitCode", queryInfo.unit_code);
htQueryInfo.Add("UnitId", queryInfo.unit_id);
htQueryInfo.Add("UserCode", queryInfo.user_code);
htQueryInfo.Add("UserId", queryInfo.user_id);
htQueryInfo.Add("IfCode", queryInfo.if_code);
htQueryInfo.Add("AppCode", queryInfo.app_code);
return(GetLogsCount(htQueryInfo));
}
/// <summary>
/// 获取日志列表
/// </summary>
public IList <Log> GetLogs(LogQueryInfo queryInfo, long startRow, long rowsCount)
{
Hashtable htQueryInfo = new Hashtable();
htQueryInfo.Add("LogId", queryInfo.log_id);
htQueryInfo.Add("BizId", queryInfo.biz_id);
htQueryInfo.Add("BizName", queryInfo.biz_name);
htQueryInfo.Add("LogTypeId", queryInfo.log_type_id);
htQueryInfo.Add("LogCode", queryInfo.log_code);
htQueryInfo.Add("LogBody", queryInfo.log_body);
htQueryInfo.Add("CreateTimeBegin", queryInfo.create_time_begin);
htQueryInfo.Add("CreateTimeEnd", queryInfo.create_time_end);
htQueryInfo.Add("CreateUserId", queryInfo.create_user_id);
htQueryInfo.Add("ModifyTimeBegin", queryInfo.modify_time_begin);
htQueryInfo.Add("ModifyTimeEnd", queryInfo.modify_time_end);
htQueryInfo.Add("ModifyUserId", queryInfo.modify_user_id);
htQueryInfo.Add("CustomerCode", queryInfo.customer_code);
htQueryInfo.Add("CustomerId", queryInfo.customer_id);
htQueryInfo.Add("UnitCode", queryInfo.unit_code);
htQueryInfo.Add("UnitId", queryInfo.unit_id);
htQueryInfo.Add("UserCode", queryInfo.user_code);
htQueryInfo.Add("UserId", queryInfo.user_id);
htQueryInfo.Add("IfCode", queryInfo.if_code);
htQueryInfo.Add("AppCode", queryInfo.app_code);
var rows = GetLogs(htQueryInfo, startRow, rowsCount);
if (rows == null)
{
return(null);
}
IList <Log> list = new List <Log>();
foreach (var row in rows)
{
Log item = new Log();
item.log_id = row.LogId;
item.biz_id = row.BizId;
item.biz_name = row.BizName;
item.log_type_id = row.LogTypeId;
item.log_type_code = row.LogTypeCode;
item.log_code = row.LogCode;
item.log_body = row.LogBody;
item.create_time = row.CreateTime;
item.create_user_id = row.CreateUserId;
item.modify_time = row.ModifyTime;
item.modify_user_id = row.ModifyUserId;
item.customer_code = row.CustomerCode;
item.customer_id = row.CustomerId;
item.unit_code = row.UnitCode;
item.unit_id = row.UnitId;
item.user_code = row.UserCode;
item.user_id = row.UserId;
item.if_code = row.IfCode;
item.app_code = row.AppCode;
list.Add(item);
}
return(list);
}
/// <summary>
/// 获取客户日志数量接口
/// </summary>
/// <param name="customer_id">客户ID(必填项)</param>
/// <param name="query_info">查询条件(customer_id属性可以不设置)</param>
/// <returns></returns>
public int GetLogsCountByCustomer(string customer_id, LogQueryInfo query_info)
{
var service = new Dex.Services.LogDBService();
if (customer_id == null || customer_id.Trim().Length > 32)
{
throw new Exception("客户ID为空或超出长度限制");
}
query_info.customer_id = customer_id;
return(GetLogsCount(query_info));
}
/// <summary>
/// 获取客户日志接口
/// </summary>
/// <param name="customer_id">客户ID(必填项)</param>
/// <param name="query_info">查询条件(customer_id属性可以不设置)</param>
/// <returns></returns>
public IList <Log> GetLogsByCustomer(string customer_id,
LogQueryInfo query_info, long startRow, long rowsCount)
{
var service = new Dex.Services.LogDBService();
if (customer_id == null || customer_id.Trim().Length > 32)
{
throw new Exception("客户ID为空或超出长度限制");
}
query_info.customer_id = customer_id;
return(GetLogs(query_info, startRow, rowsCount));
}
public GetCountContract GetLogsCountJson(string userId, string userPwd,
LogQueryInfo queryInfo)
{
return(GetLogsCount(TransType.JSON, userId, userPwd, queryInfo));
}
/// <summary>
/// 获取日志集合接口
/// </summary>
public GetLogsContract GetLogs(TransType transType, string userId, string userPwd,
long startRow, long rowsCount, LogQueryInfo queryInfo)
{
string bizId = Utils.NewGuid();
string methodKey = "LogService.GetLogs";
string ifCode = "C011";
var data = new GetLogsContract();
Hashtable htLogExt = new Hashtable();
htLogExt["customer_code"] = null;
htLogExt["customer_id"] = null;
htLogExt["unit_code"] = null;
htLogExt["unit_id"] = null;
htLogExt["user_code"] = null;
htLogExt["user_id"] = userId;
htLogExt["if_code"] = ifCode;
htLogExt["app_code"] = AppType.Client;
try
{
Hashtable htParams = new Hashtable();
htParams.Add("trans_type", transType);
htParams.Add("user_id", userId);
htParams.Add("user_pwd", userPwd);
htParams.Add("start_row", startRow);
htParams.Add("rows_count", rowsCount);
htParams.Add("query_info", queryInfo);
LogService.WriteTrace(bizId, methodKey, TraceLogType.Params.ToString(), htParams, userId, htLogExt);
bool statusFlag = true;
Hashtable htError = null;
CertInfo certInfo = null;
// 检查参数
Hashtable htResult = new Hashtable();
bool paramCheckFlag = false;
#region Check Length
htResult = ErrorService.CheckLength("用户ID", userId, 1, 32, true, false, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("密码", userPwd, 1, 32, true, false, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
// queryInfo
htResult = ErrorService.CheckLength("日志ID", queryInfo.log_id, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("业务ID", queryInfo.biz_id, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("业务名称", queryInfo.biz_name, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("日志类型ID", queryInfo.log_type_id, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("日志类型代码", queryInfo.log_type_code, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("日志代码", queryInfo.log_code, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("日志内容", queryInfo.log_body, 0, 200, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("开始创建时间", queryInfo.create_time_begin, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("结束创建时间", queryInfo.create_time_end, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("创建人ID", queryInfo.create_user_id, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("开始修改时间", queryInfo.modify_time_begin, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("结束修改时间", queryInfo.modify_time_end, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("修改人ID", queryInfo.modify_user_id, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("客户代码", queryInfo.customer_code, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("客户ID", queryInfo.customer_id, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("门店代码", queryInfo.unit_code, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("门店ID", queryInfo.unit_id, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("用户代码", queryInfo.user_code, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("用户ID", queryInfo.user_id, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("接口代码", queryInfo.if_code, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
htResult = ErrorService.CheckLength("平台代码", queryInfo.app_code, 0, 50, true, true, ref paramCheckFlag);
if (!paramCheckFlag)
{
return(ErrorConvert.Export <GetLogsContract>(htResult));
}
#endregion
Hashtable htQueryInfo = new Hashtable();
htQueryInfo.Add("LogId", queryInfo.log_id);
htQueryInfo.Add("BizId", queryInfo.biz_id);
htQueryInfo.Add("BizName", queryInfo.biz_name);
htQueryInfo.Add("LogTypeId", queryInfo.log_type_id);
htQueryInfo.Add("LogTypeCode", queryInfo.log_type_code);
htQueryInfo.Add("LogCode", queryInfo.log_code);
htQueryInfo.Add("LogBody", queryInfo.log_body);
htQueryInfo.Add("CreateTimeBegin", queryInfo.create_time_begin);
htQueryInfo.Add("CreateTimeEnd", queryInfo.create_time_end);
htQueryInfo.Add("CreateUserId", queryInfo.create_user_id);
htQueryInfo.Add("ModifyTimeBegin", queryInfo.modify_time_begin);
htQueryInfo.Add("ModifyTimeEnd", queryInfo.modify_time_end);
htQueryInfo.Add("ModifyUserId", queryInfo.modify_user_id);
htQueryInfo.Add("CustomerCode", queryInfo.customer_code);
htQueryInfo.Add("CustomerId", queryInfo.customer_id);
htQueryInfo.Add("UnitCode", queryInfo.unit_code);
htQueryInfo.Add("UnitId", queryInfo.unit_id);
htQueryInfo.Add("UserCode", queryInfo.user_code);
htQueryInfo.Add("UserId", queryInfo.user_id);
htQueryInfo.Add("IfCode", queryInfo.if_code);
htQueryInfo.Add("AppCode", queryInfo.app_code);
Dex.Services.AuthService authService = new Dex.Services.AuthService();
// 检查User
Hashtable htUser = new Hashtable();
htUser.Add("UserId", userId);
htUser.Add("CertPwd", userPwd);
statusFlag = authService.Validate(htUser, ref certInfo);
if (!statusFlag)
{
htError = ErrorService.OutputError(ErrorCode.A009, "用户ID与密码不匹配", true);
data.status = Utils.GetStatus(false);
data.error_code = htError["error_code"].ToString();
data.error_full_desc = htError["error_desc"].ToString();
LogService.WriteError(bizId, methodKey, data.error_code, data.ToString(), userId, htLogExt);
return(data);
}
// 获取数据
Services.LogDBService logDBService = new Services.LogDBService();
IList <LogInfo> logs = logDBService.GetLogs(htQueryInfo, startRow, rowsCount);
if (logs != null)
{
data.Logs = new List <LogContract>();
foreach (var log in logs)
{
LogContract logContract = new LogContract();
logContract.log_id = log.LogId;
logContract.biz_id = log.BizId;
logContract.biz_name = log.BizName;
logContract.log_type_id = log.LogTypeId;
logContract.log_type_code = log.LogTypeCode;
logContract.log_code = log.LogCode;
logContract.log_body = log.LogBody;
logContract.create_time = log.CreateTime;
logContract.create_user_id = log.CreateUserId;
logContract.modify_time = log.ModifyTime;
logContract.modify_user_id = log.ModifyUserId;
logContract.customer_code = log.CustomerCode;
logContract.customer_id = log.CustomerId;
logContract.unit_code = log.UnitCode;
logContract.unit_id = log.UnitId;
logContract.user_code = log.UserCode;
logContract.user_id = log.UserId;
logContract.if_code = log.IfCode;
logContract.app_code = log.AppCode;
data.Logs.Add(logContract);
}
}
data.status = Utils.GetStatus(statusFlag);
LogService.WriteTrace(bizId, methodKey, TraceLogType.Return.ToString(), data.ToString(), userId, htLogExt);
}
catch (Exception ex)
{
data.status = Utils.GetStatus(false);
data.error_code = ErrorCode.A000.ToString();
data.error_full_desc = ex.ToString();
LogService.WriteError(bizId, methodKey, data.error_code, data.ToString(), userId, htLogExt);
}
return(data);
}
public GetLogsContract GetLogsJson(string userId, string userPwd,
long startRow, long rowsCount, LogQueryInfo queryInfo)
{
return(GetLogs(TransType.JSON, userId, userPwd, startRow, rowsCount, queryInfo));
}
/// <summary>
/// 获取日志数量接口
/// </summary>
/// <param name="query_info">查询条件</param>
/// <returns></returns>
private int GetLogsCount(LogQueryInfo query_info)
{
var service = new Dex.Services.LogDBService();
return(service.GetLogsCount(query_info));
}
/// <summary>
/// 获取日志接口
/// </summary>
/// <param name="query_info">查询条件</param>
/// <returns></returns>
private IList <Log> GetLogs(LogQueryInfo query_info, long startRow, long rowsCount)
{
var service = new Dex.Services.LogDBService();
return(service.GetLogs(query_info, startRow, rowsCount));
}