//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); } }