public static int LayPhieuNhan()
{
DataService ds = new DataService();
object obj = ds.ExecuteScalar(new SqlCommand("select PhieuNhan from THAM_SO"));
return Convert.ToInt32(obj);
}
public static int LayPhieuDangKy()
{
DataService ds = new DataService();
object obj = ds.ExecuteScalar(new System.Data.SqlClient.SqlCommand("select PhieuDangKy from THAM_SO"));
return Convert.ToInt32(obj);
}
public static void GanPhieuNhan(int id)
{
DataService ds = new DataService();
ds.ExecuteNoneQuery(new SqlCommand("update THAM_SO set PhieuNhan = " + id));
}
public static long LayHoaDon()
{
DataService ds = new DataService();
object obj = ds.ExecuteScalar(new SqlCommand("select HoaDon from THAM_SO"));
return Convert.ToInt32(obj);
}
public static void GanHoaDon(long id)
{
DataService ds = new DataService();
ds.ExecuteNoneQuery(new SqlCommand("update THAM_SO set HoaDon = " + id));
}
