public static List <IndexDescriptionPair> GetModels()
{
List <IndexDescriptionPair> r = new List <IndexDescriptionPair>();
StringBuilder Sql_Module = new StringBuilder();
//过滤Scdel标记为已删除的数据 2013-10-15
Sql_Module.Append("Select ID,Description,Dcdel from sys_biz_Module Where (Scdel IS NULL or Scdel=0) order by CatlogCode");
//Sql_Module.Append("Select ID,Description from sys_biz_Module order by CatlogCode");
DataTable ModuleData = Agent.CallLocalService("Yqun.BO.LoginBO.dll", "GetDataTable", new object[] { Sql_Module.ToString() }) as DataTable;
if (ModuleData != null)
{
foreach (DataRow Row in ModuleData.Rows)
{
String Index = Row["ID"].ToString();
String Description = Row["Description"].ToString();
IndexDescriptionPair pair = new IndexDescriptionPair();
pair.Index = Index;
pair.Description = Description;
r.Add(pair);
}
}
return(r);
}
public List <IndexDescriptionPair> GetModels()
{
List <IndexDescriptionPair> Pairs = new List <IndexDescriptionPair>();
StringBuilder sql_select = new StringBuilder();
sql_select.Append("select * from sys_biz_reminder_stadiummodel order by orderIndex");
DataTable Data = GetDataTable(sql_select.ToString());
if (Data != null)
{
foreach (DataRow Row in Data.Rows)
{
String Index = Row["ID"].ToString();
String Text = Row["Description"].ToString();
IndexDescriptionPair Pair = new IndexDescriptionPair();
Pair.Index = Index;
Pair.Description = Text;
Pairs.Add(Pair);
}
}
return(Pairs);
}
public List <IndexDescriptionPair> InitSheetInfo(string[] Indexes)
{
List <IndexDescriptionPair> pairs = new List <IndexDescriptionPair>();
StringBuilder Sql_Sheets = new StringBuilder();
//2013-10-27 增加查询条件 Scdel=0 Scdel为新增字段，0表示未删除，1表示已删除。
Sql_Sheets.Append("Select ID,Scts, Description, DataTable,Scdel from sys_biz_Sheet where Scdel=0 and ID in ('");
Sql_Sheets.Append(string.Join("','", Indexes));
Sql_Sheets.Append("')");
DataTable Data = GetDataTable(Sql_Sheets.ToString());
foreach (DataRow Row in Data.Rows)
{
String Index = Row["ID"].ToString();
String Scts = Row["Scts"].ToString();
String Description = Row["Description"].ToString();
String DataTable = Row["DataTable"].ToString();
IndexDescriptionPair pair = new IndexDescriptionPair();
pair.Index = Index;
pair.Scts = Scts;
pair.Description = Description;
pair.DataTable = DataTable;
pairs.Add(pair);
}
return(pairs);
}
