public static byte ListBindMultiKey(ListControl listBox, string sql, string[] dataFieldKey, string dataFieldShow, string addZeroRow = "", string selectValue = "", short selectIndex = -888) { listBox.Items.Clear(); try { if (PCIBusiness.Tools.NullToString(sql).Length < 5) { return(22); } string dataValue; string keyValue; int k; using (PCIBusiness.MiscList dList = new PCIBusiness.MiscList()) if (dList.ExecQuery(sql, 0) == 0) { while (!dList.EOF) { if (dataFieldKey.Length == 1) { keyValue = dList.GetColumn(dataFieldKey[0]); } else { keyValue = ""; for (k = 0; k < dataFieldKey.Length; k++) { keyValue = keyValue + "/" + dList.GetColumn(dataFieldKey[k]); } if (keyValue.StartsWith("/")) { keyValue = keyValue.Substring(1); } } dataValue = dList.GetColumn(dataFieldShow); listBox.Items.Add(new ListItem(dataValue, keyValue)); dList.NextRow(); } } else { return(5); } if (addZeroRow.Length > 0) { listBox.Items.Insert(0, (new ListItem(addZeroRow, ""))); } if (listBox.Items.Count > 0) { if (selectValue.Length > 0) { ListSelect(listBox, selectValue, "0"); } else if (selectIndex >= listBox.Items.Count) { listBox.SelectedIndex = listBox.Items.Count - 1; } else if (selectIndex >= 0) { listBox.SelectedIndex = selectIndex; } } return(0); } catch { } return(99); }
public static void ListBind(ListControl listBox, string sql, object dataSource, string dataFieldKey, string dataFieldShow, string addZeroRow = "", string selectValue = "", short selectIndex = -888) { listBox.Items.Clear(); try { if (PCIBusiness.Tools.NullToString(sql).Length > 0) { string dataValue; string keyValue; using (PCIBusiness.MiscList dList = new PCIBusiness.MiscList()) if (dList.ExecQuery(sql, 0) == 0) { while (!dList.EOF) { dataValue = dList.GetColumn(dataFieldShow); keyValue = dList.GetColumn(dataFieldKey); listBox.Items.Add(new ListItem(dataValue, keyValue)); dList.NextRow(); } } } else if (dataSource != null) { listBox.DataSource = dataSource; listBox.DataValueField = dataFieldKey; listBox.DataTextField = dataFieldShow; listBox.DataBind(); } else { return; } if (addZeroRow.Length > 0) { listBox.Items.Insert(0, (new ListItem(addZeroRow, "0"))); } if (listBox.Items.Count > 0) { if (selectValue.Length > 0) { ListSelect(listBox, selectValue, "0"); } // else if ( selectIndex == 0 ) // listBox.SelectedIndex = 0; else if (selectIndex >= listBox.Items.Count) { listBox.SelectedIndex = listBox.Items.Count - 1; } else if (selectIndex >= 0) { listBox.SelectedIndex = selectIndex; } } } catch (Exception ex) { } }