예제 #1
0
        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());
        }
예제 #2
0
        protected void btnDel_Click(object sender, EventArgs e)
        {
            if (grid1.SelectedRowIndexArray != null && grid1.SelectedRowIndexArray.Length > 0)
            {
                string strSelectID = "0";
                for (int i = 0, count = grid1.SelectedRowIndexArray.Length; i < count; i++)
                {
                    int rowIndex = grid1.SelectedRowIndexArray[i];
                    foreach (object key in grid1.DataKeys[rowIndex])
                    {
                        strSelectID = key.ToString();
                    }
                }
                #region  除逻辑

                zlzw.BLL.StoreStatisticsListBLL     storeStatisticsListBLL   = new zlzw.BLL.StoreStatisticsListBLL();
                zlzw.Model.StoreStatisticsListModal storeStatisticsListModal = storeStatisticsListBLL.GetModel(int.Parse(Get_StoreStatisticsID(strSelectID)));
                storeStatisticsListModal.IsEnable = 0;
                storeStatisticsListBLL.Update(storeStatisticsListModal);
                StoreStatisticsList_BindGrid();

                #endregion
            }
            else
            {
                return;
            }
        }
예제 #3
0
        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();
        }
예제 #4
0
        /// <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();
            }
        }
예제 #6
0
        protected void btnSaveRefresh_Click(object sender, EventArgs e)
        {
            if (Request.QueryString["Type"] == "1")
            {
                //编辑保存
                zlzw.Model.StoreStatisticsListModal storeStatisticsListModal = new zlzw.Model.StoreStatisticsListModal();
                storeStatisticsListModal.StoreDictionaryKey = drpStoreDictionaryKey.SelectedValue;
                storeStatisticsListModal.DictionaryKey      = drpDictionaryKey.SelectedValue;
                if (txbStoreStatisticsDate.Text == "")
                {
                    storeStatisticsListModal.StoreStatisticsDate = DateTime.Parse(ViewState["StoreStatisticsDate"].ToString());
                }
                else
                {
                    storeStatisticsListModal.StoreStatisticsDate = DateTime.Parse(txbStoreStatisticsDate.Text.ToString());
                }

                storeStatisticsListModal.IndexValue           = txbIndexValue.Text;
                storeStatisticsListModal.StoreStatisticsOrder = int.Parse(txbStoreStatisticsOrder.Text);
                storeStatisticsListModal.IsEnable             = 1;
                storeStatisticsListModal.PublishDate          = DateTime.Parse(ViewState["PublishDate"].ToString());
                storeStatisticsListModal.StoreStatisticsGUID  = new Guid(ViewState["StoreStatisticsGUID"].ToString());
                storeStatisticsListModal.StoreStatisticsID    = int.Parse(Get_StoreStatisticsID(Request.QueryString["value"]));
                zlzw.BLL.StoreStatisticsListBLL storeStatisticsListBLL = new zlzw.BLL.StoreStatisticsListBLL();
                storeStatisticsListBLL.Update(storeStatisticsListModal);
            }
            else
            {
                //添加保存

                zlzw.Model.StoreStatisticsListModal storeStatisticsListModal = new zlzw.Model.StoreStatisticsListModal();
                storeStatisticsListModal.StoreDictionaryKey   = drpStoreDictionaryKey.SelectedValue;
                storeStatisticsListModal.DictionaryKey        = drpDictionaryKey.SelectedValue;
                storeStatisticsListModal.StoreStatisticsDate  = DateTime.Parse(txbStoreStatisticsDate.Text.ToString());
                storeStatisticsListModal.IndexValue           = txbIndexValue.Text;
                storeStatisticsListModal.StoreStatisticsOrder = int.Parse(txbStoreStatisticsOrder.Text);
                storeStatisticsListModal.IsEnable             = 1;
                storeStatisticsListModal.PublishDate          = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"));
                storeStatisticsListModal.StoreStatisticsGUID  = System.Guid.NewGuid();
                zlzw.BLL.StoreStatisticsListBLL storeStatisticsListBLL = new zlzw.BLL.StoreStatisticsListBLL();
                storeStatisticsListBLL.Add(storeStatisticsListModal);
            }

            // 2. Close this window and Refresh parent window
            PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
        }
예제 #7
0
        private void LoadData(string strType)
        {
            if (strType == "1")
            {
                string strID = Request.QueryString["value"];//操作ID
                zlzw.BLL.StoreStatisticsListBLL     storeStatisticsListBLL   = new zlzw.BLL.StoreStatisticsListBLL();
                zlzw.Model.StoreStatisticsListModal storeStatisticsListModal = storeStatisticsListBLL.GetModel(int.Parse(Get_StoreStatisticsID(strID)));
                drpStoreDictionaryKey.SelectedValue = storeStatisticsListModal.StoreDictionaryKey;             //所属店铺
                drpDictionaryKey.SelectedValue      = storeStatisticsListModal.DictionaryKey;                  //所属指标
                txbStoreStatisticsDate.Text         = storeStatisticsListModal.StoreStatisticsDate.ToString(); //评比日期
                txbIndexValue.Text           = storeStatisticsListModal.IndexValue;                            //指标数值
                txbStoreStatisticsOrder.Text = storeStatisticsListModal.StoreStatisticsOrder.ToString();       //排序序号

                ViewState["StoreStatisticsDate"] = storeStatisticsListModal.StoreStatisticsDate.ToString();
                ViewState["PublishDate"]         = storeStatisticsListModal.PublishDate.ToString();
                ViewState["StoreStatisticsGUID"] = storeStatisticsListModal.StoreStatisticsGUID.ToString();
                ToolbarText2.Text = "编辑一个指标评比";
            }
            btnClose.OnClientClick = ActiveWindow.GetConfirmHideReference();
        }