Ejemplo n.º 1
0
        /// <summary>
        /// 审核
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool ApprovalRefundsMoney(RefundsMoneyInfo_Approval model)
        {
            if (model == null)
            {
                return(false);
            }
            const string SQL = @"Update RefundsMoney
                                 Set BankName=@BankName,BankAccountNo=@BankAccountNo,UserName=@UserName,RejectReason=@RejectReason,
                                     Status=@Status,ModifyTime=@ModifyTime,ModifyUser=@ModifyUser
                                 where ID=@ID";

            using (SqlConnection conn = Databases.GetSqlConnection(GlobalConfig.ERP_DB_NAME, false))
            {
                int result = conn.Execute(SQL, new
                {
                    ID            = model.ID,
                    BankName      = model.BankName,
                    BankAccountNo = model.BankAccountNo,
                    UserName      = model.UserName,
                    RejectReason  = model.RejectReason,

                    Status     = model.IsApproved ? (int)RefundsMoneyStatusEnum.PendingPayment : (int)RefundsMoneyStatusEnum.Rejected,
                    ModifyTime = DateTime.Now,
                    ModifyUser = model.ModifyUser,
                });
                return(result > 0);
            }
        }
Ejemplo n.º 2
0
        public void TestMethod_Approval()
        {
            Init();

            var model = new RefundsMoneyInfo_Approval()
            {
                ID            = Guid.Parse("05852844-E829-4443-B354-0635076CA98D"),
                BankAccountNo = "11",
                BankName      = "22",
                UserName      = "******",
                ModifyUser    = "******",
                IsApproved    = true,
                RejectReason  = "通过"
            };
            var result = _refundsMoneyDal.ApprovalRefundsMoney(model);

            Assert.IsNotNull(result);
        }