Smokewinetea.DAL/ReserveDal.cs

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

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

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


namespace Smokewinetea.DAL
{
    public class ReserveDal
    {
        public static List<ReserveModels> getAllList(string op,string type,string tj)
        {
            StringBuilder strSql = new StringBuilder();
            switch (op)
            {
                case "查询全部": strSql.Append("select ReserveUmder,ReserveName,Reservenumder,ReserveAprices,Producingarea,ProductTime,DueTime,Company,StockTime,ReserveAlprices,Resertyoe from Reserve");
                    break;
                case "模糊查询": strSql.AppendFormat("select * from Reserve where Resertyoe like'%{0}%' and ReserveName like '%{1}%'",type ,tj);
                   
                    break;
            }

            SqlDataReader dr = DbHelper.ExecuteReader(strSql.ToString());

            List<ReserveModels> modelList = new List<ReserveModels>();
            ReserveModels model;
            while (dr.Read())
            {
                model = new ReserveModels();
                model.ReserveUmder = Convert.ToInt32(dr["ReserveUmder"]);
                model.ReserveName = dr["ReserveName"].ToString();
                model.Reservenumder = dr["Reservenumder"].ToString();
                model.ReserveAprices = Convert.ToInt32(dr["ReserveAprices"]);
                model.Producingarea = dr["Producingarea"].ToString();
                model.ProductTime =Convert.ToDateTime( dr["ProductTime"]);
                model.DueTime =Convert.ToDateTime ( dr["DueTime"]);
                model.Company = dr["company"].ToString();
                model.StockTime =Convert.ToDateTime( dr["StockTime"]);
                model.ReserveAlprices = Convert.ToInt32(dr["ReserveAlprices"]);
                model.Resertyoe = dr["Resertyoe"].ToString();
                modelList.Add(model);
            }
            dr.Close();
            DbHelper.ConClose();
            
            return modelList;
        }

          /// <summary>
        /// 计算物品小于10条的有多少条记录
        /// </summary>
        /// <returns></returns>
        public static List<ReserveModels> umder()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select COUNT(Reservenumder) from Reserve where Reservenumder < 10");
            SqlDataReader dr = DbHelper.ExecuteReader(strSql.ToString());