/// <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, ""); } }