/// <summary>
/// 会员操作日志
/// </summary>
/// <param name="message"></param>
/// <param name="operate_type"></param>
/// <param name="generate_module"></param>
public void Logging(string message, int operate_type, int generate_module)
{
UpdateEndDateTimeWithMemberLog();
T_ZC_MemberLog member_log = new T_ZC_MemberLog();
member_log.Message = message;
member_log.Member = CurrentMember();
member_log.OperateType = operate_type;
member_log.GenerateModule = generate_module;
//为了避免用户的意外退出，造成最后一个操作无法记录结束的时间，这里近似的给一个结束时间
member_log.EndDateTime = DateTime.Now;
member_log.Continuance = member_log.EndDateTime - member_log.StartDateTime;
db.T_ZC_MemberLog.Add(member_log);
db.SaveChanges();
Session["MemberLogID"] = member_log.ID;
}
public ActionResult ImportOperateLogWithExcel(HttpPostedFileBase excel_file)
{
string file_name = System.IO.Path.GetFileName(excel_file.FileName);
try
{
string filePhysicalPath = Server.MapPath("~/TempFile/" + file_name);
excel_file.SaveAs(filePhysicalPath);
var excel = new ExcelQueryFactory(filePhysicalPath);
var logs = from c in excel.WorksheetNoHeader()
select c;
foreach (var log in logs)
{
T_ZC_MemberLog member_log = new T_ZC_MemberLog();
member_log.StartDateTime = Convert.ToDateTime(log[1]);
member_log.EndDateTime = Convert.ToDateTime(log[2]);
member_log.Message = log[3].ToString();
member_log.OperateType = GetValueOfEnumByName(log[4].ToString(),typeof(OperateTypes));
member_log.GenerateModule = GetValueOfEnumByName(log[5].ToString(), typeof(GenerateSystem));
member_log.MemberID = Convert.ToInt32(log[6]);
db.T_ZC_MemberLog.Add(member_log);
}
db.SaveChanges();
return ReturnJson(true, "导入成功", "", "", true, "");
}
catch(Exception e)
{
return ReturnJson(false, e.Message, "", "", false, "");
}
}
