public ActionResult SaveForm(string keyValue, TrainingCarEntity entity)
{
try
{
DateTime firsttime = DateTime.Now; //Util.Time.CalculateFirstDateOfWeek(DateTime.Now);
DateTime endTime = DateTime.Now.AddDays(6); //Util.Time.CalculateLastDateOfWeek(DateTime.Now);
var monthworklist = MonthWorkDayBLL.Instance.GetList(new MonthWorkDayEntity()
{
ObjectId = entity.SchoolId,
StartTime = firsttime.ToString(),
EndTime = endTime.ToString()
}).OrderBy(p => p.WorkDay).ToList();
if (monthworklist.Count() == 0)
{
return(Error("未设置当月工作日时间,请前去设置后再操作"));
}
List <TrainingTimeTableEntity> worktimelist = null;
worktimelist = TrainingTimeTableBLL.Instance.GetList(new TrainingTimeTableEntity()
{
SchoolId = entity.SchoolId
}).OrderBy(p => p.SortNum).ToList();
if (worktimelist.Count() == 0)
{
return(Error("未设置该考场实训时段,请前去设置后再操作"));
}
if (keyValue != "")
{
entity.TrainingCarId = keyValue;
TrainingCarBLL.Instance.Update(entity);
}
else
{
entity.TrainingCarId = Util.Util.NewUpperGuid();
entity.CreateTime = DateTime.Now;
if (TrainingCarBLL.Instance.Add(entity))
{
TrainingFreeTimeBLL.Instance.AddInitFreeTime(monthworklist, worktimelist, entity.TrainingCarId);
}
}
return(Success("保存成功"));
}
catch (Exception ex)
{
ex.Data["Method"] = "TrainingCarController>>SaveForm";
new ExceptionHelper().LogException(ex);
return(Error("保存失败"));
}
}
public ActionResult GetListJson(string queryJson)
{
var watch = CommonHelper.TimerStart();
TrainingCarEntity para = new TrainingCarEntity();
if (!string.IsNullOrWhiteSpace(queryJson))
{
var queryParam = queryJson.ToJObject();
if (!queryParam["schoolid"].IsEmpty())
{
para.SchoolId = queryParam["schoolid"].ToString();
}
if (!queryParam["trainingtype"].IsEmpty())
{
para.TrainingType = int.Parse(queryParam["trainingtype"].ToString());
}
}
var list = TrainingCarBLL.Instance.GetList(para);
return(Content(list.ToJson()));
}
public ActionResult GetPageListJson(Pagination pagination, string queryJson)
{
var watch = CommonHelper.TimerStart();
TrainingCarEntity para = new TrainingCarEntity();
if (!string.IsNullOrWhiteSpace(queryJson))
{
var queryParam = queryJson.ToJObject();
//类型
if (!queryParam["condition"].IsEmpty() && !queryParam["keyword"].IsEmpty())
{
var condition = queryParam["condition"].ToString().ToLower();
switch (condition)
{
case "name":
para.Name = queryParam["keyword"].ToString();
break;
case "schoolname":
para.SchoolName = queryParam["keyword"].ToString();
break;
case "carnumber":
para.CarNumber = queryParam["keyword"].ToString();
break;
}
}
}
var pageList = new List <TrainingCarEntity>();
try
{
pageList = TrainingCarBLL.Instance.GetPageList(para, ref pagination);
if (pageList != null)
{
var StartTime = Util.Time.CalculateFirstDateOfWeek(DateTime.Now).ToString();
var EndTime = Util.Time.CalculateLastDateOfWeek(DateTime.Now).ToString();
pageList.ForEach((o) =>
{
if (o.TrainingCarId != null)
{
o.WeekApplayCount = TrainingOrderBLL.Instance.GetList(new TrainingOrderEntity()
{
TrainingCarId = o.TrainingCarId,
StartTime = Util.Time.CalculateFirstDateOfWeek(DateTime.Now).ToString(),
EndTime = Util.Time.CalculateLastDateOfWeek(DateTime.Now).ToString()
}).Count();
o.TotalApplayCount = TrainingOrderBLL.Instance.GetList(new TrainingOrderEntity()
{
TrainingCarId = o.TrainingCarId
}).Count();
}
});
}
}
catch (Exception ex)
{
}
var JsonData = new
{
rows = pageList,
total = pagination.total,
page = pagination.page,
records = pagination.records,
costtime = CommonHelper.TimerEnd(watch)
};
return(Content(JsonData.ToJson()));
}
public JsonResult ImportExcel(HttpPostedFileBase file)
{
int count = 0;
var result = new ReturnMessage(false)
{
Message = "上传失败!"
};
try
{
var data = ExcelHelper.ExcelImport(file.InputStream);
if (data != null)
{
if (data.Columns.Count != 5)
{
result.Message = "请按照模板格式正确填写内容!";
return(Json(result));
}
int successcount = 0, errorcount = 0;
foreach (System.Data.DataRow row in data.Rows)
{
try
{
if (row[0].ToString() != "")
{
TrainingCarEntity entity = new TrainingCarEntity();
entity.TrainingCarId = Util.Util.NewUpperGuid();
entity.Name = row[0].ToString();
var schoolList = SchoolBLL.Instance.GetList(new SchoolEntity()
{
Name = row[1].ToString()
});
if (schoolList != null && schoolList.Count() > 0)
{
var school = schoolList.FirstOrDefault();
entity.SchoolId = school.SchoolId;
entity.SchoolName = school.Name;
}
entity.CarNumber = row[2].ToString();
if (row[3].ToString() != "")
{
int[] values = (int[])System.Enum.GetValues(typeof(QX360.Model.Enums.TrainingType));
string[] texts = (string[])System.Enum.GetNames(typeof(QX360.Model.Enums.TrainingType));
for (int i = 0; i < values.Length; i++)
{
if (texts[i] == row[3].ToString())
{
entity.TrainingType = values[i];
entity.TrainingTypeName = row[3].ToString();
break;
}
}
}
entity.Remark = row[4].ToString();
entity.CreateTime = DateTime.Now;
entity.CreateId = LoginUser.UserId;
TrainingCarBLL.Instance.Add(entity);
successcount++;
}
}
catch (Exception)
{
errorcount++;
}
}
result.IsSuccess = true;
result.Message = string.Format("导入成功({0}条),失败({1}条))!", successcount, errorcount);
}
}
catch (Exception ex)
{
ex.Data["Method"] = "OrderLogisticController>>Import";
new ExceptionHelper().LogException(ex);
}
return(Json(result));
}
/// <summary>
/// 导出EXCEL
/// </summary>
public void ExportExcel(string queryJson)
{
string cacheKey = Request["cacheid"] as string;
HttpRuntime.Cache[cacheKey + "-state"] = "processing";
HttpRuntime.Cache[cacheKey + "-row"] = "0";
try
{
//这里要url解码
var queryParam = Server.UrlDecode(queryJson).ToJObject();
TrainingCarEntity para = new TrainingCarEntity();
//类型
if (!queryParam["condition"].IsEmpty() && !queryParam["keyword"].IsEmpty())
{
var condition = queryParam["condition"].ToString().ToLower();
switch (condition)
{
case "name":
para.Name = queryParam["keyword"].ToString();
break;
case "schoolname":
para.SchoolName = queryParam["keyword"].ToString();
break;
case "carnumber":
para.CarNumber = queryParam["keyword"].ToString();
break;
}
}
var list = TrainingCarBLL.Instance.GetList(para);
if (list != null)
{
var StartTime = Util.Time.CalculateFirstDateOfWeek(DateTime.Now).ToString();
var EndTime = Util.Time.CalculateLastDateOfWeek(DateTime.Now).ToString();
list.ForEach((o) =>
{
if (o.TrainingCarId != null)
{
o.WeekApplayCount = TrainingOrderBLL.Instance.GetList(new TrainingOrderEntity()
{
TrainingCarId = o.TrainingCarId,
StartTime = Util.Time.CalculateFirstDateOfWeek(DateTime.Now).ToString(),
EndTime = Util.Time.CalculateLastDateOfWeek(DateTime.Now).ToString()
}).Count();
o.TotalApplayCount = TrainingOrderBLL.Instance.GetList(new TrainingOrderEntity()
{
TrainingCarId = o.TrainingCarId
}).Count();
}
if (o.Status != null)
{
o.StatusName = ((QX360.Model.Enums.UseStatus)o.Status).ToString();
}
});
//设置导出格式
ExcelConfig excelconfig = new ExcelConfig();
excelconfig.Title = "实训车辆信息";
excelconfig.TitleFont = "微软雅黑";
excelconfig.TitlePoint = 10;
excelconfig.FileName = "实训车辆信息.xls";
excelconfig.IsAllSizeColumn = true;
//每一列的设置,没有设置的列信息，系统将按datatable中的列名导出
List <ColumnEntity> listColumnEntity = new List <ColumnEntity>();
excelconfig.ColumnEntity = listColumnEntity;
ColumnEntity columnentity = new ColumnEntity();
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "Name", ExcelColumn = "实训车辆名称", Width = 20
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "CarNumber", ExcelColumn = "车牌号", Width = 20
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "SchoolName", ExcelColumn = "所属考场", Width = 15
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "TrainingTypeName", ExcelColumn = "实训类型", Width = 15
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "WeekApplayCount", ExcelColumn = "本周预约次数", Width = 15
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "TotalApplayCount", ExcelColumn = "预约总次数", Width = 15
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "StatusName", ExcelColumn = "状态", Width = 15
});
//需合并索引
//excelconfig.MergeRangeIndexArr = new int[] { 0, 1, 2, 3, 4, 5, 6, 7 };
//调用导出方法
ExcelHelper <TrainingCarEntity> .ExcelDownload(list, excelconfig);
HttpRuntime.Cache[cacheKey + "-state"] = "done";
}
}
catch (Exception)
{
HttpRuntime.Cache[cacheKey + "-state"] = "error";
}
}
/// <summary>
/// 导出EXCEL
/// </summary>
public void ExportExcel(string queryJson)
{
string cacheKey = Request["cacheid"] as string;
HttpRuntime.Cache[cacheKey + "-state"] = "processing";
HttpRuntime.Cache[cacheKey + "-row"] = "0";
TrainingCarEntity para = new TrainingCarEntity();
try
{
//这里要url解码
string time = "";
string examplaceid = "";
int trainingtype = 0;
if (!string.IsNullOrWhiteSpace(queryJson))
{
var queryParam = Server.UrlDecode(queryJson).ToJObject();
if (!queryParam["examplaceid"].IsEmpty())
{
examplaceid = queryParam["examplaceid"].ToString();
}
if (!queryParam["trainingtype"].IsEmpty())
{
trainingtype = int.Parse(queryParam["trainingtype"].ToString());
}
if (!queryParam["Time"].IsEmpty())
{
time = queryParam["Time"].ToString();
}
}
DataTable dt = GetDatable(time, examplaceid, trainingtype);
if (dt != null)
{
var scholl = SchoolBLL.Instance.GetEntity(examplaceid);
//设置导出格式
ExcelConfig excelconfig = new ExcelConfig();
excelconfig.Title = scholl == null ? "" : scholl.Name + time + "-考场预约业务明细-";
excelconfig.TitleFont = "微软雅黑";
excelconfig.TitlePoint = 10;
excelconfig.FileName = "考场预约业务明细.xls";
excelconfig.IsAllSizeColumn = true;
//每一列的设置,没有设置的列信息，系统将按datatable中的列名导出
List <ColumnEntity> listColumnEntity = new List <ColumnEntity>();
excelconfig.ColumnEntity = listColumnEntity;
ColumnEntity columnentity = new ColumnEntity();
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "TimeSection", ExcelColumn = "预约时段", Width = 20
});
var list = TrainingCarBLL.Instance.GetList(new TrainingCarEntity()
{
SchoolId = examplaceid,
TrainingType = trainingtype
}).OrderBy((o) => o.SortNum).ToList();
if (list != null)
{
foreach (var item in list)
{
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "car_" + item.TrainingCarId, ExcelColumn = item.Name, Width = 20
});
}
}
//调用导出方法
ExcelHelper.ExcelDownload(dt, excelconfig);
HttpRuntime.Cache[cacheKey + "-state"] = "done";
}
}
catch (Exception)
{
HttpRuntime.Cache[cacheKey + "-state"] = "error";
}
}
public ActionResult GetPageListJson(Pagination pagination, string queryJson)
{
var watch = CommonHelper.TimerStart();
TrainingCarEntity para = new TrainingCarEntity();
if (!string.IsNullOrWhiteSpace(queryJson))
{
var queryParam = queryJson.ToJObject();
if (!queryParam["StartTime"].IsEmpty() && !queryParam["EndTime"].IsEmpty())
{
DateTime startTime = queryParam["StartTime"].ToDate();
DateTime endTime = queryParam["EndTime"].ToDate();
para.StartTime = startTime.ToString();
para.EndTime = endTime.ToString();
}
//类型
if (!queryParam["condition"].IsEmpty() && !queryParam["keyword"].IsEmpty())
{
var condition = queryParam["condition"].ToString().ToLower();
switch (condition)
{
case "name":
para.Name = queryParam["keyword"].ToString();
break;
case "schoolname":
para.SchoolName = queryParam["keyword"].ToString();
break;
case "carnumber":
para.CarNumber = queryParam["keyword"].ToString();
break;
}
}
}
var pageList = new List <TrainingCarEntity>();
try
{
pageList = TrainingCarBLL.Instance.GetPageList(para, ref pagination);
if (pageList != null)
{
pageList.ForEach((o) =>
{
int subricCount = 0;
int nosubricCount = 0;
if (o.TrainingCarId != null)
{
//预约时段总数 包括系统定制预约时间段和后台创建加班时间段
var orderList = TrainingOrderBLL.Instance.GetList(new TrainingOrderEntity()
{
TrainingCarId = o.TrainingCarId,
StartTime = para.StartTime,
EndTime = para.EndTime
}).Where(p => p.Status != (int)RCHL.Model.Enums.TrainingStatus.已取消).ToList();
if (orderList != null)
{
orderList.ForEach((order) =>
{
//查询预约明细
var orderDetailList = TrainingOrderDetailBLL.Instance.GetList(new TrainingOrderDetailEntity()
{
TrainingOrderId = order.TrainingOrderId
});
subricCount += orderDetailList.Count();
});
}
o.TotalSubricCount = subricCount;
//未预约时段总数
var freeadatelist = TrainingFreeDateBLL.Instance.GetList(new TrainingFreeDateEntity()
{
ObjectId = o.TrainingCarId,
StartTime = para.StartTime,
EndTime = para.EndTime
});
if (freeadatelist != null)
{
freeadatelist.ForEach((freedate) =>
{
//查询预约明细
var fgreeTimeList = TrainingFreeTimeBLL.Instance.GetList(new TrainingFreeTimeEntity()
{
TrainingFreeDateId = freedate.TrainingFreeDateId,
FreeStatus = (int)RCHL.Model.Enums.FreeTimeStatus.空闲
});
nosubricCount += fgreeTimeList.Count();
});
}
o.TotalNoSubricCount = nosubricCount;
}
});
}
}
catch (Exception ex)
{
}
var JsonData = new
{
rows = pageList,
total = pagination.total,
page = pagination.page,
records = pagination.records,
costtime = CommonHelper.TimerEnd(watch)
};
return(Content(JsonData.ToJson()));
}
/// <summary>
/// 导出EXCEL
/// </summary>
public void ExportExcel(string queryJson)
{
string cacheKey = Request["cacheid"] as string;
HttpRuntime.Cache[cacheKey + "-state"] = "processing";
HttpRuntime.Cache[cacheKey + "-row"] = "0";
TrainingCarEntity para = new TrainingCarEntity();
try
{
//这里要url解码
var queryParam = Server.UrlDecode(queryJson).ToJObject();
if (!queryParam["StartTime"].IsEmpty() && !queryParam["EndTime"].IsEmpty())
{
DateTime startTime = queryParam["StartTime"].ToDate();
DateTime endTime = queryParam["EndTime"].ToDate();
para.StartTime = startTime.ToString();
para.EndTime = endTime.ToString();
}
//类型
if (!queryParam["condition"].IsEmpty() && !queryParam["keyword"].IsEmpty())
{
var condition = queryParam["condition"].ToString().ToLower();
switch (condition)
{
case "name":
para.Name = queryParam["keyword"].ToString();
break;
case "schoolname":
para.SchoolName = queryParam["keyword"].ToString();
break;
case "carnumber":
para.CarNumber = queryParam["keyword"].ToString();
break;
}
}
var list = TrainingCarBLL.Instance.GetList(para);
if (list != null)
{
var StartTime = Util.Time.CalculateFirstDateOfWeek(DateTime.Now).ToString();
var EndTime = Util.Time.CalculateLastDateOfWeek(DateTime.Now).ToString();
list.ForEach((o) =>
{
int subricCount = 0;
int nosubricCount = 0;
string subricinfo = "";
string nosubricinfo = "";
if (o.TrainingCarId != null)
{
//预约时段总数 包括系统定制预约时间段和后台创建加班时间段
var orderList = TrainingOrderBLL.Instance.GetList(new TrainingOrderEntity()
{
TrainingCarId = o.TrainingCarId,
StartTime = para.StartTime,
EndTime = para.EndTime
}).Where(p => p.Status != (int)RCHL.Model.Enums.TrainingStatus.已取消).ToList();
if (orderList != null)
{
orderList.ForEach((order) =>
{
//查询预约明细
var orderDetailList = TrainingOrderDetailBLL.Instance.GetList(new TrainingOrderDetailEntity()
{
TrainingOrderId = order.TrainingOrderId
});
subricCount += orderDetailList.Count();
subricinfo += order.ServiceDate + " " + order.ServiceTime + " " + order.MemberName + "(" + order.MemberMobile + ")" + "/";
});
}
o.TotalSubricCount = subricCount;
o.SubricInfo = subricinfo.TrimEnd('/');
//未预约时段总数
var freeadatelist = TrainingFreeDateBLL.Instance.GetList(new TrainingFreeDateEntity()
{
ObjectId = o.TrainingCarId,
StartTime = para.StartTime,
EndTime = para.EndTime
});
if (freeadatelist != null)
{
freeadatelist.ForEach((freedate) =>
{
if (freedate.FreeDate != null)
{
nosubricinfo += Convert.ToDateTime(freedate.FreeDate).ToString("yyyy-MM-dd");
//查询预约明细
string freetimeinfo = "";
var freeTimeList = TrainingFreeTimeBLL.Instance.GetList(new TrainingFreeTimeEntity()
{
TrainingFreeDateId = freedate.TrainingFreeDateId,
FreeStatus = (int)RCHL.Model.Enums.FreeTimeStatus.空闲
});
freeTimeList.ForEach((freeTime) =>
{
freetimeinfo += freeTime.TimeSection + " ";
});
nosubricCount += freeTimeList.Count();
nosubricinfo += " " + freetimeinfo + "/";
}
});
}
o.TotalNoSubricCount = nosubricCount;
o.NoSubricInfo = nosubricinfo.TrimEnd('/');
}
});
//设置导出格式
ExcelConfig excelconfig = new ExcelConfig();
excelconfig.Title = "实训车辆预约报表";
excelconfig.TitleFont = "微软雅黑";
excelconfig.TitlePoint = 10;
excelconfig.FileName = "实训车辆预约报表.xls";
excelconfig.IsAllSizeColumn = true;
//每一列的设置,没有设置的列信息，系统将按datatable中的列名导出
List <ColumnEntity> listColumnEntity = new List <ColumnEntity>();
excelconfig.ColumnEntity = listColumnEntity;
ColumnEntity columnentity = new ColumnEntity();
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "CarNumber", ExcelColumn = "车牌号", Width = 20
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "Name", ExcelColumn = "实训车辆名称", Width = 20
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "SchoolName", ExcelColumn = "所属考场", Width = 15
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "TrainingTypeName", ExcelColumn = "实训类型", Width = 15
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "TotalSubricCount", ExcelColumn = "已预约时段总数", Width = 15
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "SubricInfo", ExcelColumn = "已预约时段详情", Width = 20
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "TotalNoSubricCount", ExcelColumn = "未预约时段总数", Width = 15
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "NoSubricInfo", ExcelColumn = "未预约时段详情", Width = 20
});
//需合并索引
//excelconfig.MergeRangeIndexArr = new int[] { 0, 1, 2, 3, 4, 5, 6, 7 };
//调用导出方法
ExcelHelper <TrainingCarEntity> .ExcelDownload(list, excelconfig);
HttpRuntime.Cache[cacheKey + "-state"] = "done";
}
}
catch (Exception)
{
HttpRuntime.Cache[cacheKey + "-state"] = "error";
}
}
