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