Пример #1
0
        /// <summary>
        /// 订单审批
        /// </summary>
        /// <param name="pParams"></param>
        public void OrdersApprove(Dictionary <string, string> pParams)
        {
            TInoutEntity       orderEntity  = new TInoutEntity();
            TInoutStatusEntity statusEntity = new TInoutStatusEntity();

            TInoutDetailEntity[] orderDetailEntity = null;

            #region 拼接查询SQL
            StringBuilder strSearchSql = new StringBuilder();
            strSearchSql.AppendFormat(@"
            select 
	            inout.order_id OrdersID
	            ,inout.order_no OrdersNo
                ,ISNULL(store.UsedAmount,0) UsedAmount
                ,ISNULL(store.StockAmount,0) StockAmount
                ,store.*
            from T_Inout inout
            inner join T_Inout_Detail inout_detail on inout.order_id=inout_detail.order_id
            inner join StoreItemDailyStatus store on inout_detail.sku_id=store.SkuID
            where inout.customer_id='{0}' and inout.order_id='{1}'
            and store.StatusDate between cast(inout_detail.Field1 as datetime) and convert(char(10),dateadd(dd,-1,inout_detail.Field2),120)                   
            order by store.StatusDate", CurrentUserInfo.ClientID, pParams["pOrdersID"]);
            #endregion

            DataSet dsSource = this.SQLHelper.ExecuteDataset(strSearchSql.ToString());
            StoreItemDailyStatusEntity[] storeEntity = ConvertHelper <StoreItemDailyStatusEntity> .ConvertToList(dsSource.Tables[0]).ToArray();

            SqlTransaction tran = this.SQLHelper.CreateTransaction();
            using (tran.Connection)
            {
                try
                {
                    //更新订单主表信息
                    if (pParams.ContainsKey("pOrdersID"))
                    {
                        orderDetailEntity = new TInoutDetailDAO(CurrentUserInfo).QueryByEntity(new TInoutDetailEntity {
                            order_id = pParams["pOrdersID"]
                        }, null);
                        orderEntity            = GetByID(pParams["pOrdersID"]);
                        orderEntity.Status     = pParams["pOrdersStatus"];
                        orderEntity.StatusDesc = pParams["pOrdersDesc"];
                        orderEntity.Field7     = orderEntity.Status;
                        orderEntity.Field10    = orderEntity.StatusDesc;

                        if (pParams["pRemark"] != null && pParams["pRemark"] != "")
                        {
                            orderEntity.Remark = pParams["pRemark"];
                        }
                        orderEntity.ModifyTime   = DateTime.Now.ToString();
                        orderEntity.ModifyUserID = CurrentUserInfo.UserID;
                        if (orderEntity.Status == "500" || orderEntity.Status == "400")
                        {
                            T_InoutEntity[] entity = new T_InoutDAO(CurrentUserInfo).QueryByEntity(new T_InoutEntity {
                                order_id = pParams["pOrdersID"]
                            }, null);
                            new VipDAO(this.CurrentUserInfo).ProcSetCancelOrder(this.CurrentUserInfo.ClientID, pParams["pOrdersID"], entity[0].vip_no);
                        }
                        Update(orderEntity);
                    }

                    //更新房态 库存数量
                    if (storeEntity != null && storeEntity.Length > 0)
                    {
                        for (int i = 0; i < storeEntity.Length; i++)
                        {
                            if (pParams["pOrdersType"].ToString() == "1")
                            {
                                //1.审核通过
                                if (storeEntity[i].StockAmount != 0 && storeEntity[i].StockAmount > 0)
                                {
                                    storeEntity[i].StockAmount = storeEntity[i].StockAmount - (int)Math.Round((decimal)orderDetailEntity[0].OrderQty, 0);
                                }
                                if (storeEntity[i].UsedAmount != 100 && storeEntity[i].UsedAmount < 100)
                                {
                                    storeEntity[i].UsedAmount = storeEntity[i].UsedAmount + (int)Math.Round((decimal)orderDetailEntity[0].OrderQty, 0);
                                }
                                storeEntity[i].LastUpdateBy   = CurrentUserInfo.UserID;
                                storeEntity[i].LastUpdateTime = DateTime.Now;
                            }
                            else
                            {
                                //2.审核不通过
                                if (storeEntity[i].StockAmount != 100 && storeEntity[i].StockAmount < 100)
                                {
                                    storeEntity[i].StockAmount += (int)Math.Round((decimal)orderDetailEntity[0].OrderQty, 0);
                                }
                                if (storeEntity[i].UsedAmount != 0 && storeEntity[i].UsedAmount > 0)
                                {
                                    storeEntity[i].UsedAmount -= (int)Math.Round((decimal)orderDetailEntity[0].OrderQty, 0);
                                }
                                storeEntity[i].LastUpdateBy   = CurrentUserInfo.UserID;
                                storeEntity[i].LastUpdateTime = DateTime.Now;
                            }
                            new StoreItemDailyStatusDAO(CurrentUserInfo).Update(storeEntity[i]);
                        }
                    }

                    //添加订单操作流水
                    statusEntity.OrderID     = pParams["pOrdersID"];
                    statusEntity.OrderStatus = int.Parse(pParams["pOrdersStatus"]);
                    if (pParams["pCheckResult"] != null && pParams["pCheckResult"] != "")
                    {
                        statusEntity.CheckResult = int.Parse(pParams["pCheckResult"]);
                    }
                    statusEntity.CustomerID = CurrentUserInfo.ClientID;
                    statusEntity.CreateBy   = CurrentUserInfo.UserID;
                    new TInoutStatusDAO(CurrentUserInfo).Create(statusEntity);
                    tran.Commit();
                }
                catch (Exception ex)
                {
                    Loggers.Exception(new ExceptionLogInfo()
                    {
                        ClientID = CurrentUserInfo.ClientID, UserID = CurrentUserInfo.UserID, ErrorMessage = ex.Message
                    });
                    tran.Rollback();
                }
            }
        }
Пример #2
0
        /// <summary>
        /// 装载实体
        /// </summary>
        /// <param name="pReader">向前只读器</param>
        /// <param name="pInstance">实体实例</param>
        protected void Load(IDataReader pReader, out T_RefundOrderEntity pInstance)
        {
            //将所有的数据从SqlDataReader中读取到Entity中
            pInstance = new T_RefundOrderEntity();
            pInstance.PersistenceHandle = new PersistenceHandle();
            pInstance.PersistenceHandle.Load();

            if (pReader["RefundID"] != DBNull.Value)
            {
                pInstance.RefundID = (Guid)pReader["RefundID"];
            }
            if (pReader["SalesReturnID"] != DBNull.Value)
            {
                pInstance.SalesReturnID = (Guid)pReader["SalesReturnID"];
            }
            if (pReader["RefundNo"] != DBNull.Value)
            {
                pInstance.RefundNo = Convert.ToString(pReader["RefundNo"]);
            }
            if (pReader["VipID"] != DBNull.Value)
            {
                pInstance.VipID = Convert.ToString(pReader["VipID"]);
                var vipDao  = new VipDAO(this.CurrentUserInfo);
                var vipInfo = vipDao.GetByID(pInstance.VipID);
                if (vipInfo != null)
                {
                    pInstance.VipName = vipInfo.VipName;
                }
            }
            if (pReader["DeliveryType"] != DBNull.Value)
            {
                pInstance.DeliveryType = Convert.ToInt32(pReader["DeliveryType"]);
            }
            if (pReader["OrderID"] != DBNull.Value)
            {
                pInstance.OrderID = Convert.ToString(pReader["OrderID"]);

                var inoutDAO  = new T_InoutDAO(CurrentUserInfo);
                var inoutInfo = inoutDAO.GetByID(pInstance.OrderID);
                if (inoutInfo != null)
                {
                    pInstance.OrderNo    = inoutInfo.order_no;         //订单号
                    pInstance.PayOrderID = inoutInfo.paymentcenter_id; //支付回调标识,商户单号
                }
            }
            if (pReader["ItemID"] != DBNull.Value)
            {
                pInstance.ItemID = Convert.ToString(pReader["ItemID"]);
            }
            if (pReader["SkuID"] != DBNull.Value)
            {
                pInstance.SkuID = Convert.ToString(pReader["SkuID"]);
            }
            if (pReader["Qty"] != DBNull.Value)
            {
                pInstance.Qty = Convert.ToInt32(pReader["Qty"]);
            }
            if (pReader["ActualQty"] != DBNull.Value)
            {
                pInstance.ActualQty = Convert.ToInt32(pReader["ActualQty"]);
            }
            if (pReader["UnitID"] != DBNull.Value)
            {
                pInstance.UnitID = Convert.ToString(pReader["UnitID"]);
            }
            if (pReader["UnitName"] != DBNull.Value)
            {
                pInstance.UnitName = Convert.ToString(pReader["UnitName"]);
            }
            if (pReader["UnitTel"] != DBNull.Value)
            {
                pInstance.UnitTel = Convert.ToString(pReader["UnitTel"]);
            }
            if (pReader["Address"] != DBNull.Value)
            {
                pInstance.Address = Convert.ToString(pReader["Address"]);
            }
            if (pReader["Contacts"] != DBNull.Value)
            {
                pInstance.Contacts = Convert.ToString(pReader["Contacts"]);
            }
            if (pReader["Phone"] != DBNull.Value)
            {
                pInstance.Phone = Convert.ToString(pReader["Phone"]);
            }
            if (pReader["RefundAmount"] != DBNull.Value)
            {
                pInstance.RefundAmount = Convert.ToDecimal(pReader["RefundAmount"]);
            }
            if (pReader["ConfirmAmount"] != DBNull.Value)
            {
                pInstance.ConfirmAmount = Convert.ToDecimal(pReader["ConfirmAmount"]);
            }
            if (pReader["ActualRefundAmount"] != DBNull.Value)
            {
                pInstance.ActualRefundAmount = Convert.ToDecimal(pReader["ActualRefundAmount"]);
            }
            if (pReader["Points"] != DBNull.Value)
            {
                pInstance.Points = Convert.ToInt32(pReader["Points"]);
            }
            if (pReader["PointsAmount"] != DBNull.Value)
            {
                pInstance.PointsAmount = Convert.ToDecimal(pReader["PointsAmount"]);
            }
            if (pReader["ReturnAmount"] != DBNull.Value)
            {
                pInstance.ReturnAmount = Convert.ToDecimal(pReader["ReturnAmount"]);
            }
            if (pReader["Amount"] != DBNull.Value)
            {
                pInstance.Amount = Convert.ToDecimal(pReader["Amount"]);
            }
            if (pReader["CouponID"] != DBNull.Value)
            {
                pInstance.CouponID = Convert.ToString(pReader["CouponID"]);
            }
            if (pReader["PayOrderID"] != DBNull.Value)
            {
                pInstance.PayOrderID = Convert.ToString(pReader["PayOrderID"]);
            }
            if (pReader["Status"] != DBNull.Value)
            {
                pInstance.Status = Convert.ToInt32(pReader["Status"]);
            }
            if (pReader["CustomerID"] != DBNull.Value)
            {
                pInstance.CustomerID = Convert.ToString(pReader["CustomerID"]);
            }
            if (pReader["CreateTime"] != DBNull.Value)
            {
                pInstance.CreateTime = Convert.ToDateTime(pReader["CreateTime"]);
            }
            if (pReader["CreateBy"] != DBNull.Value)
            {
                pInstance.CreateBy = Convert.ToString(pReader["CreateBy"]);
            }
            if (pReader["LastUpdateTime"] != DBNull.Value)
            {
                pInstance.LastUpdateTime = Convert.ToDateTime(pReader["LastUpdateTime"]);
            }
            if (pReader["LastUpdateBy"] != DBNull.Value)
            {
                pInstance.LastUpdateBy = Convert.ToString(pReader["LastUpdateBy"]);
            }
            if (pReader["IsDelete"] != DBNull.Value)
            {
                pInstance.IsDelete = Convert.ToInt32(pReader["IsDelete"]);
            }
        }