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);
}
