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
}
