private void frmStockout_Load(object sender, EventArgs e) { txtBarcode.MaxLength = 11; txtBarcode.Focus(); pro.FillAutonumber(11, lblTransactionId); txtChange.Visible = false; txtAmountTender.Visible = false; lblamountTender.Visible = false; lblchange.Visible = false; txtTotalAmount.Size = new Size(150, 76); timer1.Start(); pro.ResponsiveDtg(dtgList); }
private void frmTransaction_Load(object sender, EventArgs e) { txtBarcode.MaxLength = 11; pro.sqlselect = "SELECT p.Barcode,ProductName,Category,p.OriginalPrice,DateReceived,ReceivedQty,Unit FROM tblcategory c, tblproduct p,tblstockin s WHERE p.CategoryId=c.CategoryId AND p.Barcode=s.Barcode ORDER BY DateReceived Desc"; pro.LoadData(pro.sqlselect, dtgList); pro.sqlselect = "SELECT OrderId,Supplier,OrderDate,p.Barcode,ProductName,Description,Category,p.OriginalPrice,OrderQty,Unit,OrderTotal " + " FROM tblcategory c, tblproduct p,tblorder o , tblsupplier s " + " WHERE p.CategoryId=c.CategoryId AND p.Barcode=o.Barcode AND o.SupplierId=s.SupplierId AND Rem='Ordered' And p.Barcode = '" + txtBarcode.Text + "'"; pro.LoadData(pro.sqlselect, dtgOrderlist); dtgOrderlist.Columns[0].Visible = false; pro.ResponsiveDtg(dtgOrderlist); }