public static bool SelectVali(string strCon, string MSNV, string SoVe, int LanXe, int TramId)
{
if (CSDL.Ve_Test(strCon, SoVe))
{
return(true);
}
DataTable dataTable = new DataTable();
string[] parameterNames = new string[]
{
"@MSNV"
};
string[] parameterValues = new string[]
{
MSNV
};
dataTable = CSDL.TruyXuatCSDLByProcedure(strCon, "SeValiData", parameterNames, parameterValues, 1);
try
{
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 & (int)VeXe.CabinInMaVali(maVali) == LanXe)
{
string left = Strings.Format(DateAndTime.Now, "yyMMdd");
string left2 = Strings.Format(DateAndTime.DateAdd(DateInterval.Day, -1.0, DateAndTime.Now), "yyMMdd");
string left3 = Strings.Format(DateAndTime.Now, "HH");
string right3 = "12";
switch (ModuleKhaiBaoConst.CaTrucMain)
{
case 1:
case 2:
if ((int)VeXe.CatrucInMaVali(maVali) == ModuleKhaiBaoConst.CaTrucMain & Operators.CompareString(left, VeXe.NgayInMaValiString(maVali), false) == 0)
{
bool result = true;
return(result);
}
break;
case 3:
if ((int)VeXe.CatrucInMaVali(maVali) == ModuleKhaiBaoConst.CaTrucMain & ((Operators.CompareString(left, VeXe.NgayInMaValiString(maVali), false) == 0 & Operators.CompareString(left3, right3, false) > 0) | (Operators.CompareString(left2, VeXe.NgayInMaValiString(maVali), false) == 0 & Operators.CompareString(left3, right3, false) < 0)))
{
bool result = true;
return(result);
}
break;
}
}
}
}
finally
{
if (enumerator is IDisposable)
{
(enumerator as IDisposable).Dispose();
}
}
}
catch (Exception expr_1F4)
{
ProjectData.SetProjectError(expr_1F4);
Exception ex = expr_1F4;
ModuleKhac.SaveError(ex.Message, "SelectVali");
ProjectData.ClearProjectError();
}
return(false);
}
