/// <summary> /// 获取列表(全部) /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public JsonRsp <TicketBatchViewModel> GetAllList() { JsonRsp <TicketBatchViewModel> rsp = new JsonRsp <TicketBatchViewModel>(); TicketBatchModel model = new TicketBatchModel(); OQL q = OQL.From(model) .Select() .OrderBy(model.ID, "asc") .END; List <TicketBatchModel> list = q.ToList <TicketBatchModel>();//使用OQL扩展 rsp.data = list.ConvertAll <TicketBatchViewModel>(o => { return(new TicketBatchViewModel() { ID = o.ID, TicketTypeId = o.TicketTypeId, TicketBatchNo = o.TicketBatchNo, TicketPrefix = o.TicketPrefix, DataFrom = o.DataFrom, Count = o.Count, TicketBatchName = o.TicketBatchName, CreateId = o.CreateId, CreateUser = o.CreateUser, CreateIP = o.CreateIP, CreateTime = o.CreateTime, Status = o.Status, }); } ); rsp.success = true; rsp.code = 0; return(rsp); }
/// <summary> /// 改 /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonRsp Update(TicketBatchModel model) { int returnvalue = Update <TicketBatchModel>(model); return(new JsonRsp { success = returnvalue > 0, code = returnvalue }); }
/// <summary> /// 删 /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonRsp Remove(TicketBatchModel model) { int returnvalue = EntityQuery <TicketBatchModel> .Instance.Delete(model); return(new JsonRsp { success = returnvalue > 0, code = returnvalue }); }
BLLBase context = new BLLBase();//自动创建表 /// <summary> /// 增 /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonRsp Add(TicketBatchModel model) { //新增加的都是新数据 model.IsOld = false; model.DataFrom = (int)DataFromEnum.手动创建; model.TicketBatchNo = "P" + DateTime.Now.ToString("yyyyMMddHHmmss"); int returnvalue = Add <TicketBatchModel>(model); List <TicketInfo> ticketList = new List <TicketInfo>(); long tickIndex = 0; for (int i = 0; i < model.Count; i++) { //salt string salt = Guid.NewGuid().ToString(); string pwd = new RandomHelper().GetRandomInt(100000, 999999).ToString(); string MD5PWD = EncryptHelper.MD5Encoding(pwd, salt); string signStr = "0" + salt; string balanceKey = EncryptHelper.MD5Encoding(signStr, salt); tickIndex += 1; TicketInfo ticket = new TicketInfo { TicketCode = model.TicketPrefix + model.TicketTypeId.ToString() + tickIndex.ToString("00000000"), TicketPwd = pwd, TicketMD5Pwd = MD5PWD, Salt = salt, TicketTypeId = model.TicketTypeId, Consumptionlevel = (int)ConsumptionlevelEnum.初始化, MoneyTyp = (int)MoneyTypeEnum.初始化, CustomId = 0, InitialAmount = 0, TotalAmount = 0, Deductions = 0, Balance = 0, BalanceKey = balanceKey, Status = (int)CredentialEnum.未交付, IsExpire = false, IsActivated = false, //MakeTime=null, //ExpireDate=null, TicketBatchNo = model.TicketBatchNo, DataFrom = (int)DataFromEnum.手动创建, IsOld = false, //GrantId = 0, //GrantTime=null, Sort = i, }; returnvalue = Add <TicketInfo>(ticket); } //returnvalue=context.AddList<TicketInfo>(ticketList); return(new JsonRsp { success = returnvalue > 0, code = returnvalue }); }
/// <summary> /// save /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonRsp Save(TicketBatchModel model) { if (model.ID == 0) { return(Add(model)); } else { return(Update(model)); } }
BLLBase context = new BLLBase();//自动创建表 /// <summary> /// 增 /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonRsp Add(TicketBatchModel model) { model.TicketBatchNo = "P" + DateTime.Now.ToString("yyyyMMddHHmmss"); model.CreateUser = AdminName; model.CreateIP = Util.GetLocalIP(); model.CreateTime = DateTime.Now; int returnvalue = EntityQuery <TicketBatchModel> .Instance.Insert(model); List <TicketInfo> ticketList = new List <TicketInfo>(); long tickIndex = 0; for (int i = 0; i < model.Amount; i++) { //salt string salt = Guid.NewGuid().ToString(); string pwd = new RandomHelper().GetRandomInt(100000, 999999).ToString(); string MD5PWD = EncryptHelper.MD5Encoding(pwd, salt); tickIndex += 1; ticketList.Add(new TicketInfo { TicketCode = model.TicketPrefix + model.TicketTypeId.ToString() + tickIndex.ToString("00000000"), TicketPwd = pwd, TicketMD5Pwd = MD5PWD, Salt = salt, TicketTypeId = model.TicketTypeId, Consumptionlevel = BaseEnum.ConsumptionlevelEnum.初始化, MoneyTyp = BaseEnum.MoneyTypeEnum.初始化, CustomID = 0, InitialAmount = 0, Deductions = 0, Balance = 0, Status = (int)BaseEnum.CredentialEnum.未交付, IsExpire = false, IsActivated = false, //MakeTime=null, //ExpireDate=null, TicketBatchNo = model.TicketBatchNo, GrantBy = 0, //GrantTime=null, Sort = i, CreateUser = AdminName, CreateIP = Util.GetLocalIP(), CreateTime = DateTime.Now, }); } //returnvalue=context.AddList<TicketInfo>(ticketList); return(new JsonRsp { success = returnvalue > 0, code = returnvalue }); }
/// <summary> /// save /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonRsp DeleteById(long[] Ids) { //删除 测试数据----------------------------------------------------- TicketBatchModel user = new TicketBatchModel(); OQL deleteQ = OQL.From(user) .Delete() .Where(cmp => cmp.Comparer(user.ID, "IN", Ids)) //为了安全,不带Where条件是不会全部删除数据的 .END; int returnvalue = EntityQuery <TicketBatchModel> .Instance.ExecuteOql(deleteQ); return(new JsonRsp { success = returnvalue > 0, code = returnvalue }); }
/// <summary> /// 查 根据Id获取详情,如果没有则返回空对象 /// </summary> /// <param name="TicketerID"></param> /// <returns></returns> public TicketBatchModel GetModelById(int accountId) { TicketBatchModel model = new TicketBatchModel() { ID = accountId }; if (EntityQuery <TicketBatchModel> .Fill(model)) { return(model); } else { return(null); } }
/// <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 = "请选择要操作的数据" }); } TicketBatchModel user = new TicketBatchModel(); user.Status = status; OQL q = OQL.From(user) .Update(user.Status) .Where(cmp => cmp.Comparer(user.ID, "IN", Ids)) .END; int returnvalue = EntityQuery <TicketBatchModel> .Instance.ExecuteOql(q); return(new JsonRsp { success = returnvalue > 0, code = returnvalue }); }
public ActionResult Save(TicketBatchModel model) { return(Json(bll.Save(model), JsonRequestBehavior.AllowGet)); }