Smokewinetea.DAL/BoosrEceiveDAl.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using SmokewineteaModels;
using System.Data.SqlClient;
using System.Data;

namespace Smokewinetea.DAL
{
  public  class BoosrEceiveDAl
    {
      /// <summary>
      /// 查询
      /// </summary>
      /// <param name="op"></param>
      /// <param name="to"></param>
      /// <param name="tj"></param>
      /// <returns></returns>
      public static List<BoosrEceiveModel> boosr(string op,DateTime to,string tj)
      {
          StringBuilder sql = new StringBuilder();
          switch (op)
          {
              case "查询全部": sql.Append("select BeUmber,BeName,BeTime,Benumber,Beunitprice,BeAlprices,BendName,Benstatus,CustomNameB,MemberB from BoosrEceive");
                  break;
              case "模糊查询": sql.AppendFormat("select * from BoosrEceive where BeTime ='{0}' and BeName like '%{1}%'", to,tj);
                  break;
          }
          SqlDataReader dr = DbHelper.ExecuteReader(sql.ToString());
          List<BoosrEceiveModel> list = new List<BoosrEceiveModel>();
          BoosrEceiveModel boos;
          while(dr.Read())
          {
              boos = new BoosrEceiveModel();
              boos.BeUmber = Convert.ToInt32(dr[0]);
              boos.BeName = dr[1].ToString();
              boos.BeTime = Convert.ToDateTime(dr[2]);
              boos.Benumber = Convert.ToInt32(dr[3]);
              boos.Beunitprice = Convert.ToInt32(dr[4]);
              boos.BeAlprices = Convert.ToInt32(dr[5]);
              boos.BendName = dr[6].ToString();
              boos.Benstatus = dr[7].ToString();
              boos.CustomNameB = dr[8].ToString();
              boos.MemberB = Convert.ToInt32(dr[9]);  
              list.Add(boos);
          }
          dr.Close();
          DbHelper.ConClose();
          return list;

      }

      /// <summary>
      /// 删除
      /// </summary>
      /// <param name="boos"></param>
      /// <returns></returns>
      public static int deleteBoos(int boos)
      {