public DataTable selectBySSdId(String ssDId)
{
DataTable dt = new DataTable();
String sql = "select bdi.* " +
"From " + bdI.table + " bdi " +
"Left Join t_billdisp bd On bdi.billdisp_id = bd.billdisp_id " +
"Where bd.ssdata_id ='" + ssDId + "' ";
dt = conn.selectData(conn.connSSData, sql);
return(dt);
}
public DataTable selectByOpSId(String opsId)
{
DataTable dt = new DataTable();
String sql = "select opdx.* " +
"From " + opDX.table + " opdx " +
//"Left Join t_billtran bt On bti.billtran_id = bt.billtran_id " +
"Where opdx." + opDX.opservices_id + " ='" + opsId + "' ";
dt = conn.selectData(conn.connSSData, sql);
return(dt);
}
public DataTable selectBySSdId(String ssDId)
{
DataTable dt = new DataTable();
String sql = "select bti.* " +
"From " + btI.table + " bti " +
"Left Join t_billtran bt On bti.billtran_id = bt.billtran_id " +
"Where bt.ssdata_id ='" + ssDId + "' ";
dt = conn.selectData(conn.connSSData, sql);
return(dt);
}
public DataTable selectByYearMonth(String yearId, String monthId)
{
DataTable dt = new DataTable();
String sql = "select bt.* " +
"From " + bt.table + " bt " +
"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bt." + bt.ssdata_visit_id + " " +
"Left Join t_ssdata ss On ss.ssdata_id = ssv.ssdata_id " +
"Where ss.year_id ='" + yearId + "' and ss.month_id ='" + monthId + "' and ssv.active = '1' " +
"Order By bt." + bt.billtran_id;
dt = conn.selectData(conn.connSSData, sql);
return(dt);
}
public DataTable selectByYearMonth(String yearId, String monthId)
{
DataTable dt = new DataTable();
String sql = "select ops.* " +
"From " + opS.table + " ops " +
"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = ops." + opS.ssdata_visit_id + " " +
"Left Join t_ssdata ss On ss.ssdata_id = ssv.ssdata_id " +
"Where ss.year_id ='" + yearId + "' and ss.month_id ='" + monthId + "' and ssv.active = '1' " +
"Order By ops." + opS.opservices_id;
dt = conn.selectData(conn.connSSData, sql);
return(dt);
}
public DataTable selectBySsdId(String ssdId)
{
DataTable dt = new DataTable();
String re = "";
String sql = "select ssp.* " +
"From " + ssP.table + " ssp " +
//"LEft Join t_ssdata ssd" +
"Where ssp." + ssP.ssdata_id + " ='" + ssdId + "' and active = '1' " +
"Order By " + ssP.split_no + " ";
dt = conn.selectData(conn.connSSData, sql);
return(dt);
}
public String selectIDByYearMonth(String yearId, String monthId)
{
DataTable dt = new DataTable();
String re = "";
String sql = "select * " +
"From " + ssd.table + " " +
"Where year_id ='" + yearId + "' and month_id ='" + monthId + "' and active = '1' " +
"Order By " + ssd.pkField + " desc ";
dt = conn.selectData(conn.connSSData, sql);
if (dt.Rows.Count > 0)
{
re = dt.Rows[0]["ssdata_id"].ToString();
}
return(re);
}
public DataTable selectAll()
{
DataTable dt = new DataTable();
String sql = "select fm20.* " +
"From " + fm20.table + " fm20 ";
dt = conn.selectData(conn.connMainHIS, sql);
return(dt);
}
public DataTable selectByssDId(String ssId)
{
DataTable dt = new DataTable();
String sql = "select ssv.* " +
"From " + ssdV.table + " ssv " +
"Left Join t_ssdata ss On ss.ssdata_id = ssv.ssdata_id " +
"Where ssv." + ssdV.ssdata_id + "='" + ssId + "' " +
"Order By ssv." + ssdV.visit_date + ",ssv." + ssdV.visit_time;
dt = conn.selectData(conn.connSSData, sql);
return(dt);
}
public DataTable selectAll()
{
DataTable dt = new DataTable();
String sql = "select fm01.*, fm06.MNC_FN_GRP_DSC as MNC_FN_GRP_DES, fm20.MNC_GRP_SS2_DSC " +
"From " + fm01.table + " fm01 " +
"Left Join finance_m06 fm06 On fm01." + fm01.MNC_FN_GRP + " = fm06.MNC_FN_GRP_CD " +
"Left Join finance_m20 fm20 On fm01.MNC_GRP_SS2 = fm20.MNC_GRP_SS2 " +
"Where fm01." + fm01.MNC_FN_STS + " ='Y' ";
dt = conn.selectData(conn.connMainHIS, sql);
return(dt);
}