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];
}