protected void rptClassList_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "lbEdit") { string id = e.CommandArgument.ToString(); proid = int.Parse(id); pimg= pbll.proImgsGetModel(id); this.lbProname.Text = pimg.Product_name; this.proimg.ImageUrl = "~/ProImg/" + pimg.ImgName; if (!this.proimg.Visible) { this.proimg.Visible = true; } this.btnSubmit.Text = "修改"; } if (e.CommandName == "lbDelete") { string id = e.CommandArgument.ToString(); comm.DeleteByCondition("dbo.tbProimgs", " where imgID=" + id); pageindex = 0; Proimglist(); } }
/// <summary> /// 根据图片编号查询图片详细模型 /// </summary> /// <param name="imgsid">图片编号</param> /// <returns>tbProimgs</returns> public tbProimgs proImgsGetModel(string imgID) { SqlParameter[] parameters = { new SqlParameter("@imgID", SqlDbType.Int,4) }; parameters[0].Value = imgID; tbProimgs model = new tbProimgs(); DataSet ds = dbhelper.ExcuteSelectReturnDataSet("tbProimgs_GetModel", CommandType.StoredProcedure, parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["imgID"].ToString() != "") { model.imgID = int.Parse(ds.Tables[0].Rows[0]["imgID"].ToString()); } if (ds.Tables[0].Rows[0]["Proid"].ToString() != "") { model.Proid = int.Parse(ds.Tables[0].Rows[0]["Proid"].ToString()); } model.ImgName = ds.Tables[0].Rows[0]["ImgName"].ToString(); model.Product_name = ds.Tables[0].Rows[0]["Product_name"].ToString(); return model; } else { return null; } }
/// <summary> /// 修改产品图片信息 /// </summary> /// <param name="model">tbProimgs对象</param> /// <returns>int</returns> public int proimgsUpdate(tbProimgs model) { SqlParameter[] parameters = { new SqlParameter("@imgID", SqlDbType.Int,4), new SqlParameter("@Proid", SqlDbType.Int,4), new SqlParameter("@ImgName", SqlDbType.NVarChar,200)}; parameters[0].Value = model.imgID; parameters[1].Value = model.Proid; parameters[2].Value = model.ImgName; return dbhelper.ExcuteCommandReturnInt("tbProimgs_Update", CommandType.StoredProcedure, parameters); }
/// <summary> /// 增加一条产品图片数据 /// </summary> public int proImagsAdd(tbProimgs model) { SqlParameter[] parameters = { new SqlParameter("@imgID", SqlDbType.Int,4), new SqlParameter("@Proid", SqlDbType.Int,4), new SqlParameter("@ImgName", SqlDbType.NVarChar,200)}; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.Proid; parameters[2].Value = model.ImgName; dbhelper.ExcuteCommandReturnInt("tbProimgs_ADD", CommandType.StoredProcedure, parameters); return (int)parameters[0].Value; }