private void frmProduct_Load(object sender, EventArgs e)
{
try
{
txtBarcode.MaxLength = 11;
//pro.FillAutonumber(1, lblProductId);
pro.sql = "Select CategoryId, Category + '[' + CategoryType + ']' as 'CategType' From tblcategory";
pro.FillComboBox(pro.sql, "CategoryId", "CategType", cboCategory);
string categoryid = cboCategory.SelectedValue.ToString();
int id = Int32.Parse(categoryid);
pro.PassingAutonumberLbl(id, lblProductId);
pro.sqlselect = "SELECT ProductId,p.Barcode,ProductName,Description,Category + '[' + CategoryType + ']' as 'Category' ,p.OriginalPrice,MarkupPrice,ProductQty,Unit FROM tblcategory c, tblproduct p WHERE p.CategoryId=c.CategoryId";
pro.LoadData(pro.sqlselect, dtglist);
pro.dtgcolor(dtglist, 7);
useFunc.clearTxt(this);
}
catch
{
}
}
private void clearProduct()
{
txtProduct.Clear();
txtDescription.Clear();
txtPrice.Clear();
txtMarkupPrice.Clear();
pro.sql = "Select CategoryId,Category + '[' + CategoryType + ']' as 'Category' From tblcategory";
pro.FillComboBox(pro.sql, "CategoryId", "Category", cboCategory);
string categoryid = cboCategory.SelectedValue.ToString();
int id = Int32.Parse(categoryid);
pro.PassingAutonumberLbl(id, lblProductId);
}
private void LoadData()
{
prolist.sqlselect = "SELECT OrderDate,p.Barcode,ProductName,Description,Category,p.OriginalPrice,OrderQty,Unit,OrderTotal FROM tblcategory c, tblproduct p,tblorder o WHERE p.CategoryId=c.CategoryId AND p.Barcode=o.Barcode";
prolist.LoadData(prolist.sqlselect, dataGridView1);
txtBarcode.MaxLength = 11;
prolist.FillComboBox("SELECT * FROM tblsupplier", "SupplierId", "Supplier", comboBox1);
clearStockin();
}
private void frmPurchaseOrder_Load(object sender, EventArgs e)
{
pro.sqlselect = "SELECT OrderDate,p.Barcode,ProductName,Description,Category,p.OriginalPrice,OrderQty,Unit,OrderTotal FROM tblcategory c, tblproduct p,tblorder o WHERE p.CategoryId=c.CategoryId AND p.Barcode=o.Barcode";
pro.LoadData(pro.sqlselect, dtgList);
txtBarcode.MaxLength = 11;
pro.FillComboBox("SELECT * FROM tblsupplier", "SupplierId", "Supplier", comboBox1);
clearStockin();
}