public int themLS(LayHang LH) { try { return(lhDAO.ThemLS(LH)); } catch (SqlException ex) { throw ex; } }
public int Xoa(LayHang LH) { try { return(lhDAO.Xoa(LH)); } catch (SqlException ex) { throw ex; } }
public int Xoa(LayHang LH) { string delete = "DELETE FROM SanPham WHERE MaSP = '" + LH.MaSP + "';"; try { return(myExcuteNoneQuery(delete)); } catch (SqlException ex) { throw ex; } }
public int LaySL(LayHang LH, string a) { string laysl = "SELECT SoLuong FROM SanPham WHERE MaSP = '" + LH.SoLuong + "';"; try { a = myExecuteScalar(laysl).ToString(); return(int.Parse(a)); } catch (SqlException ex) { throw ex; } }
public void TestLayHang_ThieuTenSP() { LayHangBUS LHBus = new LayHangBUS(); int a; string make = "K01"; string masp = "95486"; string tensp = ""; string soluong = "1000"; string ngaylay = (DateTime.Now).ToString(); string nguoilay = "hien"; LayHang LH = new LayHang(make, masp, tensp, soluong, ngaylay, nguoilay); a = LHBus.Xoa(LH); Assert.AreEqual(0, a); }
public int ThemLS(LayHang LH) { string select = "INSERT INTO LSXuatHang (MaKe, MaSP, TenSP, SoLuong, NgayLay, NguoiLay) " + "VALUES('" + LH.MaKe + "','" + LH.MaSP + "','" + LH.TenSP + "','" + LH.SoLuong + "','" + LH.NgayLay + "','" + LH.NguoiLay + "');"; try { return(myExcuteNoneQuery(select)); } catch (SqlException ex) { throw ex; } }
public void TestLayHang_ThieuMaKe_MaSP_TenSP_SoLuong_NgayLay_NguoiLay() { LayHangBUS LHBus = new LayHangBUS(); int a; string make = ""; string masp = ""; string tensp = ""; string soluong = ""; string ngaylay = ""; string nguoilay = ""; LayHang LH = new LayHang(make, masp, tensp, soluong, ngaylay, nguoilay); a = LHBus.Xoa(LH); Assert.AreEqual(0, a); }
public void TestLayHang_ThieuSoLuong_NgayLay_NguoiLay() { LayHangBUS LHBus = new LayHangBUS(); int a; string make = "K01"; string masp = "95486"; string tensp = "Pin sạc dự phòng"; string soluong = ""; string ngaylay = ""; string nguoilay = ""; LayHang LH = new LayHang(make, masp, tensp, soluong, ngaylay, nguoilay); a = LHBus.Xoa(LH); Assert.AreEqual(0, a); }
public void TestLayHang_ThieuMaKe_MaSP_NguoiLay() { LayHangBUS LHBus = new LayHangBUS(); int a; string make = ""; string masp = ""; string tensp = "Pin sạc dự phòng"; string soluong = "1000"; string ngaylay = (DateTime.Now).ToString(); string nguoilay = ""; LayHang LH = new LayHang(make, masp, tensp, soluong, ngaylay, nguoilay); a = LHBus.Xoa(LH); Assert.AreEqual(0, a); }
private void btnLayHang_Click(object sender, EventArgs e) { sqlcnn.Open(); String a; String select = "SELECT SoLuong FROM SanPham WHERE MaSP = '" + txtMaSP5.Text + "';"; SqlCommand selectcmd = new SqlCommand(select, sqlcnn); a = selectcmd.ExecuteScalar().ToString(); sqlcnn.Close(); int total; this.textBox1.Text = this.txtSL5.Text; string make = this.txtMaKe5.Text; string masp = this.txtMaSP5.Text; string tensp = this.txtTenSP5.Text; string soluong = this.txtSL5.Text; string ngaylay = (DateTime.Now).ToString(); string nguoilay = lbgetUser.Text; LayHang LH = new LayHang(make, masp, tensp, soluong, ngaylay, nguoilay); SanPham SP = new SanPham(masp, tensp, make, soluong); int SoDong; int y = int.Parse(a); int x = int.Parse(textBox1.Text); if (x < y) { total = y - x; SoDong = new SanPhamDAO().CapNhap(SP, total); SoDong = new LayHangDAO().ThemLS(LH); } else if (x == y) { SoDong = new SanPhamDAO().Xoa(SP); SoDong = new LayHangDAO().ThemLS(LH); } else { MessageBox.Show("SL lấy ra lớn hơn SL có trong kho"); } loadData(); }
public List <LayHang> GetLayHangDAO() { string select = "SELECT * FROM XuatHang"; string make; string masp; string tensp; string soluong; string ngaylay; string nguoilay; List <LayHang> list = new List <LayHang>(); connect(); try { SqlDataReader sda = layDuLieuTuBang(select); while (sda.Read()) { make = sda[0].ToString(); masp = sda[1].ToString(); tensp = sda[2].ToString(); soluong = sda[3].ToString(); ngaylay = sda[4].ToString(); nguoilay = sda[5].ToString(); LayHang item = new LayHang(make, masp, tensp, soluong, ngaylay, nguoilay); list.Add(item); } sda.Close(); return(list); } catch (SqlException ex) { throw ex; } finally { disConnect(); } }