public void AddMyLove(global::Model.sys_t_oper_mylove mylove) { string sql = "select * from sys_t_oper_mylove where oper_id='" + mylove.oper_id + "' and substring(oper_type,3,2) " + (mylove.oper_type.Substring(1, 2).Equals("00") ? "=" : "!=") + " '00' "; var tb = d.ExecuteToTable(sql, null); if ((tb.Rows.Count < 8 && !mylove.oper_type.Substring(1, 2).Equals("00")) || (tb.Rows.Count < 10 && mylove.oper_type.Substring(1, 2).Equals("00"))) { tb = d.ExecuteToTable("select * from sys_t_oper_mylove where oper_id='" + mylove.oper_id + "' and oper_type='" + mylove.oper_type + "'", null); if (tb.Rows.Count < 1) { d.Insert(mylove); } } else { throw new Exception("超过收藏数量"); } }
public void deleteMyLove(global::Model.sys_t_oper_mylove mylove) { d.ExecuteScalar("delete from sys_t_oper_mylove where oper_id='" + mylove.oper_id + "' and oper_type='" + mylove.oper_type + "'", null); }