/// <summary>
/// 绑定下拉列表 sql 语句
/// </summary>
/// <param name="pSql">sql 语句</param>
/// <param name="pHtmlSelect">HtmlSelect</param>
/// <param name="pEditValue">修改时值</param>
/// <param name="pFieldValue">值字段 如:ProID</param>
/// <param name="pFieldText">内容字段 如:ProName</param>
/// <param name="pFirstValue">第一项的值</param>
/// <param name="pFirstText">第一项的内容</param>
public static void BGHtmlSelect(string pSql, HtmlSelect pDropList, string pEditValue, string pFieldValue, string pFieldText, string pFirstValue, string pFirstText)
{
if (pFirstText.Length > 0)
{
pDropList.Items.Add(new ListItem(pFirstText, pFirstValue));
}
using (DataTable dt = DbHelp.GetDataTable(pSql))
{
foreach (DataRow dr in dt.Rows)
{
System.Web.UI.WebControls.ListItem drlist = new ListItem();
drlist.Text = dr[pFieldText].ToString();
drlist.Value = dr[pFieldValue].ToString();
if (pEditValue == drlist.Value)
{
drlist.Selected = true;
}
pDropList.Items.Add(drlist);
}
dt.Clear();
}
}
public DataTable GetDataTable()
{
DbHelpParam dhp = new DbHelpParam(this._sql, fd.CommType, fd.DataParm, fd.ConnProvider);
return(DbHelp.GetDataTable(dhp));
}