/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">ScrollImages对象</param>
/// <returns>影响行数</returns>
public int Update(ClassLibrary.Model.AppScrollImages 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.AppScrollImages linksModel = new ClassLibrary.Model.AppScrollImages();
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/AppScrollImageList.aspx");
}
else
{
Function.goMessagePage("修改首页图片", "操作失败，请稍后再试", "Advertise/AppScrollImageList.aspx");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">ScrollImages对象</param>
public int Add(ClassLibrary.Model.AppScrollImages 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.AppScrollImages 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.AppScrollImages model = new ClassLibrary.Model.AppScrollImages();
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);
}
