Пример #1
0
        public bool CheckEntryPoint(Database database, Classes.EntryPoint EPoint)
        {
            string          query      = EntryControl.Resources.Doc.Permit.CheckPermitPoint;
            QueryParameters parameters = new QueryParameters("permit", Id);

            parameters.Add("point", EPoint.Id);

            return((int)database.ExecuteScalar(query, parameters) > 0);

            //return (EntryPoint.Equals(EntryPoint.Empty)
            //            || EntryPoint.Equals(EPoint));
        }
Пример #2
0
        protected override void ReadProperties(DbDataReader reader)
        {
            try
            {
                System.Diagnostics.Debug.WriteLine(DateTime.Now.ToString("---> HH:mm:ss.fff"));

                Creator    = new User((int)reader["creator"], (string)reader["creatorName"]);
                CreateDate = (DateTime)reader["createDate"];

                System.Diagnostics.Debug.WriteLine(DateTime.Now.ToString("HH:mm:ss.fff"));

                period      = (int)reader["period"];
                docNumber   = (int)reader["docNumber"];
                permitState = new EnumerationItem((int)reader["permitState"], (string)reader["permitStateName"]);

                System.Diagnostics.Debug.WriteLine(DateTime.Now.ToString("HH:mm:ss.fff"));

                dateFrom = (DateTime)reader["dateFrom"];
                dateTo   = (DateTime)reader["dateTo"];

                System.Diagnostics.Debug.WriteLine(DateTime.Now.ToString("HH:mm:ss.fff"));

                cargo      = new Cargo((int)reader["cargo"], (string)reader["cargoName"]);
                vehicle    = new Vehicle((int)reader["vehicle"], (string)reader["vehicleName"]);
                driverName = (string)reader["driverName"];
                contact    = (string)reader["contact"];

                System.Diagnostics.Debug.WriteLine(DateTime.Now.ToString("HH:mm:ss.fff"));

                if (DBNull.Value.Equals(reader["entryPointName"]))
                {
                    EntryPoint = EntryPoint.Empty;
                }
                else
                {
                    EntryPoint = new Classes.EntryPoint((int)reader["entryPoint"], (string)reader["entryPointName"]);
                }
                multiEntry = (short)reader["multiEntry"];

                System.Diagnostics.Debug.WriteLine(DateTime.Now.ToString("HH:mm:ss.fff"));

                comment = "";
                //if (DBNull.Value.Equals(reader["comment"]))
                //    comment = "";
                //else
                //    comment = (string)reader["comment"];
                System.Diagnostics.Debug.WriteLine(DateTime.Now.ToString("HH:mm:ss.fff"));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Пример #3
0
 public PermitPoint(Permit permit, DbDataReader reader)
 {
     Permit    = permit;
     Point     = new Classes.EntryPoint((int)reader["pointid"], (string)reader["pointName"]);
     isAllowed = ((int)reader["isAllowed"]) > 0;
 }
Пример #4
0
 public EntryPointGroup(string groupName, DbDataReader reader)
 {
     GroupName  = groupName;
     EntryPoint = new Classes.EntryPoint(reader);
     IsIncluded = !DBNull.Value.Equals(reader["groupName"]);
 }