public static int DeleteBorrowedById(int id) { int iSuccess = 0; int uSuccess = 0; BorrowORLoanInfo borrowInfo = BorrowDAL.GetBorrowById(id); UserInfo userInfo = UserDAL.GetUserByName(borrowInfo.Borrower); BorrowDAL.DeleteBorrowed(id, out iSuccess); if (iSuccess > 0) { if (borrowInfo.BorrowORLoanType == 2) { CardInfo cardInfo = CardDAL.GetCardByCardNumber(borrowInfo.BorrowedAccount, userInfo.Id); float amount = cardInfo.Amount - borrowInfo.Amount; float borrowAmount = cardInfo.BorrowAmount - borrowInfo.Amount; CardDAL.UpdateCardAmount(amount, borrowAmount, cardInfo.Id, 3, out uSuccess); } } if (iSuccess > 0 && ((borrowInfo.BorrowORLoanType == 2 && uSuccess > 0) || (borrowInfo.BorrowORLoanType != 2 && uSuccess == 0))) { return(1); } else { return(0); } }
private bool ValidBorrow(string email, string bookName, string publishingHouse, int publicationYear) { Inventory inventory = EditionDAL.GetEditionInventory(bookName, publishingHouse, publicationYear); if (inventory.CurrentStock <= 0.1 * inventory.InitialStock) { Helper.DisplayError("\n There are no books available for borrow."); return(false); } int NMC = Helper.GetConfigData()["NMC"]; int PER = Helper.GetConfigData()["PER"]; List <Borrow> borrows = BorrowDAL.GetBorrowsForUser(email); borrows.RemoveAll(d => d.EndDate < DateTime.Today); if (borrows.Count >= NMC) { Borrow firstBorrow = borrows[borrows.Count - NMC]; Borrow lastBorrow = borrows[borrows.Count - 1]; if (DateTime.Today >= lastBorrow.StartDate && DateTime.Today < firstBorrow.StartDate.AddDays(PER * 7)) { Helper.DisplayError("\n You can't borrow another book. Come again on " + firstBorrow.StartDate.AddDays(PER * 7)); return(false); } } return(true); }
public static bool run_insql(Borrow br, int i) { switch (i) { case 0: return(BorrowDAL.ex_insert_insql(br)); case 1: return(BorrowDAL.ex_update_insql(br)); case 2: return(BorrowDAL.ex_delete_insql(br)); default: return(false); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; Borrow borrow = new Borrow(); int flag = Convert.ToInt32(context.Request["flag"]); borrow.ID = Convert.ToInt32(context.Request["ID"]); borrow.UID = Convert.ToInt32(context.Request["UID"]); borrow.BID = Convert.ToInt32(context.Request["BID"]); borrow.Borrow_time = Convert.ToDateTime(context.Request["Borrow_time"]); borrow.Return_time = Convert.ToDateTime(context.Request["Return_time"]); borrow.Is_return = context.Request["Is_return"]; if (flag == 0) { DataTable GetBorrow = BorrowDAL.GetBorrow(); string json = null; if (GetBorrow != null) { json = Common.JsonHelper.DataSetToJson(GetBorrow); } context.Response.Write(json); } else if (flag == 1) { DataTable GetBorrow = BorrowDAL.Select(borrow.UID); string json = null; if (GetBorrow != null) { json = Common.JsonHelper.DataSetToJson(GetBorrow); } context.Response.Write(json); } else if (flag == 2) { int Insert = BorrowDAL.Insert(borrow); context.Response.Write(Insert); } else if (flag == 3) { int Update = BorrowDAL.Update(borrow); context.Response.Write(Update); } else if (flag == 4) { int Delete = BorrowDAL.Delete(borrow); context.Response.Write(Delete); } }
public List <Borrow> GetBorrowsForUser() { string email = Helper.ReadString("Introduce the email of the user:"******"\n Wrong email!"); Console.ForegroundColor = ConsoleColor.DarkBlue; email = Helper.ReadString("Reintroduce the email of the user:"); } List <Borrow> borrows = null; borrows = BorrowDAL.GetBorrowsForUser(email); return(borrows); }
public static int InsertOrUpdatetoBorrowed(BorrowORLoanInfo info) { int iSuccess = 0; int uSuccess = 0; BorrowORLoanInfo borrowInfo = new BorrowORLoanInfo(); UserInfo userInfo = UserDAL.GetUserByName(info.Borrower); CardInfo cardInfo = CardDAL.GetCardByCardNumber(info.BorrowedAccount, userInfo.Id); if (info.Id > 0) { borrowInfo = BorrowDAL.GetBorrowById(info.Id); } BorrowDAL.InsertOrUpdatetoBorrowed(info, out iSuccess); if (iSuccess > 0 && info.BorrowORLoanType == 2) { float amount = 0; float borrowAmount = 0; if (info.Id > 0) { amount = cardInfo.Amount + (info.Amount - borrowInfo.Amount); borrowAmount = cardInfo.BorrowAmount + (info.Amount - borrowInfo.Amount); } else { amount = cardInfo.Amount + info.Amount; borrowAmount = cardInfo.BorrowAmount + info.Amount; } CardDAL.UpdateCardAmount(amount, borrowAmount, cardInfo.Id, 3, out uSuccess); } if ((iSuccess > 0 && info.Id > 0) && ((info.BorrowORLoanType == 2 && uSuccess > 0) || (info.BorrowORLoanType != 2 && uSuccess == 0))) { return(2); } else if ((iSuccess > 0 && info.Id == 0) && ((info.BorrowORLoanType == 2 && uSuccess > 0) || (info.BorrowORLoanType != 2 && uSuccess == 0))) { return(1); } else { return(0); } }
//显示所借书信息 public DataTable GetBorrow(int rdID) { return(BorrowDAL.GetBorrow(rdID)); }
//按书名查找 public DataTable GetBookName(string bkName) { return(BorrowDAL.GetBookName(bkName)); }
//借书 public int Insert(Borrow borrow) { return(BorrowDAL.Insert(borrow)); }
public bool delByStaffName(string StaffName, string PhoneID) { BorrowDAL borrowdal = new BorrowDAL(); return(borrowdal.delByStaffName(StaffName, PhoneID)); }
//按序号查找 public DataTable GetBookID(int bkID) { return(BorrowDAL.GetBookID(bkID)); }
//续借时更新borrow表记录 public int UpdateContinue(Borrow borrow) { return(BorrowDAL.UpdateContinue(borrow)); }
//根据读者类别rdTye获取可借书天数等信息 public DataTable GetReaderType(int rdType) { return(BorrowDAL.GetReaderType(rdType)); }
public static void ConnectDataBase() { #region DAL.ReaderType测试 Console.WriteLine("DAL.SqlHelper:测试数据库连接..."); SqlHelper.OpenConn(); Console.WriteLine("DAL.SqlHelper:测试数据库关闭...\n"); SqlHelper.CloseConn(); Console.WriteLine("Model.ReaderType:测试创建数据单元..."); ReaderType rdt1 = new ReaderType(); rdt1.rdType = 1; rdt1.rdTypeName = "admin"; rdt1.maxBorrowDay = 30; rdt1.maxBorrowNum = 8; rdt1.maxContinueTimes = 1; Console.WriteLine("DAL.ReaderType:测试Delete()..."); ReaderTypeDAL.Delete(rdt1); Console.WriteLine("DAL.ReaderType:测试Add()..."); rdt1.rdType = ReaderTypeDAL.Add(rdt1); string old_rdTypeName = rdt1.rdTypeName; rdt1.rdTypeName = "管理员"; Console.WriteLine("DAL.ReaderType:测试Update()...rdType由" + old_rdTypeName + "改为" + rdt1.rdTypeName + "\n"); ReaderTypeDAL.Update(rdt1); #endregion #region DAL.Reader测试 Console.WriteLine("Model.Reader:测试创建数据单元..."); Reader rd1 = new Reader(); rd1.rdID = 1; rd1.rdUsername = "******"; rd1.rdPassword = "******"; rd1.rdName = "duguying"; rd1.rdSex = "男"; rd1.rdType = 1; rd1.rdDept = "计科院"; rd1.rdPhone = "18900000000"; rd1.rdEmail = "*****@*****.**"; rd1.rdDateReg = DateTime.Now; rd1.rdPhoto = Encoding.Default.GetBytes("test"); rd1.rdStatus = "正常"; rd1.rdHaveBorrowNum = 1; Console.WriteLine("DAL.Reader:测试Delete()..."); ReaderDAL.Delete(rd1); Console.WriteLine("DAL.Reader:测试Add()..."); rd1.rdID = ReaderDAL.Add(rd1); string old_rdPassword = rd1.rdPassword; rd1.rdPassword = "******"; Console.WriteLine("DAL.Reader:测试Update()...rdPassword由" + old_rdPassword + "改为" + rd1.rdPassword + "\n"); ReaderDAL.Update(rd1); #endregion #region DAL.Borrow测试 Console.WriteLine("Model.Borrow:测试创建数据单元..."); Borrow br1 = new Borrow(); br1.borrowId = 1; br1.bkId = 1; br1.ldContinueTimes = 0; br1.ldDateOut = DateTime.Now; br1.ldDateRetPlan = DateTime.Now; br1.ldDateRetAct = DateTime.Now; br1.ldOverDay = 12; br1.ldOverMoney = 1.2f; br1.IsHasReturn = false; br1.OperatorLendId = 1; br1.OperatorRetId = 0; Console.WriteLine("DAL.Borrow:测试Delete()..."); BorrowDAL.Delete(br1); Console.WriteLine("DAL.Borrow:测试Add()..."); br1.borrowId = (decimal)BorrowDAL.Add(br1); float old_ldPunishMoney = br1.ldPunishMoney; br1.ldPunishMoney = 2.4f; Console.WriteLine("DAL.Borrow:测试Update()...ldPunishMoney由" + old_ldPunishMoney + "改为" + br1.ldPunishMoney + "\n"); BorrowDAL.Update(br1); #endregion #region DAL.Book测试 Console.WriteLine("Model.Book:测试创建数据单元..."); Book bk1 = new Book(); bk1.bkId = 1; bk1.bkCode = "1234"; bk1.bkName = "测试书籍"; bk1.bkAuthor = "作者"; bk1.bkPress = "出版社"; bk1.bkDatePress = DateTime.Now; bk1.bkISBN = "92520111234"; bk1.bkCatalog = "计算机科学"; bk1.bkLanguage = 0; bk1.bkPages = 300; bk1.bkPrice = 30.5f; bk1.bkDateIn = DateTime.Now; bk1.bkBrief = "Go语言基础教程"; bk1.bkCover = Encoding.Default.GetBytes("test"); bk1.bkStatus = "在馆"; Console.WriteLine("DAL.Book:测试Delete()..."); BookDAL.Delete(bk1); Console.WriteLine("DAL.Book:测试Add()..."); bk1.bkId = BookDAL.Add(bk1); string old_bkName = bk1.bkName; bk1.bkName = "Go语言云动力"; Console.WriteLine("DAL.Book:测试Update()...bkName由" + old_bkName + "改为" + bk1.bkName + "\n"); BookDAL.Update(bk1); #endregion #region DAL.Admin测试 Console.WriteLine("Model.Admin:测试创建数据单元..."); Admin ad1 = new Admin(); ad1.adminId = 1; ad1.adminUsername = "******"; ad1.adminPassword = "******"; ad1.adminEmail = "*****@*****.**"; ad1.adminLastLoginDate = DateTime.Now; Console.WriteLine("DAL.Admin:测试Delete()..."); AdminDAL.Delete(ad1); Console.WriteLine("DAL.Admin:测试Add()..."); ad1.adminId = AdminDAL.Add(ad1); string old_adminPassword = ad1.adminPassword; ad1.adminPassword = "******"; Console.WriteLine("DAL.Admin:测试Update()...adminPassword由" + old_adminPassword + "改为" + ad1.adminPassword + "\n"); AdminDAL.Update(ad1); #endregion #region 测试数据清理 ReaderTypeDAL.Delete(rdt1); Console.WriteLine("ReaderType:数据已清理"); ReaderDAL.Delete(rd1); Console.WriteLine("Reader:数据已清理"); BorrowDAL.Delete(br1); Console.WriteLine("Borrow:数据已清理"); BookDAL.Delete(bk1); Console.WriteLine("Book:数据已清理"); AdminDAL.Delete(ad1); Console.WriteLine("Admin:数据已清理\n"); #endregion #region DAL.Admin扩展操作测试 AdminDAL.getAdminByUsername("lijun"); #endregion }
//根据Book表查询图书状态 public DataTable GetbkStatus(int bkID) { return(BorrowDAL.GetbkStatus(bkID)); }
public static Int32 GetBorrowNotReturn(Reader reader) { return(BorrowDAL.Counter(reader.rdID)); }
public static Int32 SubmitAction(UserAction action) { switch (action.actionSource) { case "ReaderType": switch (action.actionType) { case "Add": try { return(ReaderTypeDAL.Add((ReaderType)action.actionModel)); } catch (Exception) { return(0); } case "Update": try { return(ReaderTypeDAL.Update((ReaderType)action.actionModel)); } catch (Exception) { return(0); } case "Delete": try { return(ReaderTypeDAL.Delete((ReaderType)action.actionModel)); } catch (Exception) { return(0); } default: throw new Exception("Error actionType!"); } case "Reader": switch (action.actionType) { case "Add": try { return(ReaderDAL.Add((Reader)action.actionModel)); } catch (Exception) { return(0); } case "Update": try { return(ReaderDAL.Update((Reader)action.actionModel)); } catch (Exception) { return(0); } case "Delete": try { return(ReaderDAL.Delete((Reader)action.actionModel)); } catch (Exception) { return(0); } case "Password": try { return(ReaderDAL.Password((Reader)action.actionModel)); } catch (Exception) { return(0); } case "Permission": try { return(ReaderDAL.Permission((Reader)action.actionModel)); } catch (Exception) { return(0); } default: throw new Exception("Error actionType!"); } case "Book": switch (action.actionType) { case "Add": try { return(BookDAL.Add((Book)action.actionModel)); } catch (Exception) { return(0); } case "Update": try { return(BookDAL.Update((Book)action.actionModel)); } catch (Exception) { return(0); } case "Delete": try { return(BookDAL.Delete((Book)action.actionModel)); } catch (Exception) { return(0); } default: throw new Exception("Error actionType!"); } case "Borrow": switch (action.actionType) { case "Borrow": try { return(BorrowDAL.Borrow((Borrow)action.actionModel)); } catch (Exception) { return(0); } case "Update": try { return(BorrowDAL.Update((Borrow)action.actionModel)); } catch (Exception) { return(0); } case "Delete": try { return(BorrowDAL.Delete((Borrow)action.actionModel)); } catch (Exception) { return(0); } case "Return": try { return(BorrowDAL.Return((Borrow)action.actionModel)); } catch (Exception) { return(0); } case "Continue": try { return(BorrowDAL.Continue((Borrow)action.actionModel)); } catch (Exception) { return(0); } default: throw new Exception("Error actionType!"); } default: throw (new Exception("Error actionSource!")); } }
public bool returnPhone(string StaffName, string PhoneName, string PhoneStage, string PhoneNum, string Test, string IsNormal, string Remark) { BorrowDAL borrowdal = new BorrowDAL(); return(borrowdal.returnPhone(StaffName, PhoneName, PhoneStage, PhoneNum, Test, IsNormal, Remark)); }
public bool isBorrowed(string PhoneID) { BorrowDAL borrowdal = new BorrowDAL(); return(borrowdal.isBorrowed(PhoneID)); }
public IList <BorrowInfo> selByCondition(string strSql) { BorrowDAL borrowdal = new BorrowDAL(); return(borrowdal.selByCondition(strSql)); }
//获取读者信息 public DataTable GetReader(int rdID) { return(BorrowDAL.GetReader(rdID)); }
public static BorrowORLoanCollection GetBorrowList(List <QueryElement> list) { return(BorrowDAL.GetBorrowList(list)); }
//借书后更新读者借书本数 public int UpdateBorrowNum(Reader reader) { return(BorrowDAL.UpdateBorrowNum(reader)); }
public IList <BorrowInfo> GetNoneBorrow() { BorrowDAL borrowdal = new BorrowDAL(); return(borrowdal.getNoneBorrow()); }
//还书时更新所借图书信息 public int UpdateBk(Borrow borrow) { return(BorrowDAL.UpdateBk(borrow)); }
//dgvBook指定行操作 public static Borrow GetBookInformation(int bkID) { return(BorrowDAL.GetObjectByID(bkID)); }
//根据Reader表查询证件状态 public DataTable GetrdStatus(int rdID) { return(BorrowDAL.GetrdStatus(rdID)); }
public bool addBorrow(string StaffName, string PhoneName, string PhoneStage, string PhoneNum, string Operator) { BorrowDAL borrowdal = new BorrowDAL(); return(borrowdal.addBorrow(StaffName, PhoneName, PhoneStage, PhoneNum, Operator)); }
public static DataTable GetDTby(string type, string content, int row, int number, int rdID) { return(BorrowDAL.Searchby(type, content, row, number, rdID)); }
public static BorrowORLoanInfo GetBorrowById(int id) { return(BorrowDAL.GetBorrowById(id)); }