private SelectCriteria Set18K6CSelectCriteria(int radioHandle)
{
SelectCriteria selectCriteria = new SelectCriteria();
selectCriteria.countCriteria = 1;
selectCriteria.pCriteria = new SelectCriterion[selectCriteria.countCriteria];
selectCriteria.pCriteria[0] = new SelectCriterion();
// change the mask attributes as appropriate for the specific tag
selectCriteria.pCriteria[0].mask.bank = MemoryBank.EPC;
selectCriteria.pCriteria[0].mask.offset = 112; // bit offset in the EPC memory bank, for the 6th word of the EPC
selectCriteria.pCriteria[0].mask.count = 16; // 16 bits to match starting at offset
selectCriteria.pCriteria[0].mask.mask[0] = 0x00; // first byte of 6th word is 0
selectCriteria.pCriteria[0].mask.mask[1] = 0x24; // 2nd byte of 6th word is 24
selectCriteria.pCriteria[0].action.target = Target.SELECTED;
selectCriteria.pCriteria[0].action.action = rfid.Constants.Action.ASLINVA_DSLINVB;
selectCriteria.pCriteria[0].action.enableTruncate = 0;
var result = link.Set18K6CSelectCriteria(radioHandle, selectCriteria, 0);
logger.Information("link.Set18K6CSelectCriteria => {Result}", result);
return(selectCriteria);
}
public void initDDL()
{
//template.Bindings["Value"];
//template.Bindings["Key"];
string tableName = this["Table"].GetValue <string>();
string displayFieldName = this["DisplayField"].GetValue <string>();
valueFieldName = this["ValueField"].GetValue <string>();
SelectCriteria sc = new SelectCriteria();
sc.fields = new System.Collections.ArrayList();
sc.fields.Add(displayFieldName);
sc.fields.Add(valueFieldName);
myRows = DynamicRow.FindRows(tableName, sc);
foreach (DynamicRow row in myRows)
{
ctl.Items.Add(row[displayFieldName].AsObject());
}
ctl.SelectedIndexChanged += new EventHandler(ctl_SelectedIndexChanged);
}
public Query(Uri serviceUri)
{
this.baseUri = serviceUri;
this.select = new SelectCriteria(this);
this.where = new FilterCriteria(this);
this.order = new OrderByCriteria(this);
}
public ConfigureSelect_Edit(LakeChabotReader reader, SelectCriteria criteria)
{
InitializeComponent( );
configureSelect_Display.setReader(reader);
configureSelect_Display.setSource(criteria);
configureSelect_Display.Mode = ConfigureSelect_Display.EDIT_MODE; // edit on
}
public ConfigureSelect_Edit( LakeChabotReader reader, SelectCriteria criteria )
{
InitializeComponent( );
configureSelect_Display.setReader( reader );
configureSelect_Display.setSource( criteria );
configureSelect_Display.Mode = ConfigureSelect_Display.EDIT_MODE; // edit on
}
public ListMapping GetMappingByList(string list)
{
var criteria = new SelectCriteria <ListMapping>
{
ExpressionSelect = new List <Expression <Func <ListMapping, bool> > >
{
item => item.ListName == list.ToString()
}
};
return(_listMappingProvider.List(criteria).FirstOrDefault());
}
public void RefreshGrid(BaseCriteriaCollection bcc) //ControlSchema template, BaseCriteriaCollection criteria=null)
{
string tableName = this["TableName"].GetValue <string>("");
string[] columns = this["Columns"].GetValue <string[]>(null);
string[] titles = this["ColumnHeaders"].GetValue <string[]>(null);
int i = 0;
DataTable dt = new DataTable();
SelectCriteria sc = new SelectCriteria();
sc.fields = new System.Collections.ArrayList();
ctl.Columns.Clear();
foreach (string column in columns)
{
WinUI.DataGridViewTextBoxColumn col = new WinUI.DataGridViewTextBoxColumn();
col.HeaderText = titles[i++];
col.DataPropertyName = column;
col.Name = column;
ctl.Columns.Add(col);
dt.Columns.Add(column);
sc.fields.Add(column);
}
if (bcc != null)
{
sc.Criteria = bcc;
}
//sc.Criteria = criteria;
DynamicRowCollection rows = DynamicRow.FindRows(tableName, sc);
for (i = 0; i < rows.Count; i++)
{
DataRow dr = dt.NewRow();
foreach (string column in columns)
{
dr[column] = rows[i][column].fValue;
}
dt.Rows.Add(dr);
}
ctl.DataSource = dt;
}
public QueryCriteria Concat(QueryCriteria queryCriteria)
{
if (queryCriteria == null)
{
return(this);
}
Dictinct = queryCriteria.Dictinct;
SelectCriteria.AddRange(queryCriteria.SelectCriteria);
JoinCriteria.AddRange(queryCriteria.JoinCriteria);
WhereCriteria.AddRange(queryCriteria.WhereCriteria);
InternalWhere.AddRange(queryCriteria.InternalWhere);
OrderCriteria.AddRange(queryCriteria.OrderCriteria);
return(this);
}
ConfigureSelect_Edit dlg; // frame ( form ) for containing edit mode panel
public ConfigureSelect_Display( )
:
base( )
{
InitializeComponent( );
this.selectCriteria = new SelectCriteria( );
this.selectCriteria.pCriteria = new SelectCriterion[CRITERIA_MAXIM];
for (int index = 0; index < CRITERIA_MAXIM; ++index)
{
this.selectCriteria.pCriteria[index] = new SelectCriterion( );
}
foreach (Target item in Enum.GetValues(typeof(Target)))
{
this.inventoryTarget.Items.Add(item);
}
this.inventoryTarget.Items.Remove(Target.UNKNOWN);
foreach (MemoryBank item in Enum.GetValues(typeof(MemoryBank)))
{
this.memoryBank.Items.Add(item);
}
//clark 2011.07.08 Doesn't support reserved,
this.memoryBank.Items.Remove(MemoryBank.RESERVED);
this.memoryBank.Items.Remove(MemoryBank.UNKNOWN);
//Mod FJ for NXP authentication function, 2018-02-02
foreach (rfid.Constants.Action item in Enum.GetValues(typeof(rfid.Constants.Action)))
//foreach (Action item in Enum.GetValues(typeof(Action)))
{
this.action.Items.Add(item);
}
this.action.Items.Remove(rfid.Constants.Action.UNKNOWN);
//this.action.Items.Remove(Action.UNKNOWN);
//End FJ for NXP authentication function, 2018-02-02
this.truncation.Items.Add("DISABLE");
this.truncation.Items.Add("ENABLE");
// active criteria value set to 1 in props to force flip
// view ( invis ) of center panel if first pass shows now
// criteria active...
Mode = VIEW_MODE; // always start in view mode...
}
public void setSource(SelectCriteria criteria)
{
this.selectCriteria = criteria;
// to trigger redraw etc. events... wont occur if values
// are actually equal...
if (this.activeCriteria.Value == criteria.countCriteria)
{
activeCriteria_ValueChanged(null, null);
}
else
{
this.activeCriteria.Value = criteria.countCriteria;
}
}
public List <Definition> List(DefTypes defTypes)
{
var criteria = new SelectCriteria <Definition>
{
PageSize = Int32.MaxValue,
ExpressionSort = new List <Expression <Func <Definition, dynamic> > > {
item => item.Code, item => item.Name
},
ExpressionSelect = new List <Expression <Func <Definition, bool> > >
{
item => item.TypeId == (int)defTypes,
item => item.Status == (int)DefStatus.Active
}
};
return(List(criteria));
}
public virtual PagerList <TEntity> List(int pageIndex, int pageSize)
{
var criteria = DefaultSelectCriteria();
if (criteria == null)
{
criteria = new SelectCriteria <TEntity>
{
PageIndex = pageIndex,
PageSize = pageSize
};
}
else
{
criteria.PageSize = pageSize;
criteria.PageIndex = pageIndex;
}
return(List(criteria));
}
public ConfigureSelect_Display( )
: base()
{
InitializeComponent( );
this.selectCriteria = new SelectCriteria( );
this.selectCriteria.pCriteria = new SelectCriterion[ CRITERIA_MAXIM ];
for( int index = 0; index < CRITERIA_MAXIM; ++ index )
{
this.selectCriteria.pCriteria[ index ] = new SelectCriterion( );
}
foreach (Target item in Enum.GetValues(typeof(Target)))
{
this.inventoryTarget.Items.Add(item);
}
this.inventoryTarget.Items.Remove(Target.UNKNOWN);
foreach (MemoryBank item in Enum.GetValues(typeof(MemoryBank)))
{
this.memoryBank.Items.Add(item);
}
//clark 2011.07.08 Doesn't support reserved,
this.memoryBank.Items.Remove(MemoryBank.RESERVED);
this.memoryBank.Items.Remove(MemoryBank.UNKNOWN);
foreach (Action item in Enum.GetValues(typeof(Action)))
{
this.action.Items.Add(item);
}
this.action.Items.Remove(Action.UNKNOWN);
this.truncation.Items.Add( "DISABLE" );
this.truncation.Items.Add( "ENABLE" );
// active criteria value set to 1 in props to force flip
// view ( invis ) of center panel if first pass shows now
// criteria active...
Mode = VIEW_MODE; // always start in view mode...
}
public int TotalCount(SelectCriteria <TEntity> criteria)
{
int result;
if (criteria.PageIndex <= 0)
{
criteria.PageIndex = 1;
}
var db = GetObjectContext();
{
InitDataContext(db);
var query = from entities in db.GetTable <TEntity>() select entities;
if ((criteria.ExpressionSelect != null) && (criteria.ExpressionSelect.Any()))
{
query = criteria.ExpressionSelect.Aggregate(query, (current, expressionSelect) => current.Where(expressionSelect));
}
result = query.Count();
}
return(result);
}
// Should only see this event if in edit mode and in a form
// container, otherwise the save button is hidden...
private void saveButton_Click(object sender, EventArgs e)
{
SelectCriteria criteria = new SelectCriteria( );
criteria.countCriteria = this.selectCriteria.countCriteria;
criteria.pCriteria = new SelectCriterion[criteria.countCriteria];
uint select;
reader.MacReadRegister(RegisterData.HST_INV_CFG, out select);
select &= 0xFFFFBFFF;
select |= (criteria.countCriteria > 0) ? (uint)(1 << 14) : 0;
reader.MacWriteRegister(RegisterData.HST_INV_CFG, select);
for (int index = 0; index < criteria.countCriteria; ++index)
{
criteria.pCriteria[index] = this.selectCriteria.pCriteria[index];
}
Result result = LakeChabotReader.MANAGED_ACCESS.API_l8K6CSetSelectCriteria(selectCriteria);
if (Result.OK == result)
{
// triggered only when in enclosing frame ( form )
(( Form )this.Parent).Close( );
}
else
{
// ERR
MessageBox.Show
(
"Reader Error.\n\nThe Reader was unable to configure the specified settings.\n\nThe follow error occurred: " + result.ToString( ),
"Configure Select Criteria Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
}
}
// Should only see this event if in edit mode and in a form
// container, otherwise the save button is hidden...
private void saveButton_Click( object sender, EventArgs e )
{
SelectCriteria criteria = new SelectCriteria( );
criteria.countCriteria = this.selectCriteria.countCriteria;
criteria.pCriteria = new SelectCriterion[ criteria.countCriteria ];
uint select;
reader.MacReadRegister(RegisterData.HST_INV_CFG, out select);
select &= 0xFFFFBFFF;
select |= (criteria.countCriteria >0) ? (uint)(1 << 14) : 0;
reader.MacWriteRegister(RegisterData.HST_INV_CFG, select);
for( int index = 0; index < criteria.countCriteria; ++ index )
{
criteria.pCriteria[ index ] = this.selectCriteria.pCriteria[ index ];
}
Result result = LakeChabotReader.MANAGED_ACCESS.API_l8K6CSetSelectCriteria(selectCriteria);
if ( Result.OK == result )
{
// triggered only when in enclosing frame ( form )
( ( Form ) this.Parent ).Close( );
}
else
{
// ERR
MessageBox.Show
(
"Reader Error.\n\nThe Reader was unable to configure the specified settings.\n\nThe follow error occurred: " + result.ToString( ),
"Configure Select Criteria Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
}
}
public ConfigureSelect_Display(SelectCriteria criteria)
:
this()
{
this.setSource(criteria);
}
public PagerList <TEntity> List(SelectCriteria <TEntity> criteria)
{
PagerList <TEntity> res = null;
if (criteria.PageIndex <= 0)
{
criteria.PageIndex = 1;
}
var db = GetObjectContext();
{
InitDataContext(db);
var query = GetBaseListSelectQuery(db);
if (query is ObjectQuery <TEntity> )
{
(query as ObjectQuery <TEntity>).MergeOption = MergeOption.NoTracking;
}
//Apply entity select
if ((criteria.ExpressionSelect != null) && (criteria.ExpressionSelect.Any()))
{
query = criteria.ExpressionSelect.Aggregate(query,
(current, expressionSelect) => current.Where(expressionSelect));
}
var applyPaging = criteria.PageSize > 0;
//Apply sorting
if ((criteria.ExpressionSort != null) && (criteria.ExpressionSort.Any()))
{
IOrderedQueryable <TEntity> sortedQuery = null;
foreach (var expressionSort in criteria.ExpressionSort)
{
if (sortedQuery == null)
{
sortedQuery = criteria.Sort == SortDirection.Ascending ? query.OrderBy(expressionSort) : query.OrderByDescending(expressionSort);
}
else
{
sortedQuery = criteria.Sort == SortDirection.Ascending ? sortedQuery.ThenBy(expressionSort) : sortedQuery.ThenByDescending(expressionSort);
}
}
query = sortedQuery;
}
else
{
if (applyPaging)
{
query = query.OrderBy(e => 1);
}
}
// apply distinct
if (query != null && criteria.IsDistinct)
{
query = query.Distinct();
}
if (query != null)
{
var totalCount = query.Count();
if (applyPaging)
{
query = query.Skip((criteria.PageIndex - 1) * criteria.PageSize).Take(criteria.PageSize);
}
res = new PagerList <TEntity>(query.ToList(), totalCount, criteria.PageIndex, criteria.PageSize);
}
}
return(res);
}
private void Get18K6CSelectCriteria(int radioHandle, SelectCriteria selectCriteria)
{
Result result = link.Get18K6CSelectCriteria(radioHandle, selectCriteria);
logger.Information("link.Get18K6CSelectCriteria => {Result}", result);
}
public ConfigureSelect_Display( SelectCriteria criteria )
: this()
{
this.setSource( criteria );
}
public void setSource( SelectCriteria criteria )
{
this.selectCriteria = criteria;
// to trigger redraw etc. events... wont occur if values
// are actually equal...
if ( this.activeCriteria.Value == criteria.countCriteria )
{
activeCriteria_ValueChanged( null, null );
}
else
{
this.activeCriteria.Value = criteria.countCriteria;
}
}
