protected void cbo_UnitDim_ItemRequestedByValue(object source, DevExpress.Web.ASPxEditors.ListEditItemRequestedByValueEventArgs e)
{
UnitDim obj = session.GetObjectByKey <UnitDim>(e.Value);
if (obj != null)
{
cbo_UnitDim.DataSource = new UnitDim[] { obj };
cbo_UnitDim.DataBindItems();
}
}
protected void cbCars_ItemRequestedByValue(object source, DevExpress.Web.ASPxEditors.ListEditItemRequestedByValueEventArgs e)
{
if (e.Value != null && e.Value is int)
{
var data = MyDataSource.GetData(cbLocation.Text);
var query = from r in data where r.Value == (int)e.Value select r;
cbCars.DataSource = query;
cbCars.DataBind();
}
}
protected void cboInventory_ItemRequestedByValue(object source, DevExpress.Web.ASPxEditors.ListEditItemRequestedByValueEventArgs e)
{
Inventory obj = session.GetObjectByKey <Inventory>(e.Value);
if (obj != null)
{
cboInventory.DataSource = new Inventory[] { obj };
cboInventory.DataBindItems();
}
}
protected void cboAccount_ItemRequestedByValue(object source, DevExpress.Web.ASPxEditors.ListEditItemRequestedByValueEventArgs e)
{
Account obj = session.GetObjectByKey <Account>(e.Value);
if (obj != null)
{
cboAccount.DataSource = new Account[] { obj };
cboAccount.DataBindItems();
}
}
protected void dxcbocompany_ItemRequestedByValue(object source, DevExpress.Web.ASPxEditors.ListEditItemRequestedByValueEventArgs e)
{
DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source;
//use datareaders - much faster than loading into collections
string[] _cols = { "NameAndAddressBook.CompanyID, NameAndAddressBook.CompanyName, NameAndAddressBook.Customer" };
Int32 _id = wwi_func.vint(e.Value.ToString());
SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.NameAndAddressBook).WhereExpression("CompanyID").IsEqualTo(_id);
IDataReader _rd = _query.ExecuteReader();
_combo.DataSource = _rd;
_combo.ValueField = "CompanyID";
_combo.TextField = "CompanyName";
_combo.DataBind();
}
protected void dxcbotitle_ItemRequestedByValue(object source, DevExpress.Web.ASPxEditors.ListEditItemRequestedByValueEventArgs e)
{
DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source;
int _printerid = wwi_func.vint(this.dxlblprinter2.Text.ToString());
//use datareaders - much faster than loading into collections
string[] _cols = { "PublishipAdvanceTitleTable.PATitleID, PublishipAdvanceTitleTable.Title, PublishipAdvanceOrderTable.PrinterID" };
Int32 _id = wwi_func.vint(e.Value.ToString());
SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.PublishipAdvanceOrderTable).LeftOuterJoin("PublishipAdvanceTitleTable", "PAOrderID", "PublishipAdvanceOrderTable", "OrderID").WhereExpression("PATitleID").IsEqualTo(_id).And("PrinterId").IsEqualTo(_printerid);
IDataReader _rd = _query.ExecuteReader();
_combo.DataSource = _rd;
_combo.ValueField = "PATitleID";
_combo.TextField = "Title";
_combo.DataBind();
}
//container search
protected void dxcboContainer_ItemRequestedByValue(object source, DevExpress.Web.ASPxEditors.ListEditItemRequestedByValueEventArgs e)
{
DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source;
Int32 _id = 0;
if (e.Value != null)
{
_id = wwi_func.vint(e.Value.ToString());
}
//use datareaders - much faster than loading into collections
string[] _cols = { "ContainerSubID", "ContainerNumber" };
SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Views.PearsonRugbyContainerView).WhereExpression("ContainerSubID").IsEqualTo(_id);
IDataReader _rd = _query.ExecuteReader();
_combo.DataSource = _rd;
_combo.ValueField = "ContainerSubID";
_combo.TextField = "ContainerNumber";
_combo.DataBindItems();
}
protected void dxcbocompany_ItemRequestedByValue(object source, DevExpress.Web.ASPxEditors.ListEditItemRequestedByValueEventArgs e)
{
DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source;
//use datareaders - much faster than loading into collections
string[] _cols = { "NameAndAddressBook.CompanyID, NameAndAddressBook.CompanyName, NameAndAddressBook.Customer" };
Int32 _id = wwi_func.vint(e.Value.ToString());
SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.NameAndAddressBook).WhereExpression("CompanyID").IsEqualTo(_id);
IDataReader _rd = _query.ExecuteReader();
_combo.DataSource = _rd;
_combo.ValueField = "CompanyID";
_combo.TextField = "CompanyName";
_combo.DataBind();
//this.sdsCompany.ConnectionString = ConfigurationManager.ConnectionStrings["PublishipSQLConnectionString"].ToString();
//this.sdsCompany.SelectCommand = @"SELECT [CompanyID], [CompanyName], [Customer] FROM [NNameAndAddressBook] WHERE (CompanyID = @ID)";
//this.sdsCompany.SelectParameters.Clear();
//this.sdsCompany.SelectParameters.Add("ID", TypeCode.Int32, e.Value.ToString());
//_combo.DataSource = this.sdsCompany;
//_combo.DataBind();
}
public abstract void ItemRequestedByValue(Session session,
object source,
DevExpress.Web.ASPxEditors.ListEditItemRequestedByValueEventArgs e);
protected void cboBuiltInSingleSelectionList_ItemRequestedByValue(object source, DevExpress.Web.ASPxEditors.ListEditItemRequestedByValueEventArgs e)
{
NASCustomFieldTypeBuiltInSingleSelectionListStrategy.ItemRequestedByValue(session, source, e);
}
