/// <summary>
/// 绑定树型视图
/// </summary>
/// <param name="dtTree">数据源</param>
/// <param name="ddl">下拉框</param>
/// <param name="dmField">值字段名称：Dm或Id</param>
/// <param name="first">首行显示文本</param>
public static void BindTreeView(DataTable dtTree, ExtAspNet.DropDownList ddl, string dmField, string first)
{
if (!String.IsNullOrEmpty(first))
{
dtTree.Rows[0]["Mc"] = first;
}
List <Globals.ExtTreeItem> myList = new List <Globals.ExtTreeItem>();
foreach (DataRow dr in dtTree.Rows)
{
string txtField = "Mc";
string id = dr[dmField].ToString();
string mc = dr[txtField].ToString();
int lv = int.Parse(dr["depth"].ToString());
bool canSel = bool.Parse(dr["select"].ToString());
myList.Add(new Globals.ExtTreeItem(id, mc, lv, canSel));
}
ddl.EnableSimulateTree = true;
ddl.DataTextField = "Name";
ddl.DataValueField = "Id";
ddl.DataSimulateTreeLevelField = "Level";
ddl.DataEnableSelectField = "CanSelect";
ddl.DataSource = myList;
ddl.DataBind();
}
/// <summary>
/// 根据特定条件,下拉框数据加载
/// </summary>
/// <param name="DDL_Items">下拉框</param>
/// <param name="tablename">表名</param>
/// <param name="mtext">名称字段</param>
/// <param name="mvalue">编号字段</param>
/// <param name="RowName">条件字段名</param>
/// <param name="oValue">条件字段值</param>
public static void LoadSelectionBySql(ref ExtAspNet.DropDownList DDL_Items, string sql, string mtext, string mvalue)
{
DDL_Items.DataSource = CSql.CreateDataSet(sql);
DDL_Items.Items.Clear();
DDL_Items.DataTextField = mtext;
DDL_Items.DataValueField = mvalue;
DDL_Items.DataBind();
}
/// <summary>
/// 根据特定条件,下拉框数据加载
/// </summary>
/// <param name="DDL_Items">下拉框</param>
/// <param name="tablename">表名</param>
/// <param name="mtext">名称字段</param>
/// <param name="mvalue">编号字段</param>
/// <param name="RowName">条件字段名</param>
/// <param name="oValue">条件字段值</param>
public static void LoadSelection(ref ExtAspNet.DropDownList DDL_Items, string tablename, string mtext, string mvalue, string RowName, string oValue)
{
DDL_Items.DataSource = GetSelections(tablename, RowName, oValue);
DDL_Items.Items.Clear();
DDL_Items.DataTextField = mtext;
DDL_Items.DataValueField = mvalue;
DDL_Items.DataBind();
}
/// <summary>
/// 根据特定条件,下拉框数据加载
/// </summary>
/// <param name="DDL_Items">下拉框</param>
/// <param name="tablename">表名</param>
/// <param name="mtext">名称字段</param>
/// <param name="mvalue">编号字段</param>
/// <param name="ConStr">条件字段</param>
public static void LoadSelection(ref ExtAspNet.DropDownList DDL_Items, string tablename, string mtext, string mvalue, string ConStr)
{
string sqlTxt = "SELECT * FROM " + tablename + " where " + ConStr;
DDL_Items.DataSource = CSql.CreateDataSet(sqlTxt);
DDL_Items.Items.Clear();
DDL_Items.DataTextField = mtext;
DDL_Items.DataValueField = mvalue;
DDL_Items.DataBind();
}
/// <summary>
/// 根据值返回下拉框数据INDEX
/// </summary>
/// <param name="DDL_Items">下拉框</param>
/// <param name="Value">值</param>
/// <returns>INDEX</returns>
public static int GetIndex(ref ExtAspNet.DropDownList DDL_Items, string Value)
{
if (Value.Trim() == "")
{
return(0);
}
for (int i = 0; i < DDL_Items.Items.Count; i++)
{
if (DDL_Items.Items[i].Text.Trim() == Value.Trim())
{
return(i);
}
}
return(0);
}
/// <summary>
///下拉框数据加载
/// </summary>
/// <param name="DDL_Items">下拉框</param>
/// <param name="tablename">表名</param>
/// <param name="mtext">名称字段</param>
/// <param name="mvalue">编号字段</param>
/// <param name="isTextShowCode">文本带编号显示</param>
public static void LoadSelection(ref ExtAspNet.DropDownList DDL_Items, string tablename, string mtext, string mvalue, bool isShowWithCode)
{
string sqlTxt = "";
if (isShowWithCode == true)
{
sqlTxt = "SELECT " + mvalue + "+' | '+" + mtext + " as " + mtext + "," + mvalue + " FROM " + tablename + " order by " + mvalue;
}
else
{
sqlTxt = "SELECT " + mtext + "," + mvalue + " FROM " + tablename + " order by " + mvalue;
}
DDL_Items.DataSource = CSql.CreateDataSet(sqlTxt);
DDL_Items.Items.Clear();
DDL_Items.SelectedIndex = -1;
DDL_Items.DataTextField = mtext;
DDL_Items.DataValueField = mvalue;
DDL_Items.DataBind();
}
/// <summary>
/// 根据特定条件,下拉框数据加载
/// </summary>
/// <param name="DDL_Items">下拉框</param>
/// <param name="tablename">表名</param>
/// <param name="mtext">名称字段</param>
/// <param name="mvalue">编号字段</param>
/// <param name="ConStr">条件字段</param>
/// <param name="defaultText">默认字段（插入第一行的字段）文本内容</param>
/// <param name="defaultValue">默认字段（插入第一行的字段）值</param>
public static void LoadSelection(ref ExtAspNet.DropDownList DDL_Items, string tablename, string mtext, string mvalue, string ConStr, string defaultText, string defaultValue)
{
string sqlTxt = "SELECT * FROM " + tablename + " where " + ConStr;
DataSet ds = new DataSet();
ds = CSql.CreateDataSet(sqlTxt);
//添加一行选择行
DataRow dr = ds.Tables[0].NewRow();
dr[mvalue] = defaultValue;
dr[mtext] = defaultText;
ds.Tables[0].Rows.InsertAt(dr, 0);
DDL_Items.DataSource = ds.Tables[0];
DDL_Items.Items.Clear();
DDL_Items.DataTextField = mtext;
DDL_Items.DataValueField = mvalue;
DDL_Items.DataBind();
}
/// <summary>
/// 根据值设定下拉框选中项
/// </summary>
/// <param name="DDL_Items">下拉框</param>
/// <param name="Value">值</param>
public static void SetIndex(ref ExtAspNet.DropDownList DDL_Items, string Value)
{
DDL_Items.SelectedIndex = -1;
DDL_Items.SelectedValue = Value;
}