public DataTable selectByPk(String copId)
{
DataTable dt = new DataTable();
String sql = "select dtrOld.* " +
"From " + dtrOld.table + " dtrOld " +
"Where dtrOld." + dtrOld.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectByPk(String pttId)
{
DataTable dt = new DataTable();
String sql = "select lformDay1.* " +
"From " + lformDay1.table + " lformDay1 " +
"Where lformDay1." + lformDay1.pkField + " ='" + pttId + "' ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectByPttId(String copId)
{
DataTable dt = new DataTable();
String sql = "select note.* " +
"From " + note.table + " note " +
"Where note." + note.t_patient_id + " ='" + copId + "' and note." + note.active + "='1'";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectByPk(String pttId)
{
DataTable dt = new DataTable();
String sql = "select oPkg.* " +
"From " + oPkg.table + " oPkg " +
"Where oPkg." + oPkg.pkField + " ='" + pttId + "' ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectDistinctByRemark()
{
DataTable dt = new DataTable();
String sql = "select distinct orreq.remark " +
"From " + orreq.table + " orreq " +
"Where orreq." + orreq.active + "='1' ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectByPk(String pttId)
{
DataTable dt = new DataTable();
String sql = "select eggsd.* " +
"From " + eggsd.table + " eggsd " +
"Where eggsd." + eggsd.pkField + " ='" + pttId + "' ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectByPk(String copId)
{
DataTable dt = new DataTable();
String sql = "select jobpxD.* " +
"From " + jobpxD.table + " jobpxD " +
"Where jobpxD." + jobpxD.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectByPk(String copId)
{
DataTable dt = new DataTable();
String sql = "select stf.* " +
"From " + itm.table + " stf " +
"Where stf." + itm.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectByPk(String copId)
{
DataTable dt = new DataTable();
String sql = "select bsp.* " +
"From " + bsp.table + " bsp " +
"Where bsp." + bsp.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectByCreditCardName()
{
DataTable dt = new DataTable();
String sql = "select obilg." + obilg.ID + ",obilg." + obilg.Name + " " +
"From " + obilg.table + " obilg " +
"Where active = '1' " +
"Order By obilg." + obilg.Name;
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectByCashCardName()
{
DataTable dt = new DataTable();
String sql = "select oca." + oca.CashID + ",oca." + oca.CashName + " " +
"From " + oca.table + " oca " +
"Where active = '1' " +
"Order By oca." + oca.CashID;
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectByLabOrderId(String copId)
{
DataTable dt = new DataTable();
String sql = "select note.*, LabItem.LName " +
"From " + log.table + " note " +
"Left Join LabItem on note." + log.lab_id + "= LabItem.LID " +
"Where note." + log.lab_order_id + " ='" + copId + "' and note." + log.active + "='1'";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectAll()
{
DataTable dt = new DataTable();
String sql = "select fbg.* " +
"From " + labG.table + " fbg " +
" " +
"Where fbg." + labG.active + " ='1' ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectAll()
{
DataTable dt = new DataTable();
String sql = "select pfx.* " +
"From " + pfx.table + " pfx " +
" " +
"Where pfx." + pfx.active + " ='1' ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectAll()
{
DataTable dt = new DataTable();
String sql = "select deposit.* ,pck.PackageName " +
"From " + deposit.table + " deposit " +
"Left Join PackageHeader pck On deposit.pck_id = pck.PCKID " +
" Where deposit." + deposit.active + " ='1' " +
"Order By deposit.deposit_date ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectAll()
{
DataTable dt = new DataTable();
String sql = "select dept.* " +
"From " + dept.table + " dept " +
" " +
"Where dept." + dept.active + " ='1' ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectAll()
{
DataTable dt = new DataTable();
String sql = "select agnO.* " +
" From " + oAgn.table + " agnO " +
"Where " + oAgn.active + "='1'" +
"Order By " + oAgn.agentname + " ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectAll()
{
DataTable dt = new DataTable();
String sql = "select dwithdraw.* " +
"From " + dwithdraw.table + " dwithdraw " +
//"Left Join f_patient_prefix pfx On stf.prefix_id = pfx.f_patient_prefix_id " +
" Where dwithdraw." + dwithdraw.active + " ='1' " +
"Order By dwithdraw.withdraw_date ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectAll()
{
DataTable dt = new DataTable();
String sql = "select act.* " +
"From " + act.table + " act " +
//"Left Join f_patient_prefix pfx On stf.prefix_id = pfx.f_patient_prefix_id " +
" Where act." + act.active + " ='1' " +
"Order By act.credit_bank_name ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectAll()
{
DataTable dt = new DataTable();
String sql = "select fpn.* " +
"From " + frac.table + " fpn " +
" " +
"Where fpn." + frac.active + " ='1' ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectAll()
{
DataTable dt = new DataTable();
String sql = "select crl.* " +
"From " + crl.table + " crl " +
" " +
"Where crl." + crl.active + " ='1' ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectAll()
{
DataTable dt = new DataTable();
String sql = "select oranes.* " +
"From " + oranes.table + " oranes " +
" " +
"Where oranes." + oranes.active + " ='1' ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectAll()
{
DataTable dt = new DataTable();
String sql = "select * " +
"From " + stkn.table + " dsc " +
//"Left Join f_patient_prefix pfx On stf.prefix_id = pfx.f_patient_prefix_id " +
" Where dsc." + stkn.active + " ='1' " +
"Order By sort1 ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectAll()
{
DataTable dt = new DataTable();
String sql = "select stkc.* " +
"From " + stkc.table + " stkc " +
" " +
"Where stkc." + stkc.active + " ='1' " +
"Order By stkc." + stkc.rec_draw_sale_date + ",stkc." + stkc.status_rec_draw + ",stkc." + stkc.stock_id;
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectAll()
{
DataTable dt = new DataTable();
String sql = "select * " +
"From " + lbM.table + " dgs " +
//"Left Join f_patient_prefix pfx On stf.prefix_id = pfx.f_patient_prefix_id " +
" Where dgs." + lbM.active + " ='1' " +
"Order By lab_unit_id ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectAll()
{
DataTable dt = new DataTable();
String sql = "select dgss.*, dgs.doc_group_name " +
"From " + dgss.table + " dgss " +
"Left Join b_doc_group_scan dgs On dgs.doc_group_id = dgss.doc_group_id " +
" Where dgss." + dgss.active + " ='1' " +
"Order By dgss.doc_group_id, dgss.doc_group_sub_id ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectByPk(String copId)
{
DataTable dt = new DataTable();
String sql = "select pttI.* " +
"From " + pttI.table + " pttI " +
"Where pttI." + pttI.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public LabPrescription selectByPk(String id)
{
LabPrescription cop1 = new LabPrescription();
DataTable dt = new DataTable();
String sql = "select labPresc.* " +
"From " + lPresc.table + " labPresc " +
//"Left Join f_patient_prefix pfx On stf.prefix_id = pfx.f_patient_prefix_id " +
"Where labPresc." + lPresc.pkField + " ='" + id + "' " +
"Order By presc_id ";
dt = conn.selectData(conn.conn, sql);
cop1 = setPrescription(dt);
return(cop1);
}
public TemplateDrug selectByPk(String id)
{
TemplateDrug cop1 = new TemplateDrug();
DataTable dt = new DataTable();
String sql = "select tdrug.* " +
"From " + tdrug.table + " tdrug " +
//"Left Join f_patient_prefix pfx On stf.prefix_id = pfx.f_patient_prefix_id " +
"Where tdrug." + tdrug.pkField + " ='" + id + "' " +
"Order By tdrug.sort1 ";
dt = conn.selectData(conn.conn, sql);
cop1 = setAccCashTransfer(dt);
return(cop1);
}
public DataTable selectByDate1(String date)
{
DataTable dt = new DataTable();
String sql = "select ptt." + pttO.PID + ",ptt." + pttO.PIDS + ",CONCAT(ptt." + pttO.PName + ",' ',ptt." + pttO.PSurname + ") as name,ptt." + pttO.EmergencyPersonalContact + " " +
"From " + pttO.table + " ptt " +
"Left join f_patient_prefix fpp on fpp.f_patient_prefix_id = ptt.f_patient_prefix_id " +
"Where ptt." + pttO.OName + " >='" + date + " 00:00:00' and ptt." + pttO.OName + " <='" + date + " 23:59:59' " +
"Order By ptt." + pttO.OName;
dt = conn.selectData(conn.conn, sql);
return(dt);
}
