private string Get_StoreStatisticsID(string strStoreStatisticsGUID) { zlzw.BLL.StoreStatisticsListBLL storeStatisticsListBLL = new zlzw.BLL.StoreStatisticsListBLL(); DataTable dt = storeStatisticsListBLL.GetList("StoreStatisticsGUID='" + strStoreStatisticsGUID + "'").Tables[0]; return(dt.Rows[0]["StoreStatisticsID"].ToString()); }
private void StoreStatisticsList_BindGrid() { zlzw.BLL.StoreStatisticsListBLL storeStatisticsListBLL = new zlzw.BLL.StoreStatisticsListBLL(); DataTable dt = storeStatisticsListBLL.GetList(grid1.PageSize, grid1.PageIndex + 1, "*", "PublishDate", 0, "desc", "IsEnable=1").Tables[0]; grid1.DataSource = dt; grid1.DataBind(); }
/// <summary> /// 获取总页数 /// </summary> /// <returns></returns> private int Get_StoreStatisticsListTotalCount() { zlzw.BLL.StoreStatisticsListBLL storeStatisticsListBLL = new zlzw.BLL.StoreStatisticsListBLL(); DataTable dt = storeStatisticsListBLL.GetList("IsEnable=1").Tables[0]; if (dt.Rows.Count > 0) { return(dt.Rows.Count); } else { return(0); } }
private void Load_IndicatorsList() { zlzw.BLL.DictionaryListBLL dictionaryListBLL = new zlzw.BLL.DictionaryListBLL(); DataTable dt01 = dictionaryListBLL.GetList("IsEnable=1 and DictionaryCategory='Indicators'").Tables[0]; for (int nCount = 0; nCount < dt01.Rows.Count; nCount++) { if (Request.QueryString["id"] == null) { if (nCount == 0) { labMenuList.Text += "<a class='h_hover2' href='StoreStatisticsList.aspx?id=" + dt01.Rows[nCount]["DictionaryKey"].ToString() + "'>" + dt01.Rows[nCount]["DictionaryValue"].ToString() + "</a>"; } else { labMenuList.Text += "<a href='StoreStatisticsList.aspx?id=" + dt01.Rows[nCount]["DictionaryKey"].ToString() + "'>" + dt01.Rows[nCount]["DictionaryValue"].ToString() + "</a>"; } } else { if (dt01.Rows[nCount]["DictionaryKey"].ToString() == Request.QueryString["id"]) { labMenuList.Text += "<a class='h_hover2' href='StoreStatisticsList.aspx?id=" + dt01.Rows[nCount]["DictionaryKey"].ToString() + "'>" + dt01.Rows[nCount]["DictionaryValue"].ToString() + "</a>"; } else { labMenuList.Text += "<a href='StoreStatisticsList.aspx?id=" + dt01.Rows[nCount]["DictionaryKey"].ToString() + "'>" + dt01.Rows[nCount]["DictionaryValue"].ToString() + "</a>"; } } } if (Request.QueryString["id"] != null) { zlzw.BLL.StoreStatisticsListBLL storeStatisticsListBLL = new zlzw.BLL.StoreStatisticsListBLL(); DataTable dt = storeStatisticsListBLL.GetList("DictionaryKey='" + Request.QueryString["id"] + "'").Tables[0]; Repeater1.DataSource = dt; Repeater1.DataBind(); } else { zlzw.BLL.StoreStatisticsListBLL storeStatisticsListBLL = new zlzw.BLL.StoreStatisticsListBLL(); DataTable dt = storeStatisticsListBLL.GetList("DictionaryKey='" + dt01.Rows[0]["DictionaryKey"].ToString() + "'").Tables[0]; Repeater1.DataSource = dt; Repeater1.DataBind(); } }