public static DataTable ListDataBySql(string sql) { ADOSys_Config_ListPage instance = new ADOSys_Config_ListPage(); return instance.idb.ReturnDataTable(sql); }
/// <summary> /// 执行SQL语句 /// </summary> /// <param name="TableName"></param> /// <param name="filter"></param> /// <returns></returns> public DataTable ListViewData(string sql) { ADOSys_Config_ListPage instance = new ADOSys_Config_ListPage(); //string sql = "SELECT * FROM " + TableName + " WHERE (Stat is null or Stat=0) AND " + filter; return instance.idb.ReturnDataTable(sql); }
/// <summary> /// 获取Sys_Config_ListPage,Sys_Config_Fieled配置 /// </summary> /// <param name="moduleName"></param> /// <param name="M_Model"></param> /// <param name="D_List"></param> /// <returns></returns> public static Sys_Config_ListPage GetListConfig(string moduleName, out Sys_Config_ListPage M_Model, out List<Sys_Config_Fieled> D_List) { ADOSys_Config_ListPage ListInstance = new ADOSys_Config_ListPage(); ADOSys_Config_Fieled FieledInstance = new ADOSys_Config_Fieled(); M_Model = null; D_List = null; try { if (!string.IsNullOrEmpty(moduleName)) { //第一步:根据传入模块获取Grid配置 List<Sys_Config_ListPage> _ListPage = ListInstance.GetListByWhere(" AND M_ModuleCode='" + moduleName + "'"); if (_ListPage.Count > 0) { M_Model = _ListPage[0]; } //第二步:根据模块获取所有字段 D_List = FieledInstance.GetListByWhere(" AND D_ModuleCode='" + moduleName + "'"); } else { M_Model = null; D_List = null; } } catch (System.Exception ex) { M_Model = null; D_List = null; } return M_Model; }