Example #1
0
        private void DdlBind()
        {
            //绑定客户类型
            BLL.T_Dictionary          B_Dic = new BLL.T_Dictionary();
            List <Model.T_Dictionary> L_Dic = B_Dic.GetList(" and dType='D01'");

            ddlType.DataSource     = L_Dic;
            ddlType.DataTextField  = "dName";
            ddlType.DataValueField = "ID";
            ddlType.DataBind();

            //绑定一级区域
            BLL.T_Regional          B_Reg = new BLL.T_Regional();
            List <Model.T_Regional> L_Reg = B_Reg.GetList(" and ParentID=0 order by SortNum asc,ID asc");

            Model.T_Regional M_Reg = new Model.T_Regional();
            M_Reg.ID      = 0;
            M_Reg.RName   = "无";
            M_Reg.SortNum = 0;
            L_Reg.Add(M_Reg);
            L_Reg = L_Reg.OrderBy(o => o.SortNum).ToList();
            ddlOneArea.DataSource     = L_Reg;
            ddlOneArea.DataTextField  = "RName";
            ddlOneArea.DataValueField = "ID";
            ddlOneArea.DataBind();

            //绑定二级区域
            List <Model.T_Regional> L_RegTwo = new List <Model.T_Regional>();

            L_RegTwo.Add(M_Reg);
            ddlTwoArea.DataSource     = L_RegTwo;
            ddlTwoArea.DataTextField  = "RName";
            ddlTwoArea.DataValueField = "ID";
            ddlTwoArea.DataBind();

            //绑定银行
            List <Model.T_Dictionary> L_DicBank = B_Dic.GetList(" and dType='D03'");

            Model.T_Dictionary M_Dic = new Model.T_Dictionary();
            M_Dic.ID       = 0;
            M_Dic.dName    = "无";
            M_Dic.dSortNum = 0;
            L_DicBank.Add(M_Dic);
            L_DicBank              = L_DicBank.OrderBy(o => o.dSortNum).ToList();
            ddlBank.DataSource     = L_DicBank;
            ddlBank.DataTextField  = "dName";
            ddlBank.DataValueField = "ID";
            ddlBank.DataBind();
        }
Example #2
0
        /// <summary>
        /// 绑定下拉框
        /// </summary>
        /// <param name="ddl"></param>
        /// <param name="dType">数据字典类型</param>
        private void BindDropDownList(DropDownList ddl, string dType)
        {
            string strWhere = "";//条件

            strWhere = " and dType='" + dType + "'";
            BLL.T_Dictionary bll = new BLL.T_Dictionary();
            DataTable        dt  = bll.GetDataTable(strWhere);

            ddl.Items.Clear();
            ddl.Items.Add(new ListItem("--不限--", "00"));
            foreach (DataRow dr in dt.Rows)
            {
                ddl.Items.Add(new ListItem(dr["dName"].ToString(), dr["dNum"].ToString()));
            }
        }