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);
}