/// <summary>
/// 搜索一个表中的数据，返回list集合
/// </summary>
/// <param name="tableName">要搜索表的名称</param>
/// <param name="searchName">要搜索的内容</param>
/// <returns></returns>
public static List <Model.UserBorrow> Search_nowTable(string tableName, string searchName)
{
List <Model.UserBorrow> Data = new List <Model.UserBorrow>();
SqlDataReader reader = DAL.DAL.Reader(DAL.DAL.SelectString("*", tableName,
"ApparatusName like @apparatusname or " +
"BorrowDate like @borrowdate or " +
"BorrowNumber like @borrownumber or " +
"ReturnDate like @returndate or " +
"UserName like @username or " +
"Telephone like @telephone"),
new SqlParameter(@"apparatusname", searchName),
new SqlParameter(@"borrowdate", searchName),
new SqlParameter(@"borrownumber", searchName),
new SqlParameter(@"returndate", searchName),
new SqlParameter(@"username", searchName),
new SqlParameter(@"telephone", searchName)
);
while (reader.Read())
{
Model.UserBorrow data = new Model.UserBorrow();
{
data.ApparatusName = reader["ApparatusName"].ToString();
data.BorrowDate = reader["BorrowDate"].ToString();
data.ReturnDate = reader["ReturnDate"].ToString();
data.UserName = reader["UserName"].ToString();
data.Telephone = reader["Telephone"].ToString();
data.BorrowNumber = reader["BorrowNumber"].ToString();
}
Data.Add(data);
}
reader.Close();
return(Data);
}
public static bool Test_YesterdayBorrow()
{
bool mybool = false;
List <Model.UserBorrow> Data = new List <Model.UserBorrow>();//用来储存符合条件的记录
SqlDataReader reader = DAL.DAL.Reader(DAL.DAL.SelectString("*", "YesterdayBorrow", string.Empty), null);
while (reader.Read())
{
Model.UserBorrow data = new Model.UserBorrow
{
Id = int.Parse(reader["Id"].ToString()),
ApparatusName = reader["ApparatusName"].ToString(),
BorrowDate = reader["BorrowDate"].ToString(),
BorrowNumber = reader["BorrowNumber"].ToString(),
ReturnDate = reader["Returndate"].ToString(),
Telephone = reader["Telephone"].ToString(),
UserName = reader["UserName"].ToString()
};
string[] yesterdayDate = data.ReturnDate.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries); //分割数据库YesterdayBorrow表中借用日期
string[] Year_month_day = yesterdayDate[0].Split(new char[] { '/' }, StringSplitOptions.RemoveEmptyEntries); //分割借用日期年月日，为数组
string[] Now_year_month_day = DateTime.Now.ToShortDateString().Split(new char[] { '/' }, StringSplitOptions.RemoveEmptyEntries); //分割现在年月日，为数组
//现在的年份大于归还日期的年份
if (Int32.Parse(Now_year_month_day[0]) > Int32.Parse(Year_month_day[0]))
{
Data.Add(data);//将符合条件的记录添加到集合
}
//年份相同时，比较月份，现在月份大时，直接添加
if (Int32.Parse(Now_year_month_day[0]) == Int32.Parse(Year_month_day[0]) && Int32.Parse(Now_year_month_day[1]) > Int32.Parse(Year_month_day[1]))
{
Data.Add(data);//将符合条件的记录添加到集合
}
//年份、月份相同时，比较日，现在日大时，直接添加
if (Int32.Parse(Now_year_month_day[0]) == Int32.Parse(Year_month_day[0]) && Int32.Parse(Now_year_month_day[1]) == Int32.Parse(Year_month_day[1]) && Int32.Parse(Now_year_month_day[2]) > Int32.Parse(Year_month_day[2]))
{
Data.Add(data);//将符合条件的记录添加到集合
}
}
reader.Close();
int insertRows = 0;
int deleteRows = 0;
//遍历储存有符合条件的记录，添加到NoReturnRecord
foreach (Model.UserBorrow item in Data)
{
insertRows = DAL.DAL.Execute(DAL.DAL.InsertString("NoReturnRecord", "(ApparatusName,BorrowDate,BorrowNumber,ReturnDate,UserName,Telephone)", "(@ApparatusName,@BorrowDate,@BorrowNumber,@ReturnDate,@UserName,@Telephone)"),
new SqlParameter(@"ApparatusName", item.ApparatusName),
new SqlParameter(@"BorrowDate", item.BorrowDate),
new SqlParameter(@"BorrowNumber", item.BorrowNumber),
new SqlParameter(@"ReturnDate", item.ReturnDate),
new SqlParameter(@"UserName", item.UserName),
new SqlParameter(@"Telephone", item.Telephone));
}
//遍历数组，删除TodayBorrow表中符合条件的记录
foreach (Model.UserBorrow item in Data)
{
deleteRows = BLL.Delete_Borrow(item.Id.ToString(), "YesterdayBorrow");
}
if (insertRows > 0 && deleteRows > 0)
{
mybool = true;
}
return(mybool);
}
