public DataTable selectByPk(String copId) { DataTable dt = new DataTable(); String sql = "select jcl.* " + "From " + jcl.table + " jcl " + "Where jcl." + jcl.pkField + " ='" + copId + "' "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectByPk(String copId) { DataTable dt = new DataTable(); String sql = "select bill.* " + "From " + dtr.table + " bill " + //"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " + "Where ett." + dtr.pkField + " ='" + copId + "' "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectByCusId(String copId) { DataTable dt = new DataTable(); String sql = "select bll.* " + "From " + rcp.table + " bll " + //"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " + "Where bll." + rcp.job_id + " ='" + copId + "' and " + rcp.active + "='1' "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select expC.* " + "From " + expndT.table + " expC " + " " + "Where expC." + expndT.active + " ='1' "; dt = conn.selectData(conn.conn, sql); return dt; }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select iss.* " + "From " + iss.table + " iss " + " " + "Where iss." + iss.active + " ='1' "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select trk.* " + "From " + trk.table + " trk " + " " + "Where trk." + trk.active + " ='1' "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select ugw.* " + "From " + ugw.table + " ugw " + " " + "Where ugw." + ugw.active + " ='1' "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select btax.* " + "From " + btax.table + " btax " + " " + "Where btax." + btax.active + " ='1' "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select ett.* " + "From " + ett.table + " ett " + " " + "Where ett." + ett.active + " ='1' "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select jdv.* " + "From " + jdv.table + " jdv " + " " + "Where jdv." + jdv.active + " ='1' "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select pti.* " + "From " + pti.table + " pti " + " " + "Where pti." + pti.active + " ='1' "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select cop.* " + "From " + cusR.table + " cop " + " " + "Where cop." + cusR.active + " ='1' "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select ban.* " + "From " + expnP.table + " ban " + " " + "Where ban." + expnP.active + " ='1' "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select rsc.* " + "From " + rsc.table + " rsc " + " " + "Where rsc." + rsc.active + " ='1' " + "Order By rsc." + rsc.reserve_cash_id; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select itmGrp.* " + "From " + ftt.table + " itmGrp " + " "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectJobNoImport() { year = DateTime.Now.Year.ToString(); DataTable dt = new DataTable(); String sql = ""; sql = "select job.jobno, job.cusrefno, job.jobdate, job.imdate, job.bl, job.importer, job.vslname, job.housebl,job.bl " + ", imp.tname, job4.im_ename, job.vslnamerem, couo.name as origin, couc.name as consignmnt, job.loaded, plc.name as loaded_name " + ", job.released, plcr.name as name_repleased, job.out_released, plco.name as name_out_repleased, job.approval, plca.name as name_approval " + "from job_" + year + " as job " + "left join importer imp on imp.code = job.importer " + "left join job_4_" + year + " job4 on job4.jobno = job.jobno " + "left join country couo on couo.code = job.origin " + "left join country couc on couc.code = job.consignmnt " + "left join place plc on plc.code = job.loaded " + "left join place plcr on plcr.code = job.released " + "left join place plco on plco.code = job.out_released " + "left join place plca on plca.code = job.approval " + "Where job.cusrefno is null or job.cusrefno = '' " + "Order By job.jobno desc "; dt = conn.selectData(conn.connIm, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select expC.* " + "From " + rsp.table + " expC " + " " + "Where expC." + rsp.active + " ='1' " + "Order By expC." + rsp.reserve_pay_id; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectByEccStfid(String eccDoc, String stfId) { DataTable dt = new DataTable(); String whereecc = ""; if (!eccDoc.Equals("")) { whereecc = " and erf." + erf.ecc_doc + " = '" + eccDoc + "'"; } String sql = "select erf.* " + "From " + erf.table + " erf " + //"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " + "Where erf." + erf.status_appv + " ='0' and erf." + erf.active + "='1' and erf." + erf.pay_staff_id + "='" + stfId + "'" + whereecc; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select cem.* " + "From " + cem.table + " cem " + " " + "Where cem." + cem.active + " ='1' and cem." + cem.status_combo + "='combo'" + ""; dt = conn.selectData(conn.conn, sql); return(dt); }