public String updateHospDrugCode(String drug_id, String hospdrugcode)
{
String re = "", sql = "";
DataTable dt = new DataTable();
sql = "Select mnc_ph_cd From pharmacy_m01 Where mnc_ph_cd = '" + hospdrugcode + "'";
dt = conn.selectDataNoClose(conn.connMainHISNoClose, sql);
if (dt.Rows.Count > 0)
{
re = dt.Rows[0]["mnc_ph_cd"].ToString();
}
else
{
re = "";
}
if (!re.Equals(""))
{
sql = "Update " + dCL.table + " Set " +
dCL.status_his_ok + "='1' " +
"Where " + dCL.drugcat_id + "=" + drug_id;
re = conn.ExecuteNonQueryNoCloseMainHIS(conn.connSSDataNoClose, sql);
}
return(re);
}