TrainSign.DAL/H_userCollect.cs

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

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

using System;
using System.Text;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Data;
using TindWit.DBUtility;

namespace Maticsoft.DAL
{
    //H_userCollect
    public partial class H_userCollect
    {

        public bool Exists(int collectID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from H_userCollect");
            strSql.Append(" where ");
            strSql.Append(" collectID = @collectID  ");
            SqlParameter[] parameters = {
					new SqlParameter("@collectID", SqlDbType.Int,4)
			};
            parameters[0].Value = collectID;

            return DbHelperSQL.Exists(strSql.ToString(), parameters);
        }




        public Maticsoft.Model.H_userCollect ExistsUserCollect(int userID, int collectContentID)
        {

            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  status from H_userCollect  ");
            strSql.Append(" where userID ='" + userID + "' and collectContentID='" + collectContentID + "'");

            Maticsoft.Model.H_userCollect model = new Maticsoft.Model.H_userCollect();
            DataSet ds = DbHelperSQL.Query(strSql.ToString());

            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["status"].ToString() != "")
                {
                    model.status = int.Parse(ds.Tables[0].Rows[0]["status"].ToString());
                }
                return model;
            }
            else
            {
                return null;
            }
        }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Maticsoft.Model.H_userCollect model)
        {