public JsonResult GetAllJson() { try { List <TICKET_TYPE> lst = db.TICKET_TYPE.ToList(); var entity = new List <TicketTypeModel>(); foreach (var item in lst) { var ticket = new TicketTypeModel(); ticket.TYPEID = item.TYPEID; ticket.TYPENAME = item.TYPENAME; ticket.DESCRIPTIONS = item.DESCRIPTIONS; ticket.TYPE_CHECK = item.TYPE_CHECK; ticket.TYPE_CODE = item.TYPE_CODE; entity.Add(ticket); } return(this.Json(new { entity }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json("error", JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit(TicketTypeModel model) { CategoryService objService = new CategoryService(); objService.Update(model); return(RedirectToAction("Index")); }
// // GET: /Category/ public ActionResult Index() { CategoryService objService = new CategoryService(); TicketTypeModel objModel = new TicketTypeModel(); List <TicketTypeModel> lstCat = new List <TicketTypeModel>(); List <TicketTypeModel> lstACat = new List <TicketTypeModel>(); List <TicketTypeModel> lstSubCat = new List <TicketTypeModel>(); lstCat = objService.getCat(); objModel.ListCat = new List <TicketTypeModel>(); objModel.ListCat.AddRange(lstCat); string jsonData = JsonConvert.SerializeObject(lstCat); string result = jsonData.Replace("[", string.Empty).Replace("]", string.Empty); ViewBag.ListCat = result; lstSubCat = objService.getSubCat(); objModel.ListSubCat = new List <TicketTypeModel>(); objModel.ListSubCat.AddRange(lstSubCat); lstACat = objService.getActiveCat(); objModel.ListActiveCat = new List <TicketTypeModel>(); objModel.ListActiveCat.AddRange(lstACat); return(View(objModel)); }
/// <summary> /// 改 /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonRsp Update(TicketTypeModel model) { int returnvalue = EntityQuery <TicketTypeModel> .Instance.Update(model); return(new JsonRsp { success = returnvalue > 0, code = returnvalue }); }
/// <summary> /// 增 /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonRsp Add(TicketTypeModel model) { int returnvalue = Add <TicketTypeModel>(model); return(new JsonRsp { success = returnvalue > 0, code = returnvalue }); }
/// <summary> /// 改 /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonRsp Update(TicketTypeModel model) { int returnvalue = Update <TicketTypeModel>(model); return(new JsonRsp { success = returnvalue > 0, code = returnvalue }); }
public int UpdateSubCat(TicketTypeModel model) { Mapper.CreateMap <TicketTypeModel, TicketSubType>(); TicketSubType objUser = Dbcontext.TicketSubTypes.SingleOrDefault(m => m.TTSID == model.TTSID); objUser = Mapper.Map(model, objUser); return(Dbcontext.SaveChanges()); }
public int Update(TicketTypeModel model) { Mapper.CreateMap <TicketTypeModel, TicketTypeMaster>(); TicketTypeMaster objUser = Dbcontext.TicketTypeMasters.SingleOrDefault(m => m.TicketTypeID == model.TicketTypeID); objUser = Mapper.Map(model, objUser); return(Dbcontext.SaveChanges()); }
public ActionResult Edit(int id) { CategoryService objService = new CategoryService(); TicketTypeModel objModel = new TicketTypeModel(); objModel = objService.getByID(id); return(View(objModel)); }
/// <summary> /// 获取管理员列表(全部) /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public List <TicketTypeModel> GetAllModelList() { TicketTypeModel model = new TicketTypeModel(); OQL q = OQL.From(model) .Select() .OrderBy(model.ID, "asc") .END; return(q.ToList <TicketTypeModel>());//使用OQL扩展 }
/// <summary> /// save /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonRsp Save(TicketTypeModel model) { if (model.ID == 0) { return(Add(model)); } else { return(Update(model)); } }
/// <summary> /// 获取列表(分页) /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public JsonRsp <ChargeCardViewModel> GetPageList(int pageIndex, int pageSize, bool limit = true) { JsonRsp <ChargeCardViewModel> rsp = new JsonRsp <ChargeCardViewModel>(); ChargeCardsModel c = new ChargeCardsModel(); CustomModel custom = new CustomModel(); TicketTypeModel t = new TicketTypeModel(); OQL joinQ = OQL.From(c) .Join(custom).On(c.CustomId, custom.ID) .LeftJoin(t).On(c.TicketTypeID, t.ID) .Select() .OrderBy(c.Sort, "desc") .END; //分页 if (limit) { joinQ.Limit(pageSize, pageIndex, true); } PWMIS.DataProvider.Data.AdoHelper db = PWMIS.DataProvider.Adapter.MyDB.GetDBHelper(); EntityContainer ec = new EntityContainer(joinQ, db); rsp.data = (List <ChargeCardViewModel>)ec.MapToList <ChargeCardViewModel>(() => new ChargeCardViewModel() { ID = c.ID, CustomId = c.CustomId, CustomName = custom.CustomName, TicketTypeID = c.TicketTypeID, TicketTypeName = t.TicketTypeName, MoneyType = c.MoneyType, CurrentCount = c.CurrentCount, FaceAmount = c.FaceAmount, CurrentAmount = c.CurrentAmount, ExpireDate = c.ExpireDate, TicketBatchId = c.TicketBatchId, TicketStart = c.TicketStart, TicketEnd = c.TicketEnd, Consumptionlevel = c.Consumptionlevel, IsCommonCard = c.IsCommonCard, Sort = c.Sort, CreateId = c.CreateId, CreateUser = c.CreateUser, CreateIP = c.CreateIP, CreateTime = c.CreateTime, UpdateBy = c.UpdateUser, UpdateIP = c.UpdateIP, UpdateTime = c.UpdateTime, }); rsp.success = true; rsp.code = 0; rsp.count = joinQ.PageWithAllRecordCount; return(rsp); }
public ActionResult Create(int?id) { var model = new TicketTypeModel { IsActive = true }; if (id != null) { model = ticketTypeService.GetTicketTypeById((int)id).MapFromServerToClient(); } return(View(model)); }
public ActionResult Create(TicketTypeModel ticketTypeModel) { if (ticketTypeModel.TicketTypeId == 0) { ticketTypeModel.RecCreatedBy = User.Identity.GetUserId(); ticketTypeModel.RecCreatedOn = DateTime.UtcNow; TempData["Message"] = new MessageViewModel { IsSaved = true, Message = "Ticket Type has been saved successfully." }; } else { TempData["Message"] = new MessageViewModel { IsUpdated = true, Message = "Ticket Type has been updated." }; } ticketTypeModel.RecLastUpdatedBy = User.Identity.GetUserId(); ticketTypeModel.RecLastUpdateOn = DateTime.UtcNow; if (ticketTypeModel.IsLeave) { if (ticketTypeModel.LeaveTypes != null) { var leaveType = (LeaveType)ticketTypeModel.LeaveTypes; switch (leaveType) { case LeaveType.Casual: ticketTypeModel.LeaveType = 0; break; case LeaveType.Medical: ticketTypeModel.LeaveType = 1; break; case LeaveType.HalfDay: ticketTypeModel.LeaveType = 2; break; case LeaveType.Annual: ticketTypeModel.LeaveType = 3; break; } } } ticketTypeService.SaveTicketType(ticketTypeModel.MapFromClientToServer()); return(RedirectToAction("Index")); }
public int InsertSubCat(TicketTypeModel model) { try { Mapper.CreateMap <TicketTypeModel, TicketSubType>(); TicketSubType objUser = Mapper.Map <TicketSubType>(model); Dbcontext.TicketSubTypes.Add(objUser); return(Dbcontext.SaveChanges()); } catch (Exception ex) { throw ex; } }
public TicketTypeModel getByIDSubCat(int id) { try { Mapper.CreateMap <TicketSubType, TicketTypeModel>(); TicketSubType objCityMaster = Dbcontext.TicketSubTypes.Where(m => m.TTSID == id).SingleOrDefault(); TicketTypeModel objCityItem = Mapper.Map <TicketTypeModel>(objCityMaster); return(objCityItem); } catch (Exception ex) { throw ex; } }
/// <summary> /// 增 /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonRsp Add(TicketTypeModel model) { //salt string strSalt = Guid.NewGuid().ToString(); model.CreateUser = AdminName; model.CreateIP = Util.GetLocalIP(); model.CreateTime = DateTime.Now; int returnvalue = EntityQuery <TicketTypeModel> .Instance.Insert(model); return(new JsonRsp { success = returnvalue > 0, code = returnvalue }); }
/// <summary> /// 获取管理员列表(分页) /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public JsonRsp <TicketViewModel> GetPageList(int pageIndex, int pageSize) { JsonRsp <TicketViewModel> rsp = new JsonRsp <TicketViewModel>(); TicketInfo ticket = new TicketInfo(); TicketTypeModel ticketType = new TicketTypeModel(); //Select 方法不指定具体要选择的实体类属性,可以推迟到EntityContainer类的MapToList 方法上指定 OQL joinQ = OQL.From(ticket) .Join(ticketType).On(ticket.TicketTypeId, ticketType.ID) .Select() .OrderBy(ticket.Sort, "desc") .END; joinQ.Limit(pageSize, pageIndex, true); PWMIS.DataProvider.Data.AdoHelper db = PWMIS.DataProvider.Adapter.MyDB.GetDBHelper(); EntityContainer ec = new EntityContainer(joinQ, db); rsp.data = (List <TicketViewModel>)ec.MapToList <TicketViewModel>(() => new TicketViewModel() { ID = ticket.ID, TicketCode = ticket.TicketCode, TicketTypeId = ticket.TicketTypeId, Consumptionlevel = BaseEnum.ConsumptionlevelEnum.初始化, MoneyTyp = BaseEnum.MoneyTypeEnum.初始化, CustomID = 0, InitialAmount = 0, CostAmount = 0, Balance = 0, Status = BaseEnum.CredentialEnum.未交付, IsExpire = false, IsActivated = false, //MakeTime=null, //ExpireDate=null, TicketBatchNo = ticket.TicketBatchNo, GrantBy = 0, //GrantTime=null, CreateBy = AdminName, CreateIP = Util.GetLocalIP(), CreateTime = ticket.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"), Sort = ticket.Sort, }); rsp.success = true; rsp.code = 0; rsp.count = joinQ.PageWithAllRecordCount; return(rsp); }
/// <summary> /// save /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonRsp DeleteById(long[] Ids) { //删除 测试数据----------------------------------------------------- TicketTypeModel user = new TicketTypeModel(); OQL deleteQ = OQL.From(user) .Delete() .Where(cmp => cmp.Comparer(user.ID, "IN", Ids)) //为了安全,不带Where条件是不会全部删除数据的 .END; int returnvalue = EntityQuery <TicketTypeModel> .Instance.ExecuteOql(deleteQ); return(new JsonRsp { success = returnvalue > 0, code = returnvalue }); }
public ActionResult EditSubCat(int id) { CategoryService objService = new CategoryService(); TicketTypeModel objModel = new TicketTypeModel(); objModel = objService.getByIDSubCat(id); List <TicketTypeModel> lstACat = new List <TicketTypeModel>(); lstACat = objService.getActiveCat(); objModel.ListActiveCat = new List <TicketTypeModel>(); objModel.ListActiveCat.AddRange(lstACat); return(View(objModel)); }
public static TicketType MapFromClientToServer(this TicketTypeModel source) { return(new TicketType { TicketTitle = source.TicketTitle, IsActive = source.IsActive, RecCreatedBy = source.RecCreatedBy, RecCreatedOn = source.RecCreatedOn, RecLastUpdateOn = source.RecLastUpdateOn, RecLastUpdatedBy = source.RecLastUpdatedBy, TicketDescription = source.TicketDescription, TicketTypeId = source.TicketTypeId, IsLeave = source.IsLeave, LeaveType = source.LeaveType }); }
/// <summary> /// 查 根据Id获取详情,如果没有则返回空对象 /// </summary> /// <param name="TicketerID"></param> /// <returns></returns> public TicketTypeModel GetModelById(int accountId) { TicketTypeModel model = new TicketTypeModel() { ID = accountId }; if (EntityQuery <TicketTypeModel> .Fill(model)) { return(model); } else { return(null); } }
public ActionResult Index(TicketTypeModel model, string cmd) { CategoryService objService = new CategoryService(); if (cmd == "Save Category") { model.IsActive = true; objService.Insert(model); TempData["Msg"] = "Category Successfully Added."; } else { model.Status = true; objService.InsertSubCat(model); TempData["Msg"] = "Sub Category Successfully Added."; } return(RedirectToAction("Index")); }
/// <summary> /// 获取管理员列表(分页) /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public JsonRsp <TicketBatchViewModel> GetPageList(int pageIndex, int pageSize) { JsonRsp <TicketBatchViewModel> rsp = new JsonRsp <TicketBatchViewModel>(); TicketBatchModel ticket = new TicketBatchModel(); TicketTypeModel ticketType = new TicketTypeModel(); //Select 方法不指定具体要选择的实体类属性,可以推迟到EntityContainer类的MapToList 方法上指定 OQL joinQ = OQL.From(ticket) .Join(ticketType).On(ticket.TicketTypeId, ticketType.ID) .Select() .OrderBy(ticket.ID, "desc") .END; joinQ.Limit(pageSize, pageIndex, true); PWMIS.DataProvider.Data.AdoHelper db = PWMIS.DataProvider.Adapter.MyDB.GetDBHelper(); EntityContainer ec = new EntityContainer(joinQ, db); rsp.data = (List <TicketBatchViewModel>)ec.MapToList <TicketBatchViewModel>(() => new TicketBatchViewModel() { ID = ticket.ID, TicketTypeId = ticket.TicketTypeId, TicketTypeIdStr = ticketType.TicketTypeName, TicketBatchNo = ticket.TicketBatchNo, TicketPrefix = ticket.TicketPrefix, DataFrom = ticket.DataFrom, Count = ticket.Count, TicketBatchName = ticket.TicketBatchName, CreateId = ticket.CreateId, CreateUser = ticket.CreateUser, CreateIP = ticket.CreateIP, CreateTime = ticket.CreateTime, Status = ticket.Status, }); rsp.success = true; rsp.code = 0; rsp.count = joinQ.PageWithAllRecordCount; return(rsp); }
/// <summary> /// 启用/禁用 /// </summary> /// <param name="accountStatus"></param> /// <returns></returns> public JsonRsp SetStatus(long[] Ids, int status) { if (Ids == null) { return(new JsonRsp { success = false, retmsg = "请选择要操作的数据" }); } TicketTypeModel user = new TicketTypeModel(); user.Status = status; OQL q = OQL.From(user) .Update(user.Status) .Where(cmp => cmp.Comparer(user.ID, "IN", Ids)) //为了安全,不带Where条件是不会全部删除数据的 .END; int returnvalue = EntityQuery <TicketTypeModel> .Instance.ExecuteOql(q); return(new JsonRsp { success = returnvalue > 0, code = returnvalue }); }
/// <summary> /// 获取列表(分页) /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public JsonRsp <TicketTypeViewModel> GetPageList(int pageIndex, int pageSize) { JsonRsp <TicketTypeViewModel> rsp = new JsonRsp <TicketTypeViewModel>(); TicketTypeModel m = new TicketTypeModel(); OQL q = OQL.From(m) .Select() .OrderBy(m.ID, "asc") .END; //分页 q.Limit(pageSize, pageIndex, true); //q.PageWithAllRecordCount = allCount; //List<Employee> list= EntityQuery<Employee>.QueryList(q); List <TicketTypeModel> list = q.ToList <TicketTypeModel>();//使用OQL扩展 rsp.data = list.ConvertAll <TicketTypeViewModel>(o => { return(new TicketTypeViewModel() { ID = o.ID, TicketTypeName = o.TicketTypeName, CreateId = o.CreateId, CreateUser = o.CreateUser, CreateIP = o.CreateIP, CreateTime = o.CreateTime, Sort = o.Sort, Status = o.Status, UpdateBy = o.UpdateUser, UpdateIP = o.UpdateIP, UpdateTime = o.UpdateTime, }); } ); rsp.success = true; rsp.code = 0; rsp.count = q.PageWithAllRecordCount; return(rsp); }
public static TicketTypeModel MapFromServerToClient(this TicketType source) { var toReturn = new TicketTypeModel { TicketTitle = source.TicketTitle, IsActive = source.IsActive, RecCreatedBy = source.RecCreatedBy, RecCreatedOn = source.RecCreatedOn, RecLastUpdateOn = source.RecLastUpdateOn, RecLastUpdatedBy = source.RecLastUpdatedBy, TicketDescription = source.TicketDescription, TicketTypeId = source.TicketTypeId, IsLeave = source.IsLeave, LeaveType = source.LeaveType }; if (source.LeaveType != null) { var leaveTypes = (LeaveType)source.LeaveType; toReturn.LeaveTypes = leaveTypes; } return(toReturn); }
public JsonResult CapNhatLoaiVe(TicketTypeModel _model) { try { if (_model.TYPEID > 0) { TICKET_TYPE ticketType = db.TICKET_TYPE.Where(s => s.TYPEID == _model.TYPEID).FirstOrDefault(); ticketType.TYPENAME = _model.TYPENAME; ticketType.DESCRIPTIONS = _model.DESCRIPTIONS; ticketType.TYPE_CHECK = _model.TYPE_CHECK; ticketType.TYPE_CODE = _model.TYPE_CODE; db.SaveChanges(); return(Json("Success", JsonRequestBehavior.AllowGet)); } else { int checkTrungMaLoaiVe = db.TICKET_TYPE.Where(s => s.TYPE_CODE == _model.TYPE_CODE).Count(); if (checkTrungMaLoaiVe > 0) { return(Json("Trùng mã loại vé", JsonRequestBehavior.AllowGet)); } TICKET_TYPE ticket = new TICKET_TYPE(); ticket.TYPENAME = _model.TYPENAME; ticket.DESCRIPTIONS = _model.DESCRIPTIONS; ticket.TYPE_CHECK = _model.TYPE_CHECK; ticket.TYPE_CODE = _model.TYPE_CODE; db.TICKET_TYPE.Add(ticket); db.SaveChanges(); return(Json("Success", JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json("Error", JsonRequestBehavior.AllowGet)); } }
public JsonResult GetAll(JqueryDataTableParamModel model) { try { var loaiVe = db.TICKET_TYPE.OrderBy(c => c.TYPEID); if (!string.IsNullOrWhiteSpace(model.sSearch)) { string search = model.sSearch.Trim().ToUpper(); loaiVe = loaiVe.Where(c => (c.TYPENAME.ToUpper().Contains(search) || c.DESCRIPTIONS.ToUpper().Contains(search) || c.TYPE_CODE.ToUpper().Contains(search))).OrderBy(c => c.TYPEID); } switch (model.iSortCol_0) { case 1: { if (model.sSortDir_0 == "asc") { loaiVe = loaiVe.OrderBy(s => s.TYPENAME); } else { loaiVe = loaiVe.OrderByDescending(s => s.TYPENAME); } break; } case 2: { if (model.sSortDir_0 == "asc") { loaiVe.OrderBy(s => s.TYPE_CODE); } else { loaiVe.OrderByDescending(s => s.TYPE_CODE); } break; } default: break; } //Lấy bản ghi trả về view var lstArry = loaiVe.Skip(model.iDisplayStart).Take(model.iDisplayLength); int count = loaiVe.Count(); var entity = new List <TicketTypeModel>(); foreach (var item in lstArry) { var ticket = new TicketTypeModel(); ticket.TYPEID = item.TYPEID; ticket.TYPENAME = item.TYPENAME; ticket.DESCRIPTIONS = item.DESCRIPTIONS; ticket.TYPE_CHECK = item.TYPE_CHECK; ticket.TYPE_CODE = item.TYPE_CODE; entity.Add(ticket); } return(this.Json(new { sEcho = model.sEcho, iTotalRecords = count, iTotalDisplayRecords = count, data = entity }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json("error", JsonRequestBehavior.AllowGet)); } }
public ActionResult Save(TicketTypeModel model) { return(Json(bll.Save(model), JsonRequestBehavior.AllowGet)); }