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));
}