DAL/DALOrder.cs

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

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

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

namespace DAL
{
   public class DALOrder
    {
        //绑定订单数据
        public DataSet OrderBind(int a, int b, string c)
        {
            String sql = "select * from tb_OrderInfo";
            return SQLHelper.PagedataSet(sql, a, b, c);

        }

        //查询订单
        public DataSet SelOrder(int a, int b, string c, COrder order)
        {
            string sql = "select * from tb_OrderInfo where OrderID like '%" + order.Order_id + "%'";
            DataSet ds = SQLHelper.PagedataSet(sql, a, b, c);
            return ds;
        }

        //查询是否存在该订单
        public int CountOrder(COrder order)
        {
            string sql = "select count(*) from tb_OrderInfo where OrderID like '%" + order.Order_id + "%'";
            int result = Convert.ToInt32(DBHelperSQL.ExecuteSqlCell(sql));
            return result;
        }

        //删除某条订单
        public int DeleteOrder(COrder order)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("delete from tb_OrderInfo where OrderID = @id");
            SqlParameter[] par ={
                                    new SqlParameter ("@id",SqlDbType.VarChar)
                                };
            par[0].Value = order.Order_id;
            return DBHelperSQL.ExecuteSql(sql.ToString(), par);
        }



        //删除某条订单的详细订单
        public int DeleteDetail(COrder order)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("delete from tb_Detail where OrderID = @id");
            SqlParameter[] par ={
                                    new SqlParameter ("@id",SqlDbType.VarChar)
                                };
            par[0].Value = order.Order_id;
            return DBHelperSQL.ExecuteSql(sql.ToString(), par);