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