/// <summary> /// 根据主键id查询信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public static GuiGeShuMOD GetmodByid(string productNo) { GuiGeShuMOD mod = new GuiGeShuMOD(); string sqlcommandString = "select * from GuiGeShu where productNo like '%" + productNo + "%'"; try { SqlDataReader reader = SqlHelper.ExecuteReader(sqlcommandString); if (reader.Read()) { mod.Id = Convert.ToInt32(reader["id"].ToString()); mod.FileUrl = reader["FileUrl"].ToString(); mod.ProductNo = reader["productNo"].ToString(); reader.Close(); return mod; } else { reader.Close(); return null; } } 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; Boolean fileOK = false; if (Request.QueryString["id"] != null && Request.QueryString["id"].ToString() != "") { DataSet ds = GuiGeShuBLL.GetmodAll(" and productNo='" + Request.QueryString["id"] + "'"); if (ds != null && ds.Tables[0].Rows.Count > 0) { mod = new GuiGeShuMOD(); mod.ProductNo = txtProductNo.Text.Trim(); //上传外形图纸 if (fuGuigeshu.HasFile) { // 得到文件的后缀 String fileExtension = System.IO.Path.GetExtension(fuGuigeshu.FileName).ToLower(); // 允许的文件后缀 String[] allowedExtensions = { ".pdf", ".PDF" }; // 看包含的文件是否是被允许的文件后缀 for (int i = 0; i < allowedExtensions.Length; i++) { if (fileExtension == allowedExtensions[i].ToLower()) { // 如果是,标志位置为真 fileOK = true; } } if (fileOK) { string url = "~/fileUpload/" + fuGuigeshu.FileName; if (fuGuigeshu.HasFile) { string fileType = fuGuigeshu.PostedFile.ContentType; string name = fuGuigeshu.PostedFile.FileName; //文件路径 FileInfo fileInfo = new FileInfo(name); try { fuGuigeshu.SaveAs(Server.MapPath(url)); mod.FileUrl = url; fileOK = false; num = GuiGeShuBLL.Updatemod(mod); } catch (Exception ex) { Response.Write("<script>alert('上传有误,请重新上传!');</script>"); } } } else { Response.Write("<script>alert('只能上传pdf格式的文件!');</script>"); return; } } else { ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert('您没有要上传的文件!');", true); return; } } } else { mod = new GuiGeShuMOD(); mod.ProductNo = txtProductNo.Text.Trim(); //上传外形图纸 if (fuGuigeshu.HasFile) { // 得到文件的后缀 String fileExtension = System.IO.Path.GetExtension(fuGuigeshu.FileName).ToLower(); // 允许的文件后缀 String[] allowedExtensions = { ".pdf", ".PDF" }; // 看包含的文件是否是被允许的文件后缀 for (int i = 0; i < allowedExtensions.Length; i++) { if (fileExtension == allowedExtensions[i].ToLower()) { // 如果是,标志位置为真 fileOK = true; } } if (fileOK) { string url = "~/fileUpload/" + fuGuigeshu.FileName; if (fuGuigeshu.HasFile) { string fileType = fuGuigeshu.PostedFile.ContentType; string name = fuGuigeshu.PostedFile.FileName; //文件路径 FileInfo fileInfo = new FileInfo(name); try { fuGuigeshu.SaveAs(Server.MapPath(url)); mod.FileUrl = url; fileOK = false; num = GuiGeShuBLL.Insertmod(mod); } catch (Exception ex) { Response.Write("<script>alert('上传有误,请重新上传!');</script>"); } } } else { Response.Write("<script>alert('只能上传pdf格式的文件!');</script>"); return; } } else { ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert('您没有要上传的文件!');", true); return; } } if (num > 0) { // btnPrint.Visible = true; ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "DetailsPageControl.CloseBox();alert('提交成功');')DetailsPageControl.ReflushList('orderManage/GuiGeShu.aspx');", true); } else { ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert('提交失败');", true); } }
/// <summary> /// 更新 /// </summary> /// <param name="dtomodList">数据对象</param> /// <returns></returns> public static int Updatemod(GuiGeShuMOD mod) { string sqlCommandString = "Update GuiGeShu Set FileUrl=@FileUrl where productNo=@productNo"; SqlParameter[] arParams = new SqlParameter[2]; arParams[0] = new SqlParameter("@FileUrl", mod.FileUrl); arParams[1] = new SqlParameter("@productNo", mod.ProductNo); return SqlHelper.ExecuteNonQuery(CommandType.Text, sqlCommandString, arParams); }
/// <summary> /// 添加 /// </summary> /// <param name="dtomodList">对象</param> /// <returns></returns> public static int Insertmod(GuiGeShuMOD mod) { string sqlCommandString = "Insert Into GuiGeShu(FileUrl,productNo)Values(@FileUrl,@productNo)"; SqlParameter[] arParams = new SqlParameter[2]; arParams[0] = new SqlParameter("@FileUrl", mod.FileUrl); arParams[1] = new SqlParameter("@productNo", mod.ProductNo); return SqlHelper.ExecuteNonQuery(CommandType.Text, sqlCommandString, arParams); }