BLL/Base2/MCartModels.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Text;
namespace BLL.Models
{
    public class MCartModels
    {
        /// <summary>
        /// 添加一个收藏
        /// </summary>
        /// <param name="userid"></param>
        /// <param name="fav"></param>
        /// <returns></returns>
        public bool AddFav(string userid,string fav) {

            bool ret = false;
            string str_sqlo = "select * from [tb_mc_fav] where userid=" + userid;
            DataTable dt = new DataTable();
            Library.SqlProvider.OleDb db = new Library.SqlProvider.OleDb();
            try {

                dt = db.ExecuteDataset(COMM.PucConfig.ConnectionStringA, CommandType.Text, str_sqlo).Tables[0];
            }
            catch (Exception ex) { }
            string str_sql = string.Empty;
            if(dt.Rows.Count==0){

                fav = fav + ",";
                str_sql = "inster into [tb_mc_fav] ( userid,fav)values( " + userid + ",'" + fav + "' )";


            }else{

                string str_fav = dt.Rows[0]["fav"].ToString();
                string[] strs_fav = str_fav.Split(new char[]  {','});
                StringBuilder str_favb = new StringBuilder();
                foreach(string s in strs_fav){

                    if (s != fav) {

                        str_favb.Append(s);
                        str_favb.Append(",");
                    }

                }
                str_favb.Append(fav);
                str_favb.Append(",");
               str_sql = "update  [tb_mc_article] set fav='"+str_favb.ToString()+"' where userid= "+userid;
                
            }
            
            
            try
            {
                db.ExecuteNonQuery(COMM.PucConfig.ConnectionStringA, CommandType.Text, str_sql);
                ret = true;
            }