//添加按钮
protected void btnadd_Click(object sender, EventArgs e)
{
if (this.txtphotoname.Text == null || this.txtcribe.Text == null)
{
{ Page.ClientScript.RegisterStartupScript(typeof(string), "飞", "<script>alert(' 请输入相关信息')</script>"); }
}
else
{
model_photoalbum bum = new model_photoalbum();
bum.photobumName = this.txtphotoname.Text.Trim();
bum.photobumcribe = this.txtcribe.Text.Trim();
int a = new BLL_photoalbum().BLL_insert_photoalbum_data_ExecuteNonQuery(bum);
if (a > 0)
{
Page.ClientScript.RegisterStartupScript(typeof(string), "飞", "<script>alert('添加成功')</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(typeof(string), "飞", "<script>alert('添加失败')</script>");
}
this.GVwMaintainPhoto.DataSource = new BLL_photoalbum().BLL_select_photoalbum_all();
this.GVwMaintainPhoto.DataBind();
}
}
/// <summary>
/// 向相册表中插入相册
/// </summary>
/// <param name="pho"></param>
/// <returns></returns>
public int insert_photoalbum_data_ExecuteNonQuery(model_photoalbum pho)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter ("@photobumName",pho.photobumName ),
new SqlParameter ("@photobumcribe",pho.photobumcribe)
};
int a = sqlHelper.ExecuteNonQuery("insert_photoalbum_data", parm);
return a;
}
/// <summary>
/// --更新相册表中数据根据相册ID
/// </summary>
/// <param name="pho"></param>
/// <returns></returns>
public int update_photoalbum_where_ID(model_photoalbum pho)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter("@photoalbumID",pho.photoalbumID ),
new SqlParameter ("@photobumName",pho.photobumName ),
new SqlParameter ("@photobumcribe",pho.photobumcribe)
};
int a = sqlHelper.ExecuteNonQuery("update_photoalbum_where_ID", parm);
return a;
}
protected void GVwMaintainPhoto_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
model_photoalbum bum = new model_photoalbum();
bum.photoalbumID = Convert.ToInt32(this.GVwMaintainPhoto.DataKeys[e.RowIndex].Value);
TextBox box = GVwMaintainPhoto.Rows[e.RowIndex].Cells[0].FindControl("TextBox1") as TextBox;
TextBox boc = GVwMaintainPhoto.Rows[e.RowIndex].Cells[0].FindControl("TextBox2") as TextBox;
bum.photobumName = box.Text;
bum.photobumcribe = boc.Text;
int a = new BLL_photoalbum().update_photoalbum_where_ID(bum);
}
/// <summary>
/// 查询相册表中有哪些相册
/// </summary>
/// <returns>list集合</returns>
public List <model_photoalbum> selcet_photoalbum_count()
{
List <model_photoalbum> list = new List <model_photoalbum>();
SqlDataReader dr = sqlHelper.ExecuteReader("select_photoalbum_name");
while (dr.Read())
{
model_photoalbum pho = new model_photoalbum();
pho.photoalbumID = Convert.ToInt32(dr["photoalbumID"]);
pho.photobumName = dr["photobumName"].ToString();
list.Add(pho);
}
return(list);
}
/// <summary>
/// 维护相册查询所有相册表中相册的信息
/// </summary>
/// <returns>List</returns>
public List<model_photoalbum> select_photoalbum_all()
{
List<model_photoalbum> list = new List<model_photoalbum>();
SqlDataReader dr = sqlHelper.ExecuteReader("select_photoalbum_all");
while (dr.Read())
{
model_photoalbum me = new model_photoalbum();
me.photoalbumID = Convert.ToInt32(dr["photoalbumID"]);
me.photobumName = dr["photobumName"].ToString();
me.photobumcribe = dr["photobumcribe"].ToString();
list.Add(me);
}
return list;
}
/// <summary>
/// --更新相册表中数据根据相册ID
/// </summary>
/// <param name="pho"></param>
/// <returns></returns>
public int update_photoalbum_where_ID(model_photoalbum pho)
{
return(new DAL_photoalbum().update_photoalbum_where_ID(pho));
}
/// <summary>
/// 向相册表中插入相册
/// </summary>
/// <param name="pho"></param>
/// <returns></returns>
public int BLL_insert_photoalbum_data_ExecuteNonQuery(model_photoalbum pho)
{
return(new DAL_photoalbum().insert_photoalbum_data_ExecuteNonQuery(pho));
}
