public ActionResult ExportAll() { QueryParam queryParam = new QueryParam(); var extendParams = Request.Params["extendParams"]; if (extendParams != null) { JavaScriptSerializer js = new JavaScriptSerializer(); List <FilterModel> filters = js.Deserialize <List <FilterModel> >(extendParams); Dictionary <string, FilterModel> filterSet = filters.ToDictionary(key => key.key, model => model); queryParam.filters = filterSet; } SalaryRecordManager manager = new SalaryRecordManager(); OperateResult or = manager.ExportAll(queryParam); if (or.status == OperateStatus.Success && or.data != null) { string exportFileName = string.Concat("导出", DateTime.Now.ToString("yyyyMMddHHmmss"), ".xlsx"); return(new ExportExcelResult { SheetName = "工资单记录", FileName = exportFileName, ExportData = (DataTable)or.data }); } return(Json(or, JsonRequestBehavior.AllowGet)); }
public ActionResult GetAssessmentByPager(Pager pager) { QueryParam queryParam = new QueryParam { pager = pager }; var extendParams = Request.Params["extendParams"]; if (extendParams != null) { JavaScriptSerializer js = new JavaScriptSerializer(); List <FilterModel> filters = js.Deserialize <List <FilterModel> >(extendParams); Dictionary <string, FilterModel> filterSet = filters.ToDictionary(key => key.key, model => model); queryParam.filters = filterSet; } SalaryRecordManager manager = new SalaryRecordManager(); OperateResult or = manager.GetAssessmentByPager(queryParam); if (or.status == OperateStatus.Success && or.data != null) { return(Json(or.data, JsonRequestBehavior.AllowGet)); } return(Json(or, JsonRequestBehavior.AllowGet)); }
public ActionResult SaveBatch() { string data = Request.Params["salaryRecord"]; if (data == null) { return(Json( new OperateResult { content = "无数据", }, JsonRequestBehavior.AllowGet )); } JavaScriptSerializer js = new JavaScriptSerializer(); List <SalaryRecord> lstData = js.Deserialize <List <SalaryRecord> >(data); if (lstData.Count == 0) { return(Json( new OperateResult { content = "无数据", }, JsonRequestBehavior.AllowGet )); } SalaryRecordManager manager = new SalaryRecordManager(); OperateResult or = manager.AddBatch(lstData); return(Json(or, JsonRequestBehavior.AllowGet)); }
public ActionResult UnlockStatusBatch() { string data = Request.Params["salaryRecord"]; string status = Request.Params["status"]; if (data == null || status == null) { return(Json( new OperateResult { content = "数据异常", }, JsonRequestBehavior.AllowGet )); } JavaScriptSerializer js = new JavaScriptSerializer(); List <long> lstData = js.Deserialize <List <long> >(data); if (lstData.Count == 0) { return(Json( new OperateResult { content = "无数据", }, JsonRequestBehavior.AllowGet )); } OperateResult or = SalaryRecordManager.UpdateStatusBatch(lstData, status); return(Json(or, JsonRequestBehavior.AllowGet)); }
public ActionResult RefreshSalary() { string data = Request.Params["requestData"]; if (data == null) { return(Json( new OperateResult { content = "无数据", }, JsonRequestBehavior.AllowGet )); } JavaScriptSerializer js = new JavaScriptSerializer(); SalaryRecord model = js.Deserialize <SalaryRecord>(data); if (model == null) { return(Json( new OperateResult { content = "无数据", }, JsonRequestBehavior.AllowGet )); } OperateResult or = SalaryRecordManager.RefreshSalary(model); return(Json(or, JsonRequestBehavior.AllowGet)); }
public void Dispose() { SalaryRecordManager.RemoveAll(); AssessmentManager.RemoveAll(); EmployeeManager.RemoveAll(); DepartmentManager.RemoveAll(); PostManager.RemoveAll(); LevelManager.RemoveAll(); PerformanceManager.RemoveAll(); BenefitManager.RemoveAll(); try { FileInfo file = new FileInfo("../../TestUnint.sql"); string script = file.OpenText().ReadToEnd(); SystemDB db = new SystemDB(); db.Database.ExecuteSqlCommand(script); } catch (Exception e) { Trace.WriteLine(Model.Utility.Utility.GetExceptionMsg(e)); } }
public ActionResult GetAllEntities() { OperateResult or = SalaryRecordManager.GetAll(); if (or.status == OperateStatus.Success && or.data != null) { return(Json(or.data, JsonRequestBehavior.AllowGet)); } return(Json(or, JsonRequestBehavior.AllowGet)); }
public ActionResult SaveSingle() { string month = Request.Params["month"]; if (month == null) { return(Json( new OperateResult { content = "请输入考核月", }, JsonRequestBehavior.AllowGet )); } string data = Request.Params["salaryRecord"]; if (data == null) { return(Json( new OperateResult { content = "无数据", }, JsonRequestBehavior.AllowGet )); } JavaScriptSerializer js = new JavaScriptSerializer(); SalaryRecord model = js.Deserialize <SalaryRecord>(data); if (model == null) { return(Json( new OperateResult { content = "无数据", }, JsonRequestBehavior.AllowGet )); } SalaryRecordManager manager = new SalaryRecordManager(); OperateResult or = manager.Add(model); return(Json(or, JsonRequestBehavior.AllowGet)); }
public ActionResult EditEntity() { string data = Request.Params["requestData"]; if (data == null) { return(Json( new OperateResult { content = "无考核数据", }, JsonRequestBehavior.AllowGet )); } JavaScriptSerializer js = new JavaScriptSerializer(); SalaryRecord model = js.Deserialize <SalaryRecord>(data); if (model == null) { return(Json( new OperateResult { content = "无考核数据", }, JsonRequestBehavior.AllowGet )); } if (!ModelState.IsValid) { return(Json( new OperateResult { content = Model.Utility.GetModelStateErrors(ModelState), }, JsonRequestBehavior.AllowGet )); } OperateResult or = SalaryRecordManager.Update(model); return(Json(or, JsonRequestBehavior.AllowGet)); }
public ActionResult UnlockStatus(long id, string status) { OperateResult or = SalaryRecordManager.UpdateStatus(id, status); return(Json(or, JsonRequestBehavior.AllowGet)); }
public bool EmployeeSalaryInputStub(string month) { Random random = new Random(); QueryParam queryParam = new QueryParam { pager = new Pager { page = 1, rows = EmployeeStubSize } }; FilterModel filter = new FilterModel { key = "month", value = month }; Dictionary <string, FilterModel> filterSet = new Dictionary <string, FilterModel>(); filterSet.Add(filter.key, filter); queryParam.filters = filterSet; var or = SalaryRecordManager.GetAssessmentAll(queryParam); if (or.status == OperateStatus.Error) { return(false); } dynamic listAssessment = or.data; foreach (var ass in listAssessment) { SalaryRecord e = new SalaryRecord(); PropertyInfo[] pArray = ass.GetType().GetProperties(); Type t = ass.GetType(); //e.billSerial = Convert.ToString(); //e.employeeId = Convert.ToInt64(t.GetProperty("employeeId").GetValue(ass)); e.billSerial = t.GetProperty("billSerial").GetValue(ass); e.assessmentInfoId = t.GetProperty("assessmentInfoId").GetValue(ass); e.levelSalary = t.GetProperty("levelSalary").GetValue(ass); e.fullAttendanceRewards = t.GetProperty("fullAttendanceRewards").GetValue(ass); e.performanceRewards = t.GetProperty("performanceRewards").GetValue(ass); e.benefitRewards = t.GetProperty("benefitRewards").GetValue(ass); e.seniorityRewards = t.GetProperty("seniorityRewards").GetValue(ass); e.normalOvertimeRewards = t.GetProperty("normalOvertimeRewards").GetValue(ass); e.holidayOvertimeRewards = t.GetProperty("holidayOvertimeRewards").GetValue(ass); e.shouldTotal = t.GetProperty("shouldTotal").GetValue(ass); e.actualTotal = t.GetProperty("actualTotal").GetValue(ass); or = SalaryRecordManager.Add(e); if (or.status == OperateStatus.Error) { StackTrace st = new StackTrace(new StackFrame(true)); string msg = $"App Trace >>> in file: {st.GetFrame(0).GetFileName()} " + $"line {st.GetFrame(0).GetFileLineNumber()} message: {or.content}"; Trace.WriteLine(msg); return(false); } } return(true); }