//end bind combos
protected void dxcbocountry_Init(object sender, EventArgs e)
{
DevExpress.Web.ASPxEditors.ASPxComboBox _cbo = (DevExpress.Web.ASPxEditors.ASPxComboBox)sender;
try
{
string _path = AppDomain.CurrentDomain.BaseDirectory;
_path += "xml\\country_iso.xml";
// pass _qryFilter to have keyword-filter RSS Feed
// i.e. _qryFilter = XML -> entries with XML will be returned
DataSet _ds = new DataSet();
_ds.ReadXml(_path);
DataView _dv = _ds.Tables[0].DefaultView;
//_dv.RowFilter = "ddls ='pallet'";
_cbo.DataSource = _dv;
_cbo.DataBind();
_cbo.Value = null;
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
/// <summary>
/// incremental filtering and partial loading of name and address book for speed
/// both ItemsRequestedByFilterCondition and ItemRequestedByValue must be set up for this to work
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void dxcbocompany_ItemsRequestedByFilterCondition(object source, DevExpress.Web.ASPxEditors.ListEditItemsRequestedByFilterConditionEventArgs e)
{
DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source;
string _filter = !string.IsNullOrEmpty(e.Filter) ? e.Filter: "";
{
//use datareaders - much faster than loading into collections
string[] _cols = { "NameAndAddressBook.CompanyID, NameAndAddressBook.CompanyName, NameAndAddressBook.Customer" };
//SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.NameAndAddressBook).Paged(e.BeginIndex + 1, e.EndIndex +1, "CompanyID").WhereExpression("CompanyName").Like(string.Format("%{0}%", e.Filter.ToString())).And("Customer").IsEqualTo(true) ;
SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.NameAndAddressBook).Paged(e.BeginIndex + 1, e.EndIndex + 1, "CompanyID").WhereExpression("CompanyName").Like(string.Format("%{0}%", e.Filter.ToString()));
IDataReader _rd = _query.ExecuteReader();
_combo.DataSource = _rd;
_combo.ValueField = "CompanyID";
_combo.TextField = "CompanyName";
_combo.DataBind();
//use sqldatasource
//this.sdsCompany.ConnectionString = ConfigurationManager.ConnectionStrings["PublishipSQLConnectionString"].ToString();
//this.sdsCompany.SelectCommand = @"SELECT [CompanyID], [CompanyName], [Customer] FROM (select [CompanyID], [CompanyName], [Customer], row_number()over(order by t.[CompanyName]) as [rn] from [NameAndAddressBook] as t where (([CompanyName]) LIKE @filter)) as st where st.[rn] between @startIndex and @endIndex;";
//this.sdsCompany.SelectParameters.Clear();
//this.sdsCompany.SelectParameters.Add("filter", TypeCode.String, string.Format("%{0}%", _filter));
//this.sdsCompany.SelectParameters.Add("startindex", TypeCode.Int32, (e.BeginIndex + 1).ToString());
//this.sdsCompany.SelectParameters.Add("endindex", TypeCode.Int32, (e.EndIndex + 1).ToString());
//_combo.DataSource = this.sdsCompany;
//_combo.DataBind();
}
}
protected void BindAspxDdl(DevExpress.Web.ASPxEditors.ASPxComboBox ddl, string column, string regex, string txtField, string valField)
{
ddl.DataSource = dept.GetTreeList(column, regex);
ddl.TextField = txtField;
ddl.ValueField = valField;
ddl.DataBind();
}
protected void BindAspxDdl(DevExpress.Web.ASPxEditors.ASPxComboBox ddl, string where, string txtField, string valField)
{
ddl.DataSource = dept.GetList2(where);
ddl.TextField = txtField;
ddl.ValueField = valField;
ddl.DataBind();
}
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();
}
//end send advance email
#endregion
#region company filters
/// <summary>
/// incremental filtering and partial loading of name and address book for speed
/// both ItemsRequestedByFilterCondition and ItemRequestedByValue must be set up for this to work
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void dxcbocompany_ItemsRequestedByFilterCondition(object source, DevExpress.Web.ASPxEditors.ListEditItemsRequestedByFilterConditionEventArgs e)
{
DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source;
string _filter = !string.IsNullOrEmpty(e.Filter) ? e.Filter : "";
{
//use datareaders - much faster than loading into collections
string[] _cols = { "NameAndAddressBook.CompanyID, NameAndAddressBook.CompanyName, NameAndAddressBook.Customer" };
//SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.NameAndAddressBook).Paged(e.BeginIndex + 1, e.EndIndex +1, "CompanyID").WhereExpression("CompanyName").Like(string.Format("%{0}%", e.Filter.ToString())).And("Customer").IsEqualTo(true) ;
SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.NameAndAddressBook).Paged(e.BeginIndex + 1, e.EndIndex + 1, "CompanyID").WhereExpression("CompanyName").Like(string.Format("%{0}%", e.Filter.ToString()));
IDataReader _rd = _query.ExecuteReader();
_combo.DataSource = _rd;
_combo.ValueField = "CompanyID";
_combo.TextField = "CompanyName";
_combo.DataBind();
}
}
//end pdf
#endregion
#region incremental filtering for previous titles
/// <summary>
/// incremental filtering and partial loading of name and address book for speed
/// both ItemsRequestedByFilterCondition and ItemRequestedByValue must be set up for this to work
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void dxcbotitle_ItemsRequestedByFilterCondition(object source, DevExpress.Web.ASPxEditors.ListEditItemsRequestedByFilterConditionEventArgs e)
{
//restricted to logged in user
DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source;
int _printerid = wwi_func.vint(this.dxlblprinter2.Text.ToString());
string _filter = !string.IsNullOrEmpty(e.Filter) ? e.Filter : "";
{
//use datareaders - much faster than loading into collections
string[] _cols = { "PublishipAdvanceTitleTable.PATitleID, PublishipAdvanceTitleTable.Title, PublishipAdvanceOrderTable.PrinterID" };
//string[] _cols = { "PublishipAdvanceTitleTable.PATitleID, PublishipAdvanceTitleTable.Title" };
SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.PublishipAdvanceOrderTable).LeftOuterJoin("PublishipAdvanceTitleTable", "PAOrderID", "PublishipAdvanceOrderTable", "OrderID").Paged(e.BeginIndex + 1, e.EndIndex + 1, "PATitleID").WhereExpression("Title").Like(string.Format("%{0}%", e.Filter.ToString())).And("PrinterId").IsEqualTo(_printerid);
//SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.PublishipAdvanceTitleTable).Paged(e.BeginIndex + 1, e.EndIndex + 1, "PATitleID").WhereExpression("Title").Like(string.Format("%{0}%", e.Filter.ToString()));
IDataReader _rd = _query.ExecuteReader();
_combo.DataSource = _rd;
_combo.ValueField = "PATitleID";
_combo.TextField = "Title";
_combo.DataBind();
}
}
//******************************
/// <summary>
/// disable auto populated fields on edit
/// hide auto populated fields on new
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void dxgrdTarget_CellEditorInitialize(object sender, ASPxGridViewEditorEventArgs e)
{
if (e.Column.Name == "colTargetID" || e.Column.Name == "colUpdateUser" || e.Column.Name == "colInsertUser")
{
DevExpress.Web.ASPxEditors.ASPxTextBox _tx = ((DevExpress.Web.ASPxEditors.ASPxTextBox)e.Editor);
if (e.Column.Grid.IsNewRowEditing)
{
_tx.ClientVisible = false;
}
else if (e.Column.Grid.IsEditing)
{
_tx.ClientEnabled = false;
}
}
//end text columns
if (e.Column.Name == "colInsertDate" || e.Column.Name == "colUpdateDate")
{
DevExpress.Web.ASPxEditors.ASPxDateEdit _dx = ((DevExpress.Web.ASPxEditors.ASPxDateEdit)e.Editor);
if (e.Column.Grid.IsNewRowEditing)
{
_dx.ClientVisible = false;
}
else if (e.Column.Grid.IsEditing)
{
_dx.ClientEnabled = false;
}
}
//290113 bind priority codes
if (e.Column.Name == "colPriorityCode")
{
DevExpress.Web.ASPxEditors.ASPxComboBox _cb = ((DevExpress.Web.ASPxEditors.ASPxComboBox)e.Editor);
_cb.DataBind();
}
}
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();
}
