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));
}
