/// <summary> /// 生成列表下拉框数据 /// </summary> /// <param name="tablename"></param> /// <param name="fieldname"></param> /// <param name="condition"></param> /// <param name="allowedit"></param> /// <returns></returns> public static string ColComboList(string tablename, string fieldname, string condition, params bool[] allowedit) { string strlist = ""; //设置下拉列表是否可以手动修改值 if (allowedit != null && allowedit[0] == true) { strlist += "| "; } else { strlist += " "; } TableManager.SetOrder(fieldname); DataTable table = TableManager.Select(tablename, "distinct " + fieldname, condition); foreach (DataRow row in table.Rows) { if (!string.IsNullOrEmpty(Utils.NvStr(row[0]))) { strlist += "|" + Utils.NvStr(row[0]); } } return(strlist); }
public List <DictionaryEntry> GetDataMapDistinct(string valuefield, string textfield, string condition) { if (valuefield.CompareTo(textfield) == 0) { TableManager.SetOrder(TableManager.GetParameterName(valuefield)); DataTable table = TableManager.Select(this.GetTableName(), "distinct " + valuefield, condition); List <DictionaryEntry> maplist = new List <DictionaryEntry>(); foreach (DataRow row in table.Rows) { if (Utils.NvStr(row[0]) != "") { maplist.Add(new DictionaryEntry(Utils.NvStr(row[0]), Utils.NvStr(row[0]))); } } return(maplist); } else { TableManager.SetOrder(TableManager.GetParameterName(valuefield) + "," + TableManager.GetParameterName(textfield)); DataTable table = TableManager.Select(this.GetTableName(), "distinct " + valuefield + "," + textfield, condition); List <DictionaryEntry> maplist = new List <DictionaryEntry>(); foreach (DataRow row in table.Rows) { maplist.Add(new DictionaryEntry(Utils.NvStr(row[0]), Utils.NvStr(row[1]))); } return(maplist); } }
public virtual T[] Select(params MyField[] paramfields) { string fields = ""; Type t = this.GetType(); PropertyInfo[] props = t.GetProperties(); foreach (PropertyInfo p in props) { string fName = p.Name.ToUpper(); fields += fName + ","; } fields = fields.Substring(0, fields.Length - 1); DataTable table = TableManager.Select(this.GetTableName(), fields, paramfields); List <T> list = new List <T>(); foreach (DataRow row in table.Rows) { T item = new T(); BeanHelper.DataRowToModel(row, item); list.Add(item); } return(list.ToArray()); }
/// <summary> /// 生成列表下拉框数据(含全部选项) /// </summary> /// <param name="tablename"></param> /// <param name="fieldname"></param> /// <param name="condition"></param> /// <param name="alltext">默认:全部,可自定义</param> /// <param name="allowedit"></param> /// <returns></returns> public string ColComboList(string fieldname, string condition, string alltext, params bool[] allowedit) { string strlist = ""; //设置下拉列表是否可以手动修改值 if (allowedit.Length > 0 && allowedit[0] == true) { strlist += "| "; } else { strlist += " "; } //全部 strlist += "|" + (string.IsNullOrEmpty(alltext) ? "全部" : alltext); TableManager.SetOrder(fieldname); DataTable table = TableManager.Select(this.GetTableName(), "distinct " + fieldname, condition); foreach (DataRow row in table.Rows) { if (!string.IsNullOrEmpty(Utils.NvStr(row[0]))) { strlist += "|" + Utils.NvStr(row[0]); } } return(strlist); }