/// <summary>
/// 添加图片
/// </summary>
/// <param name="p">图片信息</param>
/// <returns>受影响的行数</returns>
public int AddPhoto(Photos p)
{
string sql = "insert into Photos (PTypeId, PTitle, PUrl, PDes) values (@PTypeId,@PTitle, @PUrl, @PDes)";
SqlParameter[] param = {
new SqlParameter("@PTypeId",SqlDbType.Int){Value=p.PTypeId},
new SqlParameter("@PTitle",SqlDbType.NVarChar){Value=p.PTitle},
new SqlParameter("@PUrl",SqlDbType.NVarChar){Value=p.PUrl},
new SqlParameter("@PDes",SqlDbType.NVarChar){Value=p.PDes}
};
return SQLHelper.ExecuteNonQuery(sql,CommandType.Text,param);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int pid;
if (int.TryParse(Request.QueryString["pid"], out pid))
{
Photos p = new PhotosBLL().GetPhotoByPid(pid);
if (p != null)
{
title = p.PTitle;
url = p.PUrl;
des = p.PDes;
id = p.PId.ToString() ;
}
else
{
Response.Write("<script>alert('加载失败！');location.href='Default.aspx'</script>");
}
}
else
{
Response.Write("<script>alert('参数错误！');location.href='Default.aspx'</script>");
}
}
else
{
Photos p = new Photos();
p.PTitle = Request.Form["txtTitle"];
p.PUrl = Request.Form["url"];
p.PDes = Request.Form["txtDes"];
p.PId = Convert.ToInt32(Request.Form["pid"]);
p.PTypeId = 1;
if (new PhotosBLL().Update(p))
{
Response.Write("<script>alert('修改成功！');location.href='Default.aspx'</script>");
}
else
{
msg.Text = "<script>alert('修改失败');</script>";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
string msg = "";
HttpPostedFile file = Request.Files[0];
if (file.ContentLength != 0)
{
if (file.ContentType == "image/jpeg" || file.ContentType == "image/pjpeg")
{
string ext = System.IO.Path.GetExtension(file.FileName);
string name = DateTime.Now.ToString("yyMMddhhmmss") + new Random().Next(1000, 10000) + ext;
string fullName = Request.MapPath("../images/" + name);
file.SaveAs(fullName);
Photos p = new Photos();
p.PTypeId = 1;
p.PTitle = Request.Form["txtTitle"];
p.PUrl = name;
p.PDes = Request.Form["txtDes"];
if (new PhotosBLL().Insert(p))
{
Response.Write("<script>alert('添加成功！');location.href='Default.aspx';</script>");
}
else
{
msg = "添加失败！";
}
}
else
{
msg = "请选择jpg类型文件！";
}
}
else
{
msg = "请选择文件！";
}
lblMsg.Text = msg;
lblMsg.ForeColor = Color.Red;
}
}
/// <summary>
/// 获得SqlParameter数组
/// </summary>
/// <param name="p">photos对象</param>
/// <param name="flag">0--增加，1--更新</param>
/// <returns></returns>
private SqlParameter[] GetParam(Photos p, int flag)
{
List<SqlParameter> list = new List<SqlParameter>();
list.AddRange(new SqlParameter[]{
new SqlParameter("@PTitle",SqlDbType.NVarChar),
new SqlParameter("@PUrl",SqlDbType.NVarChar),
new SqlParameter("@PDes",SqlDbType.NVarChar),
new SqlParameter("@PTypeId",SqlDbType.NVarChar)});
list[0].Value = p.PTitle;
list[1].Value = p.PUrl;
list[2].Value = p.PDes;
list[3].Value = p.PTypeId;
if (flag == 1)
{
list.Add(new SqlParameter("@PId", p.PId));
list[list.Count - 1].Value = p.PId;
}
return list.ToArray();
}
/// <summary>
/// DataTable转换成photos对象
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
private List<Photos> DTToList(DataTable dt)
{
List<Photos> list = new List<Photos>();
foreach (DataRow dr in dt.Rows)
{
Photos p = new Photos();
//dr["PClicks"] != DBNull.Value 判断dr["PClicks"]是否为空
p.PClicks = Convert.ToInt32(dr["PClicks"]);
p.PDes = dr["PDes"].ToString();
p.PDown = Convert.ToInt32(dr["PDown"]);
p.PId = Convert.ToInt32(dr["PId"]);
p.PTime = Convert.ToDateTime(dr["PTime"]);
p.PTitle = dr["PTitle"].ToString();
p.PTypeId = Convert.ToInt32(dr["PTypeId"]);
p.PUp = Convert.ToInt32(dr["PUp"]);
p.PUrl = dr["PUrl"].ToString();
list.Add(p);
}
return list;
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public bool Update(Photos p)
{
string sql = "update Photos set PTitle=@PTitle,PUrl=@PUrl,PDes=@PDes,PTypeId=@PTypeId where PId=@PId";
return SQLHelper.ExecuteNonQuery(sql, GetParam(p, 1)) > 0;
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public bool Insert(Photos p)
{
string sql = "insert into Photos (PTypeId, PTitle, PUrl, PDes) values(@PTypeId, @PTitle, @PUrl, @PDes)";
return SQLHelper.ExecuteNonQuery(sql, GetParam(p, 0)) > 0;
}
public int DeletePhoto(Photos p)
{
return DeletePhoto(p.PId);
}
/// <summary>
/// 添加图片
/// </summary>
/// <param name="p">图片信息</param>
/// <returns>受影响的行数</returns>
public int AddPhoto(Photos p)
{
return photoDAl.AddPhoto(p);
}
/// <summary>
/// 更新图片
/// </summary>
/// <param name="p">图片信息</param>
/// <returns>受影响的行数</returns>
public int UpdatePhoto(Photos p)
{
return photoDAl.UpdatePhoto(p);
}
/// <summary>
/// 添加跟修改照片
/// </summary>
/// <param name="action">add添加 edit修改</param>
/// <param name="p">照片对象</param>
/// <returns></returns>
public bool Save(string action,Photos p)
{
bool r = false;
if (action=="add")
{
r = AddPhoto(p) > 0 ? true : false;
}
else if (action=="edit")
{
r = UpdatePhoto(p) > 0 ? true : false;
}
return r;
}
/// <summary>
/// 更新图片
/// </summary>
/// <param name="p">图片信息</param>
/// <returns>受影响的行数</returns>
public int UpdatePhoto(Photos p)
{
string sql = "update photos set PTypeId=@PTypeId, PTitle=@PTitle, PUrl=@PUrl, PDes=@PDes where PId=" + p.PId;
SqlParameter[] param ={
new SqlParameter("@PTypeId",SqlDbType.Int){Value=p.PTypeId},
new SqlParameter("@PTitle",SqlDbType.NVarChar){Value=p.PTitle},
new SqlParameter("@PUrl",SqlDbType.NVarChar){Value=p.PUrl},
new SqlParameter("@PDes",SqlDbType.NVarChar){Value=p.PDes}
};
return SQLHelper.ExecuteNonQuery(sql, CommandType.Text, param);
}
/// <summary>
/// 根据对象删除数据
/// </summary>
/// <param name="id">photos对象id</param>
/// <returns></returns>
public bool Delete(Photos p)
{
return Delete(p.PId);
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public bool Update(Photos p)
{
return pd.Update(p);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public bool Insert(Photos p)
{
return pd.Insert(p);
}