Smokewinetea.DAL/StockDal.cs

（开头部分） 3KB

这里只显示每个文件的开头 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 StockDal
    {
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="jh"></param>
        /// <param name="jj"></param>
        /// <returns></returns>
        public static List<StockModels> getAllList(string jh, string jj)
        {
            StringBuilder strSql = new StringBuilder();

            switch (jh)
            {
                case "查询全部": strSql.Append("select StockUmber, StockName,StockTime,Stocknumber,Unitprice,Alprices,ExamineGoods,AdvancePayment,NetPay,TermDay,Drawee from Stock order by StockUmber desc");
                    break;
                case "查询": strSql.AppendFormat("select * from Stock where  StockName like '%{0}%' ", jj);

                    break;
            }

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

            List<StockModels> modelList = new List<StockModels>();
            StockModels model;
            while (dr.Read())
            {
                model = new StockModels();
                model.StockUmber = Convert.ToInt32(dr["StockUmber"]);
                model.StockName = dr["StockName"].ToString();
                model.StockTime = dr["StockTime"].ToString();
                model.Stocknumber = dr["Stocknumber"].ToString();
                model.Unitprice = Convert.ToInt32(dr["Unitprice"]);
                model.Alprices = Convert.ToInt32(dr["Alprices"]);
                model.ExamineGoods = dr["ExamineGoods"].ToString();
                model.AdvancePayment = Convert.ToInt32(dr["AdvancePayment"]);
                model.NetPay = Convert.ToInt32(dr["NetPay"]);
                model.TermDay = dr["TermDay"].ToString();
                model.Drawee = dr["Drawee"].ToString();
                modelList.Add(model);
            }
            dr.Close();
            DbHelper.ConClose();
            return modelList;
        }


        /// <summary>
        /// 修改
后面还有 42 行代码，解锁后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。