Smokewinetea.DAL/PurchaseDal.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 PurchaseDal
    {
        public static List<PurchaseModels> getAllList(string op, string tk)
        {
            StringBuilder strSql = new StringBuilder();
            switch (op)
            {
                case "查询全部": strSql.Append("select PurchaseUmber, PurchaseName,PurchaseTime,Purchasenumber,Purchaseunitprice,PurchaseAlprices,PurchaseReason,PurchaseStaff from purchase");
                    break;
                case "查询": strSql.AppendFormat("select * from purchase where PurchaseName like '%{0}%' ", tk);
                  
                    break;
            }
            SqlDataReader dr = DbHelper.ExecuteReader(strSql.ToString());
            List<PurchaseModels> modelList = new List<PurchaseModels>();
            PurchaseModels model;
            while (dr.Read())
            {
                model = new PurchaseModels();
                model.PurchaseUmber = Convert.ToInt32(dr["PurchaseUmber"]);
                model.PurchaseName = dr["PurchaseName"].ToString();
                model.PurchaseTime = Convert.ToDateTime(dr["PurchaseTime"]);
                model.Purchasenumber = dr["Purchasenumber"].ToString();
                model.Purchaseunitprice = Convert.ToInt32(dr["Purchaseunitprice"]);
                model.PurchaseAlprices = Convert.ToInt32(dr["PurchaseAlprices"]);
                model.PurchaseReason = dr["PurchaseReason"].ToString();
                model.PurchaseStaff = dr["PurchaseStaff"].ToString();
                modelList.Add(model);
            }
            dr.Close();
            DbHelper.ConClose();
            return modelList;
        }

        /// <summary>
        /// 退货表
        /// </summary>
        /// <returns></returns>
        public static List<PurchaseModels> GetAllPurchase()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select PurchaseName,purchaseTime,Purchasenumber,Purchaseunitprice,PurchaseAlprices,PurchaseReason,PurchaseStaff from purchase");
            SqlDataReader dr = DbHelper.ExecuteReader(strSql.ToString());
            List<PurchaseModels> modelList = new List<PurchaseModels>();
            PurchaseModels model;
            while (dr.Read())
            {
                model = new PurchaseModels();
                model.PurchaseName = dr[0].ToString();