public bool AddPropImg(Entity.Goods.PropImg model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PropImg("); strSql.Append("PropImgID,ID,Position,Properties,Url"); strSql.Append(") values ("); strSql.Append("@PropImgID,@ID,@Position,@Properties,@Url"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@PropImgID", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@Position", SqlDbType.Int, 4), new SqlParameter("@Properties", SqlDbType.VarChar, 1000), new SqlParameter("@Url", SqlDbType.VarChar, 200) }; parameters[0].Value = model.PropImgId; parameters[1].Value = model.Id; parameters[2].Value = model.Position; parameters[3].Value = model.Properties; parameters[4].Value = model.Url; int Ares = DBHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (Ares > 0) { return(true); } else { return(false); } }
public bool UpdatePropImg(Entity.Goods.PropImg model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PropImg set "); strSql.Append(" PropImgID = @PropImgID , "); strSql.Append(" ID = @ID , "); strSql.Append(" Position = @Position , "); strSql.Append(" Properties = @Properties , "); strSql.Append(" Url = @Url "); strSql.Append(" where PropImgID=@PropImgID"); SqlParameter[] parameters = { new SqlParameter("@PropImgID", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@Position", SqlDbType.Int, 4), new SqlParameter("@Properties", SqlDbType.VarChar, 1000), new SqlParameter("@Url", SqlDbType.VarChar, 200) }; parameters[5].Value = model.PropImgId; parameters[6].Value = model.Id; parameters[7].Value = model.Position; parameters[8].Value = model.Properties; parameters[9].Value = model.Url; int Ares = DBHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (Ares > 0) { return(true); } else { return(false); } }