private BookDamageLog GetBookDamageLog(ref List <string> error) { List <string> errorList = new List <string>();//错误列表 string bookId = textBox_bookId.Text; if (string.IsNullOrEmpty(bookId)) { errorList.Add("BookId Error"); } string checkerId = textBox_checkerId.Text; if (string.IsNullOrEmpty(checkerId)) { errorList.Add("ReaderId Error"); } string detail = textBox_detail.Text; if (string.IsNullOrEmpty(detail)) { errorList.Add("Detail Error"); } BookDamageLog bookBorrowLog = new BookDamageLog() { BookId = int.Parse(bookId), CheckerId = int.Parse(checkerId), DamageDetail = detail, CheckTime = DateTime.Now, RepairState = comboBox_chooseType.Text, }; error = errorList; return(bookBorrowLog); }
private void button_stateChange_Click(object sender, EventArgs e) { DialogResult dialogResult = MessageBox.Show("是否确定修改", "修改确认", MessageBoxButtons.YesNoCancel); //设置弹出窗体的格式 if (dialogResult == DialogResult.Yes) //如果选择确认按钮 { int id; if (!int.TryParse(idTextBox.Text, out id))//将其转换为数字失败 { MessageBox.Show("编号格式错误"); return; } BookDamageLog log = new BookDamageLog() { Id = id, RepairState = comboBox_State.Text }; if (circulationBll.UpdateDamageLog(log))//调用修改方法 { MessageBox.Show("修改成功"); } else { MessageBox.Show("修改失败"); } } }
private void btn_addCase_Click(object sender, EventArgs e) { try { List <string> errorList = new List <string>();//创建一个错误列表 //获取根据当前页面内容生成的订单(若有错误会被添加到错误列表中) var list = new BookDamageLog[] { GetBookDamageLog(ref errorList) }; if (errorList.Count == 0) { if (userCaseHandle.AddUserCases(list.ToList())) { MessageBox.Show("添加成功"); } } else { MessageBox.Show("添加失败"); foreach (var i in errorList) { MessageBox.Show(i);//逐条显示错误信息 } } } catch (Exception ex) { MessageBox.Show(ex.Message); } DataBind(); }
public void AddDamageLogTest() { Tools.UserCaseHandle userCaseHandle = new Tools.UserCaseHandle(@"C:\Users\96464\Desktop\软件工程\测试用例\Add_BookDamageLog.xls"); IEnumerable bookDamageLogs = userCaseHandle.GetUserCases(); List <string> errorList = new List <string>(); foreach (var i in bookDamageLogs) { Assert.AreEqual(false, circulationBll.AddDamageLog((BookDamageLog)i, ref errorList)); } int maxId = -1; foreach (Book i in circulationBll.GetAllBooksArray()) { if (i.Id > maxId) { maxId = i.Id; } } BookDamageLog log = new BookDamageLog() { Id = 1, BookId = maxId, RepairState = "已修复", CheckerId = utilBll.GetUserIdFormNumber("201709001013"), CheckTime = DateTime.Now, DamageDetail = "add单元测试损坏详情" + DateTime.Now.ToString("yy-MM-dd") }; Assert.AreEqual(true, circulationBll.AddDamageLog((BookDamageLog)log, ref errorList)); }
private void damageButton_Click(object sender, EventArgs e) { try { int id; if (!int.TryParse(logId, out id))//将其转换为数字失败 { MessageBox.Show("书籍编号格式错误"); return; } if (circulationBll.ReturnBorrowedBook(id))//调用还书方法 { MessageBox.Show("还书成功"); } else { MessageBox.Show("还书失败"); } List <string> errorList = new List <string>();//创建一个错误列表 BookDamageLog log = new BookDamageLog(); var form = new AddDamageForm(this, log); form.StartPosition = FormStartPosition.CenterParent; DialogResult dialogResult = form.ShowDialog(); if (dialogResult == DialogResult.Yes)//如果选择确认按钮 { int bookid; if (!int.TryParse(bookCodeTextBox.Text, out bookid))//将其转换为数字失败 { MessageBox.Show("书籍编号格式错误"); return; } log.BookId = bookid; log.RepairState = "待修复"; if (circulationBll.AddDamageLog(log, ref errorList))//添加破损记录 { MessageBox.Show("增加破损成功"); } else { MessageBox.Show("增加破损失败"); } } if (errorList.Count > 0) { foreach (var i in errorList) { MessageBox.Show(i); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 更改损坏状态 /// </summary> /// <param name="log">图书损坏记录</param> /// <returns>更改成功与否</returns> public bool UpdateDamageLog(BookDamageLog log) { bool result; try { result = circulationDal.UpdateDamageLog(log); } catch (Exception ex) { Console.WriteLine(ex.Message); throw ex; } return(result); }
/// <summary> /// 增加书籍损坏记录 /// </summary> /// <param name="log">损坏记录</param> /// <returns>损坏记录</returns> public bool AddDamageLog(BookDamageLog log, ref List <string> errorMsg) { bool result = false; try { if (!BookDamageLog.isNull(log)) //是否有空项 { if (BookDamageLog.isNormative(log, ref errorMsg)) //是否符合规范 { result = circulationDal.AddDamageLog(log); } } } catch (Exception ex) { Console.WriteLine(ex.Message); throw ex; } return(result); }
/// <summary> /// 更改损坏状态 /// </summary> /// <param name="log">图书损坏记录</param> /// <returns>更改成功与否</returns> public bool UpdateDamageLog(BookDamageLog log) { string sqlStr = "UPDATE tb_BookDamageLog SET " + "RepairState=@state " + "where Id=@id;"; //储存Datatable MySqlParameter[] para = new MySqlParameter[]//存储相应参数的容器 { new MySqlParameter("@state", log.RepairState), new MySqlParameter("@id", log.Id), }; int count = helper.ExecuteNonQuery(sqlStr, para, CommandType.Text); if (count > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加书籍损坏记录 /// </summary> /// <param name="log">损坏记录</param> /// <returns>损坏记录</returns> public bool AddDamageLog(BookDamageLog log) { string sqlStr = "INSERT INTO tb_BookDamageLog (" + "BookId," + "CheckerId," + "CheckTime," + "DamageDetail," + "RepairState" + ") " + "VALUES(" + "@bookId," + "@checkerId," + "@checkTime," + "@damageDetail," + "@repairState" + ");"; //储存Datatable MySqlParameter[] para = new MySqlParameter[]//存储相应参数的容器 { new MySqlParameter("@bookId", log.BookId), new MySqlParameter("@checkerId", log.CheckerId), new MySqlParameter("@checkTime", log.CheckTime), new MySqlParameter("@damageDetail", log.DamageDetail), new MySqlParameter("@repairState", log.RepairState), }; int count = helper.ExecuteNonQuery(sqlStr, para, CommandType.Text); if (count > 0) { return(true); } else { return(false); } }
public AddDamageForm(Form form, BookDamageLog log) { InitializeComponent(); parentForm = form; damageLog = log; }