public String updateSS2(String code, String ss2)
{
String re = "", sql = "";
sql = "Update " + fm01.table + " Set " +
" " + fm01.MNC_GRP_SS2 + "='" + ss2 + "' " +
"Where " + fm01.MNC_FN_CD + "='" + code + "'";
re = conn.ExecuteNonQuery1(conn.connMainHIS, sql);
return(re);
}
public String update(BillDispItems p)
{
String re = "";
String sql = "";
sql = "Update " + bdI.table + " Set " +
" " + bdI.chargeamt + "='" + p.chargeamt + "' " +
", " + bdI.claimcat + "='" + p.claimcat + "' " +
", " + bdI.claimcont + "='" + p.claimcont + "' " +
", " + bdI.dfscode + "='" + p.dfscode + "' " +
", " + bdI.dfstext + "='" + p.dfstext + "' " +
", " + bdI.dispid + "='" + p.dispid + "' " +
", " + bdI.drgid + "='" + p.drgid + "' " +
", " + bdI.hospdrgid + "='" + p.hospdrgid + "' " +
", " + bdI.multidisp + "='" + p.multidisp + "' " +
", " + bdI.packsize + "='" + p.packsize + "' " +
", " + bdI.prdcat + "='" + p.prdcat + "' " +
", " + bdI.prdsecode + "='" + p.prdsecode + "' " +
", " + bdI.quantity + "='" + p.quantity + "' " +
", " + bdI.reimbamt + "='" + p.reimbamt + "' " +
", " + bdI.reimbprice + "='" + p.reimbprice + "' " +
", " + bdI.sigcode + "='" + p.sigcode + "' " +
", " + bdI.sigtext + "='" + p.sigtext + "' " +
", " + bdI.supplyfor + "='" + p.supplyfor + "' " +
", " + bdI.unitprice + "='" + p.unitprice + "' " +
"Where " + bdI.pkField + "='" + p.billdisp_items_id + "'";
re = conn.ExecuteNonQuery1(conn.connSSData, sql);
return(re);
}
public String update(BillTranItems p)
{
String re = "";
String sql = "";
sql = "Update " + btI.table + " Set " +
"" + btI.billmuad + "='" + p.billmuad + "'" +
"," + btI.chargeamt + "='" + p.chargeamt + "'" +
"," + btI.claimamount + "='" + p.claimamount + "'" +
"," + btI.claimcat + "='" + p.claimcat + "'" +
"," + btI.claimup + "='" + p.claimup + "'" +
"," + btI.desc1 + "='" + p.desc1.Replace("'", "''") + "'" +
"," + btI.invno + "='" + p.invno + "'" +
"," + btI.lccode + "='" + p.lccode + "'" +
"," + btI.qty + "='" + p.qty + "'" +
"," + btI.stdcode + "='" + p.stdcode + "'" +
"," + btI.svdate + "='" + p.svdate + "'" +
"," + btI.svrefid + "='" + p.svrefid + "'" +
"," + btI.up + "='" + p.up + "' " +
"Where " + btI.billtran_items_id + "='" + p.billtran_items_id + "'";
re = conn.ExecuteNonQuery1(conn.connSSData, sql);
return(re);
}
public String update(BillTran p)
{
String re = "";
String sql = "";
sql = "Update " + bt.table + " Set " +
bt.amount + "='" + p.amount + "'" +
"," + bt.authcode + "='" + p.authcode + "'" +
"," + bt.billno + "='" + p.billno + "'" +
"," + bt.claimamt + "='" + p.claimamt + "'" +
"," + bt.dttran + "='" + p.dttran + "'" +
"," + bt.hcode + "='" + p.hcode + "'" +
"," + bt.hmain + "='" + p.hmain + "'" +
"," + bt.hn + "='" + p.hn + "'" +
"," + bt.invno + "='" + p.invno + "'" +
"," + bt.memberno + "='" + p.memberno + "'" +
"," + bt.name + "='" + p.name + "'" +
"," + bt.otherpayplan + "='" + p.otherpayplan + "'" +
"," + bt.paid + "='" + p.paid + "'" +
"," + bt.payplan + "='" + p.payplan + "'" +
"," + bt.pid + "='" + p.pid + "'" +
"," + bt.otherpay + "='" + p.otherpay + "'" +
//"," + bt.ssdata_id + "='" + p.ssdata_id + "'" +
//"," + bt.ssdata_visit_id + "='" + p.ssdata_visit_id + "'" +
"," + bt.station + "='" + p.station + "'" +
"," + bt.tflag + "='" + p.tflag + "'" +
"," + bt.vercode + "='" + p.vercode + "' " +
"Where " + bt.billtran_id + "='" + p.billtran_id + "'";
re = conn.ExecuteNonQuery1(conn.connSSData, sql);
return(re);
}
public String update(OpServices p)
{
String re = "";
String sql = "";
sql = "Update " + opS.table + " Set " +
" " + opS.careaccount + "='" + p.careaccount + "'" +
"," + opS.claimcat + "='" + p.claimcat + "'" +
"," + opS.class1 + "='" + p.class1 + "'" +
"," + opS.clinic + "='" + p.clinic + "'" +
"," + opS.codeset + "='" + p.codeset + "'" +
"," + opS.completion + "='" + p.completion + "'" +
"," + opS.begdt + "='" + p.begdt + "'" +
"," + opS.dtappoint + "='" + p.dtappoint + "'" +
"," + opS.enddt + "='" + p.enddt + "'" +
"," + opS.hcode + "='" + p.hcode + "'" +
"," + opS.hn + "='" + p.hn + "'" +
"," + opS.invno + "='" + p.invno + "'" +
"," + opS.lccode + "='" + p.lccode + "'" +
"," + opS.pid + "='" + p.pid + "'" +
"," + opS.stdcode + "='" + p.stdcode + "'" +
"," + opS.svcharge + "='" + p.svcharge + "'" +
"," + opS.svid + "='" + p.svid + "'" +
"," + opS.svpid + "='" + p.svpid + "'" +
"," + opS.svtxcode + "='" + p.svtxcode + "'" +
"," + opS.typein + "='" + p.typein + "'" +
"," + opS.typeout + "='" + p.typeout + "'" +
"," + opS.typeserv + "='" + p.typeserv + "'" +
"Where " + opS.pkField + "='" + p.opservices_id + "'";
re = conn.ExecuteNonQuery1(conn.connSSData, sql);
return(re);
}
public String update(BillDisp p)
{
String re = "";
String sql = "";
sql = "Update " + bd.table + " Set " +
" " + bd.benefitplan + "='" + p.benefitplan + "'" +
"," + bd.chargeamt + "='" + p.chargeamt + "'" +
"," + bd.claimamt + "='" + p.claimamt + "'" +
"," + bd.daycover + "='" + p.daycover + "'" +
"," + bd.dispdt + "='" + p.dispdt + "'" +
"," + bd.dispestat + "='" + p.dispestat + "'" +
"," + bd.dispid + "='" + p.dispid + "'" +
"," + bd.hn + "='" + p.hn + "'" +
"," + bd.invno + "='" + p.invno + "'" +
"," + bd.itemcnt + "='" + p.itemcnt + "'" +
"," + bd.otherpay + "='" + p.otherpay + "'" +
"," + bd.paid + "='" + p.paid + "'" +
"," + bd.pid + "='" + p.pid + "'" +
"," + bd.prescb + "='" + p.prescb + "'" +
"," + bd.prescdt + "='" + p.prescdt + "'" +
"," + bd.providerid + "='" + p.providerid + "'" +
"," + bd.reimburser + "='" + p.reimburser + "'" +
"," + bd.svid + "='" + p.svid + "' " +
"Where " + bd.billdisp_id + "='" + p.billdisp_id + "'";
re = conn.ExecuteNonQuery1(conn.connSSData, sql);
return(re);
}
public String insert(TSsdataSplit p)
{
String re = "";
String sql = "";
p.active = "1";
//p.ssdata_id = "";
sql = "Insert Into " + ssP.table + "(" + ssP.active + "," + ssP.date_time_end + "," +
ssP.date_time_start + "," + ssP.split_no + "," + ssP.split_start_date_time + "," +
ssP.ssdata_id + "," + ssP.status_process + ") " +
"Values ('" + p.active + "','" + p.date_time_end + "','" +
p.date_time_start + "','" + p.split_no + "','" + p.split_start_date_time + "','" +
p.ssdata_id + "','" + p.status_process + "' " +
")";
re = conn.ExecuteNonQuery1(conn.connSSData, sql);
return(re);
}
public String updateDateEnd(String ssId)
{
String sql = "", re = "";
sql = "Update " + ssd.table + " Set " +
ssd.date_end + "= convert(varchar, getdate(), 120) " +
"Where " + ssd.pkField + "='" + ssId + "'";
re = conn.ExecuteNonQuery1(conn.connSSData, sql);
return(re);
}
public String update(OpServicesOpdX p)
{
String re = "";
String sql = "";
sql = "Update " + opDX.table + " Set " +
"," + opDX.class1 + "='" + p.class1 + "'" +
"," + opDX.code + "='" + p.code + "'" +
"," + opDX.codeset + "='" + p.codeset + "'" +
"," + opDX.desc1 + "='" + p.desc1.Replace("'", "''") + "'" +
"," + opDX.sl + "='" + p.sl + "'" +
"," + opDX.svid + "='" + p.svid + "'" +
"Where " + opDX.opservices_opdx_id + "='" + p.opservices_opdx_id + "'";
re = conn.ExecuteNonQuery1(conn.connSSData, sql);
return(re);
}