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