private void cmdsearch_Click(object sender, EventArgs e)
{
try
{
ProductServiceTable service = new ProductServiceTable();
DataTable table = service.searchByProductName(txtSearch.Text.Trim());
DataSet ds = new DataSet();
ds.Tables.Add(table);
if (table.Rows.Count != 0)
{
panel1.Visible = true;
dataGrid2.DataSource = ds.Tables["Products"];
TotalRecord = ds.Tables["Products"].Rows.Count;
double tmpPageCount = (double)TotalRecord / PageSize;
PageCount = Convert.ToInt32(Math.Ceiling(tmpPageCount));
// tsRecordCount.Text = TotalRecord.ToString() + " รายการ";
CurrentPage = 1;
RecordToDisplay = 0;
ShowRecord(CurrentPage);
FormatDgvProduct("Products2");
lbltotal.Visible = true;
lbltotal.Text = "จำนวนที่ค้นพบ :" + table.Rows.Count + " รายการ";
}
else
{
panel1.Visible = false;
DataTable tablenull = new DataTable("Products");
DataSet dsnull = new DataSet();
dataGrid1.DataSource = dsnull.Tables["Products"];
lbltotal.Visible = true;
lbltotal.Text = "จำนวนที่ค้นพบ : " + tablenull.Rows.Count + " รายการ";
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void loadData()
{
try
{
ProductServiceTable service = new ProductServiceTable();
DataTable table = service.getDocCheckProductAll(); ;
DataSet ds = new DataSet();
ds.Tables.Add(table);
if (table.Rows.Count != 0)
{
dataGrid1.DataSource = ds.Tables["DocCheckProduct"];
FormatDgvProduct("DocCheckProduct");
label2.Visible = true;
label2.Text = "�ӹǹ���鹾� :" + table.Rows.Count + " ��¡��";
}
else
{
DataTable tablenull = new DataTable("DocCheckProduct");
DataSet dsnull = new DataSet();
dsnull.Tables.Add(tablenull);
dataGrid1.DataSource = dsnull.Tables["DocCheckProduct"];
FormatDgvProduct("DocCheckProduct");
label2.Visible = true;
label2.Text = "�ӹǹ���鹾� : " + tablenull.Rows.Count + " ��¡��";
}
}
catch (Exception ex) {
}
}
private void frmTest4_Load(object sender, EventArgs e)
{
ProductServiceTable service = new ProductServiceTable();
DataTable table = new DataTable("DocCheckProductDetails");
table = service.getDocCheckProductDetailByDCodeDataTable("1");
DataSet ds = new DataSet();
ds.Tables.Add(table);
dataGrid1.DataSource = ds.Tables["DocCheckProductDetails"];
FormatDgvProduct();
}
private void cmdsearch_Click(object sender, EventArgs e)
{
try
{
ProductServiceTable service = new ProductServiceTable();
DataTable table = new DataTable("DocCheckProductDetails");
table = service.getDocCheckProductDetailByDCodeAndPNameTable(idocCheckProduct.Code, this.txtSearch.Text.Trim());
DataSet ds = new DataSet();
ds.Tables.Add(table);
if (table.Rows.Count != 0)
{
dataGrid2.DataSource = ds.Tables["DocCheckProductDetails"];
TotalRecord = ds.Tables["DocCheckProductDetails"].Rows.Count;
double tmpPageCount = (double)TotalRecord / PageSize;
PageCount = Convert.ToInt32(Math.Ceiling(tmpPageCount));
//tsRecordCount.Text = TotalRecord.ToString() + " ��¡��";
CurrentPage = 1;
RecordToDisplay = 0;
ShowRecord(CurrentPage);
FormatDgvProduct("DocCheckProductDetails2");
label2.Visible = true;
label2.Text = "�ӹǹ���鹾� :" + table.Rows.Count + " ��¡��";
if (TotalRecord > 3)
{
panel1.Visible = true;
}
else {
panel1.Visible = false;
}
}
else
{
DataTable tablenull = getDataTableDocCheck();
DataSet dsnull = new DataSet();
dsnull.Tables.Add(tablenull);
dataGrid1.DataSource = tablenull;
label2.Visible = true;
label2.Text = "�ӹǹ���鹾� : 0 ��¡��";
panel1.Visible = false;
}
checkgrid = false;
}
catch (NullReferenceException ex)
{
}
}
