예제 #1
0
        /// <summary>
        /// 上传退款信息
        /// </summary>
        /// <param name="obj"></param>
        public void AddZcOrderRefund(ZcOrderRefund obj)
        {
            string            sql  = "insert into zc_order_refund (id, createTime, updateTime, order_id, order_amount, actual_amount, order_refund_status, hand_date) values (:id,:createTime,:updateTime,:order_id,:order_amount,:actual_amount,:order_refund_status,:hand_date)";
            OracleConnection  conn = null;
            OracleTransaction tran = null;
            OracleCommand     cmd  = new OracleCommand();

            try
            {
                conn            = OracleUtil.OpenConn();
                tran            = conn.BeginTransaction();
                cmd.CommandText = sql;
                cmd.Connection  = conn;

                cmd.Parameters.Add(":id", obj.Id);
                cmd.Parameters.Add(":createTime", obj.CreateTime);
                cmd.Parameters.Add(":updateTime", obj.UpdateTime);
                cmd.Parameters.Add(":order_id", obj.Order_id);
                cmd.Parameters.Add(":order_amount", obj.Order_amount);
                cmd.Parameters.Add(":actual_amount", obj.Actual_amount);
                cmd.Parameters.Add(":order_refund_status", obj.Order_refund_status);
                cmd.Parameters.Add(":hand_date", obj.Hand_date);
                cmd.ExecuteNonQuery();
                tran.Commit();
            }
            catch (Exception ex)
            {
                tran.Rollback();
                List <UploadInfo> uploadList = new List <UploadInfo>();
                UploadDao         dao        = new UploadDao();
                UploadInfo        obj1       = new UploadInfo();
                obj1.Id         = obj.Id;
                obj1.CreateTime = DateTime.Now;
                obj1.UpdateTime = DateTime.Now;
                obj1.Type       = Constant.ZC_ORDER_REFUND;
                uploadList.Add(obj1);
                dao.AddUploadInfo(uploadList);
                log.Error("上传退款信息到服务器失败", ex);
            }
            finally
            {
                tran.Dispose();
                cmd.Dispose();
                OracleUtil.CloseConn(conn);
            }
        }
예제 #2
0
        public bool AddZcOrderRefundI(ZcOrderRefund obj)
        {
            bool              flag = false;
            string            sql  = "insert into zc_order_refund (id, createTime, updateTime, order_id, order_amount, actual_amount, order_refund_status, hand_date) values (:id,:createTime,:updateTime,:order_id,:order_amount,:actual_amount,:order_refund_status,:hand_date)";
            OracleConnection  conn = null;
            OracleTransaction tran = null;
            OracleCommand     cmd  = new OracleCommand();

            try
            {
                conn            = OracleUtil.OpenConn();
                tran            = conn.BeginTransaction();
                cmd.CommandText = sql;
                cmd.Connection  = conn;

                cmd.Parameters.Add(":id", obj.Id);
                cmd.Parameters.Add(":createTime", obj.CreateTime);
                cmd.Parameters.Add(":updateTime", obj.UpdateTime);
                cmd.Parameters.Add(":order_id", obj.Order_id);
                cmd.Parameters.Add(":order_amount", obj.Order_amount);
                cmd.Parameters.Add(":actual_amount", obj.Actual_amount);
                cmd.Parameters.Add(":order_refund_status", obj.Order_refund_status);
                cmd.Parameters.Add(":hand_date", obj.Hand_date);
                cmd.ExecuteNonQuery();
                tran.Commit();
                flag = true;
            }
            catch (Exception ex)
            {
                tran.Rollback();
                flag = false;
                log.Error("上传退款信息到服务器失败", ex);
            }
            finally
            {
                tran.Dispose();
                cmd.Dispose();
                OracleUtil.CloseConn(conn);
            }
            return(flag);
        }
예제 #3
0
        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="obj"></param>
        public void AddZcOrderRefund(ZcOrderRefund obj)
        {
            string           sql  = "insert into zc_order_refund values (@id,@createTime,@updateTime,@order_id,@order_amount,@actual_amount,@order_refund_status,@hand_date)";
            MySqlConnection  conn = null;
            MySqlTransaction tran = null;
            MySqlCommand     cmd  = new MySqlCommand();

            try
            {
                conn            = GetConnection();
                tran            = conn.BeginTransaction();
                cmd.CommandText = sql;
                cmd.Connection  = conn;

                cmd.Parameters.Add(new MySqlParameter("@id", obj.Id));
                cmd.Parameters.Add(new MySqlParameter("@createTime", obj.CreateTime));
                cmd.Parameters.Add(new MySqlParameter("@updateTime", obj.UpdateTime));
                cmd.Parameters.Add(new MySqlParameter("@order_id", obj.Order_id));
                cmd.Parameters.Add(new MySqlParameter("@order_amount", obj.Order_amount));
                cmd.Parameters.Add(new MySqlParameter("@actual_amount", obj.Actual_amount));
                cmd.Parameters.Add(new MySqlParameter("@order_refund_status", obj.Order_refund_status));
                cmd.Parameters.Add(new MySqlParameter("@hand_date", obj.Hand_date));
                cmd.ExecuteNonQuery();
                tran.Commit();
            }
            catch (Exception ex)
            {
                tran.Rollback();
                log.Error("新增ZcOrderRefund发生异常", ex);
            }
            finally
            {
                cmd.Dispose();
                tran.Dispose();
                CloseConnection(conn);
            }
        }
