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 = CooperativeSale_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 cmdView_Click1(object sender, ImageClickEventArgs e)
{
txtPageNumber.Text = "1";
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 = CooperativeSale_Data.GetList(dtfrom, dtto, nPageSize, nPageNumber, Session["CooperativeKey"].ToInt());
if (nTable.Rows.Count == 0)
{
nTable.Rows.Add("", 0, "", DateTime.Now, "", 0, "", 0);
}
ListSale.DataSource = nTable;
ListSale.DataBind();
LoadPages();
}
public void LoadData()
{
txtfromDatetime.Text = "01/01/2013";
txttoDatetime.Text = DateTime.Now.ToString("dd/MM/yyyy");
//LoadDataToToolboxWeb.DropDown_DDL(DDLSeeds, "Select SeedsKey,SeedsName from PUL_Seeds where SeedsKey IN (Select SeedsKey FROM PUL_CheckEquipment WHERE MemberKey = " + Convert.ToInt16(Session["EmployeeKey"]) + ")", false);
int nPageNumber = int.Parse(txtPageNumber.Text);
int nPageSize = int.Parse(txtPageSize.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 = CooperativeSale_Data.GetList(dtfrom, dtto, nPageSize, nPageNumber, Session["CooperativeKey"].ToInt());
ListSale.DataSource = nTable;
if (nTable.Rows.Count == 0)
{
nTable.Rows.Add("", 0, "", DateTime.Now, "", 0, "", 0);
}
ListSale.DataBind();
DateTime dt = DateTime.Now;
LoadPages();
}
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("CU0015");
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());
CooperativeSale_Info info = new CooperativeSale_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 = CooperativeSale_Data.GetList(nPageSize, nPageNumber, Session["CooperativeKey"].ToInt());
if (nTable.Rows.Count == 0)
{
nTable.Rows.Add("", 0, "", DateTime.Now, "", 0, "", 0);
}
ListSale.DataSource = nTable;
ListSale.DataBind();
LoadPages();
}
}
catch
{
Response.Write("<script >alert('Có lỗi gì đó vui lòng thử lại!')</script>");
}
}
}
