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