public String insert(BDrugCatalogue p) { String re = ""; String sql = ""; sql = "Insert Into " + dCL.table + "(" + dCL.content1 + "," + dCL.datechange + "," + dCL.dateeffect + "," + dCL.dateupdate + "," + dCL.dfscode + "," + dCL.distributor + "," + dCL.dosageform + "," + dCL.drugcat_code + "," + dCL.genericname + "," + dCL.hospdrugcode + "," + dCL.ised + "," + dCL.manufactrer + "," + dCL.ndc24 + "," + dCL.productcat + "," + dCL.specprep + "," + dCL.strength + "," + dCL.tmtid + "," + dCL.tradename + "," + dCL.unitprice + "," + dCL.unitsize + "," + dCL.updateflag + ") " + "Values('" + p.content1.Replace("'", "''") + "','" + p.datechange + "','" + p.dateeffect + "','" + p.dateupdate + "','" + p.dfscode + "','" + p.distributor + "','" + p.dosageform.Replace("'", "''") + "','" + p.drugcat_code + "','" + p.genericname.Replace("'", "''") + "','" + p.hospdrugcode + "','" + p.ised + "','" + p.manufactrer.Replace("'", "''") + "','" + p.ndc24 + "','" + p.productcat.Replace("'", "''") + "','" + p.specprep + "','" + p.strength + "','" + p.tmtid + "','" + p.tradename.Replace("'", "''") + "','" + p.unitprice + "','" + p.unitsize + "','" + p.updateflag + "') "; re = conn.ExecuteNonQueryNoClose(conn.connSSDataNoClose, sql); return(re); }
private void initConfig() { dCL = new BDrugCatalogue(); dCL.content1 = "content1"; dCL.datechange = "datechange"; dCL.dateeffect = "dateeffect"; dCL.dateupdate = "dateupdate"; dCL.dfscode = "dfscode"; dCL.distributor = "distributor"; dCL.dosageform = "dosageform"; dCL.drugcat_code = "drugcat_code"; dCL.drugcat_id = "drugcat_id"; dCL.genericname = "genericname"; dCL.hospdrugcode = "hospdrugcode"; dCL.ised = "ised"; dCL.manufactrer = "manufactrer"; dCL.ndc24 = "ndc24"; dCL.productcat = "productcat"; dCL.specprep = "specprep"; dCL.strength = "strength"; dCL.tmtid = "tmtid"; dCL.tradename = "tradename"; dCL.unitprice = "unitprice"; dCL.unitsize = "unitsize"; dCL.updateflag = "updateflag"; dCL.status_his_ok = "status_his_ok"; dCL.table = "b_drugcatalogue"; dCL.pkField = "drugcat_id"; }
public String insertDrugCatalogue(BDrugCatalogue p) { String re = ""; re = selectByHospDrugCode(p.hospdrugcode); if (re.Equals("")) { re = insert(p); } else { p.drugcat_id = re; re = update(p); } return(re); }