public bool UpdateDescModuleInfo(Entity.Goods.DescModuleInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update DescModuleInfo set "); strSql.Append(" AnchorModuleIds = @AnchorModuleIds , "); strSql.Append(" Type = @Type "); strSql.Append(" where DescModuleInfoID=@DescModuleInfoID "); SqlParameter[] parameters = { new SqlParameter("@DescModuleInfoID", SqlDbType.Int, 4), new SqlParameter("@AnchorModuleIds", SqlDbType.VarChar, 1000), new SqlParameter("@Type", SqlDbType.VarChar, 50) }; parameters[2].Value = model.DescModuleInfoID; parameters[3].Value = model.AnchorModuleIds; parameters[4].Value = model.Type; int rows = DBHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public int AddDescModuleInfo(Entity.Goods.DescModuleInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DescModuleInfo("); strSql.Append("AnchorModuleIds,Type"); strSql.Append(") values ("); strSql.Append("@AnchorModuleIds,@Type"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@AnchorModuleIds", SqlDbType.VarChar, 1000), new SqlParameter("@Type", SqlDbType.VarChar, 50) }; parameters[0].Value = model.AnchorModuleIds; parameters[1].Value = model.Type; object obj = DBHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }