public bool GetUserCreateTime(Guid transactionid, AdminInfo admin, int curpage, int pagesize, DateTime start, DateTime end, string searchstr, out string strJsonResult)
{
bool result = true;
strJsonResult = string.Empty;
ErrorCodeInfo error = new ErrorCodeInfo();
string paramstr = string.Empty;
paramstr += $"userID:{admin.UserID}";
paramstr += $"||UserAccount:{admin.UserAccount}";
paramstr += $"||curpage:{curpage}";
paramstr += $"||pagesize:{pagesize}";
paramstr += $"||start:{start}";
paramstr += $"||end:{end}";
paramstr += $"||searchstr:{searchstr}";
string funname = "GetUserCreateTime";
try
{
do
{
BaseListInfo lists = new BaseListInfo();
SystemReportDBProvider Provider = new SystemReportDBProvider();
if (!Provider.GetUserCreateTime(transactionid, admin, curpage, pagesize, start, end, searchstr, out lists, out error))
{
strJsonResult = JsonHelper.ReturnJson(false, Convert.ToInt32(error.Code), error.Info);
LoggerHelper.Info(admin.UserAccount, funname, paramstr, Convert.ToString(error.Code), false, transactionid);
result = false;
break;
}
error.Code = ErrorCode.None;
string json = JsonConvert.SerializeObject(lists);
LoggerHelper.Info(admin.UserAccount, funname, paramstr, Convert.ToString(error.Code), true, transactionid);
strJsonResult = JsonHelper.ReturnJson(true, Convert.ToInt32(error.Code), error.Info, json);
result = true;
} while (false);
}
catch (Exception ex)
{
error.Code = ErrorCode.Exception;
LoggerHelper.Info(admin.UserAccount, funname, paramstr, Convert.ToString(error.Code), false, transactionid);
LoggerHelper.Error("SystemReportManager调用GetUserCreateTime异常", paramstr, ex.ToString(), transactionid);
strJsonResult = JsonHelper.ReturnJson(false, Convert.ToInt32(error.Code), error.Info);
result = false;
}
return(result);
}
public bool GetSystemUserCount(Guid transactionid, AdminInfo admin, out string strJsonResult)
{
bool result = true;
strJsonResult = string.Empty;
ErrorCodeInfo error = new ErrorCodeInfo();
string paramstr = string.Empty;
paramstr += $"userID:{admin.UserID}";
paramstr += $"||UserAccount:{admin.UserAccount}";
string funname = "GetSystemUserCount";
try
{
do
{
int count = 0;
SystemReportDBProvider Provider = new SystemReportDBProvider();
if (!Provider.GetSystemUserCount(transactionid, admin, out count, out error))
{
strJsonResult = JsonHelper.ReturnJson(false, Convert.ToInt32(error.Code), error.Info);
LoggerHelper.Info(admin.UserAccount, funname, paramstr, Convert.ToString(error.Code), false, transactionid);
result = false;
break;
}
error.Code = ErrorCode.None;
Dictionary <string, int> dy = new Dictionary <string, int>();
dy.Add("Conut", count);
string json = JsonConvert.SerializeObject(dy);
LoggerHelper.Info(admin.UserAccount, funname, paramstr, Convert.ToString(error.Code), true, transactionid);
strJsonResult = JsonHelper.ReturnJson(true, Convert.ToInt32(error.Code), error.Info, json);
result = true;
} while (false);
}
catch (Exception ex)
{
error.Code = ErrorCode.Exception;
LoggerHelper.Info(admin.UserAccount, funname, paramstr, Convert.ToString(error.Code), false, transactionid);
LoggerHelper.Error("SystemReportManager调用GetSystemUserCount异常", paramstr, ex.ToString(), transactionid);
strJsonResult = JsonHelper.ReturnJson(false, Convert.ToInt32(error.Code), error.Info);
result = false;
}
return(result);
}
public bool ExportNoLoginUsersToExcel(Guid transactionid, AdminInfo admin, int curpage, int pagesize, DateTime start, DateTime end, string searchstr, out byte[] filebyte, out string strJsonResult)
{
bool result = true;
strJsonResult = string.Empty;
ErrorCodeInfo error = new ErrorCodeInfo();
filebyte = new byte[0];
string paramstr = string.Empty;
paramstr += $"userID:{admin.UserID}";
paramstr += $"||UserAccount:{admin.UserAccount}";
paramstr += $"||curpage:{curpage}";
paramstr += $"||pagesize:{pagesize}";
paramstr += $"||start:{start}";
paramstr += $"||end:{end}";
paramstr += $"||searchstr:{searchstr}";
string funname = "ExportNoLoginUsersToExcel";
try
{
do
{
BaseListInfo lists = new BaseListInfo();
SystemReportDBProvider Provider = new SystemReportDBProvider();
if (!Provider.GetNoLoginUsers(transactionid, admin, curpage, pagesize, start, end, searchstr, out lists, out error))
{
strJsonResult = JsonHelper.ReturnJson(false, Convert.ToInt32(error.Code), error.Info);
LoggerHelper.Info(admin.UserAccount, funname, paramstr, Convert.ToString(error.Code), false, transactionid);
result = false;
break;
}
using (ExcelPackage package = new ExcelPackage())
{
ExcelWorksheet sheet = package.Workbook.Worksheets.Add("从未登录用户统计");
sheet.Cells[1, 1].Value = "显示名称";
sheet.Column(1).Width = 30; //设置列宽
sheet.Cells[1, 2].Value = "邮箱";
sheet.Column(2).Width = 50; //设置列宽
sheet.Cells[1, 3].Value = "创建时间";
sheet.Column(3).Width = 30; //设置列宽
sheet.Cells[1, 4].Value = "所在路径";
sheet.Column(4).Width = 150; //设置列宽
for (int i = 0; i < lists.Lists.Count; i++)
{
SystemReportInfo info = (SystemReportInfo)lists.Lists[i];
sheet.Cells[i + 2, 1].Value = info.DisplayName;
sheet.Cells[i + 2, 2].Value = info.UserAccount;
sheet.Cells[i + 2, 3].Value = info.CreateTimeName;
sheet.Cells[i + 2, 4].Value = info.DistinguishedName;
}
filebyte = package.GetAsByteArray();
}
error.Code = ErrorCode.None;
string json = JsonConvert.SerializeObject(lists);
LoggerHelper.Info(admin.UserAccount, funname, paramstr, Convert.ToString(error.Code), true, transactionid);
strJsonResult = JsonHelper.ReturnJson(true, Convert.ToInt32(error.Code), error.Info, json);
result = true;
} while (false);
}
catch (Exception ex)
{
error.Code = ErrorCode.Exception;
LoggerHelper.Info(admin.UserAccount, funname, paramstr, Convert.ToString(error.Code), false, transactionid);
LoggerHelper.Error("SystemReportManager调用ExportNoLoginUsersToExcel异常", paramstr, ex.ToString(), transactionid);
strJsonResult = JsonHelper.ReturnJson(false, Convert.ToInt32(error.Code), error.Info);
result = false;
}
return(result);
}
