protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["id"] != "" && Request.QueryString["id"] != null) { int id = Convert.ToInt32(Request.QueryString["id"]); mod = WaiKeImgBLL.GetmodByid(id); if (mod != null) { //加载客户信息 txtwaiKeNo.Text = mod.WaiKeNo; if (mod.WaiKeImg != "") { imgwaiKeImg.ImageUrl = mod.WaiKeImg; } else { imgwaiKeImg.ImageUrl = "/images/nophoto.jpg"; } } txtwaiKeNo.Enabled = false; imgwaiKeImg.Visible = true; } else { imgwaiKeImg.Visible = false; } } }
/// <summary> /// 根据主键id查询信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public static WaiKeImgMOD GetmodByid(int id) { WaiKeImgMOD mod = new WaiKeImgMOD(); string sqlcommandString = "select * from WaiKeImg where imgId=" + id; try { SqlDataReader reader = SqlHelper.ExecuteReader(sqlcommandString); if (reader.Read()) { mod.ImgId = Convert.ToInt32(reader["ImgId"].ToString()); mod.WaiKeNo = reader["WaiKeNo"].ToString(); mod.WaiKeImg = reader["WaiKeImg"].ToString(); mod.IsModify =Convert.ToInt32( reader["IsModify"].ToString()); } reader.Close(); return mod; } catch (Exception e) { throw e; } }
/// <summary> /// 添加 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Save_Click(object sender, ImageClickEventArgs e) { int num = 0; if (Request.QueryString["id"] != "" && Request.QueryString["id"] != null) { int id = Convert.ToInt32(Request.QueryString["id"]); mod = WaiKeImgBLL.GetmodByid(id); Boolean fileOK = false; //上传外形图纸 if (fuwaiKeImg.HasFile) { // 得到文件的后缀 String fileExtension = System.IO.Path.GetExtension(fuwaiKeImg.FileName).ToLower(); // 允许的文件后缀 String[] allowedExtensions = { ".gif", ".png", ".jpeg", ".jpg" }; // 看包含的文件是否是被允许的文件后缀 for (int i = 0; i < allowedExtensions.Length; i++) { if (fileExtension == allowedExtensions[i]) { // 如果是,标志位置为真 fileOK = true; } } if (fileOK) { string url = "~/fileUpload/" + fuwaiKeImg.FileName; if (fuwaiKeImg.HasFile) { string fileType = fuwaiKeImg.PostedFile.ContentType; string name = fuwaiKeImg.PostedFile.FileName; //文件路径 FileInfo fileInfo = new FileInfo(name); try { fuwaiKeImg.SaveAs(Server.MapPath(url)); mod.WaiKeImg = url; mod.IsModify = 1; fileOK = false; } catch (Exception ex) { Response.Write("<script>alert('上传有误,请重新上传!');</script>"); } } } else { Response.Write("<script>alert('只能上传gif,png,jpeg,jpg格式的文件!');</script>"); return; } } num = WaiKeImgBLL.Updatemod(mod); } else { mod = new WaiKeImgMOD(); mod.IsModify = 0; mod.WaiKeNo = txtwaiKeNo.Text.Trim(); Boolean fileOK = false; //上传外形图纸 if (fuwaiKeImg.HasFile) { // 得到文件的后缀 String fileExtension = System.IO.Path.GetExtension(fuwaiKeImg.FileName).ToLower(); // 允许的文件后缀 String[] allowedExtensions = { ".gif", ".png", ".jpeg", ".jpg" }; // 看包含的文件是否是被允许的文件后缀 for (int i = 0; i < allowedExtensions.Length; i++) { if (fileExtension == allowedExtensions[i]) { // 如果是,标志位置为真 fileOK = true; } } if (fileOK) { string url = "~/fileUpload/" + fuwaiKeImg.FileName; if (fuwaiKeImg.HasFile) { string fileType = fuwaiKeImg.PostedFile.ContentType; string name = fuwaiKeImg.PostedFile.FileName; //文件路径 FileInfo fileInfo = new FileInfo(name); try { fuwaiKeImg.SaveAs(Server.MapPath(url)); mod.WaiKeImg = url; fileOK = false; } catch (Exception ex) { Response.Write("<script>alert('上传有误,请重新上传!');</script>"); } } } else { Response.Write("<script>alert('只能上传gif,png,jpeg,jpg格式的文件!');</script>"); return; } } else { mod.WaiKeImg = ""; } num = WaiKeImgBLL.Insertmod(mod); } if (num > 0) { ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "DetailsPageControl.CloseBox();alert('提交成功');DetailsPageControl.ReflushList('ProductManage/WaiKeImgManage.aspx');", true); } else { ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert('提交失败');", true); } }
/// <summary> /// 更新 /// </summary> /// <param name="dtomodList">数据对象</param> /// <returns></returns> public static int Updatemod(WaiKeImgMOD mod) { string sqlCommandString = "Update WaiKeImg Set waiKeImg=@waiKeImg,isModify=@isModify Where imgId=@imgId"; SqlParameter[] arParams = new SqlParameter[3]; arParams[0] = new SqlParameter("@imgId", mod.ImgId); arParams[1] = new SqlParameter("@waiKeImg", mod.WaiKeImg); arParams[2] = new SqlParameter("@isModify", mod.IsModify); return SqlHelper.ExecuteNonQuery(CommandType.Text, sqlCommandString, arParams); }
/// <summary> /// 添加 /// </summary> /// <param name="dtomodList">对象</param> /// <returns></returns> public static int Insertmod(WaiKeImgMOD mod) { string sqlCommandString =string.Format( @" IF not exists(select 1 from WaiKeImg where waiKeNo='{0}') BEGIN Insert Into WaiKeImg(waiKeNo,waiKeImg,isModify)Values(@waiKeNo,@waiKeImg,@isModify) END ",mod.WaiKeNo); SqlParameter[] arParams = new SqlParameter[3]; arParams[0] = new SqlParameter("@waiKeNo", mod.WaiKeNo); arParams[1] = new SqlParameter("@waiKeImg", mod.WaiKeImg); arParams[2] = new SqlParameter("@isModify", mod.IsModify); return SqlHelper.ExecuteNonQuery(CommandType.Text, sqlCommandString, arParams); }
/// <summary> /// 更新 /// </summary> /// <param name="dtomodList">数据对象</param> /// <returns></returns> public static int Updatemod(WaiKeImgMOD mod) { return WaiKeImgDAO.Updatemod(mod); }
/// <summary> /// 添加 /// </summary> /// <param name="dtomodList">对象</param> /// <returns></returns> public static int Insertmod(WaiKeImgMOD mod) { return WaiKeImgDAO.Insertmod(mod); }