DAL/proimage.cs

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

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

using System;
using System.Collections.Generic;

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

namespace DAL
{
   public  class proimage
    {
       public int Insert(Model.proimage model)
       {

           StringBuilder sql = new StringBuilder();

           sql.Append(" insert into proimage ");

           sql.Append(" values (");

           sql.Append("@imageid,@imageurl,@color,@sizeid");

           sql.Append(")");

           SqlParameter[] par = {
                              new SqlParameter("@imageid",SqlDbType.VarChar,50),
                              new SqlParameter("@imageurl",SqlDbType.VarChar,100),
                              new SqlParameter("@color",SqlDbType.VarChar,50),
                              new SqlParameter("@sizeid",SqlDbType.VarChar,50),                        
                             };


           par[0].Value = model.imageid;
           par[1].Value = model.imageurl;
           par[2].Value = model.color;
           par[3].Value = model.sizeid;

           return Common.DbHelperSQL.ExecuteSql(sql.ToString(), par);

       }
       public int selectid(Model.proimage mym)
       {
           StringBuilder sql = new StringBuilder();

           sql.Append(" select _id  from proimage ");
           sql.Append(" where _sizeid=@sizeid ");

           SqlParameter[] par = {
                              new SqlParameter("@sizeid",SqlDbType.VarChar,50)
                                 };
           par[0].Value = mym.sizeid;

           return (int)Common.DbHelperSQL.GetSingle(sql.ToString(), par);
                         
 
       }
       public DataSet select_sizeid(string  mym)
       {
           StringBuilder sql = new StringBuilder();