public void displaySalesAndMaintain()
{
model m = new model();
m.open();
DataTable da = m.multipleTableQuery("purchaseordermaintain.*,partstbl.partname,carcompany.carcompanyname,cartype.cartype,carmodel.carmodelname,carsubmodel.carsubmodelname,carregi.contact", "(((((((purchasemaster INNER JOIN purchaseordermaintain ON purchasemaster.purchasemasterid=purchaseordermaintain.purchasemasterid)INNER JOIN partstbl ON purchaseordermaintain.partid=partstbl.partid)INNER JOIN carregi ON purchasemaster.carid=carregi.carid)INNER JOIN carcompany ON partstbl.carcompanyid=carcompany.carcompanyid)INNER JOIN cartype ON partstbl.cartypeid=cartype.cartypeid)INNER JOIN carmodel ON partstbl.carmodelid=carmodel.carmodelid)INNER JOIN carsubmodel ON partstbl.carsubmodelid=carsubmodel.carsubmodelid)", "purchasemaster.isdelete=1 and purchaseordermaintain.isdelete=1 and carcompany.isdelete=1 and cartype.isdelete=1 and carmodel.isdelete=1 and carsubmodel.isdelete=1");
POMRepeaterMaintain.DataSource = da;
POMRepeaterMaintain.DataBind();
m.close();
}
public void showPurchaseMasterDetail()
{
//int ordernogenerate = 0;
model m = new model();
m.open();
DataTable da = m.multipleTableQuery("purchaseordermaintain.*,purchasemaster.remark,partstbl.partname,carregi.contact,carregi.engineno", "(((purchasemaster INNER JOIN purchaseordermaintain ON purchasemaster.purchasemasterid=purchaseordermaintain.purchasemasterid)INNER JOIN partstbl ON purchaseordermaintain.partid=partstbl.partid)INNER JOIN carregi ON purchasemaster.carid=carregi.carid)", "purchaseordermaintain.refno = '" + refrenceno.Text + "' and purchasemaster.ispaymentdone='no' and (purchasemaster.isdelete='1' and purchaseordermaintain.isdelete='1' and partstbl.isdelete='1' and carregi.isdelete='1')");
POMRepeaterMaintain.DataSource = da;
POMRepeaterMaintain.DataBind();
m.close();
}
