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