DAL/DALshoplist2.cs

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

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

using System;
using System.Collections.Generic;

using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace DAL
{
      public    class DALshoplist2
    {
          public  SqlDataReader  readaddress(Model .address myaddress)
          {
              StringBuilder sql = new StringBuilder();
              sql.Append("select * from address where _userid=@userid");
              SqlParameter[] par ={new SqlParameter ("@userid",SqlDbType .Int ,4)
                                 };
              par[0].Value = myaddress.userid;
              return Common.DbHelperSQL.ExecuteReader (sql.ToString(), par);
 
          }
        public int insert(Model .order myorder)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("insert into ordertable(_ordernum,_userid,_buyremarks,_count,_address,_tel,_mobile,_mail,_sumprice,_name,_needbill,_waysgive) ");
            sql.Append("values(@ordernum,@userid,@buyremarks,@count,@address,@tel,@mobile,@mail,@sumprice,@name,@needbill,@waysgive)");
            SqlParameter[] par ={
                                new  SqlParameter ("@ordernum",SqlDbType .VarChar ,50),
                                new SqlParameter ("@userid",SqlDbType .Int ,4),
                                new SqlParameter ("@buyremarks",SqlDbType .VarChar ,350),
                                new SqlParameter ("@count",SqlDbType .Int ,4),
                                new SqlParameter ("@address",SqlDbType .VarChar ,150),
                                new SqlParameter ("@tel",SqlDbType .VarChar,50),
                                new SqlParameter ("@mobile",SqlDbType .VarChar ,50),
                                new SqlParameter ("@mail",SqlDbType .VarChar ,50),
                                new SqlParameter ("@sumprice",SqlDbType .Money ,8), 
                                new SqlParameter ("@name",SqlDbType .VarChar ,50),
                                new SqlParameter ("@needbill",SqlDbType .Int ,4),
                                new SqlParameter ("@waysgive",SqlDbType .VarChar  ,50)
                                
                                };
            par[0].Value = myorder.ordernum;
            par[1].Value = myorder.userid;
            par[2].Value = myorder.buyremarks;
            par[3].Value = myorder.count;
            par[4].Value = myorder.address;
            par[5].Value = myorder.tel;
            par[6].Value = myorder.mobile;
            par[7].Value = myorder.mail;
            par[8].Value = myorder.sumprice;
  
            par[9].Value = myorder.name;
            par[10].Value = myorder.needbill;
            par[11].Value = myorder.waysgive;
            return Common.DbHelperSQL.ExecuteSql (sql.ToString(), par); 
        }
        public int insertdetail(Model .orderdetail myorderdetail)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("insert into orderdetail(_count,_ordernum,_sumprice,_price,_weight,_sumweight,_title,_proid,_size,_color,_proimage,_cate) ");
            sql.Append("values(@count,@ordernum,@sumprice,@price,@weight,@sumweight,@title,@proid,@size,@color,@proimage,@cate)");