DAL/OrderService.cs

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

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

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;

namespace DAL
{
	/// <summary>
	/// 数据访问类:OrderService
	/// </summary>
	public partial class OrderService
	{
		public OrderService()
		{}
		#region  BasicMethod
        /// <summary>
        /// 获取指定状态下的订单数量
        /// </summary>
        /// <param name="userId"></param>
        /// <param name="status"></param>
        /// <returns></returns>
        public static int GetCount(int userId,int status) 
        {
            string sql = "";
            if (status != 100)
            {
                sql = "select count(*) from OrderInfo where status = " + status + " and addUser = " + userId;
            }
            else
            {
                sql = "select count(*) from OrderInfo where addUser = " + userId + " and status not in(100,150)";
            }
            object obj = DBHelperSQL.GetSingle(sql);
            if(obj != null)
            {
                return Convert.ToInt32(obj);
            }
            return 0;
        }
        /// <summary>
        /// 更新订单的二维码
        /// </summary>
        /// <param name="item"></param>
        /// <returns></returns>
        public static int UpdateCodeUrl(Model.OrderInfo item)
        {
            string sql = "update OrderInfo set pName = '" + item.PName + "' where id = " + item.id;
            return DBHelperSQL.ExecuteSql(sql);
        }
        /// <summary>
        /// 更新订单编号
        /// </summary>
        /// <param name="orderId"></param>
        /// <returns></returns>
        public static int UpdateOrderNo(int orderId, string orderNo, string orderDesc)
        {
            string sql = "update OrderInfo set orderNo = '" + orderNo + "',orderDesc='" + orderDesc + "' where id = " + orderId;
            return DBHelperSQL.ExecuteSql(sql);
        }
        /// <summary>