public bool UpdateTrangThaiKichHoat(SqlConnection conn, string s_MaQL, TrangThai.TrangThaiKichHoatBanNang TT_TrangThai)
{
try
{
string s_SQL = "Update " + Database.Schema + "." + this.sTable + " set kichhoat = @p_kichhoat where maql = @p_maql";
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = s_SQL;
cmd.Parameters.Add("@p_maql", SqlDbType.NVarChar).Value = Convert.ToInt16(s_MaQL);
cmd.Parameters.Add("@p_kichhoat", SqlDbType.Int).Value = (int)TT_TrangThai;
cmd.ExecuteNonQuery();
return(true);
}
catch
{
return(false);
}
}
public DataTable LoadTheoTrangThaiKichHoat(SqlConnection conn, TrangThai.TrangThaiKichHoatBanNang TT_Trangthai)
{
try
{
string s_SQL = "select a.maql,rtrim(a.kythuatvien) as kythuatvien,a.ndhienthi,a.trangthai,a.thoigianbd,a.tongthoigian, b.hoten,b.biensoxe from " + Database.Schema + "." + this.sTable + " a "
+ "left join " + Database.Schema + ".dskhachhang b on a.makhachhang = b.maql where a.kichhoat = " + (int)TT_Trangthai;
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = s_SQL;
SqlDataAdapter sqlAdt = new SqlDataAdapter(s_SQL, conn);
sqlAdt.Fill(dt);
return(dt);
}
catch
{
return(null);
}
}