private void BindCountry() { ArrayList array = Country.GetData(); ddlCountry.DataSource = array; ddlCountry.DataValueField = "Id"; ddlCountry.DataTextField = "Name"; ddlCountry.DataBind(); DataSet ds = new DataSet(); string queryAlarmType = "SELECT * FROM T_AlarmType"; ds = DbHelperSQL.Query(queryAlarmType); foreach (DataRow dr in ds.Tables[0].Rows) { ListItem item = new ListItem(dr["Name"].ToString(), dr["ID"].ToString()); ddlAlarmType.Items.Add(item); } string strWhere = string.Format("StatId = {0}", Request.Params["id"]); ds = _devBll.GetList(strWhere); foreach (DataRow dr in ds.Tables[0].Rows) { ListItem item = new ListItem(dr["DevCode"].ToString(), dr["Id"].ToString()); ddlDevs.Items.Add(item); } }
public void BindData() { #region //if (!Context.User.Identity.IsAuthenticated) //{ // return; //} //AccountsPrincipal user = new AccountsPrincipal(Context.User.Identity.Name); //if (user.HasPermissionID(PermId_Modify)) //{ // gridView.Columns[6].Visible = true; //} //if (user.HasPermissionID(PermId_Delete)) //{ // gridView.Columns[7].Visible = true; //} #endregion DataSet ds = new DataSet(); StringBuilder strWhere = new StringBuilder(); if (txtKeyword.Text.Trim() != "") { #warning 代码生成警告:请修改 keywordField 为需要匹配查询的真实字段名称 //strWhere.AppendFormat("keywordField like '%{0}%'", txtKeyword.Text.Trim()); } ds = bll.GetList(strWhere.ToString()); gridView.DataSource = ds; gridView.DataBind(); }
private void BindLocalCtrls() { ESMonitor.BLL.Devs LBll = new ESMonitor.BLL.Devs(); DataSet ds = new DataSet(); ds = LBll.GetList(""); this.ddlLocalCtrls.DataSource = ds; this.ddlLocalCtrls.DataTextField = "DevCode"; this.ddlLocalCtrls.DataValueField = "DevId"; //this.ddlLocalCtrls.DataBind(); }
protected void GetDevs(object sender, EventArgs e) { ddlDev.Items.Clear(); StringBuilder sb = new StringBuilder(); sb.Append("StatId = "); string statid = ddlState.SelectedValue; sb.Append(statid); DataSet ds = _bllDevs.GetList(sb.ToString()); foreach (DataRow dr in ds.Tables[0].Rows) { ListItem item = new ListItem { Text = dr["DevCode"].ToString(), Value = dr["Id"].ToString() }; ddlDev.Items.Add(item); } }
protected void GetDevs() { string statId = Request.Params["sid"]; string strWhere = "StatId =" + statId; DataSet ds = bll.GetList(strWhere); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { ListItem item = new ListItem { Text = dr["DevCode"].ToString(), Value = dr["Id"].ToString() }; controlPreset.Items.Add(item); } devId.Value = controlPreset.SelectedValue; devCode.Value = Server.UrlEncode(controlPreset.SelectedItem.Text); } ESMonitor.BLL.Stats bllstat = new ESMonitor.BLL.Stats(); statName = bllstat.GetModel(int.Parse(statId)).StatName; DevName = controlPreset.SelectedItem.Text; }
private void BindDevs() { int currentPageIndex = int.Parse(labPageIndex.Text); var ds = _bll.GetList(PageSize, currentPageIndex, StrWhere); firstPage.Enabled = true; prevPage.Enabled = true; nextPage.Enabled = true; lastPage.Enabled = true; if (labPageIndex.Text == "1") { firstPage.Enabled = false; prevPage.Enabled = false; } if (labPageIndex.Text == labPageCount.Text) { nextPage.Enabled = false; lastPage.Enabled = false; } Repeater.DataSource = ds.Tables[0]; Repeater.DataBind(); }
protected void GetDevs() { string statId = Request.Params["sid"]; if (statId == "") { return; } ddlDevs.Items.Clear(); StringBuilder sb = new StringBuilder(); sb.Append("StatId = "); sb.Append(statId); DataSet ds = _bllDevs.GetList(sb.ToString()); foreach (DataRow dr in ds.Tables[0].Rows) { ListItem item = new ListItem { Text = dr["DevCode"].ToString(), Value = dr["Id"].ToString() }; ddlDevs.Items.Add(item); } statName = _bllStats.GetModel(int.Parse(statId)).StatName; }
private void GetList(string strWhere) { dataTable = bll.GetList(strWhere).Tables[0]; }