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