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