private void LoadRows()
{
if (this.Query != null)
{
this.Grid.NoRows = this.Query.Store.Count();
for (int i = 0; i < this.Grid.NoRows; i++)
{
Model.Item item = this.Query.Store[i];
int j = 0;
foreach (Model.PropertyType proptype in this.Query.Store.ItemType.SearchPropertyTypes)
{
Model.Property property = item.Property(proptype);
this.Grid.Rows[i].Cells[j].Binding = property;
j++;
}
}
}
else
{
// Clear all Rows
this.Grid.NoRows = 0;
}
}
static void Main(string[] args)
{
Server server = new Server("http://localhost/InnovatorServer100SP4");
Database database = server.Database("CMB");
Session session = database.Login("admin", IO.Server.PasswordHash("innovator"));
Query query = session.Query("v_Order");
query.Select = "part";
query.Property("part").Select = "item_number,name,cmb_name,description,major_rev,keyed_name,state,cmb_ibs_transfer_lock,cmb_ibs_commodity_code,cmb_ibs_eng_order_no,cmb_ibs_field19,cmb_ibs_lead_time,cmb_ibs_mat_move_code,cmb_ibs_part_type,cmb_ibs_planner_code,cmb_ibs_product_code,cmb_ibs_product_group,cmb_name_no_cr,make_buy,unit";
Model.Item order = query.Store.Get("7BDC68F4B7BB49F8BC124E56246939BC");
Model.Item part = (Model.Item)order.Property("part").Value;
}
