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_Other_Data.GetList(nPageSize, nPageNumber, Session["CooperativeKey"].ToInt());
if (nTable.Rows.Count == 0)
{
nTable.Rows.Add("", 0, "", 0, 0, 0, 0, DateTime.Now, "", "", 0);
}
GV_HarvestedForSale.DataSource = nTable;
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 LoadPages()
{
int nPageNumber = int.Parse(txtPageNumber.Text);
int nPageSize = int.Parse(txtPageSize.Text);
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);
}
int nTotalRecord = CooperativePurchasing_Other_Data.Count(dtfrom, dtto, Session["CooperativeKey"].ToInt());
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)
{
int nPageNumber = int.Parse(txtPageNumber.Text);
int nPageSize = int.Parse(txtPageSize.Text);
SessionUserLogin nUserLogin = (SessionUserLogin)Session["UserLogin"];
nUserLogin.CheckRole("CU0016");
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_Other_Info info = new CooperativePurchasing_Other_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_Other_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);
if (nTable.Rows.Count == 0)
{
nTable.Rows.Add("", 0, "", 0, 0, 0, 0, DateTime.Now, "", "", 0);
}
GV_HarvestedForSale.DataSource = nTable;
GV_HarvestedForSale.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)
{
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_Other_Data.GetList(nPageSize, nPageNumber, Session["CooperativeKey"].ToInt());
if (nTable.Rows.Count == 0)
{
nTable.Rows.Add("", 0, "", 0, 0, 0, 0, DateTime.Now, "", "", 0);
}
GV_HarvestedForSale.DataSource = nTable;
GV_HarvestedForSale.DataBind();
DateTime dt = DateTime.Now;
txtfromDatetime.Text = "01/" + DateTime.Now.ToString("MM/yyyy");
txttoDatetime.Text = DateTime.Now.ToString("dd/MM/yyyy");
LoadPages();
}
