protected int ExcuteInsert()
{
int val = -10;
string InsertCommand = "INSERT INTO [Image] ([drugid], [imagename], [itype], [inum], [filepath], [ifilesize], [filetype], [filename], [imagebak1], [imagebak2]) VALUES (@drugid, @imagename, @itype, @inum, @filepath, @ifilesize, @filetype, @filename, @imagebak1, @imagebak2)";
SqlParameter[] par = new SqlParameter[10];
int idrugid = 0;
int ginum = 0;
cSourceImage csimage = new cSourceImage();
if (Session["drugid"] != null)
{
hid_drugid.Value = Session["drugid"].ToString();
idrugid = Convert.ToInt32(Session["drugid"].ToString());
ginum = csimage.GetImageNum(hid_drugid.Value, DropDownList1.SelectedIndex);
}
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("@imagename", SqlDbType.NVarChar, 40); par[1].Value = CharTextRequired1.TextValue;
par[2] = new SqlParameter("@itype", SqlDbType.Int); par[2].Value = DropDownList1.SelectedIndex;
par[3] = new SqlParameter("@inum", SqlDbType.Int); par[3].Value = ginum;
par[4] = new SqlParameter("@filepath", SqlDbType.NVarChar, 200); par[4].Value = l1.Text;
//以下5项都可以不要
par[5] = new SqlParameter("@ifilesize", SqlDbType.BigInt); par[5].Value = 0;
par[6] = new SqlParameter("@filetype", SqlDbType.NVarChar, 40); par[6].Value = "";
par[7] = new SqlParameter("@filename", SqlDbType.NVarChar, 100); par[7].Value = "";
par[8] = new SqlParameter("@imagebak1", SqlDbType.NVarChar, 40); par[8].Value = "";
par[9] = new SqlParameter("@imagebak2", SqlDbType.NVarChar, 40); par[9].Value = "";
try
{
val = csimage.ModiImage(InsertCommand, par);
}
catch
{ }
return(val);
}
