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