예제 #1
0
        public ObservableCollection <cbSysLibre> ListFileOrderByName(CB_File File)
        {
            IQueryable <cbSysLibre> Return = from Table in this.DBSage.cbSysLibre
                                             where Table.CB_File.ToUpper() == File.ToString().ToUpper() &&
                                             (Table.CB_Type == (short)CB_Type.SageText ||
                                              Table.CB_Type == (short)CB_Type.SageTable ||
                                              Table.CB_Type == (short)CB_Type.SageDate ||
                                              Table.CB_Type == (short)CB_Type.SageMontant ||
                                              Table.CB_Type == (short)CB_Type.SageSmallDate ||
                                              Table.CB_Type == (short)CB_Type.SageValeur)
                                             orderby Table.CB_Name
                                             select Table;

            return(new ObservableCollection <cbSysLibre>(Return.ToList()));
        }
예제 #2
0
        public CB_Type ReadTypeInformationLibre(String Name, CB_File File)
        {
            CB_Type Type = CB_Type.Deleted;

            if (ExistInformationLibre(Name, File))
            {
                Type = (CB_Type)this.DBSage.cbSysLibre.First(i => i.CB_Name == Name && i.CB_File.ToUpper() == File.ToString().ToUpper()).CB_Type;
            }

            return(Type);
        }
예제 #3
0
 public cbSysLibre ReadInformationLibre(String Name, CB_File File)
 {
     return(this.DBSage.cbSysLibre.FirstOrDefault(i => i.CB_Name == Name && i.CB_File.ToUpper() == File.ToString().ToUpper()));
 }
예제 #4
0
 public Boolean ExistInformationLibre(String Name, CB_File File)
 {
     return(this.DBSage.cbSysLibre.Count(i => i.CB_Name == Name && i.CB_File.ToUpper() == File.ToString().ToUpper()) == 1);
 }