public void displayOrderMasterAndMaintain()
{
model m = new model();
m.open();
DataTable da = m.multipleTableQuery("ServiceOrderMaster.orderno as SOMOrderno,ServiceOrderMaintain.refno as mrefno,ServiceOrderMaster.refno as SOMrefno,ServiceOrderMaster.*,ServiceOrderMaintain.*,ServiceOrderMaintain.orderno as morderno,ServiceOrderMaster.carid", "(ServiceOrderMaster INNER JOIN ServiceOrderMaintain On ServiceOrderMaster.serviceordermasterid=ServiceOrderMaintain.serviceordermasterid)", "ServiceOrderMaster.isdelete=1 and ServiceOrderMaintain.isdelete=1");
SOMRepeaterMaintain.DataSource = da;
SOMRepeaterMaintain.DataBind();
m.close();
}
public void OrdermasterDisplayMaintainRepeaterBind()
{
//int ordernogenerate = 0;
model m = new model();
m.open();
DataTable da = m.multipleTableQuery("ServiceOrderMaster.orderno as som,carregi.*,ServiceOrderMaintain.*,servicecategory.servicename", "(((ServiceOrderMaintain INNER JOIN ServiceOrderMaster ON ServiceOrderMaintain.serviceordermasterid=ServiceOrderMaster.serviceordermasterid)INNER JOIN servicecategory ON servicecategory.servicecategoryid=ServiceOrderMaintain.servicecategoryid)INNER JOIN carregi ON carregi.carid=ServiceOrderMaster.carid)", "carregi.contact = '" + contact.Text + "' and ServiceOrderMaster.isservicestart='yes' and (ServiceOrderMaintain.isdelete='1' and carregi.isdelete='1' and ServiceOrderMaster.isdelete='1' and servicecategory.isdelete='1')");
SOMRepeaterMaintain.DataSource = da;
SOMRepeaterMaintain.DataBind();
m.close();
}
