protected int ExcuteInsert() { int val = -10; string InsertCommand = "INSERT INTO [chemistry] ([rshid], [drugid], [cmname], [cmformula], [cmpic]) VALUES (@rshid, @drugid, @cmname, @cmformula, @cmpic)"; SqlParameter[] par = new SqlParameter[5]; int idrugid = 0; int irsid = 0; if (Session["drugid"] != null && Session["rsid"] != null) { idrugid = Convert.ToInt32(hid_drugid.Value.ToString().Trim()); irsid = Convert.ToInt32(hid_rsid.Value.ToString().Trim()); } else { //这个地方还需要再次考虑一下,是否要弹出一个窗口 Response.Redirect("../Admin/AdWeb/APassport.aspx"); } par[0] = new SqlParameter("@rshid", SqlDbType.Int); par[0].Value = irsid; par[1] = new SqlParameter("@drugid", SqlDbType.Int); par[1].Value = idrugid; par[2] = new SqlParameter("@cmname", SqlDbType.NVarChar, 80); par[2].Value = CharText1.TextValue; par[3] = new SqlParameter("@cmformula", SqlDbType.NVarChar, 100); par[3].Value = CharText2.TextValue; par[4] = new SqlParameter("@cmpic", SqlDbType.NVarChar, 100); par[4].Value = lbl_cmpicURL.Text.ToString().Trim(); cChemistry ccm = new cChemistry(); DataTable ccmdt; int gcmid = -10; try { val = ccm.ModiChemistry(InsertCommand, par); //根据文化属性编号去查询,可能和根据药物编号查询效果一致的,但是效果更好些。 //此处可能有zhuyc漏洞,因为可能有并发的问题 ccmdt = ccm.GetCmDtByRshid(irsid.ToString()); if (ccmdt.Rows.Count > 0) { //插入新的数据后马上获取它的自增主关键字,方便更新。 gcmid = Convert.ToInt32(ccmdt.Rows[ccmdt.Rows.Count - 1]["cmid"].ToString().Trim()); Session["cmid"] = gcmid; hid_cmid.Value = gcmid.ToString().Trim(); } } catch { } return(val); }
public void DataBindText(string drugid) { cChemistry ccm = new cChemistry(); try { DataTable dt = ccm.GetCmDtByDrugid(drugid); gv.Visible = (dt.Rows.Count > 0) ? true : false; if (dt.Rows.Count > 0) { //绑定到GV gv.DataSource = dt; gv.DataBind(); } } catch { } }