コード例 #1
0
    /// <summary>
    /// 搜索订单数据
    /// </summary>
    /// <param name="ordno"></param>
    /// <param name="debegin"></param>
    /// <param name="deEnd"></param>
    /// <param name="ordStatus"></param>
    /// <returns></returns>
    public List <Tab_Order4Total> GetOrds(int pgIdx = 1, string ordno = "", DateTime?debegin = null, DateTime?deEnd = null, string ordStatus = "", int pgSize = 10)
    {
        bool         bTotalCount = true;
        SqlParameter prmWhr      = new SqlParameter("@strWhere", string.Empty);
        var          prmDoCount  = new SqlParameter("@doCount", bTotalCount);

        SqlParameter[] prms = new SqlParameter[] {
            new SqlParameter("@tblName", "Tab_Order4Total"),
            new SqlParameter("@strGetFields", "*"),
            new SqlParameter("@fldName", "DateCreated"),
            new SqlParameter("@PageSize", pgSize),
            new SqlParameter("@PageIndex", pgIdx),
            prmDoCount,
            new SqlParameter("@OrderType", true),//降序
            prmWhr
        };
        string whr = "UserIdx_Fx=" + LoginUser.Idx.ToString();

        if (!string.IsNullOrEmpty(ordno))
        {
            whr += " and OrderNo='" + ordno.Replace("'", "''") + "'";
        }
        if (!string.IsNullOrEmpty(ordStatus))
        {
            whr += " and OrderStatus=" + ordStatus;
        }
        if (null != debegin)
        {
            whr += " and DateCreated>='" + debegin.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'";
        }
        if (null != deEnd)
        {
            whr += " and DateCreated<='" + deEnd.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'";
        }
        prmWhr.SqlValue = whr;
        var totalPgCount = Int32.Parse(SqlHelper.ExecuteScalar(CommandType.StoredProcedure, "P_Y_Pagination", prms).ToString());

        prmDoCount.SqlValue = false;
        var ds = SqlHelper.ExecuteDataset(CommandType.StoredProcedure, "P_Y_Pagination", prms);

        if (null == ds || ds.Tables == null || ds.Tables.Count < 1)
        {
            return(null);
        }
        return(Tab_Order4Total.ToModel(ds.Tables[0], totalPgCount));
    }
コード例 #2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        VerfiyAdmin.CheckVIPUserLogin(this);
        UserAvaPoint = VerfiyAdmin.LoginUser.AvailablePoints;
        if (!IsPostBack)
        {
            var Id  = 0;
            var idx = Request["Id"];
            if (string.IsNullOrEmpty(idx) || !Int32.TryParse(idx, out Id))
            {
                return;
            }
            var et = new Tab_Order4Total().Get(Id.ToString());
            if (null == et)
            {
                return;
            }
            lblOrdNo.Text = et.OrderNo;

            var usr = VerfiyAdmin.LoginUser; if (null == usr)
            {
                return;
            }
            lblMail.Text = usr.UserEmail;

            var counter = new Tab_Order1Counter().Get(et.CounterIdx.ToString());
            if (null == counter)
            {
                return;
            }
            lblCounterName.Text  = counter.CounterName;
            lblCounterPhone.Text = counter.CounterPhone;
            lblAddr.Text         = counter.CounterAddr;
        }

        //子订单数据获取应该从库中来
        //柜台
    }
コード例 #3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        VerfiyAdmin.CheckVIPUserLogin(this);
        UserAvaPoint = VerfiyAdmin.LoginUser.AvailablePoints;
        if (!IsPostBack)
        {
            var usr = VerfiyAdmin.LoginUser;
            if (null == usr)
            {
                return;
            }
            lblAddr.Text     = usr.Address;
            lblRealName.Text = usr.RealName;
            lblProv.Text     = usr.Province;
            lblCity.Text     = usr.City;
            lblMail.Text     = usr.UserEmail;
            lblMobile.Text   = usr.MobilePhone;
            lblPostCode.Text = usr.ZipCode;
        }
        else//提交
        {
            //1.检查积分兑换商品是否超出积分了
            //2.保存相关数据至订单主从表中
            //3.扣减当前会员可用积分
            var gifts = VerfiyAdmin.GetGiftCart();
            if (null == gifts || gifts.Count < 1)
            {
                return;
            }
            var payforPoint = gifts.Sum(k => k.GiftCount * k.PerGiftData.NeedPoint); //得到总共兑换礼品需要消耗的积分总数
            var counterIdx = Request["counterIdx"];                                  //柜台
            int ctridx = -1; bool b = Int32.TryParse(counterIdx, out ctridx);
            if (string.IsNullOrEmpty(counterIdx) || !b)                              //柜台未选择
            {
                Cmn.Js.ShowAlert("你还没有选择兑换礼品的柜台!");
                return;
            }
            var usr = VerfiyAdmin.LoginUser; if (null == usr)
            {
                return;
            }
            if (usr.AvailablePoints - payforPoint <= 0)//积分不足
            {
                Cmn.Js.ShowAlert("你的可用积分不足以兑换所有礼品!");
                return;
            }
            var OrdNo = VerfiyAdmin.GenGiftOrderNo();//订单号

            var OrdIdx = new Tab_Order4Total().AddNew(new Tab_Order4Total
            {
                OrderNo     = OrdNo,
                OrderStatus = string.Empty,
                CounterNo   = string.Empty,            //柜台号
                CounterIdx  = Int32.Parse(counterIdx), //柜台IDX
                DateCreated = DateTime.Now,
                SourcesData = SourcesDataSTR,
                TotalPoints = payforPoint,
                UserIdx_Fx  = usr.Idx
            });

            var subOrd = new Tab_Order3Detail();
            //创建子订单数据
            foreach (var item in gifts)
            {
                subOrd.AddNew(new Tab_Order3Detail
                {
                    CreatedDate   = DateTime.Now,
                    GiftCount     = item.GiftCount,
                    GiftIdx_Fx    = item.GiftIdx,
                    NeedPoint     = item.PerGiftData.NeedPoint,
                    OrdersIdx_Fx  = OrdIdx,
                    OrderStatus   = string.Empty,
                    OrderUUID     = Guid.NewGuid(),
                    SourcesData   = SourcesDataSTR,
                    CounterIdx_Fx = counterIdx,//柜台IDX
                });
            }

            //扣减当前会员可用积分
            SqlHelper.ExecuteNonQuery(CommandType.Text, Sql_UpdateUsrPoint,
                                      new SqlParameter("@prm", payforPoint), new SqlParameter("@idx", VerfiyAdmin.LoginUser.Idx));
            Session[VerfiyAdmin.LoginUserKey] = new Tab_UserCommunity().Get(VerfiyAdmin.LoginUser.Idx.ToString());

            //发送邮件
            VerfiyAdmin.SendGiftOrderMail(OrdNo);
            Response.Redirect("fexchange_success.aspx?Id=" + OrdIdx.ToString());
        }
    }