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