public ActionResult GetHomeJson()
{
HomeEntity data = new HomeEntity();
data.StudyCount = StudyOrderBLL.Instance.GetList(null).Where(o => o.Status != (int)QX360.Model.Enums.StudySubscribeStatus.取消).Count();
data.TrainingCount = TrainingOrderBLL.Instance.GetList(null).Where(o => o.Status != (int)QX360.Model.Enums.TrainingStatus.已取消).Count();
data.WithDrivingCount = WithDrivingOrderBLL.Instance.GetList(null).Where(o => o.Status != (int)QX360.Model.Enums.PaySatus.已取消).Count();
data.AuditCount = AuditOrderBLL.Instance.GetList(null).Where(o => o.Status != (int)QX360.Model.Enums.PaySatus.已取消).Count();
data.TakeAuditCount = TakeAuditOrderBLL.Instance.GetList(null).Where(o => o.Status != (int)QX360.Model.Enums.PaySatus.已取消).Count();
Pagination pager = new Pagination();
pager.page = 1;
pager.rows = 10;
pager.sidx = "CreateTime";
pager.sord = "desc";
ApplyOrderEntity para = new ApplyOrderEntity();
para.Status = (int)QX360.Model.Enums.ApplyStatus.待支付;
data.ApplyOrderList = ApplyOrderBLL.Instance.GetPageList(para, ref pager);
data.TrainingOrderList = TrainingOrderBLL.Instance.GetPageList(new TrainingOrderEntity()
{
Status = (int)QX360.Model.Enums.TrainingStatus.待审核
}, ref pager);
return(Content(data.ToJson()));
}
public JsonResult GetApplayInfo(string memberid)
{
var result = new ReturnMessage(false)
{
Message = "获取当前报名信息!"
};
try
{
var data = new ApplyOrderEntity();
var list = ApplyOrderBLL.Instance.GetList(new ApplyOrderEntity()
{
MemberId = memberid
});
if (list.Count > 0)
{
data = list.FirstOrDefault();
}
result.IsSuccess = true;
result.Message = "获取成功";
result.ResultData["Data"] = data;
}
catch (Exception ex)
{
ex.Data["Method"] = "ApplyController>>GetApplayInfo";
new ExceptionHelper().LogException(ex);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult GetTeacherApplyList(string keyword)
{
var result = new ReturnMessage(false)
{
Message = "获取失败!"
};
try
{
ApplyOrderEntity para = new ApplyOrderEntity();
para.TeacherId = LoginTeacher.UserId;
if (!string.IsNullOrWhiteSpace(keyword))
{
para.MemberName = keyword;
}
var list = ApplyOrderBLL.Instance.GetList(para);
if (list != null)
{
list.Foreach((o) =>
{
if (o.MemberId != null)
{
var member = MemberBLL.Instance.GetEntity(o.MemberId);
if (member != null)
{
if (member.HeadIcon != null)
{
var imageHost = System.Configuration.ConfigurationManager.AppSettings["ImageHost"] == "" ? string.Format("http://{0}{1}", Request.Url.Host, Request.Url.Port == 80 ? "" : ":" + Request.Url.Port) : System.Configuration.ConfigurationManager.AppSettings["ImageHost"];
member.HeadIcon = imageHost + member.HeadIcon;
}
}
}
});
}
result.IsSuccess = true;
result.Message = "获取成功!";
result.ResultData["List"] = list;
}
catch (Exception ex)
{
ex.Data["Method"] = "MaCenterController>>GetTeacherApplyList";
new ExceptionHelper().LogException(ex);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult GetPageListJson(Pagination pagination, string queryJson)
{
var watch = CommonHelper.TimerStart();
ApplyOrderEntity para = new ApplyOrderEntity();
if (!string.IsNullOrWhiteSpace(queryJson))
{
var queryParam = queryJson.ToJObject();
//类型
if (!queryParam["condition"].IsEmpty() && !queryParam["keyword"].IsEmpty())
{
var condition = queryParam["condition"].ToString().ToLower();
switch (condition)
{
case "applyorderno":
para.ApplyOrderNo = queryParam["keyword"].ToString();
break;
case "membername":
para.MemberName = queryParam["keyword"].ToString();
break;
case "membermobile":
para.MemberMobile = queryParam["keyword"].ToString();
break;
case "schoolname":
para.SchoolName = queryParam["keyword"].ToString();
break;
case "teachername":
para.TeacherName = queryParam["keyword"].ToString();
break;
}
}
if (!queryParam["status"].IsEmpty())
{
para.Status = int.Parse(queryParam["status"].ToString());
}
}
var pageList = ApplyOrderBLL.Instance.GetPageList(para, ref pagination);
if (pageList != null)
{
pageList.ForEach((o) =>
{
if (o.ProvinceId != null)
{
o.ProvinceName = AreaBLL.Instance.GetEntity(o.ProvinceId).AreaName;
}
if (o.CityId != null)
{
o.CityName = AreaBLL.Instance.GetEntity(o.CityId).AreaName;
}
if (o.CountyId != null)
{
o.CountyName = AreaBLL.Instance.GetEntity(o.CountyId).AreaName;
}
o.AddressInfo = o.ProvinceName + o.CityName + o.CountyName + o.AddressInfo;
if (o.Status != null)
{
o.StatusName = ((RCHL.Model.Enums.ApplyStatus)o.Status).ToString();
}
if (o.ServiceDate != null)
{
o.ServiceTime = Converter.ParseDateTime(o.ServiceDate).ToString("yyyy-MM-dd") + " " + o.ServiceTime;
}
});
}
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>
/// <param name="queryJson"></param>
public void ExportExcel(string queryJson)
{
string cacheKey = Request["cacheid"] as string;
HttpRuntime.Cache[cacheKey + "-state"] = "processing";
HttpRuntime.Cache[cacheKey + "-row"] = "0";
try
{
ApplyOrderEntity para = new ApplyOrderEntity();
if (!string.IsNullOrWhiteSpace(queryJson))
{
//这里要url解码
var queryParam = Server.UrlDecode(queryJson).ToJObject();
//类型
if (!queryParam["condition"].IsEmpty() && !queryParam["keyword"].IsEmpty())
{
var condition = queryParam["condition"].ToString().ToLower();
switch (condition)
{
case "applyorderno":
para.ApplyOrderNo = queryParam["keyword"].ToString();
break;
case "membername":
para.MemberName = queryParam["keyword"].ToString();
break;
case "membermobile":
para.MemberMobile = queryParam["keyword"].ToString();
break;
case "schoolname":
para.SchoolName = queryParam["keyword"].ToString();
break;
case "teachername":
para.TeacherName = queryParam["keyword"].ToString();
break;
}
}
if (!queryParam["status"].IsEmpty())
{
para.Status = int.Parse(queryParam["status"].ToString());
}
}
var list = ApplyOrderBLL.Instance.GetList(para);
if (list != null)
{
list.ForEach((o) =>
{
if (o.ProvinceId != null)
{
o.ProvinceName = AreaBLL.Instance.GetEntity(o.ProvinceId).AreaName;
}
if (o.CityId != null)
{
o.CityName = AreaBLL.Instance.GetEntity(o.CityId).AreaName;
}
if (o.CountyId != null)
{
o.CountyName = AreaBLL.Instance.GetEntity(o.CountyId).AreaName;
}
o.AddressInfo = o.ProvinceName + o.CityName + o.CountyName + o.AddressInfo;
if (o.ServiceDate != null)
{
o.ServiceTime = Converter.ParseDateTime(o.ServiceDate).ToString("yyyy-MM-dd") + " " + o.ServiceTime;
}
if (o.Status != null)
{
o.StatusName = ((RCHL.Model.Enums.StudySubscribeStatus)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 = "ApplyOrderNo", ExcelColumn = "订单号", Width = 20
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "MemberName", ExcelColumn = "用户名", Width = 15
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "MemberMobile", ExcelColumn = "联系方式", Width = 15
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "AddressInfo", ExcelColumn = "地址", Width = 15
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "ServiceTime", ExcelColumn = "上门时间", Width = 20
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "PayMoney", ExcelColumn = "已付金额", Width = 20
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "TotalMoney", ExcelColumn = "总费用", Width = 20
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "SchoolName", ExcelColumn = "报名驾校", Width = 20
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "TeacherName", ExcelColumn = "负责教练", Width = 20
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "SubjectName", ExcelColumn = "课程名称", Width = 20
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "StatusName", ExcelColumn = "状态", Width = 20
});
//需合并索引
//excelconfig.MergeRangeIndexArr = new int[] { 0, 1, 2, 3, 4, 5, 6, 7 };
//调用导出方法
ExcelHelper <ApplyOrderEntity> .ExcelDownload(list, excelconfig);
HttpRuntime.Cache[cacheKey + "-state"] = "done";
}
}
catch (Exception)
{
HttpRuntime.Cache[cacheKey + "-state"] = "error";
}
}
public ActionResult SaveForm(string keyValue, ApplyOrderEntity entity)
{
try
{
if (keyValue != "")
{
entity.ApplyOrderId = keyValue;
entity.Status = (int)RCHL.Model.Enums.ApplyStatus.已分配;
if (entity.ServiceTime != null)
{
//entity.ServiceDate = Converter.ParseDateTime(Converter.ParseDateTime(entity.ServiceTime).ToString("yyyy-MM-dd"));
//entity.ServiceTime = Converter.ParseDateTime(entity.ServiceTime).ToString("hh:mm");
}
ApplyOrderBLL.Instance.Update(entity);
}
else
{
var num = ApplyOrderBLL.Instance.CheckHasApplay(entity.MemberId);
if (num == 0)
{
return(Error("该学员已报名"));
}
entity.ApplyOrderNo = ApplyOrderBLL.Instance.GetOrderNo();
entity.ApplyOrderId = Util.Util.NewUpperGuid();
entity.ServiceDate = Converter.ParseDateTime(Converter.ParseDateTime(entity.ServiceTime).ToString("yyyy-MM-dd"));
entity.ServiceTime = Converter.ParseDateTime(entity.ServiceTime).ToString("hh:mm");
entity.CreateTime = DateTime.Now;
entity.Status = (int)RCHL.Model.Enums.ApplyStatus.已分配;
entity.CreateId = LoginUser.UserId;
ApplyOrderBLL.Instance.Add(entity);
//修改会员表中报名驾校
MemberBLL.Instance.Update(new MemberEntity()
{
MemberId = entity.MemberId,
SchoolId = entity.SchoolId,
SchoolName = entity.SchoolName
});
//插入财务信息
FinaceBLL.Instance.Add(new FinaceEntity()
{
FinaceId = Util.Util.NewUpperGuid(),
SourceType = (int)RCHL.Model.Enums.FinaceSourceType.驾校报名,
ObjectId = entity.SchoolId,
CreateTime = DateTime.Now,
CosMoney = entity.PayMoney,
Status = (int)RCHL.Model.Enums.PaySatus.已支付,
MemberId = entity.MemberId,
MemberName = entity.MemberName,
PayType = (int)RCHL.Model.Enums.PayType.线下支付,
Operate = (int)RCHL.Model.Enums.FinaceOperateType.增加,
Remark = string.Format("报名学车|{0}|{1}", entity.MemberName, entity.ApplyOrderNo)
});
}
return(Success("创建成功"));
}
catch (Exception ex)
{
ex.Data["Method"] = "ApplyOrderController>>SaveForm";
new ExceptionHelper().LogException(ex);
return(Error("保存失败"));
}
}
