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(); }