예제 #4
0
        public ZcOrderRefund FindById(string p)
        {
            ZcOrderRefund   obj  = new ZcOrderRefund();
            string          sql  = "select * from zc_order_refund where id = @id";
            MySqlConnection conn = null;
            MySqlCommand    cmd  = new MySqlCommand();

            try
            {
                conn            = GetConnection();
                cmd.CommandText = sql;
                cmd.Connection  = conn;
                cmd.Parameters.AddWithValue("@id", p);
                MySqlDataReader reader = cmd.ExecuteReader();
                if (reader.Read())
                {
                    obj.Id                  = reader.IsDBNull(0) ? string.Empty : reader.GetString(0);
                    obj.CreateTime          = reader.IsDBNull(1) ? default(DateTime) : reader.GetDateTime(1);
                    obj.UpdateTime          = reader.IsDBNull(2) ? default(DateTime) : reader.GetDateTime(2);
                    obj.Order_id            = reader.IsDBNull(3) ? string.Empty : reader.GetString(3);
                    obj.Order_amount        = reader.IsDBNull(4) ? string.Empty : reader.GetString(4);
                    obj.Actual_amount       = reader.IsDBNull(5) ? string.Empty : reader.GetString(5);
                    obj.Order_refund_status = reader.IsDBNull(6) ? string.Empty : reader.GetString(6);
                    obj.Hand_date           = reader.IsDBNull(7) ? default(DateTime) : reader.GetDateTime(7);
                }
            }
            catch (Exception ex)
            {
                log.Error("根据id获取退款信息失败", ex);
            }
            finally
            {
                cmd.Dispose();
                CloseConnection(conn);
            }
            return(obj);
        }
예제 #5
0
        public bool AddZcOrderRefundI(ZcOrderRefund obj)
        {
            RefundInfoDao dao = new RefundInfoDao();

            return(dao.AddZcOrderRefundI(obj));
        }
예제 #6
0
        /// <summary>
        /// 上传退款信息
        /// </summary>
        /// <param name="obj"></param>
        public void AddZcOrderRefund(ZcOrderRefund obj)
        {
            RefundInfoDao dao = new RefundInfoDao();

            dao.AddZcOrderRefund(obj);
        }
예제 #7
0
        public void AddZcOrderRefund(ZcOrderRefund zcOrderRefund)
        {
            BranchZcOrderRefundDao dao = new BranchZcOrderRefundDao();

            dao.AddZcOrderRefund(zcOrderRefund);
        }
