// Hàm xóa nhà cung cấp public bool deleteManhacungcap(string MAcc) { SqlCommand command = new SqlCommand("exec NHACUNGCAP_Xoa @mact", dt.getConnection); command.Parameters.Add("@mact", SqlDbType.VarChar).Value = MAcc; dt.openConnection(); if ((command.ExecuteNonQuery() == 1)) { dt.closeConnection(); return(true); } else { dt.closeConnection(); return(false); } }
// Hàm này để xóa cửa hàng public bool deleteMaCuaHang(string MACH) { SqlCommand command = new SqlCommand("exec CUAHANG_Xoa @mach", dt.getConnection); command.Parameters.Add("@mach", SqlDbType.VarChar).Value = MACH; dt.openConnection(); if (command.ExecuteNonQuery() == 1) { dt.closeConnection(); return(true); } else { dt.closeConnection(); return(false); } }
//XUAT KHO public bool insertXuatKho(string ma, string ten, DateTime ngay, int soluong, string dongia, string phieu, MemoryStream picture) { SqlCommand command = new SqlCommand ("exec proc_insXuatKho @ma, @ten, @ngay, @soluong, @dongia, @phieu,@picture", mydb.getConnection); command.Parameters.Add("@ma", SqlDbType.VarChar).Value = ma; command.Parameters.Add("@ten", SqlDbType.VarChar).Value = ten; command.Parameters.Add("@ngay", SqlDbType.DateTime).Value = ngay; command.Parameters.Add("@soluong", SqlDbType.Int).Value = soluong; command.Parameters.Add("@dongia", SqlDbType.VarChar).Value = dongia; command.Parameters.Add("@phieu", SqlDbType.VarChar).Value = phieu; command.Parameters.Add("@picture", SqlDbType.Image).Value = picture.ToArray(); mydb.openConnection(); //if (command.ExecuteNonQuery() == 1) if (command.ExecuteNonQuery() >= 1) //Do ket qua excute co so dong(row) >= 1 { mydb.closeConnection(); return(true); } else { mydb.closeConnection(); return(false); } }