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