/// <summary> /// 更新每日余额和支付表的数据库事务 /// </summary> /// <param name="db"></param> /// <param name="i"></param> /// <param name="obj"></param> /// <returns></returns> public bool Update_DbAndPF(FundsRegulatoryClient.SqlTransSvr.DayBalance db, FundPayment obj, int i) { return(service.Update_DbAndPF(db, obj, i)); }
/// <summary> ///添加退票 更新每日余额和存款表的数据库事务 /// </summary> /// <param name="db"></param> /// <param name="i"></param> /// <param name="obj"></param> /// <returns></returns> public bool Update_DbAndDF(FundsRegulatoryClient.SqlTransSvr.DayBalance db, RefundTrade rt, DepositFund obj) { return(service.Update_DbAndDF(db, obj, rt)); }
/// <summary> ///更新每日余额和存款表的数据库事务 /// </summary> /// <param name="db"></param> /// <param name="i"></param> /// <param name="obj"></param> /// <returns></returns> public bool Update_DbAndDF(FundsRegulatoryClient.SqlTransSvr.DayBalance db, DepositFund obj, int i) { return(service.Update_DbAndDF(db, obj, i)); }
/// <summary> /// 更新当日余额,存款表状态,支付表状态,添加退票信息 /// </summary> /// <returns></returns> private bool DayBalanceAndRefundAndState() { FundsRegulatoryClient.JG_AccountManageSrv.JG_AccountManageInfo ami = new FundsRegulatoryClient.JG_AccountManageSrv.JG_AccountManageInfo(); FundsRegulatoryClient.JG_AccountManageClient accountClient = FundsRegulatoryClient.JG_AccountManageClient.Instance; FundsRegulatoryClient.InterestManageClient InterestClient = FundsRegulatoryClient.InterestManageClient.Instance; // FundsRegulatoryClient.RefundTradeClient refundClient=fun ami.AM_JgAccount = CurrentObj.AccountName; ObservableCollection <FundsRegulatoryClient.JG_AccountManageSrv.JG_AccountManageInfo> acc = accountClient.Select(ami); if (acc.Count < 1) { VMHelp.ShowMessage("账户不存在", false); return(false); } FundsRegulatoryClient.InterestService.DayBalance db = new FundsRegulatoryClient.InterestService.DayBalance(); FundsRegulatoryClient.SqlTransSvr.DayBalance sqldb = new FundsRegulatoryClient.SqlTransSvr.DayBalance(); sqldb.DB_ID = db.DB_ID = acc[0].AM_ID; // db.DB_AccountNum = model.DepositAccount; sqldb.DB_Time = db.DB_Time = DateTime.Parse(DateTime.Now.ToShortDateString()); ObservableCollection <FundsRegulatoryClient.InterestService.DayBalance> dblist = new ObservableCollection <FundsRegulatoryClient.InterestService.DayBalance>(); dblist = InterestClient.SelectJG_DayBalanceInfo(db); if (dblist.Count > 0) { FundsRegulatoryClient.SqlTransSvr.RefundTrade temp = new FundsRegulatoryClient.SqlTransSvr.RefundTrade(); // CurrentObj.ID = temp.ID = VMHelp.GUID; temp.BussinessCode = FinancialRegulation.Tools.PublicData.Refund; temp.SerialNum = VMHelp.ServiceNo; temp.BankCode = VMHelp.BankCode; CurrentObj.Bankwebsite = temp.Bankwebsite = VMHelp.PointCode; CurrentObj.AccountTeller = temp.AccountTeller = VMHelp.UserCode; CurrentObj.RefundTime = temp.RefundTime = DateTime.Now; temp.AccountName = CurrentObj.AccountName; temp.BankSerialNum = CurrentObj.BankSerialNum; temp.PaymentID = CurrentObj.PaymentID; temp.RefundInstr = CurrentObj.RefundInstr; temp.RefundAmount = CurrentObj.RefundAmount; temp.RT_Type = RefundType; if (CurrentObj.BussinessCode == FinancialRegulation.Tools.PublicData.FundDeposit) { sqldb.DB_Balance = db.DB_Balance = dblist[0].DB_Balance; sqldb.DB_InterestRate = db.DB_InterestRate = dblist[0].DB_InterestRate; sqldb.DB_Balance = db.DB_Balance = db.DB_Balance - CurrentObj.RefundAmount; sqldb.ID = db.ID = dblist[0].ID; temp.AccountID = acc[0].AM_ID; DepositFund dftemp = (DepositFund)UpdatePayOrDeposit(1); temp.ID = VMHelp.GUID; if (sqlTran.Update_DbAndDF(sqldb, temp, dftemp)) { return(true); } else { return(false); } } else { sqldb.DB_Balance = db.DB_Balance = dblist[0].DB_Balance; sqldb.DB_InterestRate = db.DB_InterestRate = dblist[0].DB_InterestRate; sqldb.DB_Balance = db.DB_Balance = db.DB_Balance + CurrentObj.RefundAmount; sqldb.ID = db.ID = dblist[0].ID; temp.AccountID = acc[0].AM_ID; FundPayment fptemp = (FundPayment)UpdatePayOrDeposit(2); temp.ID = VMHelp.GUID; if (sqlTran.Update_DbAndPF(sqldb, fptemp, temp)) { return(true); } else { return(false); } } } else { return(false); } }