DAL/collect.cs

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

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

using System;
using System.Collections.Generic;

using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace DAL
{
    public   class  collect
    {
        public DataSet drco(int a,int b,Model.collect aa)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("select * from collect  where _userid=@id");
            SqlParameter[] par = {
                                     new SqlParameter("@id",SqlDbType.Int,4)
                                 };
            par[0].Value = aa.userid;
            return Common.DbHelperSQL.PageQuery(sql.ToString(),a,b,par);
        }
        public int count(Model.collect aa)
        {
            String sql = "select count(*) from collect where _userid='" + aa.userid + "'";
            int i=Convert.ToInt32(Common.DB.ExecuteScalar(sql));
            return i; 
        }

        public int inser(Model.collect aa)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("insert into collect (_userid)values(@id)");
            SqlParameter[] par = {
                                     new SqlParameter("@id",SqlDbType .Int,4)
                                 };
            par[0].Value = aa.userid;
            return Common.DbHelperSQL.ExecuteSql(sql.ToString(),par);
        }
        public int inserc(Model.collect aa)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("insert into collect (_userid,_proid,_proname,_proprice,_proimage)values(@userid,@id,@name,@price,@image)");
            SqlParameter[] par = {
                                     new SqlParameter("@userid",SqlDbType.Int,4),
                                     new SqlParameter("@id",SqlDbType.Int,4),
                                     new SqlParameter("@name",SqlDbType.VarChar,50),
                                     new SqlParameter("@price",SqlDbType.Money,16),
                                     new SqlParameter("@image",SqlDbType.VarChar,50)
                                 };
            par[0].Value = aa.userid;
            par[1].Value = aa.proid;
            par[2].Value = aa.proname;
            par[3].Value = aa.proprice;
            par[4].Value = aa.proimage;
            return Common.DbHelperSQL.ExecuteSql(sql.ToString(),par);
        }
        public int deco(Model.collect aa)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("delete from collect where _id=@id");