protected int ExcuteInsert() { int val = -10; string InsertCommand = "INSERT INTO [Reference] ([drugid], [title], [magazine], [author], [gov], [province], [year], [vol], [page], [abs], [refbak1], [refbak2]) VALUES (@drugid, @title, @magazine, @author, @gov, @province, @year, @vol, @page, @abs, @refbak1, @refbak2)"; SqlParameter[] par = new SqlParameter[12]; int idrugid = 0; if (Session["drugid"] != null) { hid_drugid.Value = Session["drugid"].ToString(); idrugid = Convert.ToInt32(Session["drugid"].ToString()); } else { //这个地方还需要再次考虑一下,是否要弹出一个窗口 Response.Redirect("../Admin/AdWeb/APassport.aspx"); } par[0] = new SqlParameter("@drugid", SqlDbType.Int); par[0].Value = Convert.ToInt32(hid_drugid.Value); par[1] = new SqlParameter("@title", SqlDbType.NVarChar, 1000); par[1].Value = CharText1.TextValue; par[2] = new SqlParameter("@magazine", SqlDbType.NVarChar, 1000); par[2].Value = CharText2.TextValue; par[3] = new SqlParameter("@author", SqlDbType.NVarChar, 800); par[3].Value = CharText3.TextValue; par[4] = new SqlParameter("@gov", SqlDbType.NText); par[4].Value = CharText4.TextValue; par[5] = new SqlParameter("@province", SqlDbType.NVarChar, 200); par[5].Value = CharText5.TextValue; par[6] = new SqlParameter("@year", SqlDbType.NVarChar, 200); par[6].Value = CharText6.TextValue; par[7] = new SqlParameter("@vol", SqlDbType.NVarChar, 200); par[7].Value = CharText7.TextValue; par[8] = new SqlParameter("@page", SqlDbType.NVarChar, 400); par[8].Value = CharText8.TextValue; par[9] = new SqlParameter("@abs", SqlDbType.NText); par[9].Value = CharText9.TextValue; par[10] = new SqlParameter("@refbak1", SqlDbType.NVarChar, 400); par[10].Value = ""; par[11] = new SqlParameter("@refbak2", SqlDbType.NVarChar, 400); par[11].Value = ""; cReference cref = new cReference(); int grefid = -10; try { val = cref.ModiReference(InsertCommand, par); //取出刚刚插入的文献编号 grefid = cref.GetRefID(idrugid.ToString()); hid_refid.Value = grefid.ToString(); } catch { } return(val); }
public void DataBindText(string drugid) { cReference refc = new cReference(); try { DataTable dt = refc.GetRefTable(drugid); gv.Visible = (dt.Rows.Count > 0) ? true : false; if (dt.Rows.Count > 0) { //绑定到GV gv.DataSource = dt; gv.DataBind(); } } catch { } }
protected int ExcuteUpdate(int refid) { int val = -10; string UpdateCommand = "UPDATE [Reference] SET [drugid] = @drugid, [title] = @title, [magazine] = @magazine, [author] = @author, [gov] = @gov, [province] = @province, [year] = @year, [vol] = @vol, [page] = @page, [abs] = @abs, [refbak1] = @refbak1, [refbak2] = @refbak2 WHERE [rfeid] = @rfeid"; SqlParameter[] par = new SqlParameter[13]; if (Session["drugid"] == null) { Response.Redirect("../Admin/AdWeb/APassport.aspx"); return(0); } par[0] = new SqlParameter("@drugid", SqlDbType.Int); par[0].Value = Convert.ToInt32(hid_drugid.Value); par[1] = new SqlParameter("@title", SqlDbType.NVarChar, 100); par[1].Value = CharText1.TextValue; par[2] = new SqlParameter("@magazine", SqlDbType.NVarChar, 100); par[2].Value = CharText2.TextValue; par[3] = new SqlParameter("@author", SqlDbType.NVarChar, 80); par[3].Value = CharText3.TextValue; par[4] = new SqlParameter("@gov", SqlDbType.Text); par[4].Value = CharText4.TextValue; par[5] = new SqlParameter("@province", SqlDbType.NVarChar, 20); par[5].Value = CharText5.TextValue; par[6] = new SqlParameter("@year", SqlDbType.NVarChar, 20); par[6].Value = CharText6.TextValue; par[7] = new SqlParameter("@vol", SqlDbType.NVarChar, 20); par[7].Value = CharText7.TextValue; par[8] = new SqlParameter("@page", SqlDbType.NVarChar, 40); par[8].Value = CharText8.TextValue; par[9] = new SqlParameter("@abs", SqlDbType.Text); par[9].Value = CharText9.TextValue; par[10] = new SqlParameter("@refbak1", SqlDbType.NVarChar, 40); par[10].Value = ""; par[11] = new SqlParameter("@refbak2", SqlDbType.NVarChar, 40); par[11].Value = ""; par[12] = new SqlParameter("@rfeid", SqlDbType.Int); par[12].Value = refid; cReference cref = new cReference(); try { val = cref.ModiReference(UpdateCommand, par); } catch { } return(val); }