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