public static void BindControl(this ListControl bindControl, DataTable dataTable, string textField, string valueField, HeaderType headerType = 0) { bindControl.Items.Clear(); if (headerType != HeaderType.None) { bindControl.Items.Add(new ListItem(headerType.GetEnumDescription(), "")); } foreach (DataRow row in dataTable.Rows) { bindControl.Items.Add(new ListItem(row[textField].ToString(), row[valueField].ToString())); } }
public static void BindEnumControl(this ListControl bindControl, Type enumType, ShowEnumType text, ShowEnumType value, HeaderType headerType = 0) { bindControl.Items.Clear(); if (headerType != HeaderType.None) { bindControl.Items.Add(new ListItem(headerType.GetEnumDescription(), "")); } foreach (EnumParameter parameter in from s in enumType.GetEnumMembers() orderby s.Value select s) { bindControl.Items.Add(new ListItem(GetShowText(parameter, text), GetShowText(parameter, value))); } }
public static void FieldNodeBind(this ListControl bindControl, XmlNode objXmlNode, string condition, HeaderType headerType = HeaderType.None) { string ConnectionKey = objXmlNode.ReadAttribute("ConnectionKey"); string TableName = objXmlNode.ReadAttribute("TableName"); string TextField = objXmlNode.ReadAttribute("TextField"); string ValueField = objXmlNode.ReadAttribute("ValueField"); string NodeCondition = objXmlNode.ReadAttribute("Condition"); string Sort = objXmlNode.ReadAttribute("Sort"); if (!string.IsNullOrWhiteSpace(condition)) { if (string.IsNullOrWhiteSpace(NodeCondition)) { NodeCondition = condition; } else { NodeCondition += " and " + condition; } } if (ConnectionKey.IsNoNullOrWhiteSpace() && TableName.IsNoNullOrWhiteSpace() && TextField.IsNoNullOrWhiteSpace() && ValueField.IsNoNullOrWhiteSpace()) { bindControl.BindControl(ConnectionKey, TableName, NodeCondition, Sort, TextField, ValueField, headerType); } else { string ListValue = objXmlNode.InnerText.Replace("\r\n", "").Trim(); if (ListValue.IsNoNullOrWhiteSpace()) { bindControl.Items.Clear(); if (headerType != HeaderType.None) { bindControl.Items.Add(new ListItem(headerType.GetEnumDescription(), "")); } foreach (string item in ListValue.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries)) { string itemValue = item.Replace("\r\n", "").Trim(); bindControl.Items.Add(new ListItem(itemValue.Split(':', ':')[0], itemValue.Split(':', ':')[1])); } } } }
public static void BindControl(this ListControl bindControl, string connectionKeyOrConnectionString, string tableName, string condition, string sort, string textField, string valueField, HeaderType headerType = 0) { string commandText = string.Format("SELECT DISTINCT {0},{1} FROM {2}", textField, valueField, tableName); if (!string.IsNullOrWhiteSpace(condition)) { commandText = commandText + " where " + condition; } if (!string.IsNullOrWhiteSpace(sort)) { commandText = commandText + " order by " + sort; } DataTable table = WTF.Framework.MySqlHelper.ExecuteDataTable(connectionKeyOrConnectionString, commandText, new MySqlParameter[0]); bindControl.Items.Clear(); if (headerType != HeaderType.None) { bindControl.Items.Add(new ListItem(headerType.GetEnumDescription(), "")); } foreach (DataRow row in table.Rows) { bindControl.Items.Add(new ListItem(row[textField].ToString(), row[valueField].ToString())); } }