示例#1
0
        public static bool TimBienSoTuVeThang(string strCon, string SoVe, ref string BienSo, ref string NgayHetHan)
        {
            DataTable dataTable = new DataTable();

            string[] parameterNames = new string[]
            {
                "@SoVe"
            };
            string[] parameterValues = new string[]
            {
                SoVe
            };
            dataTable = CSDL.TruyXuatCSDLByProcedure(strCon, "SeVeBienSoTuSoVe", parameterNames, parameterValues, 1);
            try
            {
                IEnumerator enumerator = null;
                try
                {
                    enumerator = dataTable.Rows.GetEnumerator();
                    while (enumerator.MoveNext())
                    {
                        DataRow dataRow  = (DataRow)enumerator.Current;
                        byte    loaiVe   = Conversions.ToByte(dataRow["LoaiVe"]);
                        int     thangQui = Conversions.ToInteger(dataRow["ThangQui"]);
                        int     nam      = Conversions.ToInteger(dataRow["Nam"]);
                        if (CSDL.KiemTraVeThangQui((int)loaiVe, nam, thangQui, ref NgayHetHan))
                        {
                            BienSo = Conversions.ToString(dataRow["BienSo"]);
                            return(true);
                        }
                    }
                }
                finally
                {
                    if (enumerator is IDisposable)
                    {
                        (enumerator as IDisposable).Dispose();
                    }
                }
            }
            catch (Exception expr_D7)
            {
                ProjectData.SetProjectError(expr_D7);
                Exception ex = expr_D7;
                ModuleKhac.SaveError(ex.Message, "TimBienSoTuVeThang");
                ProjectData.ClearProjectError();
            }
            return(false);
        }