DAL/product.cs

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

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

using System;
using System.Collections.Generic;

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

namespace DAL
{
   public class product
    {

       public int Insert(Model.product mym)
       {

           StringBuilder sql = new StringBuilder();

           sql.Append("insert into product");

           sql.Append(" values (");

           sql.Append("@title,@cateid,@marketprice,@localprice,@content,@posttime,@weight,@ischeap,@isrecommend,@top,@procount,@imageid");

           sql.Append(")");

           SqlParameter[] par = {
                              new SqlParameter("@title",SqlDbType.VarChar,50),
                              new SqlParameter("@cateid",SqlDbType.Int,4),
                              new SqlParameter("@marketprice",SqlDbType.Money,32),
                              new SqlParameter("@localprice",SqlDbType.Money,32),
                               new SqlParameter("@content",SqlDbType.VarChar,0),
                                new SqlParameter("@posttime",SqlDbType.VarChar,50),
                             new SqlParameter("@weight",SqlDbType.VarChar,50),  
                              new SqlParameter("@ischeap",SqlDbType.Int,4),
                              new SqlParameter("@isrecommend",SqlDbType.Int,4),
                              new SqlParameter("@top",SqlDbType.Int,4), 
                              new SqlParameter("@procount",SqlDbType.Int,5), 
                              new SqlParameter("@imageid",SqlDbType.VarChar,50),  
                             
                             };


           par[0].Value = mym.title;

           par[1].Value = mym.cateid;
           par[2].Value=mym.marketprice;
           par[3].Value=mym.localprice;
           par[4].Value=mym.content;
           par[5].Value=mym.posttime;
           par[6].Value=mym.weight;
           par[7].Value=mym.ischeap;
           par[8].Value=mym.isrecomment;
           par[9].Value=mym.top;
           par[10].Value=mym.procount;
           par[11].Value=mym.imageid;