/// <summary> /// 解锁账户信息 /// </summary> /// <param name="accountId">账户ID</param> /// <param name="mark">操作描述说明</param> /// <param name="operId">操作ID</param> /// <param name="subjecId">操作子系统编码</param> /// <param name="message">返回信息</param> /// <returns></returns> public static bool UnBlockAccountInfo(int accountId, string userCode, string userName, string operId, string mark, string subjecCode, out string message) { message = ""; bool retFlag = false; using (AccountDataSourceDataContext adsdc = new AccountDataSourceDataContext()) { Base_t_AccountInfo bai = new Base_t_AccountInfo(); bai = adsdc.Base_t_AccountInfo.FirstOrDefault(p => p.id == accountId); if (bai != null) { try { bai.status = 1; adsdc.SubmitChanges(); retFlag = true; } catch (Exception ex) { message = ex.Message; retFlag = false; } } else { message = "该账户不存在!"; retFlag = false; } //如果锁定成功,插入流水记录 if (retFlag) { Base_t_AccountDetailEntity bade = new Base_t_AccountDetailEntity(); bade.Type = 3; bade.AccountId = accountId; bade.OpTime = DateTime.Now; bade.CustmerCode = userCode; bade.CustmerName = userName; bade.OpUser = operId; bade.Resume = mark; bade.SubjectCode = subjecCode; //插入流水信息记录 InsertOperBalanceInfo(bade, out message); retFlag = true; } return retFlag; } }
/// <summary> /// 查询账户信息 /// </summary> /// <param name="starTime">起始时间</param> /// <param name="endTime"> 结止时间</param> /// <returns></returns> public static List<Base_t_AccountDetailEntity> SelectAllAccountDetailInfoByTime(int accountId, string starTime, string endTime) { using (AccountDataSourceDataContext adsdc = new AccountDataSourceDataContext()) { List<Base_t_AccountDetailEntity> badeList = new List<Base_t_AccountDetailEntity>(); Base_t_AccountDetailEntity bade; List<Base_t_AccountDetail> badList = new List<Base_t_AccountDetail>(); try { var results = from C in adsdc.Base_t_AccountDetail select C; if (accountId > 0) results = results.Where(c => c.accountId == accountId); if (!string.IsNullOrEmpty(starTime)) results = results.Where(c => c.opTime >= DateTime.Parse(starTime)); if (!string.IsNullOrEmpty(endTime)) results = results.Where(c => c.opTime <= DateTime.Parse(endTime).AddDays(1)); badList = results.OrderByDescending(c => c.opTime).ToList(); if (badList != null && badList.Count > 0) { foreach (Base_t_AccountDetail bad in badList) { bade = new Base_t_AccountDetailEntity(); PublicFunction.ObjectCopyTo(bad, bade); if (bade != null) { badeList.Add(bade); } } } return badeList; } catch (System.Exception ex) { return null; } } }
/// <summary> /// 新增账户流水信息 /// </summary> /// <param name="baaie"></param> /// <param name="message"></param> /// <returns></returns> public static bool InsertOperBalanceInfo(Base_t_AccountDetailEntity bade, out string message) { message = ""; bool retFlag = false; Base_t_AccountDetail bad = new Base_t_AccountDetail(); //检查入参 if (bade == null) { message = "传入参数有误"; return false; } //进行实体转换 PublicFunction.ObjectCopyTo(bade, bad); AccountDataSourceDataContext adsdc = new AccountDataSourceDataContext(); try { if (bad != null) { adsdc.Base_t_AccountDetail.InsertOnSubmit(bad); adsdc.SubmitChanges(); retFlag = true; message = "新增账户流水信息成功"; } else { message = "传入信息转换时出错"; } } catch (Exception ex) { retFlag = false; message = ex.Message; } return retFlag; }
/// <summary> /// 审核待审核记录 /// </summary> /// <param name="auditId"></param> /// <returns></returns> public static bool AuditOperBalanceInfo(int auditId, string operUserId,bool status, out string message) { message = ""; bool retFlag = false; using (AccountDataSourceDataContext adsdc = new AccountDataSourceDataContext()) { DbTransaction tran = adsdc.Connection.BeginTransaction(); Base_t_AccountAuditInfo baai = new Base_t_AccountAuditInfo(); Base_t_AccountInfo bai = new Base_t_AccountInfo(); baai = adsdc.Base_t_AccountAuditInfo.FirstOrDefault(p => p.id == auditId); try { //审核待审核记录 if (baai != null) { //如果流水记如存在,则根据流水记录中的账户ID取账户信息 bai = adsdc.Base_t_AccountInfo.FirstOrDefault(p => p.id == baai.accountId); baai.status = true; baai.opUser = operUserId; baai.opTime = DateTime.Now; adsdc.SubmitChanges(); retFlag = true; } //审核成功,插入操作记录到流水记录表 if (retFlag) { string mess = ""; Base_t_AccountDetailEntity bade = new Base_t_AccountDetailEntity(); PublicFunction.ObjectCopyTo(baai, bade); //自动赋值后,处理各别不同的属性值 bade.Id = 0; bade.Orderid = baai.refId; bade.Resume = baai.direction; bade.UseBalance = (decimal)baai.opBalance; if (baai.type == 0) bade.EndBalance = (decimal)bai.balance + (decimal)baai.opBalance; else bade.EndBalance = (decimal)bai.balance - (decimal)baai.opBalance; InsertOperBalanceInfo(bade, out mess); message = mess; } tran.Commit(); } catch(Exception ex) { tran.Rollback(); message = ex.Message; retFlag = false; } } return retFlag; }
/// <summary> /// 新增账户流水信息 /// </summary> /// <param name="baaie"></param> /// <param name="message"></param> /// <returns></returns> public bool InsertOperBalanceInfo(Base_t_AccountDetailEntity bade, out string message) { return AccountBusiness.InsertOperBalanceInfo(bade, out message); }