public void LoadData()
{
SessionUserLogin nUserLogin = (SessionUserLogin)Session["UserLogin"];
int nPageNumber = int.Parse(txtPageNumber.Text);
int nPageSize = int.Parse(txtPageSize.Text);
DataTable nTable = Fertilizer_Use_Data.GetList(Convert.ToInt16(Session["EmployeeKey"]), nPageSize, nPageNumber, DDLSeeds.SelectedValue);
if (nTable.Rows.Count == 0)
{
nTable.Rows.Add("", 0, null, "", "", 0, "", "", "", "", "", "", 0);
}
GV_Fertilizer_Use.DataSource = nTable;
GV_Fertilizer_Use.DataBind();
txtfromDatetime.Text = "01/01/2013";
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);
SessionUserLogin nUserLogin = (SessionUserLogin)Session["UserLogin"];
DateTime dtfrom = DateTime.ParseExact(txtfromDatetime.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
DateTime dtto = DateTime.ParseExact(txttoDatetime.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
DataTable nTable = Fertilizer_Use_Data.GetList(dtfrom, dtto, Convert.ToInt16(Session["EmployeeKey"]), nPageSize, nPageNumber, DDLSeeds.SelectedValue);
if (nTable.Rows.Count == 0)
{
nTable.Rows.Add("", 0, null, "", "", 0, "", "", "", "", "", "", 0);
}
GV_Fertilizer_Use.DataSource = nTable;
GV_Fertilizer_Use.DataBind();
LoadPages();
}
protected void LoadPages()
{
int nPageNumber = int.Parse(txtPageNumber.Text);
int nPageSize = int.Parse(txtPageSize.Text);
int nTotalRecord = Fertilizer_Use_Data.Count(Session["EmployeeKey"].ToInt(), DDLSeeds.SelectedValue);
if (nTotalRecord > nPageSize)
{
PageNumbers.Visible = true;
DataTable nTable = TNLibrary.WEB.LoadDataToToolboxWeb.LoadPageSize(nPageSize, nTotalRecord, nPageNumber);
PageNumbers.SelectedIndex = (nPageNumber - 1) - (int.Parse(nTable.Rows[0][0].ToString()) - 1);
PageNumbers.DataSource = nTable;
PageNumbers.DataBind();
}
else
{
PageNumbers.Visible = false;
}
}
protected void GrDelete(object sender, CommandEventArgs e)
{
SessionUserLogin nUserLogin = (SessionUserLogin)Session["UserLogin"];
int nPageNumber = int.Parse(txtPageNumber.Text);
int nPageSize = int.Parse(txtPageSize.Text);
nUserLogin.CheckRole("CU0003");
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());
Fertilizer_Use_Info info = new Fertilizer_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 = Fertilizer_Use_Data.GetList(Convert.ToInt16(Session["EmployeeKey"]), nPageSize, nPageNumber, DDLSeeds.SelectedValue);
if (nTable.Rows.Count == 0)
{
nTable.Rows.Add("", 0, null, "", "", 0, "", "", "", "", "", "", 0);
}
GV_Fertilizer_Use.DataSource = nTable;
GV_Fertilizer_Use.DataBind();
LoadPages();
}
}
catch
{
Response.Write("<script >alert('Có lỗi gì đó vui lòng thử lại!')</script>");
}
}
}