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