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()); }