public static int CatrucHienTai()
{
string text = "";
string right = "";
string text2 = "";
text2 = Strings.Format(DateAndTime.Now, "HH:mm:ss");
int num = 1;
do
{
if (CSDL.SelectThoiGianCatruc(ModuleKhaiBaoConst.StrConnectMain, Conversions.ToString(num), ref text, ref right))
{
if (Operators.CompareString(text, right, false) < 0)
{
if (Operators.CompareString(text2, text, false) >= 0 & Operators.CompareString(text2, right, false) <= 0)
{
return(num);
}
}
else if ((Operators.CompareString(text2, text, false) >= 0 & Operators.CompareString(text2, "23:59:59", false) <= 0) | (Operators.CompareString(text2, "00:00:00", false) >= 0 & Operators.CompareString(text2, right, false) <= 0))
{
return(num);
}
}
num = checked (num + 1);
}while (num <= 4);
return(0);
}
public static bool KiemTraVeLanCungChieu(string strCon, int LanXe, string SoVe)
{
string cmdText = "select MsVali,SoveBD,SoveKT from tbl_Vali_DataBackup where convert(int, substring(MsVali,9,2)) = " + Conversions.ToString(LanXe);
SqlConnection sqlConnection = new SqlConnection(strCon);
DataTable dataTable = new DataTable();
try
{
sqlConnection.Open();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(new SqlCommand(cmdText, sqlConnection)
{
CommandType = CommandType.Text
});
sqlDataAdapter.Fill(dataTable);
sqlConnection.Close();
IEnumerator enumerator = null;
try
{
enumerator = dataTable.Rows.GetEnumerator();
while (enumerator.MoveNext())
{
DataRow dataRow = (DataRow)enumerator.Current;
string maVali = Conversions.ToString(dataRow["MSVali"]);
string right = Conversions.ToString(dataRow["SoveBD"]);
string right2 = Conversions.ToString(dataRow["SoveKT"]);
if (Operators.CompareString(SoVe, right, false) >= 0 & Operators.CompareString(SoVe, right2, false) <= 0)
{
string text = "";
string text2 = "";
DateTime t = VeXe.NgayInMaVali(maVali);
if (CSDL.SelectThoiGianCatruc(ModuleKhaiBaoConst.StrConnectMain, Conversions.ToString(VeXe.CatrucInMaVali(maVali)), ref text, ref text2))
{
t = t.AddHours(Conversions.ToDouble(text2.Substring(0, 2))).AddMinutes(Conversions.ToDouble(text2.Substring(3, 2))).AddHours(24.0);
if (DateTime.Compare(DateAndTime.Now, t) <= 0)
{
return(true);
}
}
}
}
}
finally
{
if (enumerator is IDisposable)
{
(enumerator as IDisposable).Dispose();
}
}
}
catch (Exception expr_18A)
{
ProjectData.SetProjectError(expr_18A);
Exception ex = expr_18A;
ModuleKhac.SaveError(ex.Message, "KiemTraVeLanCungChieu");
ProjectData.ClearProjectError();
}
return(false);
}
