public String update(BDrugCatalogue p) { String re = ""; String sql = ""; sql = "Update " + dCL.table + " Set " + dCL.content1 + "='" + p.content1.Replace("'", "''") + "'" + "," + dCL.datechange + "='" + p.datechange + "'" + "," + dCL.dateeffect + "='" + p.dateeffect + "'" + "," + dCL.dateupdate + "='" + p.dateupdate + "'" + "," + dCL.dfscode + "='" + p.dfscode + "'" + "," + dCL.distributor + "='" + p.distributor + "'" + "," + dCL.dosageform + "='" + p.dosageform.Replace("'", "''") + "'" + "," + dCL.drugcat_code + "='" + p.drugcat_code + "'" + "," + dCL.genericname + "='" + p.genericname.Replace("'", "''") + "'" + "," + dCL.hospdrugcode + "='" + p.hospdrugcode + "'" + "," + dCL.ised + "='" + p.ised + "'" + "," + dCL.manufactrer + "='" + p.manufactrer.Replace("'", "''") + "'" + "," + dCL.ndc24 + "='" + p.ndc24 + "'" + "," + dCL.productcat + "='" + p.productcat.Replace("'", "''") + "'" + "," + dCL.specprep + "='" + p.specprep + "'" + "," + dCL.strength + "='" + p.strength + "'" + "," + dCL.tmtid + "='" + p.tmtid + "'" + "," + dCL.tradename + "='" + p.tradename.Replace("'", "''") + "'" + "," + dCL.unitprice + "='" + p.unitprice + "'" + "," + dCL.unitsize + "='" + p.unitsize + "'" + "," + dCL.updateflag + "='" + p.updateflag + "' " + "Where " + dCL.drugcat_id + "=" + p.drugcat_id; re = conn.ExecuteNonQueryNoClose(conn.connSSDataNoClose, sql); re = p.drugcat_id; return(re); }
public String insert(TSsdataVisitBillDispItems p) { String re = ""; String sql = ""; p.active = "1"; sql = "Insert Into " + ssdvBI.table + "(" + ssdvBI.active + "," + ssdvBI.billmuad + "," + ssdvBI.chargeamt + "," + ssdvBI.claimamount + "," + ssdvBI.claimcat + "," + ssdvBI.claimup + "," + ssdvBI.desc1 + "," + ssdvBI.invno + "," + ssdvBI.llcode + "," + ssdvBI.qty + "," + ssdvBI.ssdata_id + "," + ssdvBI.ssdata_visit_id + "," + ssdvBI.stdcode + "," + ssdvBI.svdate + "," + ssdvBI.svrefid + "," + ssdvBI.up + "," + ssdvBI.row_no + "," + ssdvBI.ssdata_billdisp_id + ") " + "Values('" + p.active + "','" + p.billmuad + "','" + p.chargeamt + "','" + p.claimamount + "','" + p.claimcat + "','" + p.claimup + "','" + p.desc1 + "','" + p.invno + "','" + p.llcode + "','" + p.qty + "','" + p.ssdata_id + "','" + p.ssdata_visit_id + "','" + p.stdcode + "','" + p.svdate + "','" + p.svrefid + "','" + p.up + "','" + p.row_no + "','" + p.ssdata_billdisp_id + "') "; re = conn.ExecuteNonQueryNoClose(conn.connSSDataNoClose, sql); return(re); }
public String insert(BillDispItems p) { String re = ""; String sql = ""; //p.active = "1"; sql = "Insert Into " + bdI.table + "(" + bdI.billdisp_id + "," + bdI.chargeamt + "," + bdI.claimcat + "," + bdI.claimcont + "," + bdI.dfscode + "," + bdI.dfstext + "," + bdI.dispid + "," + bdI.drgid + "," + bdI.hospdrgid + "," + bdI.multidisp + "," + bdI.packsize + "," + bdI.prdcat + "," + bdI.prdsecode + "," + bdI.quantity + "," + bdI.reimbamt + "," + bdI.reimbprice + "," + bdI.sigcode + "," + bdI.sigtext + "," + bdI.supplyfor + "," + bdI.unitprice + " " + ") " + "Values('" + p.billdisp_id + "','" + p.chargeamt + "','" + p.claimcat + "','" + p.claimcont + "','" + p.dfscode + "','" + p.dfstext.Replace("'", "''") + "','" + p.dispid + "','" + p.drgid + "','" + p.hospdrgid + "','" + p.multidisp + "','" + p.packsize + "','" + p.prdcat + "','" + p.prdsecode + "','" + p.quantity + "','" + p.reimbamt + "','" + p.reimbprice + "','" + p.sigcode + "','" + p.sigtext.Replace("'", "''") + "','" + p.supplyfor + "','" + p.unitprice + "'" + ") "; re = conn.ExecuteNonQueryNoClose(conn.connSSDataNoClose, sql); return(re); }
public String insert(BillTran p) { String re = ""; String sql = ""; //p.active = "1"; sql = "Insert Into " + bt.table + "(" + bt.amount + "," + bt.authcode + "," + bt.billno + "," + bt.claimamt + "," + bt.otherpay + "," + bt.dttran + "," + bt.hcode + "," + bt.hmain + "," + bt.hn + "," + bt.invno + "," + bt.memberno + "," + bt.name + "," + bt.otherpayplan + "," + bt.paid + "," + bt.payplan + "," + bt.pid + "," + bt.ssdata_id + "," + bt.ssdata_visit_id + "," + bt.station + "," + bt.tflag + "," + bt.vercode + "," + bt.ssdata_split_id + " " + ") " + "Values('" + p.amount + "','" + p.authcode + "','" + p.billno + "','" + p.claimamt + "','" + p.otherpay + "','" + p.dttran + "','" + p.hcode + "','" + p.hmain + "','" + p.hn + "','" + p.invno + "','" + p.memberno + "','" + p.name.Replace("'", "''") + "','" + p.otherpayplan + "','" + p.paid + "','" + p.payplan + "','" + p.pid + "','" + p.ssdata_id + "','" + p.ssdata_visit_id + "','" + p.station + "','" + p.tflag + "','" + p.vercode + "','" + p.ssdata_split_id + "' " + ") "; re = conn.ExecuteNonQueryNoClose(conn.connSSDataNoClose, sql); return(re); }
public String insert(OpServices p) { String re = ""; String sql = ""; //p.active = "1"; sql = "Insert Into " + opS.table + "(" + opS.careaccount + "," + opS.claimcat + "," + opS.class1 + "," + opS.clinic + "," + opS.codeset + "," + opS.completion + "," + opS.begdt + "," + opS.dtappoint + "," + opS.enddt + "," + opS.hcode + "," + opS.hn + "," + opS.invno + "," + opS.lccode + "," + opS.pid + "," + opS.ssdata_id + "," + opS.stdcode + "," + opS.svcharge + "," + opS.svid + "," + opS.svpid + "," + opS.svtxcode + "," + opS.typein + "," + opS.typeout + "," + opS.typeserv + ", " + opS.ssdata_visit_id + "," + opS.ssdata_split_id + " " + ") " + "Values('" + p.careaccount + "','" + p.claimcat + "','" + p.class1 + "','" + p.clinic + "','" + p.codeset + "','" + p.completion + "','" + p.begdt + "','" + p.dtappoint + "','" + p.enddt + "','" + p.hcode + "','" + p.hn + "','" + p.invno + "','" + p.lccode + "','" + p.pid + "','" + p.ssdata_id + "','" + p.stdcode + "','" + p.svcharge + "','" + p.svid + "','" + p.svpid + "','" + p.svtxcode + "','" + p.typein + "','" + p.typeout + "','" + p.typeserv + "','" + p.ssdata_visit_id + "','" + p.ssdata_split_id + "' " + ") "; re = conn.ExecuteNonQueryNoClose(conn.connSSDataNoClose, sql); return(re); }
public String insert(BillDisp p) { String re = ""; String sql = ""; //p.active = "1"; sql = "Insert Into " + bd.table + "(" + bd.benefitplan + "," + bd.chargeamt + "," + bd.claimamt + "," + bd.daycover + "," + bd.dispdt + "," + bd.dispestat + "," + bd.dispid + "," + bd.hn + "," + bd.invno + "," + bd.itemcnt + "," + bd.otherpay + "," + bd.paid + "," + bd.pid + "," + bd.prescb + "," + bd.prescdt + "," + bd.providerid + "," + bd.reimburser + "," + bd.ssdata_id + "," + bd.ssdata_visit_id + "," + bd.svid + "," + bd.ssdata_split_id + " " + ") " + "Values('" + p.benefitplan + "','" + p.chargeamt + "','" + p.claimamt + "','" + p.daycover + "','" + p.dispdt + "','" + p.dispestat + "','" + p.dispid + "','" + p.hn + "','" + p.invno + "','" + p.itemcnt + "','" + p.otherpay + "','" + p.paid + "','" + p.pid + "','" + p.prescb + "','" + p.prescdt + "','" + p.providerid + "','" + p.reimburser + "','" + p.ssdata_id + "','" + p.ssdata_visit_id + "','" + p.svid + "','" + p.ssdata_split_id + "' " + ") "; re = conn.ExecuteNonQueryNoClose(conn.connSSDataNoClose, sql); return(re); }
public String insert(TSsdataVisit p) { String re = ""; String sql = ""; p.active = "1"; sql = "Insert Into " + ssdV.table + "(" + ssdV.active + "," + ssdV.birth_day + "," + ssdV.branch_id + "," + ssdV.hcode + "," + ssdV.hcode_owner + "," + ssdV.hn_no + "," + ssdV.hn_yr + "," + ssdV.pid + "," + ssdV.patient_fname + "," + ssdV.patient_lname + "," + ssdV.prefix + "," + ssdV.pre_no + "," + ssdV.sex + "," + ssdV.ssdata_id + "," + ssdV.visit_date + "," + ssdV.visit_time + "," + ssdV.vn + "," + ssdV.vn_no + "," + ssdV.vn_seq + "," + ssdV.vn_sum + "," + ssdV.year_id + "," + ssdV.month_id + "," + ssdV.invno + "," + ssdV.billno + "," + ssdV.amount + "," + ssdV.paid + "," + ssdV.payplan + "," + ssdV.claimamt + "," + ssdV.otherpayplan + "," + ssdV.otherpay + "," + ssdV.prescdt + "," + ssdV.dispdt + "," + ssdV.itemcnt + "," + ssdV.prescb + "," + ssdV.svid + "," + ssdV.ssdata_split_id + ") " + "Values('" + p.active + "','" + p.birth_day + "','" + p.branch_id + "','" + p.hcode + "','" + p.hcode_owner + "','" + p.hn_no + "','" + p.hn_yr + "','" + p.pid + "','" + p.patient_fname + "','" + p.patient_lname + "','" + p.prefix + "','" + p.pre_no + "','" + p.sex + "','" + p.ssdata_id + "','" + p.visit_date + "','" + p.visit_time + "','" + p.vn + "','" + p.vn_no + "','" + p.vn_seq + "','" + p.vn_sum + "','" + p.year_id + "','" + p.month_id + "','" + p.invno + "','" + p.billno + "','" + p.amount + "','" + p.paid + "','" + p.payplan + "','" + p.claimamt + "','" + p.otherpayplan + "','" + p.otherpay + "','" + p.prescdt + "','" + p.dispdt + "','" + p.itemcnt + "','" + p.prescb + "','" + p.svid + "','" + p.ssdata_split_id + "') "; re = conn.ExecuteNonQueryNoClose(conn.connSSDataNoClose, sql); return(re); }
public String insert(OpServicesOpdX p) { String re = ""; String sql = ""; //p.active = "1"; sql = "Insert Into " + opDX.table + "(" + opDX.class1 + "," + opDX.code + "," + opDX.codeset + "," + opDX.desc1 + "," + opDX.opservices_id + "," + opDX.sl + "," + opDX.svid + ") " + "Values('" + p.class1 + "','" + p.code + "','" + p.codeset + "','" + p.desc1.Replace("'", "''") + "','" + p.opservices_id + "','" + p.sl + "','" + p.svid + "') "; re = conn.ExecuteNonQueryNoClose(conn.connSSDataNoClose, sql); return(re); }
public String insert(BillTranItems p) { String re = ""; String sql = ""; //p.active = "1"; sql = "Insert Into " + btI.table + "(" + btI.billmuad + "," + btI.billtran_id + "," + btI.chargeamt + "," + btI.claimamount + "," + btI.claimcat + "," + btI.claimup + "," + btI.desc1 + "," + btI.invno + "," + btI.lccode + "," + btI.qty + "," + btI.stdcode + "," + btI.svdate + "," + btI.svrefid + "," + btI.up + ") " + "Values('" + p.billmuad + "','" + p.billtran_id + "','" + p.chargeamt + "','" + p.claimamount + "','" + p.claimcat + "','" + p.claimup + "','" + p.desc1 + "','" + p.invno + "','" + p.lccode + "','" + p.qty + "','" + p.stdcode + "','" + p.svdate + "','" + p.svrefid + "','" + p.up + "') "; re = conn.ExecuteNonQueryNoClose(conn.connSSDataNoClose, sql); return(re); }