/// <summary>
/// 检测借书人信息
/// </summary>
/// <param name="username">借书人</param>
/// <returns>提示信息</returns>
public string Checkuser(string username)
{
string message = string.Empty;
UerInfo userinfo = new UerInfo();
GetLoanInfoMgr getLoanInfoMgr = new GetLoanInfoMgr();
userinfo = getLoanInfoMgr.CheckUserInfo(username);
if (userinfo.Booknum >= 5)
{
userinfo.Isborrow = false;
message = "每人最多可以借阅5本书，你已经借阅5本书，不能再借阅。#0";
}
else if (userinfo.OutBack > 0)
{
GetBookInfoMgr getBookInfoMgr = new GetBookInfoMgr();
GetBookItemInfoMgr getBookItemInfoMgr = new GetBookItemInfoMgr();
StringBuilder messagesb = new StringBuilder("您所借图书：");
foreach (Guid orderid in userinfo)
{
Guid bookid = getBookItemInfoMgr.GetBookID(orderid);
Bookinfo borrowbookinfo = getBookInfoMgr.GetBookInfoBybookid(bookid);
messagesb.Append("《" + borrowbookinfo.Title + "》");
}
messagesb.Append(" 超期依然未归还，请归还再借阅。#0");
message = messagesb.ToString();
userinfo.Isborrow = false;
}
else
{
message = this.GetreturnMessage(username);
}
return(message);
}
/// <summary>
/// 查询该人借书超期数量
/// </summary>
/// <param name="name">借阅人姓名</param>
/// <param name="conn">数据库连接</param>
/// <returns>超期数量</returns>
private UerInfo GetOutTimebooksum(string name, IDbConnection conn)
{
UerInfo userinfo = new UerInfo();
userinfo = this.loanInfoAccess.GetOutTimebooksum(name, conn);
return(userinfo);
}
/// <summary>
/// 检测借书人借书信息
/// </summary>
/// <param name="userName">借书人</param>
/// <returns>借书人信息</returns>
public UerInfo CheckUserInfo(string userName)
{
UerInfo userinfo = new UerInfo();
int booknum = 0;
string result = string.Empty;
booknum = this.GetbooknumbyUsername(userName);
userinfo.Booknum = booknum;
if (booknum < 5)
{
userinfo = this.GetOutTimebooksum(userName);
userinfo.OutBack = userinfo.Count;
}
return(userinfo);
}
/// <summary>
/// 查询该人借书超期数量
/// </summary>
/// <param name="name">借阅人姓名</param>
/// <param name="conn">数据库连接</param>
/// <returns>超期信息</returns>
public UerInfo GetOutTimebooksum(string name, IDbConnection conn)
{
UerInfo userinfo = new UerInfo();
try
{
string sqlforbookitem = "SELECT LoanDate, OrderNum FROM LoanInfo WHERE UserName= @name";
SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.NVarChar, 50) };
parameters[0].Value = name;
// 统计数量
using (SqlDataReader result = SqlHelper.ExecuteReader(null, conn as SqlConnection, sqlforbookitem, parameters))
{
if (result.HasRows)
{
DateTime tadytime = DateTime.Now;
while (result.Read())
{
DateTime borrowtime = result.GetDateTime(0);
Guid orderid = result.GetGuid(1);
if ((tadytime - borrowtime).Days >= 30)
{
userinfo.OutBack++;
userinfo.Add(orderid);
}
}
}
result.Close();
}
}
catch (Exception exp)
{
AppException appexp = new AppException("查询该人借书超期数量", exp, ExceptionLevel.Error);
LogManager.Log.WriteException(appexp);
}
return(userinfo);
}
/// <summary>
/// 查询该人借书超期数量
/// </summary>
protected override void ExecuteMethods()
{
this.uerInfo = this.GetOutTimebooksum(this.userName, this.Connection);
}
