public ActionResult ExportMealRecord([DataSourceRequest] DataSourceRequest request, Can_MealRecordSearchModel model)
{
var listModel = GetListData<Can_MealRecordModel, Can_MealRecordEntity, Can_MealRecordSearchModel>(request, model, ConstantSql.hrm_can_get_MealRecord, ref status);
Dictionary<string, string> formatFields = new Dictionary<string, string>();
formatFields.Add(Can_MealRecordModel.FieldNames.WorkDay, ConstantFormat.HRM_Format_DayMonthYear);
formatFields.Add(Can_MealRecordModel.FieldNames.TimeLog, ConstantFormat.HRM_Format_DayMonthYear);
formatFields.Add(Can_MealRecordModel.FieldNames.DateCreate, ConstantFormat.HRM_Format_DayMonthYear);
formatFields.Add(Can_MealRecordModel.FieldNames.Hour, ConstantFormat.HRM_Format_Grid_ShortTime);
formatFields.Add(Can_MealRecordModel.FieldNames.Amount, ConstantFormat.HRM_Format_Money);
status = ExportService.Export(listModel, model.GetPropertyValue("ValueFields").TryGetValue<string>().Split(','), formatFields);
return Json(status);
}
public ActionResult GetMealRecordList([DataSourceRequest] DataSourceRequest request, Can_MealRecordSearchModel model)
{
BaseService baseService = new BaseService();
string status = string.Empty;
#region xử lý tìm kiếm từ 6h30
DateTime dateConfig = DateTime.MinValue;
var rsTimeConfig = baseService.GetData<Sys_AllSettingEntity>(AppConfig.HRM_CAN_MEALRECORD_EATEND_CONFIG.ToString(), ConstantSql.hrm_sys_sp_get_AllSettingByKey,UserLogin, ref status).FirstOrDefault();
if (rsTimeConfig != null && rsTimeConfig.Value1 != null)
{
dateConfig = DateTimeHelper.ConvertStringToDateTime(rsTimeConfig.Value1, ConstantFormat.HRM_Format_YearMonthDay_HoursMinSecond_ffffff.ToString());
}
double hourConfig = dateConfig.Hour + (((double)dateConfig.Minute) / 60);
if (model.DateFrom != null)
{
model.DateFrom = model.DateFrom.Value.Date.AddHours(hourConfig);
}
if (model.DateTo != null)
{
model.DateTo = model.DateTo.Value.Date.AddDays(1).AddHours(hourConfig).AddMilliseconds(-1);
}
#endregion
var result = GetListData<Can_MealRecordModel, Can_MealRecordEntity, Can_MealRecordSearchModel>(request, model, ConstantSql.hrm_can_get_MealRecord, ref status);
if (model.IsExport)
{
var fullPath = ExportService.Export(result, model.ValueFields.Split(','));
return Json(fullPath);
}
request.Page = 1;
var dataSourceResult = result.ToDataSourceResult(request);
dataSourceResult.Total = result.Count() <= 0 ? 0 : result.FirstOrDefault().TotalRow;
return Json(dataSourceResult);
}
