Smokewinetea.DAL/IncreaseDal.cs

（开头部分） 4KB

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

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

namespace Smokewinetea.DAL
{
    public class IncreaseDal
    {
        /// <summary>
        /// 进货表
        /// </summary>
        /// <returns></returns>
        public static List<StockModels> GetAllGrade()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select StockName,StockTime,Stocknumber,Unitprice,Alprices,ExamineGoods,AdvancePayment,NetPay,TermDay,Drawee  from Stock");
            SqlDataReader dr = DbHelper.ExecuteReader(strSql.ToString());
            List<StockModels> modelList = new List<StockModels>();
            StockModels model;
            while (dr.Read())
            {
                model = new StockModels();
                model.StockName = dr[0].ToString();
                model.StockTime = dr[1].ToString();
                model.Stocknumber = dr[2].ToString();
                model.Unitprice = Convert.ToInt32(dr[3]);
                model.Alprices = Convert.ToInt32(dr[4]);
                model.ExamineGoods = dr[5].ToString();
                model.AdvancePayment = Convert.ToInt32(dr[6]);
                model.NetPay = Convert.ToInt32(dr[7]);
                model.TermDay = dr[8].ToString();
                model.Drawee = dr[9].ToString();

            }
            dr.Close();
            DbHelper.ConClose();
            return modelList;
        }

        //添加进货表
        public static int InsertStock(StockModels sto)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("insert into Stock values (@StockName,@StockTime,@Stocknumber,@Unitprice,@Alprices,@ExamineGoods,@AdvancePayment,@NetPay,@TermDay,@Drawee)");
            SqlParameter[] pramt ={
                                      
                                      new SqlParameter("StockName",SqlDbType.VarChar,50),
                                      new SqlParameter("StockTime",SqlDbType.DateTime),
                                      new SqlParameter("Stocknumber",SqlDbType.VarChar,50),
                                      new SqlParameter("Unitprice",SqlDbType.Money),
                                      new SqlParameter("Alprices",SqlDbType.Money),
                                      new SqlParameter("ExamineGoods",SqlDbType.VarChar,50),
                                      new SqlParameter("AdvancePayment",SqlDbType.Money),
                                      new SqlParameter("NetPay",SqlDbType.Money),
                                      new SqlParameter("TermDay",SqlDbType.DateTime),
后面还有 36 行代码，解锁后查看完整代码

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

AI 解读 AI

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

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