/// <summary> /// 更新一条数据 /// </summary> public void Update(Tunnel.Model.Tunnel_Img model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Tunnel_Img set "); strSql.Append("i_name=@i_name,"); strSql.Append("i_uri=@i_uri,"); strSql.Append("i_date=@i_date,"); strSql.Append("i_user=@i_user,"); strSql.Append("i_type=@i_type,"); strSql.Append("i_year=@i_year"); strSql.Append(" where i_id=@i_id "); SqlParameter[] parameters = { new SqlParameter("@i_id", SqlDbType.Int, 4), new SqlParameter("@i_name", SqlDbType.VarChar, 50), new SqlParameter("@i_uri", SqlDbType.VarChar, 50), new SqlParameter("@i_date", SqlDbType.DateTime), new SqlParameter("@i_user", SqlDbType.Int, 4), new SqlParameter("@i_type", SqlDbType.VarChar, 50), new SqlParameter("@i_year", SqlDbType.VarChar, 5) }; parameters[0].Value = model.i_id; parameters[1].Value = model.i_name; parameters[2].Value = model.i_uri; parameters[3].Value = model.i_date; parameters[4].Value = model.i_user; parameters[5].Value = model.i_type; parameters[6].Value = model.i_year; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 获得数据列表 /// </summary> public List <Tunnel.Model.Tunnel_Img> DataTableToList(DataTable dt) { List <Tunnel.Model.Tunnel_Img> modelList = new List <Tunnel.Model.Tunnel_Img>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Tunnel.Model.Tunnel_Img model; for (int n = 0; n < rowsCount; n++) { model = new Tunnel.Model.Tunnel_Img(); if (dt.Rows[n]["i_id"].ToString() != "") { model.i_id = int.Parse(dt.Rows[n]["i_id"].ToString()); } model.i_name = dt.Rows[n]["i_name"].ToString(); model.i_uri = dt.Rows[n]["i_uri"].ToString(); if (dt.Rows[n]["i_date"].ToString() != "") { model.i_date = DateTime.Parse(dt.Rows[n]["i_date"].ToString()); } if (dt.Rows[n]["i_user"].ToString() != "") { model.i_user = int.Parse(dt.Rows[n]["i_user"].ToString()); } model.i_type = dt.Rows[n]["i_type"].ToString(); model.i_year = dt.Rows[n]["i_year"].ToString(); modelList.Add(model); } } return(modelList); }
protected void btnSave_Click(object sender, EventArgs e) { if (FileUpload1.HasFile) { string fileContentType = FileUpload1.PostedFile.ContentType; if (fileContentType == "image/bmp" || fileContentType == "image/gif" || fileContentType == "image/pjpeg") { string name = txtname.Text.Trim() + FileUpload1.FileName.Substring(FileUpload1.FileName.LastIndexOf('.'), FileUpload1.FileName.Length - FileUpload1.FileName.LastIndexOf('.')); string temp = Server.MapPath("image") + "\\" + txtname.Text.Trim() + FileUpload1.FileName.Substring(FileUpload1.FileName.LastIndexOf('.'), FileUpload1.FileName.Length - FileUpload1.FileName.LastIndexOf('.')); string _temp = Server.MapPath("image") + "\\_" + txtname.Text.Trim() + FileUpload1.FileName.Substring(FileUpload1.FileName.LastIndexOf('.'), FileUpload1.FileName.Length - FileUpload1.FileName.LastIndexOf('.')); Tunnel.BLL.Tunnel_Img ti = new Tunnel.BLL.Tunnel_Img(); Tunnel.Model.Tunnel_Img tii = new Tunnel.Model.Tunnel_Img(); if (ti.GetModelList("i_name='" + txtname.Text.Trim() + "'").Count == 0) { tii.i_date = DateTime.Now; tii.i_name = txtname.Text.Trim(); tii.i_uri = name; tii.i_user = ul.LoginID; tii.i_type = ddlType.SelectedValue; tii.i_year = ddlYear.SelectedValue; ti.Add(tii); if (File.Exists(temp)) { File.Delete(temp); } if (File.Exists(_temp)) { File.Delete(_temp); } FileUpload1.SaveAs(temp); MakeThumbnail(temp, _temp, 133, 100, "Cut"); Tunnel.Common.Message.Show("添加成功!"); string strsql = ""; strsql = "insert into tunnel_log(l_user,l_time,l_content,l_ip,l_sort) values(" + ul.LoginID + ",'" + DateTime.Now + "','信息发布>>图片管理>>新增图片。标题:" + tii.i_name + "','" + Tunnel.Common.Common.GetIp() + "',1)"; Tunnel.Data.DbHelperSQL.ExecuteSql(strsql); } else { Tunnel.Common.Message.Show("此图片已经存在!"); } } else { Tunnel.Common.Message.Show("图片格式不支持。支持的类型有:jpg,gif,bmp"); } } else { Tunnel.Common.Message.Show("请选择图片!"); } }
protected void Page_Load(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Request.QueryString["id"])) { id = Request.QueryString["id"].ToString(); } if (!string.IsNullOrEmpty(Request.QueryString["type"])) { type = Convert.ToInt32(Request.QueryString["type"]); } if (!IsPostBack) { if (!id.Equals("") && !id.Equals("0")) { tii = ti.GetModel(Convert.ToInt32(id)); } } }
/// <summary> /// 删除记录 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void LinkButton1_Command(object sender, CommandEventArgs e) { int Id = Convert.ToInt32(e.CommandName); Tunnel.BLL.Tunnel_Img ti = new Tunnel.BLL.Tunnel_Img(); Tunnel.Model.Tunnel_Img tii = new Tunnel.Model.Tunnel_Img(); tii = ti.GetModel(Convert.ToInt32(Id)); try { File.Delete(Server.MapPath("image\\") + tii.i_uri); File.Delete(Server.MapPath("image\\_") + tii.i_uri); } catch (Exception ex) { Tunnel.Common.Message.Show(ex.Message); } ti.Delete(Convert.ToInt32(Id)); Tunnel.Common.Message.Show("删除成功!"); PageBind(); }
/// <summary> /// 得到一个对象实体 /// </summary> public Tunnel.Model.Tunnel_Img GetModel(int i_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 i_id,i_name,i_uri,i_date,i_user,i_type,i_year from Tunnel_Img "); strSql.Append(" where i_id=@i_id "); SqlParameter[] parameters = { new SqlParameter("@i_id", SqlDbType.Int, 4) }; parameters[0].Value = i_id; Tunnel.Model.Tunnel_Img model = new Tunnel.Model.Tunnel_Img(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["i_id"].ToString() != "") { model.i_id = int.Parse(ds.Tables[0].Rows[0]["i_id"].ToString()); } model.i_name = ds.Tables[0].Rows[0]["i_name"].ToString(); model.i_uri = ds.Tables[0].Rows[0]["i_uri"].ToString(); if (ds.Tables[0].Rows[0]["i_date"].ToString() != "") { model.i_date = DateTime.Parse(ds.Tables[0].Rows[0]["i_date"].ToString()); } if (ds.Tables[0].Rows[0]["i_user"].ToString() != "") { model.i_user = int.Parse(ds.Tables[0].Rows[0]["i_user"].ToString()); } model.i_type = ds.Tables[0].Rows[0]["i_type"].ToString(); model.i_year = ds.Tables[0].Rows[0]["i_year"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 获得数据列表 /// </summary> public List <Tunnel.Model.Tunnel_Img> GetList(PageBase pb, ref int count) { DataTable dt = dal.GetList(pb, ref count).Tables[0]; List <Tunnel.Model.Tunnel_Img> modelList = new List <Tunnel.Model.Tunnel_Img>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0 && pb.DoCount == 0) { Tunnel.Model.Tunnel_Img model; for (int n = 0; n < rowsCount; n++) { model = new Tunnel.Model.Tunnel_Img(); if (dt.Rows[n]["i_id"].ToString() != "") { model.i_id = int.Parse(dt.Rows[n]["i_id"].ToString()); } model.i_name = dt.Rows[n]["i_name"].ToString(); model.i_uri = dt.Rows[n]["i_uri"].ToString(); if (dt.Rows[n]["i_date"].ToString() != "") { model.i_date = DateTime.Parse(dt.Rows[n]["i_date"].ToString()); } if (dt.Rows[n]["i_user"].ToString() != "") { model.i_user = int.Parse(dt.Rows[n]["i_user"].ToString()); } if (dt.Rows[n]["i_type"].ToString() != "") { model.i_type = dt.Rows[n]["i_type"].ToString(); } if (dt.Rows[n]["i_year"].ToString() != "") { model.i_year = dt.Rows[n]["i_year"].ToString(); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Tunnel.Model.Tunnel_Img model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Tunnel_Img("); strSql.Append("i_name,i_uri,i_date,i_user,i_type,i_year)"); strSql.Append(" values ("); strSql.Append("@i_name,@i_uri,@i_date,@i_user,@i_type,@i_year)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@i_name", SqlDbType.VarChar, 50), new SqlParameter("@i_uri", SqlDbType.VarChar, 50), new SqlParameter("@i_date", SqlDbType.DateTime), new SqlParameter("@i_user", SqlDbType.Int, 4), new SqlParameter("@i_type", SqlDbType.VarChar, 50), new SqlParameter("@i_year", SqlDbType.VarChar, 5) }; parameters[0].Value = model.i_name; parameters[1].Value = model.i_uri; parameters[2].Value = model.i_date; parameters[3].Value = model.i_user; parameters[4].Value = model.i_type; parameters[5].Value = model.i_year; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 删除记录 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void LinkButton1_Command(object sender, CommandEventArgs e) { int Id = Convert.ToInt32(e.CommandName); Tunnel.BLL.Tunnel_Img ti = new Tunnel.BLL.Tunnel_Img(); Tunnel.Model.Tunnel_Img tii = new Tunnel.Model.Tunnel_Img(); tii = ti.GetModel(Convert.ToInt32(Id)); try { File.Delete(Server.MapPath("image\\") + tii.i_uri); File.Delete(Server.MapPath("image\\_") + tii.i_uri); } catch (Exception ex) { Tunnel.Common.Message.Show(ex.Message); } ti.Delete(Convert.ToInt32(Id)); Tunnel.Common.Message.Show("删除成功!"); string strsql = ""; strsql = "insert into tunnel_log(l_user,l_time,l_content,l_ip,l_sort) values(" + ul.LoginID + ",'" + DateTime.Now + "','信息发布>>图片管理>>删除图片。标题:" + tii.i_name + "','" + Tunnel.Common.Common.GetIp() + "',2)"; Tunnel.Data.DbHelperSQL.ExecuteSql(strsql); PageBind(); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Tunnel.Model.Tunnel_Img model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Tunnel.Model.Tunnel_Img model) { return(dal.Add(model)); }