/// <summary>
/// 改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonRsp Update(CustomReceiptedModel model)
{
int returnvalue = Update <CustomReceiptedModel>(model);
return(new JsonRsp {
success = returnvalue > 0, code = returnvalue
});
}
/// <summary>
/// 删
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonRsp Remove(CustomReceiptedModel model)
{
int returnvalue = EntityQuery <CustomReceiptedModel> .Instance.Delete(model);
return(new JsonRsp {
success = returnvalue > 0, code = returnvalue
});
}
/// <summary>
/// 增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonRsp Add(CustomReceiptedModel model)
{
model.CustomReceiptedNo = "S" + model.CustomId + DateTime.Now.ToString("yyyyMMddHHmmss");
int returnvalue = Add <CustomReceiptedModel>(model);
return(new JsonRsp {
success = returnvalue > 0, code = returnvalue
});
}
/// <summary>
/// 获取管理员列表（全部）
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public List <CustomReceiptedModel> GetAllModelList()
{
JsonRsp <CustomReceiptedViewModel> rsp = new JsonRsp <CustomReceiptedViewModel>();
CustomReceiptedModel model = new CustomReceiptedModel();
OQL q = OQL.From(model)
.Select()
.OrderBy(model.ID, "desc")
.END;
return(q.ToList <CustomReceiptedModel>());
}
/// <summary>
/// save
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonRsp Save(CustomReceiptedModel model)
{
if (model.ID == 0)
{
return(Add(model));
}
else
{
return(Update(model));
}
}
/// <summary>
/// save
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonRsp DeleteById(long[] Ids)
{
//删除 测试数据-----------------------------------------------------
CustomReceiptedModel user = new CustomReceiptedModel();
OQL deleteQ = OQL.From(user)
.Delete()
.Where(cmp => cmp.Comparer(user.ID, "IN", Ids)) //为了安全，不带Where条件是不会全部删除数据的
.END;
int returnvalue = EntityQuery <CustomReceiptedModel> .Instance.ExecuteOql(deleteQ);
return(new JsonRsp {
success = returnvalue > 0, code = returnvalue
});
}
/// <summary>
/// 查 根据Id获取详情，如果没有则返回空对象
/// </summary>
/// <param name="CustomReceiptederID"></param>
/// <returns></returns>
public CustomReceiptedModel GetModelById(int accountId)
{
CustomReceiptedModel model = new CustomReceiptedModel()
{
ID = accountId
};
if (EntityQuery <CustomReceiptedModel> .Fill(model))
{
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 启用/禁用
/// </summary>
/// <param name="accountStatus"></param>
/// <returns></returns>
public JsonRsp SetStatus(long[] Ids, int status)
{
if (Ids == null)
{
return(new JsonRsp {
success = false, retmsg = "请选择要操作的数据"
});
}
CustomReceiptedModel user = new CustomReceiptedModel();
user.Status = status;
OQL q = OQL.From(user)
.Update(user.Status)
.Where(cmp => cmp.Comparer(user.ID, "IN", Ids)) //为了安全，不带Where条件是不会全部删除数据的
.END;
int returnvalue = EntityQuery <CustomReceiptedModel> .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 <CustomReceiptedViewModel> GetPageList(int pageIndex, int pageSize)
{
JsonRsp <CustomReceiptedViewModel> rsp = new JsonRsp <CustomReceiptedViewModel>();
CustomReceiptedModel m = new CustomReceiptedModel();
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 <CustomReceiptedModel> list = q.ToList <CustomReceiptedModel>();//使用OQL扩展
rsp.data = list.ConvertAll <CustomReceiptedViewModel>(o =>
{
return(new CustomReceiptedViewModel()
{
ID = o.ID,
CustomAccReceiptId = o.CustomAccReceiptId,
BankAccountId = o.BankAccountId,
CurrentAmount = o.CurrentAmount,
BankSerialNumber = o.BankSerialNumber,
DateOfEntry = o.DateOfEntry,
CreateId = o.CreateId,
CreateUser = o.CreateUser,
CreateIP = o.CreateIP,
CreateTime = o.CreateTime,
Status = o.Status,
});
}
);
rsp.success = true;
rsp.code = 0;
rsp.count = q.PageWithAllRecordCount;
return(rsp);
}
public ActionResult Edit(CustomReceiptedModel model)
{
return(Json(bll.Save(model), JsonRequestBehavior.AllowGet));
}
public ActionResult Add(CustomReceiptedModel model)
{
model.ID = 0;
return(Json(bll.Save(model), JsonRequestBehavior.AllowGet));
}