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