/// <summary>
/// 启用/禁用
/// </summary>
/// <param name="accountStatus"></param>
/// <returns></returns>
public JsonRsp SetStatus(long[] Ids, int status)
{
if (Ids == null)
{
return(new JsonRsp {
success = false, retmsg = "请选择要操作的数据"
});
}
CustomTypeModel user = new CustomTypeModel();
CustomModel model = new CustomModel();
model.Status = status;
model.UpdateId = AdminId;
model.UpdateUser = AdminName;
model.UpdateIP = Util.GetLocalIP();
model.UpdateTime = DateTime.Now;
OQL q = OQL.From(model)
.Update(model.Status, model.UpdateId, model.UpdateUser, model.UpdateIP, model.UpdateIP)
.Where(cmp => cmp.Comparer(model.ID, "IN", Ids)) //为了安全，不带Where条件是不会全部删除数据的
.END;
int returnvalue = EntityQuery <CustomTypeModel> .Instance.ExecuteOql(q);
return(new JsonRsp {
success = returnvalue > 0, code = returnvalue
});
}
/// <summary>
/// 删
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonRsp Remove(CustomTypeModel model)
{
int returnvalue = EntityQuery <CustomTypeModel> .Instance.Delete(model);
return(new JsonRsp {
success = returnvalue > 0, code = returnvalue
});
}
/// <summary>
/// 增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonRsp Add(CustomTypeModel model)
{
int returnvalue = Add <CustomTypeModel>(model);
return(new JsonRsp {
success = returnvalue > 0, code = returnvalue
});
}
/// <summary>
/// 改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonRsp Update(CustomTypeModel model)
{
int returnvalue = Update <CustomTypeModel>(model);
return(new JsonRsp {
success = returnvalue > 0, code = returnvalue
});
}
/// <summary>
/// 获取管理员列表（全部）
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public List <CustomTypeModel> GetAllModelList()
{
CustomTypeModel model = new CustomTypeModel();
OQL q = OQL.From(model)
.Select()
.OrderBy(model.ID, "asc")
.END;
return(q.ToList <CustomTypeModel>());//使用OQL扩展
}
/// <summary>
/// save
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonRsp Save(CustomTypeModel model)
{
if (model.ID == 0)
{
return(Add(model));
}
else
{
return(Update(model));
}
}
/// <summary>
/// 增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonRsp Add(CustomTypeModel model)
{
model.CreateId = AdminId;
model.CreateUser = AdminName;
model.CreateIP = Util.GetLocalIP();
model.CreateTime = DateTime.Now;
int returnvalue = EntityQuery <CustomTypeModel> .Instance.Insert(model);
return(new JsonRsp {
success = returnvalue > 0, code = returnvalue
});
}
/// <summary>
/// save
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonRsp DeleteById(long[] Ids)
{
//删除 测试数据-----------------------------------------------------
CustomTypeModel user = new CustomTypeModel();
OQL deleteQ = OQL.From(user)
.Delete()
.Where(cmp => cmp.Comparer(user.ID, "IN", Ids)) //为了安全，不带Where条件是不会全部删除数据的
.END;
int returnvalue = EntityQuery <CustomTypeModel> .Instance.ExecuteOql(deleteQ);
return(new JsonRsp {
success = returnvalue > 0, code = returnvalue
});
}
/// <summary>
/// 查 根据Id获取详情，如果没有则返回空对象
/// </summary>
/// <param name="customerID"></param>
/// <returns></returns>
public CustomTypeModel GetModelById(int accountId)
{
CustomTypeModel model = new CustomTypeModel()
{
ID = accountId
};
if (EntityQuery <CustomTypeModel> .Fill(model))
{
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 获取管理员列表（分页）
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public JsonRsp <ContractViewModel> GetPageList(int pageIndex, int pageSize)
{
JsonRsp <ContractViewModel> rsp = new JsonRsp <ContractViewModel>();
ContractModel contract = new ContractModel();
CustomModel custom = new CustomModel();
CustomTypeModel customType = new CustomTypeModel();
//Select 方法不指定具体要选择的实体类属性，可以推迟到EntityContainer类的MapToList 方法上指定
OQL joinQ = OQL.From(contract)
.Join(custom).On(contract.CustomId, custom.ID)
.Join(customType).On(custom.CustomTypeId, customType.ID)
.Select()
.OrderBy(contract.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 <ContractViewModel>)ec.MapToList <ContractViewModel>(() => new ContractViewModel()
{
ID = contract.ID,
CustomId = contract.CustomId,
CustomName = custom.CustomName,
CustomTypeName = customType.CustomTypeName,
ContractNo = contract.ContractNo,
ContractAmount = contract.ContractAmount,
Deductions = contract.Deductions,
Balance = contract.Balance,
Remark = contract.Remark,
Sort = contract.Sort,
Status = contract.Status,
CreateId = contract.CreateId,
CreateUser = contract.CreateUser,
CreateIP = contract.CreateIP,
CreateTime = contract.CreateTime,
});
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 = "请选择要操作的数据"
});
}
CustomTypeModel model = new CustomTypeModel();
model.Status = status;
OQL q = OQL.From(model)
.Update(model.Status)
.Where(cmp => cmp.Comparer(model.ID, "IN", Ids)) //为了安全，不带Where条件是不会全部删除数据的
.END;
int returnvalue = EntityQuery <CustomTypeModel> .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 <CustomTypeViewModel> GetPageList(int pageIndex, int pageSize)
{
JsonRsp <CustomTypeViewModel> rsp = new JsonRsp <CustomTypeViewModel>();
CustomTypeModel m = new CustomTypeModel();
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 <CustomTypeModel> list = q.ToList <CustomTypeModel>();//使用OQL扩展
rsp.data = list.ConvertAll <CustomTypeViewModel>(o =>
{
return(new CustomTypeViewModel()
{
ID = o.ID,
CustomTypeName = o.CustomTypeName,
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 ActionResult Edit(CustomTypeModel model)
{
return(Json(bll.Save(model), JsonRequestBehavior.AllowGet));
}
public ActionResult Add(CustomTypeModel model)
{
model.ID = 0;
return(Json(bll.Save(model), JsonRequestBehavior.AllowGet));
}