예제 #8
0
        /// <summary>
        /// 网络连通时,上传数据
        /// </summary>
        public static void Upload()
        {
            UploadDao dao   = new UploadDao();
            int       count = dao.QueryCount();

            if (count != 0)
            {
                List <UploadInfo> list = dao.FindAll();
                foreach (UploadInfo obj in list)
                {
                    if (obj.Type == Constant.DAILY_RECEIVE_GOODS)
                    {
                        BranchDailyReceiveGoodsDao dailyDao = new BranchDailyReceiveGoodsDao();
                        DailyReceiveGoods          drg      = dailyDao.FindById(obj.Id);
                        drg.CreateTime = DateTime.Now;
                        drg.UpdateTime = DateTime.Now;
                        DailyReceiveGoodsService service = new DailyReceiveGoodsService();
                        bool flag = service.AddDailyReceiveGoods(drg);
                        if (flag)
                        {
                            dao.DeleteByIdAndType(obj.Id, obj.Type);
                        }
                    }
                    else if (obj.Type == Constant.ZC_ORDER_TRANSIT_UPDATE)
                    {
                        ZcOrderTransitService service = new ZcOrderTransitService();
                        bool flag = service.UpdateStatus(obj.Id, Constant.ORDER_STATUS_RECEIPT);
                        if (flag)
                        {
                            dao.DeleteByIdAndType(obj.Id, obj.Type);
                        }
                    }
                    else if (obj.Type == Constant.PAY_INFO)
                    {
                        BranchPayInfoService service = new BranchPayInfoService();
                        PayInfo        payInfo       = service.FindById(obj.Id);
                        PayInfoService masterService = new PayInfoService();
                        bool           flag          = masterService.AddPayInfoI(payInfo);
                        if (flag)
                        {
                            dao.DeleteByIdAndType(obj.Id, obj.Type);
                        }
                    }
                    else if (obj.Type == Constant.ZC_ORDER_HISTORY)
                    {
                        BranchZcOrderHistoryService branchService = new BranchZcOrderHistoryService();
                        ZcOrderHistory        history             = branchService.FindById(obj.Id);
                        ZcOrderHistoryService service             = new ZcOrderHistoryService();
                        bool flag = service.AddZcOrderHistoryI(history);
                        if (flag)
                        {
                            dao.DeleteByIdAndType(obj.Id, obj.Type);
                        }
                    }
                    else if (obj.Type == Constant.ZC_ORDER_HISTORY_ITEM)
                    {
                        BranchZcOrderHistoryItemService branchService = new BranchZcOrderHistoryItemService();
                        ZcOrderHistoryItem        item    = branchService.FindById(obj.Id);
                        ZcOrderHistoryItemService service = new ZcOrderHistoryItemService();
                        bool flag = service.AddZcOrderHistoryItemI(item);
                        if (flag)
                        {
                            dao.DeleteByIdAndType(obj.Id, obj.Type);
                        }
                    }
                    else if (obj.Type == Constant.ZC_ORDER_TRANSIT_DELETE)
                    {
                        ZcOrderTransitService service = new ZcOrderTransitService();
                        bool flag = service.DeleteById(obj.Id);
                        if (flag)
                        {
                            dao.DeleteByIdAndType(obj.Id, obj.Type);
                        }
                    }
                    else if (obj.Type == Constant.ZC_ORDER_TRANSIT_ITEM_DELETE)
                    {
                        ZcOrderTransitItemService service = new ZcOrderTransitItemService();
                        bool flag = service.DeleteByOrderIdI(obj.Id);
                        if (flag)
                        {
                            dao.DeleteByIdAndType(obj.Id, obj.Type);
                        }
                    }
                    else if (obj.Type == Constant.ZC_ORDER_REFUSE)
                    {
                        BranchZcOrderRefuseService branchService = new BranchZcOrderRefuseService();
                        ZcOrderRefuse        refuse  = branchService.FindById(obj.Id);
                        ZcOrderRefuseService service = new ZcOrderRefuseService();
                        bool flag = service.AddZcOrderRefuseI(refuse);
                        if (flag)
                        {
                            dao.DeleteByIdAndType(obj.Id, obj.Type);
                        }
                    }
                    else if (obj.Type == Constant.ZC_ORDER_REFUSE_ITEM)
                    {
                        BranchZcOrderRefuseItemService branchService = new BranchZcOrderRefuseItemService();
                        ZcOrderRefuseItem        item    = branchService.FindById(obj.Id);
                        ZcOrderRefuseItemService service = new ZcOrderRefuseItemService();
                        bool flag = service.AddZcOrderRefuseItemI(item);
                        if (flag)
                        {
                            dao.DeleteByIdAndType(obj.Id, obj.Type);
                        }
                    }
                    else if (obj.Type == Constant.ZC_ORDER_REFUND)
                    {
                        BranchZcOrderRefundService branchService = new BranchZcOrderRefundService();
                        ZcOrderRefund     refund  = branchService.FindById(obj.Id);
                        RefundInfoService service = new RefundInfoService();
                        bool flag = service.AddZcOrderRefundI(refund);
                        if (flag)
                        {
                            dao.DeleteByIdAndType(obj.Id, obj.Type);
                        }
                    }
                    else if (obj.Type == Constant.ZC_ORDER_REFUND_ITEM)
                    {
                        BranchZcOrderRefundItemService branchService = new BranchZcOrderRefundItemService();
                        ZcOrderRefundItem item    = branchService.FindById(obj.Id);
                        RefundInfoService service = new RefundInfoService();
                        bool flag = service.AddZcOrderRefundItemI(item);
                        if (flag)
                        {
                            dao.DeleteByIdAndType(obj.Id, obj.Type);
                        }
                    }
                    else if (obj.Type == Constant.ZC_ORDER_HISTORY_UPDATE)
                    {
                        BranchZcOrderHistoryService branchService = new BranchZcOrderHistoryService();
                        ZcOrderHistory        history             = branchService.FindById(obj.Id);
                        ZcOrderHistoryService service             = new ZcOrderHistoryService();
                        bool flag = service.UpdateOrderStatusByIdsI(obj.Id, history.OrderStatus);
                        if (flag)
                        {
                            dao.DeleteByIdAndType(obj.Id, obj.Type);
                        }
                    }
                }
            }
        }