public void InsertAccountInfoTest() { Base_t_AccountInfoEntity baie = new Base_t_AccountInfoEntity(); // TODO: 初始化为适当的值 baie.AccCode = "12345"; baie.Balance = 300; baie.UserId = "userid"; baie.BlockBalance = 200; baie.CreateTime = DateTime.Now; baie.Status = 1; baie.UserType = 2; string message = string.Empty; // TODO: 初始化为适当的值 string account = string.Empty; // TODO: 初始化为适当的值 string messageExpected = string.Empty; // TODO: 初始化为适当的值 bool expected = false; // TODO: 初始化为适当的值 bool actual; actual = AccountBusiness.InsertAccountInfo(baie,out account, out message); Assert.AreEqual(messageExpected, message); Assert.AreEqual(expected, actual); Assert.Inconclusive("验证此测试方法的正确性。"); }
/// <summary> /// 更新账户信息 /// </summary> /// <param name="baie"></param> /// <param name="message"></param> /// <returns></returns> public static bool UpdateAccountInfo(Base_t_AccountInfoEntity baie, out string message) { message = ""; bool retFlag = false; Base_t_AccountInfo bai = new Base_t_AccountInfo(); //转换实体 if(baie != null) PublicFunction.ObjectCopyTo(baie, bai); AccountDataSourceDataContext adsdc = new AccountDataSourceDataContext(); try { adsdc.SubmitChanges(); message = "更新成功"; retFlag = true; } catch(Exception ex) { message = ex.Message; retFlag = false; } return retFlag; }
/// <summary> /// 根据用户ID查询账户信息 /// </summary> /// <param name="userId">用户ID</param> /// <returns></returns> public static Base_t_AccountInfoEntity SelectAccountInfoByUserId(string userId) { using (AccountDataSourceDataContext adsdc = new AccountDataSourceDataContext()) { Base_t_AccountInfoEntity baie = new Base_t_AccountInfoEntity(); Base_t_AccountInfo bai = new Base_t_AccountInfo(); bai = adsdc.Base_t_AccountInfo.FirstOrDefault(p => p.userId == userId.Trim()); if (bai != null) { PublicFunction.ObjectCopyTo(bai, baie); } else return null; return baie; } }
/// <summary> /// 根据账户ID和时间查询账户信息 /// </summary> /// <param name="email">邮件</param> /// <param name="message"> 返回信息 </param> /// <param name="tel">电话</param> /// <param name="userid">用户ID</param> /// <param name="userName">用户名称</param> /// <returns></returns> public static List<Base_t_AccountInfoEntity> SelectAccountInfoByAllInfo(string userids, string email, string tel, out string message) { message = ""; //临时存储所有需要返回的用户ID List<string> userIdList = new List<string>(); List<string> endUserIdList = new List<string>(); if (!string.IsNullOrEmpty(userids)) { //因为传入的用户id有可能是多个,所以拆分生成list给临时变量 userIdList = userids.Split(',').ToList(); } using (AccountDataSourceDataContext adsdc = new AccountDataSourceDataContext()) { //根据手机的邮箱地址查询所有相关的安全账户信息 List<Base_t_AccountScurityInfo> basiList = new List<Base_t_AccountScurityInfo>(); if (!string.IsNullOrEmpty(email) && !string.IsNullOrEmpty(tel)) { basiList = adsdc.Base_t_AccountScurityInfo.Where(p => p.scurityEmail == email.Trim() && p.scurityTel == tel.Trim()).ToList<Base_t_AccountScurityInfo>(); } else { if (!string.IsNullOrEmpty(email)) basiList = adsdc.Base_t_AccountScurityInfo.Where(p => p.scurityEmail == email).ToList <Base_t_AccountScurityInfo>(); if (!string.IsNullOrEmpty(tel)) basiList = adsdc.Base_t_AccountScurityInfo.Where(p => p.scurityTel == tel.Trim()).ToList<Base_t_AccountScurityInfo>(); } //如果手机和邮箱没传入参数,则查询的用户ID就等于传入的userIDs if (string.IsNullOrEmpty(email) && string.IsNullOrEmpty(tel)) { endUserIdList = userIdList; } else //如果根据邮箱和手机找到了userID追加到之前的userId中 if (basiList != null && basiList.Count > 0) { List<string> tempUserIdList = new List<string>(); tempUserIdList = basiList.Select(p => p.accountId.ToString()).ToList(); //合并取出,即在userIdList中又在tempUserIdList中的userID,即查询条件的并集数据 foreach (string userid in tempUserIdList) { if (userIdList.IndexOf(userid) >= 0) { endUserIdList.Add(userid); } } } List<Base_t_AccountInfoEntity> baieList = new List<Base_t_AccountInfoEntity>(); Base_t_AccountInfoEntity baie; List<Base_t_AccountInfo> baiList = new List<Base_t_AccountInfo>(); try { var results = from C in adsdc.Base_t_AccountInfo select C; if (endUserIdList != null && endUserIdList.Count > 0) { foreach (string userId in endUserIdList) { results = results.Where(c => c.userId == userId); } baiList = results.OrderByDescending(c => c.createTime).ToList(); } else baiList = null; if (baiList != null && baiList.Count > 0) { foreach (Base_t_AccountInfo bai in baiList) { baie = new Base_t_AccountInfoEntity(); PublicFunction.ObjectCopyTo(bai, baie); if (baie != null) { baieList.Add(baie); } } } return baieList; } catch (System.Exception ex) { message = ex.Message; return null; } } }
/// <summary> /// 查询账户信息 /// </summary> /// <param name="accountId"></param> /// <returns></returns> public static Base_t_AccountInfoEntity SelectAccountInfo(int accountId) { Base_t_AccountInfo bai = new Base_t_AccountInfo(); Base_t_AccountInfoEntity baie = new Base_t_AccountInfoEntity(); AccountDataSourceDataContext adsdc = new AccountDataSourceDataContext(); bai = adsdc.Base_t_AccountInfo.FirstOrDefault(p => p.id == accountId); if (bai != null) PublicFunction.ObjectCopyTo(bai, baie); if (baie != null) { return baie; } return null; }
/// <summary> /// 新增账户信息 /// </summary> /// <param name="baie"></param> /// <param name="message"></param> /// <returns></returns> public static bool InsertAccountInfo(Base_t_AccountInfoEntity baie, out string accountId, out string message) { accountId = ""; bool retFlag = false; Base_t_AccountInfo adbai = new Base_t_AccountInfo(); if (baie == null) { message = "传入参数有误"; return false; } //进行实体转换 PublicFunction.ObjectCopyTo(baie, adbai); AccountDataSourceDataContext adsdc = new AccountDataSourceDataContext(); try { if (adbai != null) { adsdc.Base_t_AccountInfo.InsertOnSubmit(adbai); adsdc.SubmitChanges(); } retFlag = true; message = "新增账户信息成功"; //返回账户ID accountId = adbai.id.ToString(); } catch(Exception ex) { retFlag = false; message = ex.Message; } return retFlag; }
/// <summary> /// 新增账户信息 /// </summary> /// <param name="baie"></param> /// <param name="message"></param> /// <returns></returns> public bool InsertAccountInfo(Base_t_AccountInfoEntity baie, out string accountId, out string message) { return AccountBusiness.InsertAccountInfo(baie, out accountId, out message); }
/// <summary> /// 更新账户信息 /// </summary> /// <param name="baie"></param> /// <param name="message"></param> /// <returns></returns> public bool UpdateAccountInfo(Base_t_AccountInfoEntity baie, out string message) { return AccountBusiness.UpdateAccountInfo(baie, out message); }