private bool IsCommonValueForAllSelectedRows(DevExpress.Web.ASPxGridView.GridViewDataColumn column, object value)
{
//Determine whether the passed value is common for all rows within the specified column
bool res = true;
List <object> selectedRowValues = ASPxGridView1.GetSelectedFieldValues(column.FieldName);
for (int i = 0; i < selectedRowValues.Count; i++)
{
if (selectedRowValues[i].ToString() != value.ToString())
{
res = false;
break;
}
}
return(res);
}
public string GetFieldName(ASPxGridView ASPxGridView1, string fieldID)
{
for (int j = 1; j < ASPxGridView1.Columns.Count; j++)
{
if (ASPxGridView1.Columns[j].GetType().UnderlyingSystemType.FullName == "DevExpress.Web.ASPxGridView.GridViewDataTextColumn")
{
DevExpress.Web.ASPxGridView.GridViewDataTextColumn datacolumn = (DevExpress.Web.ASPxGridView.GridViewDataTextColumn)ASPxGridView1.Columns[j];
string field = datacolumn.FieldName;
if (field == fieldID)
{
return(datacolumn.Caption);
}
}
else if (ASPxGridView1.Columns[j].GetType().UnderlyingSystemType.FullName == "DevExpress.Web.ASPxGridView.GridViewDataColumn")
{
DevExpress.Web.ASPxGridView.GridViewDataColumn datacolumn = (DevExpress.Web.ASPxGridView.GridViewDataColumn)ASPxGridView1.Columns[j];
string field = datacolumn.FieldName;
if (field == fieldID)
{
return(datacolumn.Caption);
}
}
else if (ASPxGridView1.Columns[j].GetType().UnderlyingSystemType.FullName == "DevExpress.Web.ASPxGridView.GridViewDataComboBoxColumn")
{
DevExpress.Web.ASPxGridView.GridViewDataComboBoxColumn datacolumn = (DevExpress.Web.ASPxGridView.GridViewDataComboBoxColumn)ASPxGridView1.Columns[j];
string field = datacolumn.FieldName;
if (field == fieldID)
{
return(datacolumn.Caption);
}
}
else if (ASPxGridView1.Columns[j].GetType().UnderlyingSystemType.FullName == "DevExpress.Web.ASPxGridView.GridViewDataDateColumn")
{
DevExpress.Web.ASPxGridView.GridViewDataDateColumn datacolumn = (DevExpress.Web.ASPxGridView.GridViewDataDateColumn)ASPxGridView1.Columns[j];
string field = datacolumn.FieldName;
if (field == fieldID)
{
return(datacolumn.Caption);
}
}
}
return("");
}
//end incremental filtering of company name
/// <summary>
/// row created show break pod link button if quote is linked to pod
/// button clientviasible=false by default
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gridviewPrices1_HtmlRowCreated(object sender, ASPxGridViewTableRowEventArgs e)
{
if (e.RowType == DevExpress.Web.ASPxGridView.GridViewRowType.Data)
{
DevExpress.Web.ASPxGridView.ASPxGridView _grid = (DevExpress.Web.ASPxGridView.ASPxGridView)sender;
Int32 _onKey = e.GetValue("order_no") != null?wwi_func.vint(e.GetValue("order_no").ToString()) : 0;
if (_onKey > 0)
{
//find template controls
DevExpress.Web.ASPxGridView.GridViewDataColumn _col1 = (DevExpress.Web.ASPxGridView.GridViewDataColumn)_grid.Columns["colorderno"];
DevExpress.Web.ASPxEditors.ASPxButton _btn = (DevExpress.Web.ASPxEditors.ASPxButton)_grid.FindRowCellTemplateControl(e.VisibleIndex, _col1, "dxbtnbreak");
//var _chk = (DevExpress.Web.ASPxGridView.Rendering.GridViewTableCommandCell)e.Row.Cells[0];
//and pass data from hidden field if it's stored - make sure text box is ticked
if (_btn != null)
{
_btn.ClientVisible = true;
}
}
}
}
public void GetTitle(ASPxGridView ASPxGridView1, string tablename)
{
PublicClass pc = new PublicClass();
string ctext = pc.GetLanguageColumn();
sSQL = "select * from _TableColInfo where TABLE_NAME in ('" + tablename + "')";
DataTable dt = clsSQLCommond.ExecQuery(sSQL);
for (int j = 0; j < ASPxGridView1.Columns.Count; j++)
{
if (ASPxGridView1.Columns[j].GetType().UnderlyingSystemType.FullName == "DevExpress.Web.ASPxGridView.GridViewDataTextColumn")
{
DevExpress.Web.ASPxGridView.GridViewDataTextColumn datacolumn = (DevExpress.Web.ASPxGridView.GridViewDataTextColumn)ASPxGridView1.Columns[j];
string field = datacolumn.FieldName;
DataRow[] dw = dt.Select("COLUMN_NAME='" + field + "'");
if (dw.Length == 0)
{
}
else if (dw.Length > 0 && dw[0][ctext].ToString() != "")
{
string caption = dw[0][ctext].ToString();
datacolumn.Caption = caption;
if (dw[0]["VisibleIndex"].ToString() != "")
{
//datacolumn.VisibleIndex = int.Parse(dw[0]["VisibleIndex"].ToString());
}
}
else
{
//datacolumn.Visible = false;
}
}
else if (ASPxGridView1.Columns[j].GetType().UnderlyingSystemType.FullName == "DevExpress.Web.ASPxGridView.GridViewDataColumn")
{
DevExpress.Web.ASPxGridView.GridViewDataColumn datacolumn = (DevExpress.Web.ASPxGridView.GridViewDataColumn)ASPxGridView1.Columns[j];
string field = datacolumn.FieldName;
DataRow[] dw = dt.Select("COLUMN_NAME='" + field + "'");
if (dw.Length == 0)
{
}
else if (dw.Length > 0 && dw[0][ctext].ToString() != "")
{
string caption = dw[0][ctext].ToString();
datacolumn.Caption = caption;
if (dw[0]["VisibleIndex"].ToString() != "")
{
//datacolumn.VisibleIndex = int.Parse(dw[0]["VisibleIndex"].ToString());
}
}
else
{
//datacolumn.Visible = false;
}
}
else if (ASPxGridView1.Columns[j].GetType().UnderlyingSystemType.FullName == "DevExpress.Web.ASPxGridView.GridViewDataDateColumn")
{
DevExpress.Web.ASPxGridView.GridViewDataDateColumn datacolumn = (DevExpress.Web.ASPxGridView.GridViewDataDateColumn)ASPxGridView1.Columns[j];
string field = datacolumn.FieldName;
DataRow[] dw = dt.Select("COLUMN_NAME='" + field + "'");
if (dw.Length == 0)
{
}
else if (dw.Length > 0 && dw[0][ctext].ToString() != "")
{
string caption = dw[0][ctext].ToString();
datacolumn.Caption = caption;
if (dw[0]["VisibleIndex"].ToString() != "")
{
//datacolumn.VisibleIndex = int.Parse(dw[0]["VisibleIndex"].ToString());
}
}
else
{
//datacolumn.Visible = false;
}
}
else if (ASPxGridView1.Columns[j].GetType().UnderlyingSystemType.FullName == "DevExpress.Web.ASPxGridView.GridViewDataComboBoxColumn")
{
DevExpress.Web.ASPxGridView.GridViewDataComboBoxColumn datacolumn = (DevExpress.Web.ASPxGridView.GridViewDataComboBoxColumn)ASPxGridView1.Columns[j];
string field = datacolumn.FieldName;
DataRow[] dw = dt.Select("COLUMN_NAME='" + field + "'");
if (dw.Length == 0)
{
}
else if (dw.Length > 0 && dw[0][ctext].ToString() != "")
{
string caption = dw[0][ctext].ToString();
datacolumn.Caption = caption;
if (dw[0]["VisibleIndex"].ToString() != "")
{
//datacolumn.VisibleIndex = int.Parse(dw[0]["VisibleIndex"].ToString());
}
}
else
{
//datacolumn.Visible = false;
}
}
else if (ASPxGridView1.Columns[j].GetType().UnderlyingSystemType.FullName == "DevExpress.Web.ASPxGridView.GridViewDataSpinEditColumn")
{
DevExpress.Web.ASPxGridView.GridViewDataSpinEditColumn datacolumn = (DevExpress.Web.ASPxGridView.GridViewDataSpinEditColumn)ASPxGridView1.Columns[j];
string field = datacolumn.FieldName;
DataRow[] dw = dt.Select("COLUMN_NAME='" + field + "'");
if (dw.Length == 0)
{
}
else if (dw.Length > 0 && dw[0][ctext].ToString() != "")
{
string caption = dw[0][ctext].ToString();
datacolumn.Caption = caption;
if (dw[0]["VisibleIndex"].ToString() != "")
{
//datacolumn.VisibleIndex = int.Parse(dw[0]["VisibleIndex"].ToString());
}
}
else
{
//datacolumn.Visible = false;
}
}
}
}
