public static void fillDropDownItems(System.Web.UI.WebControls.DropDownList ddl,UserGroup _userGroupObj) { try { //if (Branch.dropDownItems.Count < 1) //{ // new BranchSelectDataByUser().getBranchDropDownItemsByUser(-1); //} UserGroup _u = new UserGroup(); _u = _userGroupObj; new UserGroupSelect(_u).UserGroupDropDownList(_u._dropDownList); ddl.DataSource = _u._dropDownList; ddl.DataTextField = "Name"; ddl.DataValueField = "Value"; ddl.DataBind(); } catch (Exception ex) { throw ex; } finally { ddl = null; } }
protected void binddrop(string message, System.Web.UI.WebControls.DropDownList drop) { drop.DataSource = comtypeBll.getType(message); drop.DataTextField = "tname"; drop.DataValueField = "id"; drop.DataBind(); }
public void fillListedUnitGroups(System.Web.UI.WebControls.ListBox lstbx) { UnitAndUnitGroupSelect _unitNGroup = new UnitAndUnitGroupSelect(); UserGroup ug = new UserGroup(); try { _unitNGroup.UserID = this._userID; _unitNGroup.ComID = this._comID; _unitNGroup.LoadListedUnitGroups(ug._dropDownList); lstbx.DataSource = ug._dropDownList; lstbx.DataTextField = "Name"; lstbx.DataValueField = "Value"; lstbx.DataBind(); } catch (Exception ex) { ex.Message.ToString(); } finally { _unitNGroup = null; ug = null; } }
public static void comboRellenar(System.Web.UI.WebControls.DropDownList combo, string textoSql, string cadenaConexion, string mensajeInicial) { combo.Items.Clear(); if (cadenaConexion == "") { cadenaConexion = ctes.conStringAdoGeneral; } dbClass pp = new dbClass(cadenaConexion); MySql.Data.MySqlClient.MySqlDataReader reg; // 'SqlClient.SqlDataReader DataTable esquema; reg = pp.sql(textoSql); esquema = reg.GetSchemaTable(); combo.DataSource = reg; //myDataReader combo.DataTextField = sf.cadena(esquema.Rows[1].ItemArray[0]); combo.DataValueField = sf.cadena(esquema.Rows[0].ItemArray[0]); //.Columns(1).ColumnName.ToString '.Item(0).ColumnName.ToString; //'"idlicencias" 'myDataReader.Fields(0).Name; combo.DataBind(); // mensajeInicial = "<Elija una opcion>"; if (mensajeInicial != "") { ListItem per = new ListItem(); per.Value = sf.cadena(0); per.Text = mensajeInicial; combo.Items.Insert(0, per); } pp.Dispose(); }
public void GetDropDownListBind(System.Web.UI.WebControls.DropDownList ddl, string strText, string strValue, DataTable db) { ddl.DataSource = GetRepeatedDadatable(db, strValue); ddl.DataTextField = strText; ddl.DataValueField = strValue; ddl.DataBind(); }
//根据数据,生成下拉列表 public void GetDropDownListBind(System.Web.UI.WebControls.DropDownList ddl, string strText, string strValue, string strTable, string strWhere) { ddl.DataSource = GetList(strTable, strWhere); ddl.DataTextField = strText; ddl.DataValueField = strValue; ddl.DataBind(); }
/// <summary> /// load dropdownlist /// </summary> /// <param name="ddl">System.Web.UI.WebControls.DropDownList ddl</param> public static void fillListBoxItems(System.Web.UI.WebControls.ListBox _lst, UnitType _unitype) { try { UnitType _c = new UnitType(); _c = _unitype; new UnitTypeSelect(_c).UnitTypeListBox(_c._dropDownList); _lst.DataSource = _c._dropDownList; _lst.DataTextField = "Name"; _lst.DataValueField = "Value"; _lst.DataBind(); } catch (Exception ex) { throw ex; } finally { _lst = null; _unitype = null; } }
public static void fillListBox(System.Web.UI.WebControls.ListBox _lst, int _comID) { try { Units _unit=new Units(); UnitInfoSelect _unitSelect = new UnitInfoSelect(); _unitSelect.ComID = _comID; _unitSelect.UnitListBoxItems(_unit._ListItems); _lst.DataSource = _unit._ListItems; _lst.DataTextField = "Name"; _lst.DataValueField = "Value"; _lst.DataBind(); } catch (Exception ex) { throw ex; } finally { _lst = null; } }
/// <summary> /// load dropdownlist /// </summary> /// <param name="ddl">System.Web.UI.WebControls.DropDownList ddl</param> public static void fillDropDownItems(System.Web.UI.WebControls.DropDownList ddl) { try { //if (Branch.dropDownItems.Count < 1) //{ // new BranchSelectDataByUser().getBranchDropDownItemsByUser(-1); //} Company _c = new Company(); new CompanySelect().CompanyDropDownList(_c._dropDownList); ddl.DataSource = _c._dropDownList; ddl.DataTextField = "Name"; ddl.DataValueField = "Value"; ddl.DataBind(); } catch (Exception ex) { throw ex; } finally { ddl = null; } }
public static void Paggination(System.Web.UI.WebControls.Repeater rptPager, int recordCount, int currentPage, int PageSize) { double dblPageCount = (double)((decimal)recordCount / decimal.Parse(PageSize.ToString())); int pageCount = (int)Math.Ceiling(dblPageCount); List<ListItem> pages = new List<ListItem>(); if (pageCount > 0) { pages.Add(new ListItem("First", "1", currentPage > 1)); pages.Add(new ListItem("Previous", (currentPage - 1).ToString(), currentPage > 1)); var page_show = 6; var both_side_page_show = page_show / 2; var show_bellow_limit = currentPage - both_side_page_show; var show_top_side_limit = pageCount - both_side_page_show; var show_bellow_lower_limit = currentPage - both_side_page_show; var show_bellow_top_upper_limit=0; if (show_bellow_lower_limit <= 0) { show_bellow_lower_limit = 1; show_bellow_top_upper_limit = show_bellow_lower_limit + both_side_page_show; } else { show_bellow_lower_limit = currentPage; show_bellow_top_upper_limit = currentPage + both_side_page_show; } var show_top_upper_limit = pageCount - both_side_page_show; var show_top_lower_limit = show_top_upper_limit - both_side_page_show; var do_no = 0; for (int i = 1; i <= pageCount; i++) { if ( ((i >= show_bellow_lower_limit) && (i <= show_bellow_top_upper_limit)) || ((i <= show_top_upper_limit) && (i >= show_top_lower_limit)) ) { pages.Add(new ListItem(i.ToString(), i.ToString(), i != currentPage)); if ((do_no == 0) && (i >= show_bellow_top_upper_limit)) { pages.Add(new ListItem("...", i.ToString(), i != currentPage)); do_no++; } } } pages.Add(new ListItem("Next", (currentPage + 1).ToString(), currentPage < pageCount)); pages.Add(new ListItem("Last", pageCount.ToString(), currentPage < pageCount)); } rptPager.DataSource = pages; rptPager.DataBind(); }
public void LogTypeBind(System.Web.UI.WebControls.DropDownList ddlControl) { string str = "select Distinct LogType from Sys_OperateLog"; ddlControl.DataSource = DbHelperSQL.DQuery(str); ddlControl.DataTextField = "LogType"; ddlControl.DataValueField = "LogType"; ddlControl.DataBind(); ddlControl.Items.Insert(0, new System.Web.UI.WebControls.ListItem("请选择操作类型", "")); }
//绑定已经存在数据库中的表(特定用在日志中的操作表) public void GetOperatTableBind(System.Web.UI.WebControls.DropDownList ddlControl, string strWhere) { string str = "select Distinct OperateTable from Sys_OperateLog where " + strWhere; ddlControl.DataSource = DbHelperSQL.DQuery(str); ddlControl.DataTextField = "OperateTable"; ddlControl.DataValueField = "OperateTable"; ddlControl.DataBind(); ddlControl.Items.Insert(0,new System.Web.UI.WebControls.ListItem("请选择操作表", "")); }
public static void CarregarCombo(string v_sAssembly, long v_iID, System.Web.UI.WebControls.DropDownList v_oDDL) { Type m_oType = Type.GetType(v_sAssembly); object m_oObjeto = System.Activator.CreateInstance(m_oType); v_oDDL.DataSource = ((Dor.Base.Base)m_oObjeto).Listar(v_iID); v_oDDL.DataValueField = ((Dor.Base.Base)m_oObjeto).GetAtributo("Codigo", "Html").ToString(); v_oDDL.DataTextField = ((Dor.Base.Base)m_oObjeto).GetAtributo("Nome", "Html").ToString(); v_oDDL.DataBind(); }
//BindSysResCheckBoxList(cblProblems,"res_fileproblems","name","name") public void BindSysResCheckBoxList(System.Web.UI.WebControls.CheckBoxList cbl,string tablename,string fieldv,string fieldt) { CommonDAL commonDAL = new CommonDAL(conn); string sql = "select * from " + tablename + " "; DataSet ds = commonDAL.GetDS(sql); cbl.DataSource = ds; cbl.DataTextField = fieldt; cbl.DataValueField = fieldv; cbl.DataBind(); }
public static void LoadQuiz_FillInTheBlanksDetailsPage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize) { int recordCount=0; int PageSize = int.Parse(ddlPageSize.SelectedValue); SqlQuiz_FillInTheBlanksDetailsProvider sqlQuiz_FillInTheBlanksDetailsProvider = new SqlQuiz_FillInTheBlanksDetailsProvider(); DataSet ds = sqlQuiz_FillInTheBlanksDetailsProvider.GetQuiz_FillInTheBlanksDetailsPageWise(pageIndex, PageSize, out recordCount); gv.DataSource = ds; gv.DataBind(); quiz_FillInTheBlanksDetailssPaggination(rptPager,recordCount, pageIndex, PageSize); }
public static void LoadHR_BenifitPackagePage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize) { int recordCount=0; int PageSize = int.Parse(ddlPageSize.SelectedValue); SqlHR_BenifitPackageProvider sqlHR_BenifitPackageProvider = new SqlHR_BenifitPackageProvider(); DataSet ds = sqlHR_BenifitPackageProvider.GetHR_BenifitPackagePageWise(pageIndex, PageSize, out recordCount); gv.DataSource = ds; gv.DataBind(); hR_BenifitPackagesPaggination(rptPager,recordCount, pageIndex, PageSize); }
public static void GetAllSTD_FeesList_NotPaid(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize) { int recordCount = 0; int PageSize = int.Parse(ddlPageSize.SelectedValue); SqlSTD_FeesProvider sqlSTD_ProgramProvider = new SqlSTD_FeesProvider(); DataSet ds = sqlSTD_ProgramProvider.GetAllSTD_FeesList_NotPaid(pageIndex, PageSize, out recordCount); gv.DataSource = processDataSet(ds); gv.DataBind(); COMN_CommonManager.Paggination(rptPager, recordCount, pageIndex, PageSize); }
public static void LoadSTD_ProgramPage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize) { int recordCount=0; int PageSize = int.Parse(ddlPageSize.SelectedValue); SqlSTD_ProgramProvider sqlSTD_ProgramProvider = new SqlSTD_ProgramProvider(); DataSet ds = sqlSTD_ProgramProvider.GetSTD_ProgramPageWise(pageIndex, PageSize, out recordCount); gv.DataSource = ds; gv.DataBind(); COMN_CommonManager common= new COMN_CommonManager(); COMN_CommonManager.Paggination(rptPager,recordCount, pageIndex, PageSize); }
public void BindSysResDDL(System.Web.UI.WebControls.DropDownList ddl, string tablename, string cond,string orderby, bool withblankitem) { SysResDAL sysResDAL = new SysResDAL(conn); DataSet ds = sysResDAL.GetSysResDS(tablename, cond, orderby); ddl.DataSource = ds; ddl.DataTextField = "name"; ddl.DataValueField = "code"; ddl.DataBind(); if (withblankitem){ ddl.Items.Insert(0,new System.Web.UI.WebControls.ListItem("", "")); } }
/// <summary> /// CheckBoxListBind� /// </summary> /// <param name="chklControl">CheckBoxList�ؼ�</param> /// <param name="strTableName">����</param> /// <param name="strText">��ʾ���ֶ�</param> /// <param name="strValue">ֵ�ֶ�</param> /// <param name="strWhere">��ѯ����</param> public static void CheckBoxListBind(System.Web.UI.WebControls.CheckBoxList chklControl, string strTableName, string strText, string strValue, string strWhere) { string strSql = "SELECT * FROM " + strTableName + " Where " + strWhere; DataSet dstTemp = new DataSet(); dstTemp = DbHelperSQL.Query(strSql); chklControl.DataSource = dstTemp.Tables[0]; chklControl.DataTextField = strText; chklControl.DataValueField = strValue; chklControl.DataBind(); }
protected void FillDDL(ref System.Web.UI.WebControls.DropDownList ddl, System.Data.SqlClient.SqlCommand sql, string textField, string valueField) { try { ddl.DataSource = getData(sql); ddl.DataTextField = textField; ddl.DataValueField = valueField; ddl.DataBind(); } catch (System.Exception ex) { conCloseNo(); } }
public static void selDropDownList(System.Web.UI.WebControls.DropDownList obj, string config, string sql, bool blCOne) { string ConnStr = ConfigurationManager.AppSettings[config]; SqlConnection cn = new SqlConnection(ConnStr); SqlDataAdapter da = new SqlDataAdapter(sql, cn); DataSet ds = new DataSet(); da.Fill(ds, "dropdownlist"); obj.DataSource = ds.Tables["dropdownlist"].DefaultView; obj.DataValueField = ds.Tables["dropdownlist"].Columns[0].ToString(); obj.DataTextField = ds.Tables["dropdownlist"].Columns[1].ToString(); obj.DataBind(); }
public void FillListBox(System.Web.UI.WebControls.ListBox lb, TTSHWCFReference.DropDownName listname, string Condition = "") { TTSHWCFServiceClient cl = new TTSHWCFServiceClient(); try { List<TTSHWCFReference.clsDropDown> listbox = cl.GetDropDownData(listname, ddlAuditModules.SelectedValue, "", "", "", "").ToList(); lb.DataSource = listbox; lb.DataTextField = "DisplayField"; lb.DataValueField = "ValueField"; lb.DataBind(); //lb.Items.Insert(0, new ListItem("--Select--", "-1")); } catch { } }
public void GetDocCodeByType(string Dept_ID, System.Web.UI.WebControls.DropDownList drgList) { Database db = DatabaseFactory.CreateDatabase(DocConnStr); string strSql = " SELECT A.L_ID,A.L_NAME FROM OA_DOC_SENDLOGO A WHERE A.MAINDEPT='" + Dept_ID + "' OR A.ISALL='1' AND CMP_CODE='" + System.Web.HttpContext.Current.Session["EPORTID"].ToString() + "'"; DbCommand cmd = db.GetSqlStringCommand(strSql); DataView dv = db.ExecuteDataView(cmd); drgList.DataSource = dv; drgList.DataTextField = "L_NAME"; drgList.DataValueField = "L_ID"; drgList.DataBind(); drgList.Items.Insert(0, "--请选择--"); drgList.SelectedIndex = 0; }
public void GetDocCodeByType(string Type_ID, System.Web.UI.WebControls.DropDownList drgList) { Database db = DatabaseFactory.CreateDatabase(DocConnStr); string strSql = (Type_ID == "4" || Type_ID == "8") ? " SELECT B_ID,B_CONTENT FROM OA_DOC_BASECODE WHERE B_TYPE='" + Type_ID + "'" : " SELECT B_ID,B_CONTENT FROM OA_DOC_BASECODE WHERE B_TYPE='" + Type_ID + "' AND CMP_CODE='"+System.Web.HttpContext.Current.Session["EPORTID"].ToString()+"'"; DbCommand cmd = db.GetSqlStringCommand(strSql); DataView dv = db.ExecuteDataView(cmd); drgList.DataSource = dv; drgList.DataTextField = "B_CONTENT"; drgList.DataValueField = "B_ID"; drgList.DataBind(); drgList.Items.Insert(0, "--请选择--"); drgList.SelectedIndex = 0; }
public static void BindUnit(System.Web.UI.WebControls.DropDownList ddl, XBase.Common.UserInfoUtil userinfo) { string sqlstr = "select ID,CodeName from officedba.CodeUnitType where UsedStatus=1 and CompanyCD=@CompanyCD"; SqlParameter[] param = { new SqlParameter("@CompanyCD",SqlDbType.VarChar) }; param[0].Value = userinfo.CompanyCD; DataSet ds = SqlHelper.ExecuteSqlX(sqlstr, param); ddl.DataTextField = "CodeName"; ddl.DataValueField = "ID"; ddl.DataSource = ds; ddl.DataBind(); ddl.DataSource = null; ddl.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---请选择单位---", "0")); }
public static void CarregarDropDownList(System.Web.UI.WebControls.DropDownList ddl, System.Data.DataTable table, string valor, string texto) { ddl.Items.Clear(); ddl.Items.Add(new ListItem("--Selecione--", "0")); foreach (System.Data.DataRow row in table.Rows) { ddl.Items.Add(new ListItem(row[texto].ToString(), row[valor].ToString())); } //ddl.DataSource = table; //ddl.Items.Clear(); //ddl.DataTextField = texto; //ddl.DataValueField = valor; //ddl.Items.Add(new ListItem("--Selecione--", "0")); ddl.DataBind(); ddl.SelectedIndex = -1; }
public static void hR_SalaryIncrementsPaggination(System.Web.UI.WebControls.Repeater rptPager, int recordCount, int currentPage, int PageSize) { double dblPageCount = (double)((decimal)recordCount / decimal.Parse(PageSize.ToString())); int pageCount = (int)Math.Ceiling(dblPageCount); List<ListItem> pages = new List<ListItem>(); if (pageCount > 0) { pages.Add(new ListItem("First", "1", currentPage > 1)); for (int i = 1; i <= pageCount; i++) { pages.Add(new ListItem(i.ToString(), i.ToString(), i != currentPage)); } pages.Add(new ListItem("Last", pageCount.ToString(), currentPage < pageCount)); } rptPager.DataSource = pages; rptPager.DataBind(); }
/// <summary> /// Fills the specified gridview with a page of data. /// </summary> /// <param name="gv">The gridview.</param> /// <param name="list">The single page of data.</param> /// <param name="count">The total count (to work out number of pages).</param> /// <param name="pageSize">Size of the page.</param> public static void Fill(System.Web.UI.WebControls.GridView gv, IList<object> list, int count, int pageSize) { //create an ObjectDateSource object programmatically ObjectDataSource ods = new ObjectDataSource(); ods.ID = "ods" + gv.ID; ods.EnablePaging = gv.AllowPaging; ods.TypeName = "ObjectAdaptor"; //can be a common base class ods.SelectMethod = "Select"; ods.SelectCountMethod = "Count"; ods.StartRowIndexParameterName = "startRowIndex"; ods.MaximumRowsParameterName = "maximumRows"; ods.EnableViewState = false; //when creating, inject the data into the table adaptor ods.ObjectCreating += delegate(object sender, ObjectDataSourceEventArgs e) { e.ObjectInstance = new ObjectAdaptor(list, count); }; ods.DataBind(); gv.PageSize = pageSize; gv.DataSource = ods; gv.DataBind(); }
/// <summary> /// load dropdownlist /// </summary> /// <param name="ddl">System.Web.UI.WebControls.DropDownList ddl</param> public static void fillDropDownItems(System.Web.UI.WebControls.DropDownList ddl, UnitType _unitype) { try { UnitType _c = new UnitType(); _c = _unitype; new UnitTypeSelect(_c).UnitTypeDropDownList(_c._dropDownList); ddl.DataSource = _c._dropDownList; ddl.DataTextField = "Name"; ddl.DataValueField = "Value"; ddl.DataBind(); } catch (Exception ex) { throw ex; } finally { ddl = null; } }