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("CU0005");
            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());
                    Pesticide_Use_Info info = new Pesticide_Use_Info(mKey);
                    if ((DateTime.Now - info.DateTimeUse).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 = Pesticide_Use_Data.GetList(Convert.ToInt16(Session["EmployeeKey"]), nPageSize, nPageNumber, DDLSeeds.SelectedValue);
                        if (nTable.Rows.Count == 0)
                        {
                            nTable.Rows.Add("", "", "", 0, null, "", "", 0, "", "", "", 0);
                        }
                        GV_Pesticide_Use.DataSource = nTable;
                        GV_Pesticide_Use.DataBind();
                        LoadPages();
                    }
                }
                catch
                {
                    Response.Write("<script >alert('Có lỗi gì đó vui lòng thử lại!')</script>");
                }
            }
        }
        protected void LoadInfo(int Key)
        {
            Pesticide_Use_Info info = new Pesticide_Use_Info(Key);

            if (Key == 0)
            {
                DateTime time = DateTime.Now;
                txtDatetime.Text = time.ToString("dd/MM/yyyy");
            }
            else
            {
                txtDatetime.Text = info.DateTimeUse.ToString("dd/MM/yyyy");
            }
            DDLPesticide.Text        = LoadDataToToolboxWeb.GetName("SELECT Trade_Name FROM PUL_Pesticides where PesticideKey = " + info.PesticideKey.ToString());
            txtArea.Text             = info.Area;
            txtDosage.Text           = info.Dosage;
            txtDose.Text             = info.Dose.ToString();
            txtPestName.Text         = info.PestName;
            txtSolution.Text         = info.Solution;
            DDLSeeds.Text            = LoadDataToToolboxWeb.GetName("SELECT SeedsName FROM PUL_Seeds where SeedsKey = (Select SeedsKey from PUL_SeedProcess where SeedProcessKey  = (Select SeedKey from PUL_Pesticide_Use where PesticideUseKey = " + info.PesticideUseKey.ToString() + "))");
            DDLEquipment.Text        = LoadDataToToolboxWeb.GetName("SELECT EquipmentName FROM PUL_Equipment where EquipmentKey = " + info.EquipmentKey.ToString());
            txtQuarantinePeriod.Text = info.QuarantinePeriod;
            DDLUnit.Text             = LoadDataToToolboxWeb.GetName("SELECT Name FROM PUL_Unit where ID = " + info.UnitKey.ToString());
        }