public HtmlSelect FetchCourseMoLrnPtrnWiseLaunchedBranchListCombined(long UniID, long FacID, long CrID, long MoLrnID, long PtrnID, string HtmlSelCrBrnID, int LevelFlag)
{
DataTable dt = crRepository.ListCourseModeOfLearningPatternWiseLaunchedBranches(UniID, FacID, CrID, MoLrnID, PtrnID);
HtmlSelect htmlSel = new HtmlSelect();
htmlSel.ID = HtmlSelCrBrnID;
htmlSel.Attributes.Add("class", "selectbox");
htmlSel.Attributes.Add("onchange", "setValue(document.getElementById(hidBrnClientID).id,this.value);FillCoursePart(this.value);ClearDropDowns(3," + LevelFlag + ");");
htmlSel.DataSource = dt;
if (dt.Rows.Count > 0)
{
htmlSel.DataTextField = "Text";
htmlSel.DataValueField = "Value";
htmlSel.DataBind();
ListItem li = new ListItem("--- Select ---", "-1");
htmlSel.Items.Insert(0, li);
}
else
{
htmlSel.DataBind();
ListItem li = new ListItem("--- No Branch ---", "-1");
htmlSel.Items.Insert(0, li);
}
return(htmlSel);
}
public void SP_populateHTMLSelect(HtmlSelect GroupSelect, string sStoredProc, string sDVF, string sDTF, string sDefault, List <string> sParams)
{
SqlDataReader objDataReader = ExecuteReader(sConnection, sStoredProc, sParams);
GroupSelect.DataSource = objDataReader;
GroupSelect.DataValueField = sDVF;
GroupSelect.DataTextField = sDTF;
GroupSelect.DataBind();
if (sDefault == "N")
{
}
else if (sDefault == "Y")
{
GroupSelect.Items.Insert(0, new ListItem("All", "0"));
}
else if (sDefault == "T")
{
GroupSelect.Items.Insert(0, new ListItem("Default, All", "0"));
}
else if (sDefault == "U")
{
GroupSelect.Items.Insert(0, new ListItem("Default, All", "0"));
}
else
{
GroupSelect.Items.Insert(0, new ListItem("-Please Select-", "0"));
}
}
public static void BindDropDownList(HtmlSelect Ddl, DataTable Dt, string Value, string Text)
{
Ddl.DataValueField = Value;
Ddl.DataTextField = Text;
Ddl.DataSource = Dt.DefaultView;
Ddl.DataBind();
}
public HtmlSelect FetchCollegeWiseConfirmedFacultyListNew(string UniID, string InstID, string ddlFacDescID)
{
InstituteRepository oInstituteRepository = new InstituteRepository();
HtmlSelect htmlSel = new HtmlSelect();
DataTable listFaculty = oInstituteRepository.AssignedConfirmedFaculties(UniID, InstID.Split('|')[0]);
try
{
if (listFaculty != null)
{
htmlSel.ID = ddlFacDescID;
htmlSel.Attributes.Add("class", "selectbox");
htmlSel.Attributes.Add("onchange", "setValue(hid_Fac_id,this.value);FillCourse(this.value);ClearDropDowns(1,5)");
htmlSel.DataSource = listFaculty;
htmlSel.DataTextField = "Fac_Desc";
htmlSel.DataValueField = "pk_Fac_ID";
htmlSel.DataBind();
ListItem li = new ListItem("--- Select ---", "-1");
htmlSel.Items.Insert(0, li);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(htmlSel);
}
public void PopulateCombo1(string sql, string TextField, string ValueField, HtmlSelect Combo)
{
DBOpen();
try
{
DA = new SqlDataAdapter(sql, con);
DS = new DataSet();
DA.Fill(DS);
Combo.Items.Add(new ListItem("Please Select", ""));
if (DS.Tables[0].Rows.Count > 0)
{
Combo.DataSource = DS;
Combo.DataTextField = TextField;
Combo.DataValueField = ValueField;
Combo.DataBind();
}
}
catch (Exception EX)
{
}
finally
{
DBClose();
DS.Dispose();
}
}
/// <summary>
/// 绑定方法自定义
/// </summary>
/// <param name="dropdownlist">控件名称</param>
/// <param name="dt">数据源</param>
/// <param name="columeText">显示的文本</param>
/// <param name="columnValue">隐藏在val里的值</param>
/// <param name="columnParentsValue">mydata里的值</param>
/// <param name="msg"></param>
public void BindDdlParentsMore(HtmlSelect dropdownlist, DataTable dt, string columeText, string columnValue, string columnParentsValue, string msg)
{
if (dt.Rows.Count > 0)
{
dropdownlist.DataSource = dt;
dropdownlist.DataTextField = columeText;
dropdownlist.DataValueField = columnValue;
dropdownlist.DataBind();
dropdownlist.Items.Insert(0, new ListItem(msg, ""));
for (int i = 1; i < dropdownlist.Items.Count; i++)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
string dd = dropdownlist.Items[i].Value;
string ddd = dt.Rows[j][columnValue].ToString();
if (dropdownlist.Items[i].Value == dt.Rows[j][columnValue].ToString())//判断如果该行option的val值与dt的该行val值相等
{
dropdownlist.Items[i].Attributes["mydata"] = dt.Rows[j][columnParentsValue].ToString();
break;
}
}
}
}
else
{
dropdownlist.Items.Clear();
dropdownlist.Items.Insert(0, new ListItem(msg, ""));
}
}
/// <summary>
/// This is a helper stub to fill a select in 1 line...
/// </summary>
/// <typeparam name="source">IEnumerable object to fill the select with</typeparam>
/// <param name="nameCol">The parameterName to use for the DataTextField when filling the select</param>
/// <param name="valCol">The parameterName to use for the DataValueField when filling the select</param>
public static void FillSelect <t>(this HtmlSelect select, t source, string nameCol, string valCol) where t : IEnumerable
{
select.DataSource = source;
select.DataTextField = nameCol;
select.DataValueField = valCol;
select.DataBind();
}
private HtmlSelect CreateSelect(Configuration.SearchInputFieldRow searchInputFieldRow)
{
HtmlSelect select = new HtmlSelect();
using (OleDbCommand command = searchInputFieldRow.GetDatabaseCommand())
{
if (command.Parameters.Count > 0)
{
command.Parameters[0].Value = AppUser.GetRole();
}
using (OleDbDataAdapter adapter = new OleDbDataAdapter(command))
{
DataTable list = new DataTable();
adapter.Fill(list);
select.DataSource = list;
select.DataValueField = list.Columns[0].ColumnName;
select.DataBind();
}
command.Connection.Dispose();
}
select.Items.Insert(0, new ListItem("", ""));
return(select);
}
public HtmlSelect FetchFacultyWiseLaunchedCourseList(long UniID, long FacID, string HtmlSelCrID, int LevelFlag) //Developed by Madhu
{
DataTable dt = crRepository.ListFacultyWiseLaunchedCourses(UniID, FacID);
HtmlSelect htmlSel = new HtmlSelect();
htmlSel.ID = HtmlSelCrID;
htmlSel.Attributes.Add("class", "selectbox");
if (LevelFlag <= 2)
{
htmlSel.Attributes.Add("onchange", "setValue(document.getElementById(hidCrClientID).id,this.value);");
}
else
{
// htmlSel.Attributes.Add("onchange", "setValue(document.getElementById(hidCrClientID).id,this.value);FetchCourseWiseLaunchedModeOfLearningList('tdModeLrnDesc',document.getElementById(hidUniClientID).value,document.getElementById(hidFacClientID).value,document.getElementById(hidCrClientID).value,document.getElementByID(hidMoLrnClientID).id," + LevelFlag + ");ClearDropDowns(2," + LevelFlag + ");");
htmlSel.Attributes.Add("onchange", "setValue(document.getElementById(hidCrClientID).id,this.value);FetchCourseWiseLaunchedModeOfLearningList('tdModeLrnDesc',document.getElementById(hidUniClientID).value,document.getElementById(hidFacClientID).value,document.getElementById(hidCrClientID).value, ddlModeLrnDescClient ," + LevelFlag + ");ClearDropDowns(2," + LevelFlag + ");");
//document.getElementById(hidCrPrClientID).value = val;
}
htmlSel.DataSource = dt;
htmlSel.DataTextField = "Text";
htmlSel.DataValueField = "Value";
htmlSel.DataBind();
ListItem li = new ListItem("--- Select ---", "-1");
htmlSel.Items.Insert(0, li);
return(htmlSel);
}
public void PopulateCombo1(string sql, string textfiled, string valuefield, HtmlSelect combo)
{
DBopen();
try
{
DA = new SqlDataAdapter(sql, con);
DS = new DataSet();
DA.Fill(DS);
//combo.Items.Add(0, "Please Select");
if (DS.Tables[0].Rows.Count > 0)
{
combo.DataSource = DS;
combo.DataTextField = textfiled;
combo.DataValueField = valuefield;
combo.DataBind();
}
}
catch (Exception ex)
{
}
finally
{
DBClose();
}
}
/// <summary>
/// 数据列表绑定
/// </summary>
/// <param name="slt">列表对象</param>
public void Bind(HtmlSelect slt)
{
slt.DataSource = this.EnumList;
slt.DataTextField = "Name";
slt.DataValueField = "Num";
slt.DataBind();
}
private void AddSalesTypeField(HtmlGenericControl container)
{
using (HtmlGenericControl salesTypeDiv = HtmlControlHelper.GetField())
{
salesTypeDiv.ID = "SalesTypeDiv";
salesTypeDiv.Attributes.Add("style", "width:200px");
using (HtmlGenericControl field = HtmlControlHelper.GetField())
{
using (HtmlGenericControl label = HtmlControlHelper.GetLabel(Titles.SalesType, "SalesTypeSelect"))
{
field.Controls.Add(label);
}
using (HtmlSelect salesTypeSelect = new HtmlSelect())
{
salesTypeSelect.ID = "SalesTypeSelect";
salesTypeSelect.DataSource = this.GetSalesTypes();
salesTypeSelect.DataTextField = "Text";
salesTypeSelect.DataValueField = "Value";
salesTypeSelect.DataBind();
field.Controls.Add(salesTypeSelect);
}
salesTypeDiv.Controls.Add(field);
}
container.Controls.Add(salesTypeDiv);
}
}
public HtmlSelect FetchCoursePartWiseCoursePartChildList(string UniID, string InstID, string FacID, string CrID, string MoLrnID, string PtrnID, string BrnID, string CrPrDetails_ID, string HtmlSelCrBrnID)
{
InstituteRepository oInstituteRepository = new InstituteRepository();
DataTable dt = oInstituteRepository.AssignCoursePartTerm(UniID, InstID, FacID, CrID, MoLrnID, PtrnID, BrnID, CrPrDetails_ID);
HtmlSelect htmlSel = new HtmlSelect();
htmlSel.ID = HtmlSelCrBrnID;
htmlSel.Attributes.Add("class", "selectbox");
// htmlSel.Attributes.Add("onchange", "FetchCourseMoLrnPtrnBrnWiseCoursePartList('tdCrPrDesc', hidUniID.value, hidFacID.value, hidCrID.value, hidMoLrnID.value, hidPtrnID.value, hidBrnID.value, 'ddlCrPrDesc'); ");//ClearDropDowns(5," + levelflag + ");");
//htmlSel.Attributes.Add("onchange", "setValue('hidCrPrID',this.value);");
htmlSel.Attributes.Add("onchange", "setCrPartTerm(this.value);");
//hCrPart.Attributes.Add("onchange", "setCrPart(this.value);");
htmlSel.DataSource = dt;
htmlSel.DataTextField = "text";
htmlSel.DataValueField = "value";
htmlSel.Style.Add("width", "230px");
htmlSel.DataBind();
ListItem li = new ListItem("--- Select ---", "-1");
htmlSel.Items.Insert(0, li);
return(htmlSel);
}
public HtmlSelect FetchCourseMoLrnPtrnWiseLaunchedBranchWiseCrPartsCombined(long UniID, long FacID, long CrID, long MoLrnID, long PtrnID, long BrnID, string HtmlSelCrBrnID, int LevelFlag)
{
DataTable dt = crRepository.ListCourseModeOfLearningPatternBrnWiseLaunchedCourseParts(UniID, FacID, CrID, MoLrnID, PtrnID, BrnID);
HtmlSelect htmlSel = new HtmlSelect();
htmlSel.ID = HtmlSelCrBrnID;
htmlSel.Attributes.Add("class", "selectbox");
if (LevelFlag <= 5)
{
htmlSel.Attributes.Add("onchange", "setValue(document.getElementById(hid_CrPrDet_id).id,this.value);FillCrPartChild(this.value);ClearDropDowns(5," + LevelFlag + ");");
}
else
{
//htmlSel.Attributes.Add("onchange", "setValue('hidBrnID',this.value);FetchCourseMoLrnPtrnBrnWiseLaunchedCoursePartList('tdCrPrDesc',hidUniID.value,hidFacID.value,hidCrID.value, hidMoLrnID.value, hidPtrnID.value, hidBrnID.value, 'ddlCrPrDesc'," + LevelFlag + ");ClearDropDowns(5," + LevelFlag + ");");
//htmlSel.Attributes.Add("onchange", "setValue(document.getElementById(hidBrnClientID).id,this.value);");
htmlSel.Attributes.Add("onchange", "setValue(document.getElementById(hid_CrPrDet_id).id,this.value);FillCrPartChild(this.value);ClearDropDowns(5," + LevelFlag + ");");
}
//htmlSel.Attributes.Add("onchange", "setBranchDetails(this.value);");
htmlSel.DataSource = dt;
htmlSel.DataTextField = "Text";
htmlSel.DataValueField = "Value";
htmlSel.DataBind();
ListItem li = new ListItem("--- Select ---", "-1");
htmlSel.Items.Insert(0, li);
return(htmlSel);
}
private void AddLanguageField(HtmlGenericControl container)
{
using (HtmlGenericControl field = new HtmlGenericControl("div"))
{
field.Attributes.Add("class", "field");
using (HtmlGenericControl label = HtmlControlHelper.GetLabel(Titles.SelectLanguage, "LanguageSelect"))
{
field.Controls.Add(label);
}
using (HtmlSelect languageSelect = new HtmlSelect())
{
languageSelect.ID = "LanguageSelect";
languageSelect.DataTextField = "Text";
languageSelect.DataValueField = "Value";
languageSelect.DataSource = this.GetLanguages();
languageSelect.DataBind();
field.Controls.Add(languageSelect);
}
container.Controls.Add(field);
}
}
public HtmlSelect FetchCourseMoLrnwiseLaunchedCoursePatternsList(long UniID, long FacID, long CrID, long MoLrnID, string HtmlSelCrPtrnID, int LevelFlag)
{
DataTable dt = crRepository.ListCourseModeOfLearningWiseLaunchedCoursePatterns(UniID, FacID, CrID, MoLrnID);
HtmlSelect htmlSel = new HtmlSelect();
htmlSel.ID = HtmlSelCrPtrnID;
htmlSel.Attributes.Add("class", "selectbox");
if (LevelFlag <= 4)
{
htmlSel.Attributes.Add("onchange", "setValue(document.getElementById(hidPtrnClientID).id,this.value);");
}
else
{
htmlSel.Attributes.Add("onchange", "setValue(document.getElementById(hidPtrnClientID).id,this.value);FetchCourseMoLrnPtrnWiseLaunchedBranchList('tdCrBrnDesc',document.getElementById(hidUniClientID).value,document.getElementById(hidFacClientID).value,document.getElementById(hidCrClientID).value, document.getElementById(hidMoLrnClientID).value, document.getElementById(hidPtrnClientID).value, ddlCrBrnDescClient ," + LevelFlag + ");ClearDropDowns(4," + LevelFlag + ");");
}
htmlSel.DataSource = dt;
htmlSel.DataTextField = "Text";
htmlSel.DataValueField = "Value";
htmlSel.DataBind();
ListItem li = new ListItem("--- Select ---", "-1");
htmlSel.Items.Insert(0, li);
return(htmlSel);
}
public static void SetHtmlSelect(HtmlSelect list)
{
list.DataSource = GetDataTable();
list.DataTextField = "Name";
list.DataValueField = "Value";
list.DataBind();
}
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (!Page.IsPostBack)
{
DeptID = (Request.QueryString["DeptID"] == null)?"":Request.QueryString["DeptID"].ToString();
displayType = (Request.QueryString["displayType"] == null)?"":Request.QueryString["displayType"].ToString();
selectedID = (Request.QueryString["StaffIDS"] == null)?"":Request.QueryString["StaffIDS"].ToString();
backfilepath = (Request.QueryString["BackFilePath"] == null)?"":Request.QueryString["BackFilePath"].ToString();
SqlDataReader dr;
UDS.Components.Database db = new UDS.Components.Database();
db.RunProc("SP_Ext_GetDepartment", out dr);
Department.DataSource = dr;
Department.DataTextField = "Department_Name";
Department.DataValueField = "Department_ID";
Department.DataBind();
}
if (Request.QueryString["ReturnPage"] != null)
{
ReturnPage = Int32.Parse(Request.QueryString["ReturnPage"].ToString());
}
else
{
ReturnPage = 0;
}
}
//允许显示的菜单栏目
private void CreateRightAccount(HtmlSelect listcontrolright, int TopMenuId)
{
Johnny.CMS.BLL.SystemInfo.TopMenuBinding bll = new Johnny.CMS.BLL.SystemInfo.TopMenuBinding();
listcontrolright.DataSource = bll.GetList(TopMenuId);
listcontrolright.DataTextField = "MenuCategoryName";
listcontrolright.DataValueField = "MenuCategoryId";
listcontrolright.DataBind();
}
//拥有权限
private void CreateRightAccount(HtmlSelect listcontrolright, int TopMenuId)
{
Johnny.CMS.BLL.Access.RolePermission bll = new Johnny.CMS.BLL.Access.RolePermission();
listcontrolright.DataSource = bll.GetList(RoleId, PermissionCategoryId);
listcontrolright.DataTextField = "PermissionName";
listcontrolright.DataValueField = "PermissionId";
listcontrolright.DataBind();
}
public static void BindDropDownList(HtmlSelect Ddl, DataTable Dt, string Value, string Text, string DefaultValue, string DefaultText)
{
Ddl.DataValueField = Value;
Ddl.DataTextField = Text;
Ddl.DataSource = Dt.DefaultView;
Ddl.DataBind();
Ddl.Items.Insert(0, new ListItem("", ""));
}
public static void LoadCombobox(HtmlSelect sl, string sql, string Text, string Value, string TextSelect)
{
sl.DataSource = Connect.GetTable(sql);
sl.DataTextField = Text;
sl.DataValueField = Value;
sl.DataBind();
sl.Items.Add(new ListItem(TextSelect, "-1"));
sl.Items.FindByValue("-1").Selected = true;
}
/// <summary>
/// 绑定HtmlSelect
/// </summary>
public static void BindCtrlHTMLDDL(DataSet ds, string textField, string valueField, HtmlSelect ddlControlName)
{
if (ddlControlName.Items.Count <= 1)
{
ddlControlName.DataSource = ds;
ddlControlName.DataTextField = textField;
ddlControlName.DataValueField = valueField;
ddlControlName.DataBind();
}
}
/// <summary>
/// 绑定HtmlSelect带默认值
/// </summary>
public static void BindCtrlHTMLDDL(DataSet ds, string textField, string valueField, HtmlSelect ddlControlName, string ddlDefaultValue)
{
if (ddlControlName.Items.Count <= 1)
{
ddlControlName.DataSource = ds;
ddlControlName.DataTextField = textField;
ddlControlName.DataValueField = valueField;
ddlControlName.DataBind();
ddlControlName.Items.FindByValue(ddlDefaultValue).Selected = true;
}
}
public static void LoadDropDownList(HtmlSelect ddl, string StringArray)
{
string[] myArr = ConvertToArray(StringArray);
List <ListItem> items = StringArray2ListItem(myArr);
for (int i = 0; i < items.Count; i++)
{
ddl.Items.Add(items[i]);
}
ddl.DataBind();
}
/// <summary>
/// 绑定IList<T>:HtmlSelect下拉列表框
/// </summary>
/// <param name="dt">DataTable</param>
/// <param name="dropdownlists">控件名称</param>
/// <param name="_Name">绑定字段名称</param>
/// <param name="_ID">绑定字段主键</param>
/// <param name="_Memo">默认显示值</param>
public static void BindHtmlSelect <T>(IList <T> list, HtmlSelect select, string _Name, string _ID, string _Memo)
{
select.DataSource = list;
select.DataTextField = _Name;
select.DataValueField = _ID;
select.DataBind();
if (!string.IsNullOrEmpty(_Memo.Trim()))
{
select.Items.Insert(0, new ListItem(_Memo, ""));
}
}
//数据绑定HtmlSelect
public static void BindHtmlSelect(HtmlSelect objTmp, string strValueField, string strTextField, string strSql)
{
objTmp.Items.Clear();
DataTable dt;
dt = SqlHelper.GetTable(strSql);
objTmp.DataSource = dt;
objTmp.DataValueField = strValueField;
objTmp.DataTextField = strTextField;
objTmp.DataBind();
}
/// <summary>
/// 绑定DataTable:HtmlSelect下拉列表框
/// </summary>
/// <param name="dt">DataTable</param>
/// <param name="dropdownlists">控件名称</param>
/// <param name="_Name">绑定字段名称</param>
/// <param name="_ID">绑定字段主键</param>
/// <param name="_Memo">默认显示值</param>
public static void BindHtmlSelect(DataTable dt, HtmlSelect select, string _Name, string _ID, string _Memo)
{
select.DataSource = dt;
select.DataTextField = _Name;
select.DataValueField = _ID;
select.Attributes.Add("title", "123");
select.DataBind();
if (!string.IsNullOrEmpty(_Memo.Trim()))
{
select.Items.Insert(0, new ListItem(_Memo, ""));
}
}
/// <summary>
/// 绑定路局
/// </summary>
public static void Bind_DDLLj(HtmlSelect ddlLjbh)
{
DataTable dt = DAL_G_Common.GetList("ShLjb", "");
if (dt.Rows.Count > 0)
{
ddlLjbh.DataSource = dt;
ddlLjbh.DataBind();
}
ddlLjbh.Items.Add("==请选择==");
ddlLjbh.SelectedIndex = ddlLjbh.Items.Count - 1;
}
/// <summary>
/// 绑定所属段
/// </summary>
public static void Bind_DDL_Ssgwd(HtmlSelect ddlGwdID, string strWhere)
{
DataTable dt = DAL_G_Common.GetList("ShJwd", strWhere);
if (dt.Rows.Count > 0)
{
ddlGwdID.DataSource = dt;
ddlGwdID.DataBind();
}
ddlGwdID.Items.Add("==请选择==");
ddlGwdID.SelectedIndex = ddlGwdID.Items.Count - 1;
}
private HtmlSelect CreateSelect(Configuration.SearchInputFieldRow searchInputFieldRow)
{
HtmlSelect select = new HtmlSelect();
using (OleDbCommand command = searchInputFieldRow.GetDatabaseCommand())
{
if (command.Parameters.Count > 0)
{
command.Parameters[0].Value = AppUser.GetRole();
}
using (OleDbDataAdapter adapter = new OleDbDataAdapter(command))
{
DataTable list = new DataTable();
adapter.Fill(list);
select.DataSource = list;
select.DataValueField = list.Columns[0].ColumnName;
select.DataBind();
}
command.Connection.Dispose();
}
select.Items.Insert(0, new ListItem("", ""));
return select;
}
