public DataTable selectSumEccDocByStatusAppv(StatusAppv statusappv)
{
DataTable dt = new DataTable();
String sql = "", wherestatusappv = "";
if (statusappv == StatusAppv.sendtoAppv)
{
wherestatusappv = " and " + ecc.status_appv + " = '0' ";
}
else if (statusappv == StatusAppv.Appv)
{
wherestatusappv = " and " + ecc.status_appv + " = '1' ";
}
sql = "select " + ecc.ecc_doc + ",sum(" + ecc.pay_amount + ") as " + ecc.pay_amount + " " +
"From " + ecc.table + " " +
//"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " +
"Where " + ecc.active + " = '1' " + wherestatusappv;
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectByStfIdStatusAppv(String stfId, StatusAppv statusappv)
{
DataTable dt = new DataTable();
String sql = "", wherestatusappv = "", wherestfId = "";
if (statusappv == StatusAppv.sendtoAppv)
{
wherestatusappv = " and " + ecc.status_appv + " = '0' ";
}
else if (statusappv == StatusAppv.Appv)
{
wherestatusappv = " and " + ecc.status_appv + " = '1' ";
}
if (!stfId.Equals(""))
{
wherestfId = " and " + ecc.pay_staff_id + " = '" + stfId + "' ";
}
sql = "select * " +
"From " + ecc.table + " " +
//"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " +
"Where " + ecc.active + " = '1' " + wherestatusappv + wherestfId;
dt = conn.selectData(conn.conn, sql);
return(dt);
}