/// <summary> /// 根据SQL语句获得对象列表 /// </summary> /// <param name="strSql"></param> /// <param name="dbParameter"></param> /// <param name="pagination"></param> /// <returns></returns> public ResultClass <List <TEntity> > FindList(string strSql, Dictionary <string, object> dbParameters, Pagination pagination) { ResultClass <List <TEntity> > _ret = new ResultClass <List <TEntity> >(); try { ResultClass <List <TEntity> > tmp = FindList(strSql, dbParameters); pagination.records = tmp.Result ? tmp.ResultData.Count : 0; if (pagination.records > 0) { string StrSql = DatabasePage.GetStrSql(strSql, dbParameters, pagination); _ret.ResultData = dbcontext.Database.SqlQuery <TEntity>(strSql, new List <DbParameter>()).ToList <TEntity>(); if (_ret.ResultData != null) { _ret.Result = true; } else { _ret.ErrorMessage = "没有数据!"; } } else { _ret.ErrorMessage = "没有数据!"; } } catch (Exception ex) { _ret.ErrorMessage = ex.Message; } return(_ret); }
/// <summary> /// /// </summary> /// <param name="objectType"></param> /// <param name="objectID"></param> /// <returns></returns> public ResultClass <List <ModuleButtonEntity> > GetModuleButtonByObjectID(Pagination pagination, string objectType, string objectID) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select t.* from Sys_ModuleButton t,Sys_RoleAuthorize r where t.F_Id=r.F_ItemId and r.F_ItemType=2 and r.F_ObjectType=@F_ObjectType and r.F_ObjectId=@F_ObjectId"); Dictionary <string, object> parameter = new Dictionary <string, object>(); parameter.Add("F_ObjectType", objectType); parameter.Add("F_ObjectId", objectID); string sql = DatabasePage.GetStrSql(strSql.ToString(), parameter, pagination); return(this.FindList(sql, new Dictionary <string, object>())); }
/// <summary> /// /// </summary> /// <param name="enCode"></param> /// <returns></returns> public List <ItemsDetailEntity> GetItemList(Pagination pagination, string enCode) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"SELECT d.* FROM Sys_ItemsDetail d INNER JOIN Sys_Items i ON i.F_Id = d.F_ItemId WHERE 1 = 1 AND i.F_EnCode = @enCode AND d.F_EnabledMark = 1 AND d.F_DeleteMark = 0 "); Dictionary <string, object> parameter = new Dictionary <string, object>(); parameter.Add("enCode", enCode); string sql = DatabasePage.GetStrSql(strSql.ToString(), parameter, pagination); ResultClass <List <ItemsDetailEntity> > _ret = this.FindList(sql, new Dictionary <string, object>()); if (_ret.Result) { return(_ret.ResultData); } return(new List <ItemsDetailEntity>()); }