void DataBindText(string drugid, int itype)
{
cSourceImage csimage = new cSourceImage();
DataTable dt = csimage.GetDTbyNum(drugid, itype);
DataList1.DataSource = dt;
DataList1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//string cid = Request.Params.Keys[0].ToString();
//string strid = Request.QueryString[cid];
//string strid = Request.QueryString["imgid"];
string strid = Request.Params["imgid"];
cSourceImage csimage = new cSourceImage();
string imgPath = csimage.GetimgPath(Convert.ToInt32(strid));
Image1.ImageUrl = imgPath;
}
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
cSourceImage csimage = new cSourceImage();
if (e.CommandName == "del")
{
int iimgid = Convert.ToInt32(e.CommandArgument);
string DeleteCommand = "DELETE FROM [Image] WHERE [imgid] = @imgid";
SqlParameter[] par = new SqlParameter[1];
int val = -10;
par[0] = new SqlParameter("@imgid", SqlDbType.Int); par[0].Value = iimgid;
try
{
//
string picPath = csimage.GetimgPath(iimgid);
val = csimage.ModiImage(DeleteCommand, par);
if (picPath != "")
{
string savePath = Server.MapPath(picPath); //必须经过这一步操作才能变成有效路径
if (System.IO.File.Exists(savePath)) //先判断文件是否存在，再执行操作
{
System.IO.File.Delete(savePath);
}
}
if (val > 0)
{
Script.AjaxAlert(DataList1, "恭喜您，图片删除成功！");
}
//删除之后要重新绑定
string drugid = hid_drugid.Value;
int itype = Convert.ToInt32(DropDownList1.SelectedItem.Value);
DataBindText(drugid, itype);
CharTextRequired1.TextValue = "";
}
catch
{ }
}
else if (e.CommandName == "detail")
{
//如果是点击原图按钮则要放大图像
// Response.Redirect("ResponseImage.aspx", "_blank", "menubar=0,width=200,height=200");
int gimgid = Convert.ToInt32(e.CommandArgument);
string str = "<script languge='javascript'> window.open('ResponseImage.aspx?imgid=" + gimgid + "','','height = 600,width = 800,top = 0,left = 0,toobar =no,menubar=no,scrollbars=yes,resizable=yes,location = no,status=no')</script>";
Response.Write(str);
}
}
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);
}
