JumboTCMS_src/JumboTCMS.DAL/normal/UserOrderDAL.cs

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

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

/*
 * 程序名称: JumboTCMS(将博内容管理系统通用版)
 * 
 * 程序版本: 7.x
 * 
 * 程序作者: 子木将博 (QQ：791104444@qq.com，仅限商业合作)
 * 
 * 版权申明: http://www.jumbotcms.net/about/copyright.html
 * 
 * 技术答疑: http://forum.jumbotcms.net/
 * 
 */

using System;
using System.Data;
using System.Web;
using JumboTCMS.Utils;
using JumboTCMS.DBUtility;

namespace JumboTCMS.DAL
{
    /// <summary>
    /// 会员订单表信息
    /// </summary>
    public class Normal_UserOrderDAL : Common
    {
        public Normal_UserOrderDAL()
        {
            base.SetupSystemDate();
        }
        /// <summary>
        /// 新增订单信息
        /// </summary>
        /// <param name="_uid"></param>
        /// <param name="_truename"></param>
        /// <param name="_address"></param>
        /// <param name="_zipcode"></param>
        /// <param name="_mobiletel"></param>
        /// <returns></returns>
        public bool NewOrder(string _uid, string _truename, string _address, string _zipcode, string _mobiletel)
        {
            using (DbOperHandler _doh = new Common().Doh())
            {
                string _ordernum = GetProductOrderNum();//订单号
                int page = 1;
                int PSize = 1000;
                int totalCount = 0;
                string sqlStr = "";
                string joinStr = "A.[ProductId]=B.Id";
                string whereStr1 = "A.State=0 AND A.UserId=" + _uid;
                string whereStr2 = "State=0 AND UserId=" + _uid;
                _doh.Reset();
                _doh.ConditionExpress = whereStr2;
                totalCount = _doh.Count("jcms_normal_user_cart");
                sqlStr = JumboTCMS.Utils.SqlHelp.GetSql0("A.*,b.points as unitprice,(b.points*a.buycount) as totalprice,b.id as productid,b.title as productname,b.img as productimg", "jcms_normal_user_cart", "jcms_module_product", "Id", PSize, page, "desc", joinStr, whereStr1, whereStr2);
                _doh.Reset();
                _doh.SqlCmd = sqlStr;
                DataTable dt = _doh.GetDataTable();
                if (dt.Rows.Count == 0)
                    return false;