private void btnDelete_Click(object sender, EventArgs e) { if (dgvReader.SelectedCells.Count > 0) { int selectedrowindex = dgvReader.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = dgvReader.Rows[selectedrowindex]; string id = selectedRow.Cells["clmnReaderId"].Value.ToString(); DialogResult result = MessageBox.Show("Do you want to delete reader: " + selectedRow.Cells["clmnReaderName"].Value + "?", "Warning", MessageBoxButtons.OKCancel); switch (result) { case DialogResult.Cancel: break; case DialogResult.OK: ReaderBLL readerBLL = new ReaderBLL(selectedRow.Cells["clmnReaderName"].Value.ToString(), Convert.ToInt64(selectedRow.Cells["clmnReaderId"].Value.ToString()), selectedRow.Cells["clmnAddress"].Value.ToString(), selectedRow.Cells["clmnPhone"].Value.ToString(), selectedRow.Cells["clmnEmail"].Value.ToString(), Convert.ToDateTime(selectedRow.Cells["clmnDateallocated"].Value), Convert.ToDateTime(selectedRow.Cells["clmnDateend"].Value), Convert.ToDateTime(selectedRow.Cells["clmnDateallocated"].Value), Convert.ToBoolean(selectedRow.Cells["clmnStaff"].Value), Convert.ToInt32(selectedRow.Cells["clmnGraduation"].Value)); if (ReaderDAL.getReaderItem(readerBLL) == null) { MessageBox.Show("Can't delete! this Reader still not to give back of book"); break; } else { ReaderDAL.deleteReader(readerBLL); MessageBox.Show("Delete complete!", "Success"); this.LoadDataToDataGridView(); break; } } } }
private void btnSave_Click(object sender, EventArgs e) { if (dgvReader.SelectedCells.Count > 0) { int selectedrowindex = dgvReader.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = dgvReader.Rows[selectedrowindex]; ReaderBLL readerBLL = new ReaderBLL(this.txtDocgia.Text, Convert.ToInt64(this.txtMadocgia.Text), this.txtDc.Text, this.txtPhone.Text, this.txtEmail.Text, Convert.ToDateTime(this.txtNgaycap.Text), Convert.ToDateTime(this.txtNgahet.Text), Convert.ToDateTime(this.txtBirthday.Text), Convert.ToBoolean(this.cboStaff.Text), Convert.ToInt32(this.cboGranduationyear.Text)); //Int64 readerId = Int64.Parse(this.txtMadocgia.Text); if (this.txtDocgia.Text == "" || this.txtPhone.Text == "" || this.txtEmail.Text == "" || this.txtDc.Text == "" || this.txtNgaycap.Text == "" || this.txtNgahet.Text == "" || this.txtBirthday.Text == "") { MessageBox.Show("You mustn't empty any fields", "Notice"); return; } if (!IsNumber(this.cboGranduationyear.Text)) { MessageBox.Show("Both of \"Reader Code\" and \"Granduation year\" must be the number format!"); return; } if (!IsAllAlphabetic(this.txtDocgia.Text)) { MessageBox.Show("The \"Reader Name\" must be the character format!"); return; } if (!IsNumber(this.txtPhone.Text)) { MessageBox.Show("the \"Phone Number\" mustn't have the letters!"); return; } ReaderDAL.updateReader(readerBLL); //MessageBox.Show(readerBLL.Code.ToString()); MessageBox.Show("Update success!", "Success"); this.LoadDataToDataGridView(); } }
/// <summary> /// 读者详情 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ReaderDetail(object sender, EventArgs e) { Reader reader = new Reader(); if (dataGridView1.SelectedRows.Count <= 0) { MessageBox.Show("Not Exist!"); return; } if (tmpTbl.Rows.Count <= 0) { MessageBox.Show("Not Exist!"); return; } int id = (int)dataGridView1.SelectedRows[0].Cells[0].Value;//书籍编号 DataTable rt; try { rt = ReaderDAL.GetReaderByID(id); }catch (Exception ex) { MessageBox.Show("获取详细信息失败,当前用户非法!" + ex.Message); return; } reader = Reader.RowsToReader(rt.Rows); UserDetailForm bdf = new UserDetailForm(reader); bdf.Show(); }
public List <reader> getReaders() { ReaderDAL readerDAL = new ReaderDAL(); List <reader> readerList; readerList = readerDAL.getReaderList(); return(readerList); }
public reader getReaderInfo(string student_card_number) { ReaderDAL readerDAL = new ReaderDAL(); reader reader; reader = readerDAL.getReaderInfo(student_card_number); return(reader); }
private void btnAdd_Click(object sender, EventArgs e) { ReaderBLL readerBLL = new ReaderBLL(); readerBLL.Name = this.txtDocgia.Text; readerBLL.Code = Convert.ToInt64(this.txtMadocgia.Text); readerBLL.Phone = this.txtPhone.Text; readerBLL.Email = this.txtEmail.Text; readerBLL.Address = this.txtDc.Text; readerBLL.Allocateddate = Convert.ToDateTime(this.txtNgaycap.Text); readerBLL.Enddate = Convert.ToDateTime(this.txtNgahet.Text); readerBLL.Birthday = Convert.ToDateTime(this.txtBirthday.Text); readerBLL.IsStaff = Convert.ToBoolean(this.cboStaff.Text); readerBLL.Granduation = Convert.ToInt32(this.cboGranduationyear.Text); if (readerBLL.Name == "" || readerBLL.Code == null || readerBLL.Phone == "" || readerBLL.Email == "" || readerBLL.Address == "" || readerBLL.Allocateddate == null || readerBLL.Enddate == null || readerBLL.Birthday == null) { MessageBox.Show("You mustn't empty any fields", "Notice"); return; } if (!IsNumber(readerBLL.Code.ToString()) || !IsNumber(readerBLL.Granduation.ToString())) { MessageBox.Show("Both of \"Reader Code\" and \"Granduation year\" must be the number format!"); return; } if (!IsAllAlphabetic(readerBLL.Name)) { MessageBox.Show("The \"Reader Name\" must be the character format!"); return; } if (!IsNumber(readerBLL.Phone)) { MessageBox.Show("the \"Phone Number\" mustn't have the letters!"); return; } /*if(ReaderDAL.getReaderItem(readerBLL) != null) * { * MessageBox.Show("The \"Reader Code\" Existed!"); * return; * }*/ List <ReaderBLL> readerList = new List <ReaderBLL>(); readerList = ReaderDAL.getReaderList(); foreach (ReaderBLL row in readerList) { //MessageBox.Show(row.IsStaff.ToString()); if (readerBLL.Code == row.Code) { MessageBox.Show("The \"Reader Code\" Existed!"); return; } } //isExist("123"); ReaderDAL.addReader(readerBLL); MessageBox.Show("Add success!", "Success"); this.LoadDataToDataGridView(); }
protected void AddReader_Click(object sender, EventArgs e) { if (ProcessGUI.IsNumeric(this.txtReaderId.Text)) { Int64 readerId = Int64.Parse(this.txtReaderId.Text); ReaderBLL readerBLL = new ReaderBLL(); readerBLL = ReaderDAL.getReaderByReaderId(readerId); this._readerBLL = readerBLL; if (readerBLL != null) { this.lblReaderName.Text = readerBLL.Name; this.lblReaderId.Text = readerBLL.Code.ToString(); this.lblEmail.Text = readerBLL.Email; this.lblAddress.Text = readerBLL.Address; this.lblDayOfBirth.Text = readerBLL.Birthday.ToShortDateString(); this.lblPhone.Text = readerBLL.Phone; this.lblQuantity.Text = "0"; int result = (DateTime.Compare(DateTime.Now, readerBLL.Enddate)); if (result > 0) { string script = "alert(\"This reader has expired!\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); this.lblStatus.Text = "Expired"; } else { BorrowBookBLL borrowBookBLL = new BorrowBookBLL(); if (borrowBookBLL.checkBookBorrowMax(readerBLL)) { this.lblStatus.Text = "Good"; Session["readerName"] = readerBLL.Name; Session["readerId"] = readerBLL.Code; Session["quantity"] = borrowBookBLL.getBookQuantityCanBorrow(readerBLL); this.lblQuantity.Text = borrowBookBLL.getBookQuantityCanBorrow(readerBLL).ToString(); } else { string script = "alert(\"Reader has borrowed maximum books!\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); this.lblStatus.Text = "Maximum"; } } } else { string script = "alert(\"Readers do not exist!\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } } }
public string getDemoRTInfo() { DoorDAL doorDAL = new DoorDAL(); List <doorRecord> doorRecordList = doorDAL.getDemoDoorInfo(); RfidDAL rfidDAL = new RfidDAL(); List <RFIDRecord> RFIDRecordList = rfidDAL.getDemoRFIDInfo(); bookDAL bookDAL = new bookDAL(); ReaderDAL readerDAL = new ReaderDAL(); LocationDAL locationDAL = new LocationDAL(); string demoInfoInJson = "["; bool flag = true; //Door_RT_info foreach (doorRecord doorRecord in doorRecordList) { if (!flag) { demoInfoInJson += ","; } string locationName = locationDAL.getLocationByDoorIp(doorRecord.Door_ip); string readerName = readerDAL.getReaderNameBySC(doorRecord.Signal_code); string each = "{\"action\":\"" + doorRecord.Action + "\","; each += "\"reader_name\":\"" + readerName + "\","; each += "\"generate_date\":\"" + doorRecord.Generate_date + "\","; each += "\"location_door\":\"" + locationName + "\","; each += "\"door_ip\":\"" + doorRecord.Door_ip + "\"}"; demoInfoInJson += each; flag = false; } //RFID_RT_info foreach (RFIDRecord RFIDRecord in RFIDRecordList) { if (!flag) { demoInfoInJson += ","; } string locationName = locationDAL.getLocationByRFIDIp(RFIDRecord.Ip); string bookName = bookDAL.getbookNameBySC(RFIDRecord.Signal_code); string each = "{\"signal_code\":\"" + RFIDRecord.Signal_code + "\","; each += "\"book_name\":\"" + bookName + "\","; each += "\"action_date\":\"" + RFIDRecord.Action_date + "\","; each += "\"location_rfid\":\"" + locationName + "\","; each += "\"ip\":\"" + RFIDRecord.Ip + "\"}"; demoInfoInJson += each; flag = false; } demoInfoInJson += "]"; return(demoInfoInJson); }
private void btnSearch_Click(object sender, EventArgs e) { string key = this.txtSearch.Text; if (key == "".Trim()) { MessageBox.Show("Please enter keyword!", "Notice"); return; } string catalog = ""; //MessageBox.Show(this.cboSearch.SelectedItem.ToString()); if (this.cboTimtheo.SelectedItem.ToString() == "Reader Name") { catalog += "docgia.tendocgia"; //MessageBox.Show(catalog); } else if (this.cboTimtheo.SelectedItem.ToString() == "Reader Id") { catalog += "docgia.madocgia"; //MessageBox.Show(catalog); } else if (this.cboTimtheo.SelectedItem.ToString() == "Phone Number") { catalog += "docgia.sdtdocgia"; //MessageBox.Show(catalog); } else if (this.cboTimtheo.SelectedItem.ToString() == "E-mail") { catalog += "docgia.emaildocgia"; //MessageBox.Show(catalog); } ReaderBLL readerBLL = new ReaderBLL(); List <ReaderBLL> readerArr = new List <ReaderBLL>(); readerArr = ReaderDAL.search(key, catalog); this.dgvReader.Rows.Clear(); if (readerArr != null) { //MessageBox.Show("ok"); foreach (ReaderBLL row in readerArr) { this.dgvReader.Rows.Add(row.Code, row.Name, row.Address, row.Phone, row.Email, row.Allocateddate.ToShortDateString(), row.Enddate.ToShortDateString(), row.Birthday.ToShortDateString(), row.IsStaff, row.Granduation); } } else { MessageBox.Show("Sorry! Can't find this reader"); return; } this.dgvReader.SelectionChanged += new EventHandler(dgvReader_SelectionChanged); this.GetSelectedValue(); }
public static bool run_insql(Reader rd, int k) { switch (k) { case 0: return(ReaderDAL.rd_insert_insql(rd)); case 1: return(ReaderDAL.rd_delete_insql(rd)); case 2: return(ReaderDAL.rd_update_insql(rd)); default: return(false); } }
public static Int32 Login(Int32 rdID, string rdPwd) { Reader reader = ReaderDAL.GetObjectByID(rdID); if (reader == null || rdID == 0) { return(1); // 1 -> 用户不存在; } if (reader.rdPwd != rdPwd) { return(2); // 2 -> 用户密码错误; } return(0); // 0 -> 登录成功; }
private void LoadDataToDataGridView() { this.dgvReader.Rows.Clear(); List <ReaderBLL> readerList = new List <ReaderBLL>(); readerList = ReaderDAL.getReaderList(); foreach (ReaderBLL row in readerList) { //MessageBox.Show(row.IsStaff.ToString()); this.dgvReader.Rows.Add(row.Code, row.Name, row.Address, row.Phone, row.Email, row.Allocateddate.ToShortDateString(), row.Enddate.ToShortDateString(), row.Birthday.ToShortDateString(), row.IsStaff, row.Granduation); } this.dgvReader.SelectionChanged += new EventHandler(dgvReader_SelectionChanged); GetSelectedValue(); }
private void button1_Click(object sender, EventArgs e) { if (!editable) { editable = true; panel1.Enabled = true; textBox5.Enabled = false; textBox10.Enabled = false; textBox11.Enabled = false; dateTimePicker1.Enabled = false; this.Text = this.Text + "[修改信息]"; button1.Text = "完成修改"; } else { editable = false; panel1.Enabled = false; this.Text = "读者详细信息"; button1.Text = "修改用户信息"; Reader rd; { rd = new Reader(); rd.rdID = int.Parse(textBox1.Text); rd.rdUsername = textBox5.Text; rd.rdName = textBox3.Text; rd.rdSex = comboBox2.Text; rd.rdType = int.Parse(comboBox1.Text); rd.rdDept = textBox6.Text; rd.rdPhone = textBox7.Text; rd.rdEmail = textBox8.Text; rd.rdDateReg = dateTimePicker1.Value; rd.rdStatus = textBox10.Text; //rd.rdHaveBorrowNum = textBox11.Text; } try { int rst = ReaderDAL.UpdateInfo(rd); if (rst <= 0) { MessageBox.Show("修改信息失败!"); } } catch (Exception ex) { MessageBox.Show("修改信息失败!"); } } }
private void btnAddReader_Click(object sender, EventArgs e) { READER reader = new READER(); CARD card = new CARD(); var tempReader = Connection.db.READERS.Count(); reader.idReader = tempIDReader + tempReader; reader.nameReader = txtFirstName.Text + txtLastName.Text; reader.idClass = cbbClass.SelectedValue.ToString(); if (cbbSex.SelectedText == "Male") { reader.sex = false; } else { reader.sex = true; } reader.birthday = Convert.ToDateTime(dtpBirthday.Text); reader.address = txtAddress.Text; ReaderDAL.addNewReader(reader); }
public static DataTable GetDTby(string type, string content, int row, int number) { return(ReaderDAL.Searchby(type, content, row, number)); }
public DataTable GetReader(int rdType, string rdDept, string rdName) { return(ReaderDAL.GetReader(rdType, rdDept, rdName)); }
public static Reader GetReader(int rdID) { return(ReaderDAL.GetObjectByID(rdID)); }
public int Update(Reader reader) { return(ReaderDAL.Update(reader)); }
public int Insert(Reader reader) { return(ReaderDAL.Insert(reader)); }
public int Delete(Reader reader) { return(ReaderDAL.Delete(reader)); }
public bool addReader(Dictionary <string, string> kv) { ReaderDAL readerDAL = new ReaderDAL(); return(readerDAL.addReader(kv)); }
public int Loss(Reader reader) { return(ReaderDAL.Loss(reader)); }
public int UnLoss(Reader reader) { return(ReaderDAL.UnLoss(reader)); }
//修改密码 public int UpdatePwd(Reader readerPwd) { return(ReaderDAL.UpdatePwd(readerPwd)); }
public ReaderBUS() { paraDAL = new parametersDAL(); dgDal = new ReaderDAL(); }
private void button2_Click(object sender, EventArgs e) { string username = textBox1.Text; string pwd = textBox2.Text; if (textBox2.Text != textBox3.Text) { MessageBox.Show("密码不一致,请重新输入!"); return; } string name = textBox4.Text; string sex = comboBox1.Text; string type = comboBox2.Text; string dept = textBox5.Text; string phone = textBox6.Text; string email = textBox7.Text; Reader rd = new Reader(); rd.rdDateReg = DateTime.Now; rd.rdDept = dept; rd.rdEmail = email; rd.rdHaveBorrowNum = 0; //rd.rdID rd.rdName = name; rd.rdPassword = pwd; rd.rdPhone = phone; byte[] picbyte; if (this.picturePath != null) { picbyte = Tools.GetBytesByImagePath(this.picturePath); } else { picbyte = Tools.GetBytesByImage(pictureBox1); }; string tpid = "0"; #region if (comboBox2.Text == "--请选择类型--" || comboBox2.Text == "") { MessageBox.Show("请选择类型"); return; } else { int rows = TypeTmpTable.Rows.Count; bool exist_flag = false; for (int i = 0; i < rows; i++) { tpid = TypeTmpTable.Rows[i].ItemArray[0].ToString().Trim(); string tp_name = TypeTmpTable.Rows[i].ItemArray[1].ToString().Trim(); string index = (tp_name + "-" + tpid).Trim(); if (index == comboBox2.Text.Trim()) { exist_flag = true; break; } } if (!exist_flag) { MessageBox.Show("选择的类型不存在!"); return; } } #endregion rd.rdPhoto = picbyte; rd.rdSex = sex; rd.rdStatus = "正常"; rd.rdType = short.Parse(tpid); rd.rdUsername = username; try { ReaderDAL.Add(rd); MessageBox.Show("添加成功"); } catch (Exception ex) { MessageBox.Show("添加失败"); return; } }
public static Reader fill(Reader rd) { ReaderDAL rdal = new ReaderDAL(); return(rdal.fill(Convert.ToInt32(rd.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!")); } }
private void Reader_Load(object sender, EventArgs e) { gridControl1.DataSource = ReaderDAL.getListReader1(); }
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 }