/// <summary>
/// 初始化构造函数
/// </summary>
/// <remarks></remarks>
public DBMapper()
{
_DB = MyDB.GetDBHelper();
_Mapper = new SqlMapper();
//_Mapper.CommandClassName = "EngineManager"
_Mapper.DataBase = _DB;
}
/// <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.ToString("N2"),
Deductions = contract.Deductions.ToString("N2"),
Balance = contract.Balance.ToString("N2"),
Remark = contract.Remark,
Sort = contract.Sort,
Status = contract.Status,
CreateBy = contract.CreateUser,
CreateIP = contract.CreateIP,
CreateTime = contract.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"),
});
rsp.success = true;
rsp.code = 0;
rsp.count = joinQ.PageWithAllRecordCount;
return(rsp);
}
public MySQLDbContext(AdoHelper db)
{
this.CurrentDataBase = db;
}
/// <summary>
/// 用连接字符串名字初始化本类
/// </summary>
public SQLiteDbContext(AdoHelper db)
{
this.CurrentDataBase = db;
}
