protected void GrDelete(object sender, CommandEventArgs e)
        {
            int nPageNumber             = int.Parse(txtPageNumber.Text);
            int nPageSize               = int.Parse(txtPageSize.Text);
            SessionUserLogin nUserLogin = (SessionUserLogin)Session["UserLogin"];

            nUserLogin.CheckRole("CU0014");
            if (!nUserLogin.Role.Del)
            {
                Response.Write("<script >alert('Bạn không có quyền xóa danh mục này!')</script>");
            }
            else
            {
                try
                {
                    int mKey = int.Parse(e.CommandArgument.ToString());
                    CooperativePurchasing_Info info = new CooperativePurchasing_Info(mKey);
                    //if ((DateTime.Now - info.Datetime).TotalDays > 7)
                    //{
                    //    Response.Write("<script >alert('Dữ liệu đã quá 7 ngày, không được phép xóa!')</script>");
                    //}
                    //else
                    {
                        info.Delete();
                        DataTable nTable  = CooperativePurchasing_Data.GetList(nPageSize, nPageNumber, Session["CooperativeKey"].ToInt());
                        DateTime  dtfrom  = DateTime.ParseExact(txtfromDatetime.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
                        DateTime  dtto    = DateTime.ParseExact(txttoDatetime.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
                        DataTable nTable2 = CooperativePurchasing_Data.GetListSale(dtfrom, dtto, nPageSize, nPageNumber, Session["CooperativeKey"].ToInt());
                        if (nTable.Rows.Count == 0)
                        {
                            nTable.Rows.Add("", DateTime.Now, "", 0, 0, 0, "", DateTime.Now, "", 0, 0, 0, "");
                        }
                        if (nTable2.Rows.Count == 0)
                        {
                            nTable2.Rows.Add(0, DateTime.Now, "", 0, 0, "", 0, 0, 0, "");
                        }
                        GV_HarvestedForSale.DataSource = nTable;
                        GV_HarvestedForSale.DataBind();
                        ListSale.DataSource = nTable2;
                        ListSale.DataBind();
                        LoadPages();
                    }
                }
                catch
                {
                    Response.Write("<script >alert('Có lỗi gì đó vui lòng thử lại!')</script>");
                }
            }
        }
        protected void cmdView_Click1(object sender, ImageClickEventArgs e)
        {
            //txtPageNumber.Text = "1";
            //int nPageNumber = int.Parse(txtPageNumber.Text);
            //int nPageSize = int.Parse(txtPageSize.Text);
            //DateTime dtfrom = DateTime.ParseExact(txtfromDatetime.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
            //DateTime dtto = DateTime.ParseExact(txttoDatetime.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
            //DataTable nTable = CooperativePurchasing_Data.GetList(dtfrom, dtto, Convert.ToInt16(Session["EmployeeKey"]), nPageSize, nPageNumber, DDLSeeds.SelectedValue);
            //if (nTable.Rows.Count == 0)
            //{
            //    nTable.Rows.Add(0, null, "", 0, 0, "", 0, "", 0, "");
            //}
            //GV_HarvestedForSale.DataSource = nTable;
            //GV_HarvestedForSale.DataBind();
            //LoadPages();
            int nPageNumber = int.Parse(txtPageNumber.Text);
            int nPageSize   = int.Parse(txtPageSize.Text);

            Session["dtfrom"] = txtfromDatetime.Text;
            Session["dtto"]   = txttoDatetime.Text;
            DateTime  dtfrom  = DateTime.ParseExact(txtfromDatetime.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
            DateTime  dtto    = DateTime.ParseExact(txttoDatetime.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
            DataTable nTable  = CooperativePurchasing_Data.GetList(nPageSize, nPageNumber, Session["CooperativeKey"].ToInt());
            DataTable nTable2 = CooperativePurchasing_Data.GetListSale(dtfrom, dtto, nPageSize, nPageNumber, Session["CooperativeKey"].ToInt());

            if (nTable.Rows.Count == 0)
            {
                nTable.Rows.Add("", DateTime.Now, "", 0, 0, 0, "", DateTime.Now, "", 0, 0, 0, "");
            }
            if (nTable2.Rows.Count == 0)
            {
                nTable2.Rows.Add(0, DateTime.Now, "", 0, 0, "", 0, 0, 0, "");
            }
            GV_HarvestedForSale.DataSource = nTable;
            ListSale.DataSource            = nTable2;
            ListSale.DataBind();
            GV_HarvestedForSale.DataBind();
            DateTime dt = DateTime.Now;

            txtfromDatetime.Text = "01/" + DateTime.Now.ToString("MM/yyyy");
            txttoDatetime.Text   = DateTime.Now.ToString("dd/MM/yyyy");
            LoadPages();
            LoadPages2();
        }
        public void LoadData()
        {
            int nPageNumber = int.Parse(txtPageNumber.Text);
            int nPageSize   = int.Parse(txtPageSize.Text);

            txtfromDatetime.Text = "01/" + DateTime.Now.ToString("MM/yyyy");
            txttoDatetime.Text   = DateTime.Now.ToString("dd/MM/yyyy");
            DateTime dtfrom;
            DateTime dtto;

            if (Session["dtfrom"] != null)
            {
                dtfrom = DateTime.ParseExact(Session["dtfrom"].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
                dtto   = DateTime.ParseExact(Session["dtto"].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
            }
            else
            {
                dtfrom = DateTime.ParseExact(txtfromDatetime.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
                dtto   = DateTime.ParseExact(txttoDatetime.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
            }
            DataTable nTable  = CooperativePurchasing_Data.GetList(nPageSize, nPageNumber, Session["CooperativeKey"].ToInt());
            DataTable nTable2 = CooperativePurchasing_Data.GetListSale(dtfrom, dtto, nPageSize, nPageNumber, Session["CooperativeKey"].ToInt());

            if (nTable.Rows.Count == 0)
            {
                nTable.Rows.Add("", DateTime.Now, "", 0, 0, 0, "", DateTime.Now, "", 0, 0, 0, "");
            }
            if (nTable2.Rows.Count == 0)
            {
                nTable2.Rows.Add(0, DateTime.Now, "", 0, 0, "", 0, 0, 0, "");
            }
            GV_HarvestedForSale.DataSource = nTable;
            ListSale.DataSource            = nTable2;
            ListSale.DataBind();

            GV_HarvestedForSale.DataBind();
            DateTime dt = DateTime.Now;

            txtfromDatetime.Text = "01/" + DateTime.Now.ToString("MM/yyyy");
            txttoDatetime.Text   = DateTime.Now.ToString("dd/MM/yyyy");
            LoadPages();
        }
        protected void cmdView_Click1(object sender, ImageClickEventArgs e)
        {
            txtPageNumber.Text = "1";
            int nPageNumber = int.Parse(txtPageNumber.Text);
            int nPageSize   = int.Parse(txtPageSize.Text);

            Session["dtfrom"] = txtfromDatetime.Text;
            Session["dtto"]   = txttoDatetime.Text;
            DateTime  dtfrom = DateTime.ParseExact(txtfromDatetime.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
            DateTime  dtto   = DateTime.ParseExact(txttoDatetime.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
            DataTable nTable = CooperativeSale_Data.GetList(dtfrom, dtto, nPageSize, nPageNumber, Session["CooperativeKey"].ToInt());

            if (nTable.Rows.Count == 0)
            {
                nTable.Rows.Add("", 0, "", DateTime.Now, "", 0, "", 0);
            }
            ListSale.DataSource = nTable;
            ListSale.DataBind();
            LoadPages();
        }
        public void LoadData()
        {
            txtfromDatetime.Text = "01/01/2013";
            txttoDatetime.Text   = DateTime.Now.ToString("dd/MM/yyyy");
            //LoadDataToToolboxWeb.DropDown_DDL(DDLSeeds, "Select SeedsKey,SeedsName from PUL_Seeds where SeedsKey IN (Select SeedsKey FROM PUL_CheckEquipment WHERE MemberKey = " + Convert.ToInt16(Session["EmployeeKey"]) + ")", false);
            int       nPageNumber = int.Parse(txtPageNumber.Text);
            int       nPageSize   = int.Parse(txtPageSize.Text);
            DateTime  dtfrom      = DateTime.ParseExact(txtfromDatetime.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
            DateTime  dtto        = DateTime.ParseExact(txttoDatetime.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
            DataTable nTable      = CooperativeSale_Data.GetList(dtfrom, dtto, nPageSize, nPageNumber, Session["CooperativeKey"].ToInt());

            ListSale.DataSource = nTable;
            if (nTable.Rows.Count == 0)
            {
                nTable.Rows.Add("", 0, "", DateTime.Now, "", 0, "", 0);
            }
            ListSale.DataBind();
            DateTime dt = DateTime.Now;

            LoadPages();
        }