private void FrmCtReport_Load(object sender, EventArgs e)
{
lsvDt.LabelWrap = true;
// Add Columns
lsvDt.Columns.Add("ลำดับ", 70, HorizontalAlignment.Left);
lsvDt.Columns.Add("รหัสสาขา", 100, HorizontalAlignment.Left);
lsvDt.Columns.Add("ชื่อสาขา", 130, HorizontalAlignment.Left);
lsvDt.Columns.Add("ชื่อลูกค้า", 120, HorizontalAlignment.Left);
lsvDt.Columns.Add("ที่อยู่", 130, HorizontalAlignment.Left);
lsvDt.Columns.Add("หมายเลขโทรศัพท์", 70, HorizontalAlignment.Left);
lsvDt.Columns.Add("วันเดือนปีเกิด", 100, HorizontalAlignment.Left);
lsvDt.Columns.Add("อายุ", 130, HorizontalAlignment.Left);
lsvDt.Columns.Add("เพศ", 120, HorizontalAlignment.Left);
lsvDt.Columns.Add("ซื้อล่าสุด", 130, HorizontalAlignment.Left);
lsvDt.Width = this.Width - 30;
lsvDt.Height = pnlNavigate.Top - 100;
//pnlNRPP.Left = this.Width - pnlNRPP.Width - 30;
LsvPageGlobVar.NRPP = 25;
LsvPageGlobVar.ConStr = _Sever_CMDFX;
LsvPageFunc.DbConnection();
LsvPageGlobVar.Page = 1;
pb.Visible = true;
backgroundWorker1.RunWorkerAsync();
lblInfo.Text = "Record Shown: " + LsvPageGlobVar.RecStart + " to " + LsvPageGlobVar.RecEnd + " Page " + LsvPageGlobVar.Page + " of " + LsvPageGlobVar.TotalPages;
}
private void btnPrev_Click(object sender, EventArgs e)
{
if (LsvPageGlobVar.Page > 1)
{
LsvPageGlobVar.Page--;
}
LsvPageFunc.FillLsvData(LsvPageGlobVar.sqlDataTable, lsvDt, 0);
lblInfo.Text = "Record Shown: " + LsvPageGlobVar.RecStart + " to " + LsvPageGlobVar.RecEnd + " Page " + LsvPageGlobVar.Page + " of " + LsvPageGlobVar.TotalPages;
}
private void BackgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
// Finish
pb.Visible = false;
try
{
//lsvSearch.addDataWithDataset(Table, false, false);
LsvPageFunc.FillLsvData(LsvPageGlobVar.sqlDataTable, lsvDt, 0);
lblInfo.Text = "Record Shown: " + LsvPageGlobVar.RecStart + " to " + LsvPageGlobVar.RecEnd + " Page " + LsvPageGlobVar.Page + " of " + LsvPageGlobVar.TotalPages;
//button_Select.Enabled = true;
pb.Visible = false;
}
catch
{
//button_Select.Enabled = true;
}
}
private void BackgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
LsvPageFunc.ExecSQLQry(_SQLLOAD);
}
