/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">ScrollImages对象</param> /// <returns>影响行数</returns> public int Update(ClassLibrary.Model.ScrollImages model) { StringBuilder strSql = new StringBuilder(); strSql.Append(string.Format("UPDATE {0} SET ", table)); strSql.Append("Title=@Title,"); strSql.Append("Img=@Img,"); strSql.Append("LinkURL=@LinkURL,"); strSql.Append("CreatedTime=@CreatedTime"); strSql.Append(" WHERE ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.NVarChar, 100), new SqlParameter("@Img", SqlDbType.NVarChar, 60), new SqlParameter("@LinkURL", SqlDbType.NVarChar, 500), new SqlParameter("@CreatedTime", SqlDbType.DateTime, 8) }; parameters[0].Value = model.ID; parameters[1].Value = model.Title; parameters[2].Value = model.Img; parameters[3].Value = model.LinkURL; parameters[4].Value = model.CreatedTime; return(SQLHelper.Execute(strSql.ToString(), parameters)); }
private void EditLink() { ClassLibrary.Model.ScrollImages linksModel = new ClassLibrary.Model.ScrollImages(); linksModel.ID = newsId; if (string.IsNullOrEmpty(Request.Form["Title"])) { Response.Write("<script>alert('请输入标题!');history.back(-1);</script>"); return; } else { linksModel.Title = Request.Form["Title"]; } linksModel.LinkURL = Request.Form["LinkURL"]; HttpPostedFile file = Request.Files["Img"]; string oldImages = Request.Form["Image_Hidden"]; if (file.ContentLength > 0) { string ext = Path.GetExtension(file.FileName); string fileName = Function.GetRandomTime() + ext; string fileFullPath = Server.MapPath(SysConfig.UploadFilePathScrollImg); Function.CreatedDirectory(fileFullPath); file.SaveAs(fileFullPath + fileName); //缩图 //Bitmap tmp = new Bitmap(fileFullPath + fileName); //Bitmap bmp0 = Function.MakeThumNail(tmp, 735, 352); //tmp.Dispose(); ////bmp0.Save(fileFullPath + fileName); //Function.SaveBitmapImg(bmp0, fileFullPath + fileName, ((long)100)); //bmp0.Dispose(); Function.DeleteFile(fileFullPath + oldImages); linksModel.Img = fileName; } else { linksModel.Img = oldImages; } if (linksBLL.Update(linksModel) > 0) { Function.goMessagePage("修改首页图片", "操作成功", "Advertise/ScrollImageList.aspx"); } else { Function.goMessagePage("修改首页图片", "操作失败,请稍后再试", "Advertise/ScrollImageList.aspx"); } }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">ScrollImages对象</param> public int Add(ClassLibrary.Model.ScrollImages model) { StringBuilder strSql = new StringBuilder(); strSql.Append(string.Format("INSERT INTO {0}(", table)); strSql.Append("Title,Img,LinkURL,CreatedTime"); strSql.Append(") VALUES ("); strSql.Append("@Title,@Img,@LinkURL,@CreatedTime)"); SqlParameter[] parameters = { new SqlParameter("@Title", SqlDbType.NVarChar, 100), new SqlParameter("@Img", SqlDbType.NVarChar, 60), new SqlParameter("@LinkURL", SqlDbType.NVarChar, 500), new SqlParameter("@CreatedTime", SqlDbType.DateTime, 8) }; parameters[0].Value = model.Title; parameters[1].Value = model.Img; parameters[2].Value = model.LinkURL; parameters[3].Value = model.CreatedTime; return(SQLHelper.Execute(strSql.ToString(), parameters)); }
/// <summary> /// 得到一个对象实体 /// </summary> /// <param name="ID">主键ID</param> /// <returns>ScrollImages对象</returns> public ClassLibrary.Model.ScrollImages GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT ID,Title,Img,LinkURL,CreatedTime"); strSql.Append(" FROM "); strSql.Append(table); strSql.Append(string.Format(" WHERE {0}=@{0}", pk)); SqlParameter[] parameters = { new SqlParameter("@" + pk, SqlDbType.Int, 4) }; parameters[0].Value = ID; ClassLibrary.Model.ScrollImages model = new ClassLibrary.Model.ScrollImages(); DataTable dt = SQLHelper.Query(strSql.ToString(), parameters); model.ID = ID; if (dt.Rows.Count > 0) { if (dt.Rows[0]["Title"] != DBNull.Value) { model.Title = Convert.ToString(dt.Rows[0]["Title"]); } if (dt.Rows[0]["Img"] != DBNull.Value) { model.Img = Convert.ToString(dt.Rows[0]["Img"]); } if (dt.Rows[0]["LinkURL"] != DBNull.Value) { model.LinkURL = Convert.ToString(dt.Rows[0]["LinkURL"]); } if (dt.Rows[0]["CreatedTime"] != DBNull.Value) { model.CreatedTime = Convert.ToDateTime(dt.Rows[0]["CreatedTime"]); } } return(model); }