//
// GET: /EnrollManageList/
public ActionResult EnrollManageList(EnrollListSearchModel search)
{
EnrollManageListModel model = new EnrollManageListModel(); //页面模型
model.search = search; //页面的搜索模型
model.search.PageSize = 15; //每页显示
model.search.CurrentPage = Convert.ToInt32(Request["pageindex"]) <= 0 ? 1 : Convert.ToInt32(Request["pageindex"]); //当前页
search.islesson = "0";
//分校下拉项
List <CommonEntity> ComCodeIL = CommonData.Get_SYS_Company_COMP_Code(UserSession.comcode);//分校
model.ComCodeIL = CommonData.Instance.GetBropDownListData_Choice(ComCodeIL);
model.search.ComCodeIL = CommonData.Instance.GetBropDownListData_Choice(ComCodeIL);
//学员状态下拉项
List <CommonEntity> StudentSourceIL = CommonData.GetDictionary_StudentSource_List(19);//1是字典类型值,仅供测试参考
model.search.StudentSourceIL = CommonData.Instance.GetBropDownListData(StudentSourceIL);
if (UserSession.comcode != null && UserSession.comcode != "1")
{
search.ComCode = UserSession.comcode;//默认查询当前分校的人员
}
model.EnrollManagelist = EnrollData.GeEnrollList(search); //填充页面模型数据
return(View(model)); //返回页面模型
}
/// <summary>
/// 根据班级信息获取学员的报名信息
/// </summary>
/// <returns></returns>
public ActionResult GetClassesByClassID()
{
AjaxStatusModel ajax = new AjaxStatusModel();
ajax.status = EnumAjaxStatus.Error; //默认失败
ajax.msg = "获取失败！"; //前台获取，用于显示提示信息
EnrollListSearchModel search = new EnrollListSearchModel();
string Enroll_Name = Request["Enroll_Name"];
string Enroll_StudentID = Request["Enroll_StudentID"];
string ClassID = Request["ClassID"];
search.ClassID = ClassID;
if (!string.IsNullOrEmpty(Enroll_Name))
{
search.ApName = Enroll_Name;
}
if (!string.IsNullOrEmpty(Enroll_StudentID))
{
search.Enroll_StudentID = Enroll_StudentID;
}
search.CurrentPage = 1; //当前页
search.PageSize = 999; //不想分页就设置成一个较大的值,比如99999
List <vw_Enroll> vw_Enroll = EnrollData.GeEnrollList(search);
ajax.data = vw_Enroll.Where(t => t.StateID != 5 && t.StateID != 6);//剔除了报名状态是，5，6的数据，5，报名冻结，6报名完成
return(Json(new { total = 1, rows = ajax.data, state = true, msg = "加载成功" }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 票据打印
/// </summary>
/// <returns></returns>
public ActionResult InvoicePrint()
{
AppointmentPrintModel m = new AppointmentPrintModel();
string apid = Request["apid"].ToString();
m.EnrollList = EnrollData.GetEnrollPrintByApid(apid);
m.bill = EnrollData.GetOneBillConfig();
return(View(m));
}
/// <summary>
/// 根据报名ID返回课时消耗记录
/// </summary>
/// <param name="enid"></param>
/// <returns></returns>
public JsonResult GetHoursLogByENID(string enid)
{
AjaxStatusModel ajax = new AjaxStatusModel(); //功能操作类的返回类型都是AjaxStatusModel，数据放到AjaxStatusModel.data中，前台获取json后加载
ajax.status = EnumAjaxStatus.Error; //默认失败
List <TransferRecord> loglist = EnrollData.GetHoursLogByENID(enid);
ajax.data = loglist;
return(Json(new { total = loglist.Count(), rows = loglist, state = true, msg = "加载成功" }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 转让协议的审核
/// </summary>
/// <returns></returns>
public ActionResult TransferAudit()
{
AjaxStatusModel ajax = new AjaxStatusModel(); //功能操作类的返回类型都是AjaxStatusModel，数据放到AjaxStatusModel.data中，前台获取json后加载
ajax.status = EnumAjaxStatus.Error; //默认失败
ajax.msg = "审核失败！"; //前台获取，用于显示提示信息
string tid = Request["tfid"]; //获取协议id
if (string.IsNullOrEmpty(tid))
{
return(Json(ajax));
}
Transfer rb = TransferData.GetTransferByID(int.Parse(tid)); //获取协议
DataProvider.Entities.Enroll jen = EnrollData.GetEnrollByID(rb.JENID); //甲方报名记录
DataProvider.Entities.Enroll yen = EnrollData.getEnrollByStudentClass(rb.YStudentID, rb.YClassid); //乙方报名记录
if (yen != null) //如果乙方有报名记录，则在原来的报名记录上增加课时，并且减少甲方课时，同时插入流水记录
{
jen.UsedHour = jen.UsedHour + rb.TranHour; //甲方剩余课时要扣除转让的课时，新增转让记录
EnrollData.TransferAudit1(jen, yen, UserSession.userid, rb);
}
else//如果乙方没有报名记录，则新增乙方报名记录，扣除甲方的报名课时
{
DataProvider.Entities.Enroll yy = new DataProvider.Entities.Enroll();
yy.ID = CommonData.DPGetTableMaxId("EN", "ID", "Enroll", 8);
yy.APID = "";
yy.StudentID = rb.YStudentID;
yy.ClassID = rb.YClassid;
yy.ClassHour = rb.TranHour;
yy.UsedHour = 0;
yy.Price = 0;
yy.Paid = 0;
yy.CreatorId = UserSession.userid;
yy.CreateTime = DateTime.Now;
yy.StateID = 0;
yy.Transferid = int.Parse(tid);
jen.UsedHour = jen.UsedHour + rb.TranHour;//甲方剩余课时要扣除转让的课时，新增转让记录
EnrollData.TransferAudit2(jen, yy, UserSession.userid, rb);
}
ajax.msg = "审核成功！";
ajax.status = EnumAjaxStatus.Success;
return(Json(ajax));
}
//
// GET: /EnrollProtocol/
public ActionResult EnrollProtocol(string id)
{
EnrollProtocolViewModel model = new EnrollProtocolViewModel();
string apid = id;
SignImage si = CommonData.GetStringKeySign(apid, 0);
SignImage si_jbr = CommonData.GetStringKeySign(apid, 1);
model.apid = apid;
model.si = si;
model.si_jbr = si_jbr;
model.EnrollList = EnrollData.GetEnrollPrintByApid(apid);
model.ap = AppointmentData.GetOnevw_AppointmentByID(apid);
model.bill = EnrollData.GetOneBillConfig();
return(View(model));
}
/// <summary>
/// 完结报名，会清空当前课时，记录课时变化日志
/// </summary>
/// <returns></returns>
public ActionResult FinishEnroll()
{
AjaxStatusModel ajax = new AjaxStatusModel();
ajax.status = EnumAjaxStatus.Error; //默认失败
ajax.msg = "完结失败！";
string enid = Request["enid"]; //报名记录的ID
bool ret = EnrollData.FinishEnroll(enid, UserSession.userid);
if (ret)
{
ajax.msg = "完结成功！剩余课时已被清零！";
ajax.status = EnumAjaxStatus.Success;
}
return(Json(ajax));
}
/// <summary>
/// 调整报名课时
/// </summary>
/// <param name="json"></param>
/// <returns></returns>
public JsonResult Ajustment()
{
AjaxStatusModel ajax = new AjaxStatusModel(); //功能操作类的返回类型都是AjaxStatusModel，数据放到AjaxStatusModel.data中，前台获取json后加载
ajax.status = EnumAjaxStatus.Error; //默认失败
ajax.msg = "调整报名课时失败！"; //前台获取，用于显示提示信息
string ENID = Request["ENID"]; //报名ID
int ClassHour = int.Parse(Request["ClassHour"].ToString()); //调整课时数
decimal Price = decimal.Parse(Request["Price"].ToString()); //调整金额
if (EnrollData.AjustmentEnroll(ENID, ClassHour, Price, UserSession.userid)) //注意时间类型，而且需要在前台把所有的值
{
ajax.msg = "调整报名课时成功！";
ajax.status = EnumAjaxStatus.Success;
}
return(Json(ajax));
}
/// <summary>
/// 冻结
/// </summary>
/// <param name="json"></param>
/// <returns></returns>
public JsonResult Frozen()
{
AjaxStatusModel ajax = new AjaxStatusModel(); //功能操作类的返回类型都是AjaxStatusModel，数据放到AjaxStatusModel.data中，前台获取json后加载
ajax.status = EnumAjaxStatus.Error; //默认失败
ajax.msg = "冻结失败！"; //前台获取，用于显示提示信息
var data = Request["data"]; //获取前台传递的数据，主要序列化
DataProvider.Entities.Enroll enl = (DataProvider.Entities.Enroll)(JsonConvert.DeserializeObject(data.ToString(), typeof(DataProvider.Entities.Enroll)));
enl.UpdateTime = DateTime.Now; //添加修改时间
enl.UpdatorId = UserSession.userid; //添加修改人
if (EnrollData.UpdateEnroll_ed(enl) > 0) //注意时间类型，而且需要在前台把所有的值
{
ajax.msg = "冻结成功！";
ajax.status = EnumAjaxStatus.Success;
}
return(Json(ajax));
}
/// <summary>
/// 支付中心
/// </summary>
/// <returns></returns>
public ActionResult PaymentList()
{
WX_PaymentListModel model = new WX_PaymentListModel();
EnrollListSearchModel search = new EnrollListSearchModel();
model.search = search;
model.search.PageSize = 100; //每页显示100条数据
model.search.CurrentPage = model.search.CurrentPage <= 0 ? 1 : model.search.CurrentPage; //获取当前页
Students s = StudentData.GetStudentByAccountID(UserSessionWX.userid); //获取学员
if (s != null)
{
search.Enroll_StudentID = s.ID;//获取学号
}
search.islesson = "0";
PagedList <vw_Enroll> vw_Enroll = EnrollData.GeEnrollList(search);//查询报名记录
model.StudentEnrollList = vw_Enroll;
return(View(model));
}
/// <summary>
/// 调整剩余课时
/// </summary>
/// <returns></returns>
public ActionResult AdjustLeftHour()
{
AjaxStatusModel ajax = new AjaxStatusModel();
ajax.status = EnumAjaxStatus.Error; //默认失败
ajax.msg = "调整课时失败，请联系管理员！"; //前台获取，用于显示提示信息
string ENID = Request["ENID"]; //报名ID
int AdjustNum = int.Parse(Request["AdjustNum"].ToString()); //调整数
if (string.IsNullOrEmpty(ENID))
{
return(Json(ajax));
}
if (EnrollData.AdjustLeftHour(ENID, AdjustNum, UserSession.userid))
{
ajax.msg = "调整课时成功！";
ajax.status = EnumAjaxStatus.Success;
}
return(Json(ajax));
}
/// <summary>
/// 导出到Excel的操作
/// </summary>
/// <param name="json"></param>
public void ExportToExcel(string Name, string BindPhone, string timeStart, string timeEnd, string ComCode, string Large, string Small)
{
DataTable datasource = EnrollData.DPExportToExcel(Name, BindPhone, timeStart, timeEnd, ComCode, Large, Small, "0");
ERP.Models.MyNPOIModel.ExportByWeb(datasource, "报名管理", "报名管理" + ".xls");
}
