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(""); }
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; } } } }