Smokewinetea.DAL/KstagDAL.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 KstagDAL
    {
        /// <summary>
        /// 添加数据
        /// </summary>
        /// <param name="bakstag"></param>
        /// <returns></returns>
        public static int BackstagInser(KstagModels bakstag)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("insert into Kstag values(@KgName,@KgTime,@Kgnumber,@Kgunitprice,@KgAlprices,@SendName,@Kgstatus,@CustomName,@Member)");
            SqlParameter[] param = {
                                     new SqlParameter("KgName",SqlDbType.VarChar,20),
                                     new SqlParameter("KgTime",SqlDbType.DateTime),
                                     new SqlParameter("Kgnumber",SqlDbType.Int,20),
                                     new SqlParameter("Kgunitprice",SqlDbType.Int,20),
                                     new SqlParameter("KgAlprices",SqlDbType.Money),
                                     new SqlParameter("SendName",SqlDbType.VarChar,20),
                                     new SqlParameter("Kgstatus",SqlDbType.VarChar,20),
                                     new SqlParameter("CustomName",SqlDbType.VarChar,50),
                                     new SqlParameter("Member",SqlDbType.Money)
                                 };
            param[0].Value = bakstag.KgName;
            param[1].Value = bakstag.KgTime;
            param[2].Value = bakstag.Kgnumber;
            param[3].Value = bakstag.Kgunitprice;
            param[4].Value = bakstag.KgAlprices;
            param[5].Value = bakstag.SendName;
            param[6].Value = bakstag.Kgstatus;
            param[7].Value = bakstag.CustomName;
            param[8].Value = bakstag.Member;

            int B = DbHelper.ExecuteNonQuery(sql.ToString(), param);
            return B;

        }
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="op"></param>
        /// <param name="to"></param>
        /// <param name="tj"></param>
        /// <returns></returns>
        public static List<KstagModels> Kstag(string op, DateTime to, string tj)
        {
            StringBuilder sql = new StringBuilder();
            switch (op)
            {
                case "查询全部": sql.Append("select KgUmber,KgName,KgTime,Kgnumber,Kgunitprice,KgAlprices,SendName,Kgstatus,CustomName,Member from  Kstag order by KgTime desc");
                    break;