public ObservableCollection <AcquisitionBaseData> Select(string _sqlwhere) { return(CommonAccess.ComSQLiteSelect <AcquisitionBaseData>(_sqlwhere)); //var collection = new ObservableCollection<AcquisitionBaseData>(); //var sql = "SELECT * FROM [AcquisitionBaseData] "; //var conn = new SQLiteConnection(connstr); //var ds = SqLiteHelper.ExecuteDataSet(conn, sql, null); //if (ds != null && ds.Tables.Count > 0) //{ // foreach (DataRow dr in ds.Tables[0].Rows) // { // var resource = new AcquisitionBaseData(); // resource.Id = int.Parse(dr["Id"].ToString()); // resource.Code = int.Parse(dr["Code"].ToString()); // resource.Confidence = int.Parse(dr["Confidence"].ToString()); // resource.Name = dr["Name"].ToString(); // resource.Remark = dr["Remark"].ToString(); // collection.Add(resource); // } //} //return collection; }
public ObservableCollection <Department> Select(string _sqlwhere) { return(CommonAccess.ComSQLiteSelect <Department>(_sqlwhere)); }
public ObservableCollection <AlarmHistory> Select(string _sqlwhere) { return(CommonAccess.ComSQLiteSelect <AlarmHistory>(_sqlwhere)); }
public ObservableCollection <SystemModule> Select(string _sqlwhere) { return(CommonAccess.ComSQLiteSelect <SystemModule>(_sqlwhere)); }
public ObservableCollection <EquipmentAlarmRecord> Select(string _sqlwhere) { return(CommonAccess.ComSQLiteSelect <EquipmentAlarmRecord>(_sqlwhere)); }
public ObservableCollection <UploadSetting> Select(string _sqlwhere) { return(CommonAccess.ComSQLiteSelect <UploadSetting>(_sqlwhere)); }
public ObservableCollection <ErrorDictionary> Select(string _sqlwhere) { return(CommonAccess.ComSQLiteSelect <ErrorDictionary>(_sqlwhere)); }
public ObservableCollection <EquipmentMaterial> Select(string _sqlwhere) { return(CommonAccess.ComSQLiteSelect <EquipmentMaterial>(_sqlwhere)); }
public ObservableCollection <DataEntiry.Equipment> Select(string _sqlwhere) { return(CommonAccess.ComSQLiteSelect <DataEntiry.Equipment>(_sqlwhere)); }
public ObservableCollection <Jurisdiction> Select(string _sqlwhere) { return(CommonAccess.ComSQLiteSelect <Jurisdiction>(_sqlwhere)); }