private void OnLoad(object sender, RoutedEventArgs e)
{
bool CRUDButtonVisibility = true;
if (null != this.relatedControl)
{
GridViewDataColumn textColumn;
IList<SchemaInfo> columns = this.relatedControl.DataSource.Schemas.ToList();
SchemaInfo schema;
int j = 1;
string[] captions = this.relatedControl.ParentDisplayCaptions.Split(',');
for (; j < columns.Count; ++j)
{
schema = columns[j];
if (!schema.IsKey)
{
textColumn = new GridViewDataColumn();
textColumn.DataMemberBinding = new Binding(schema.ColumnName);
textColumn.Header = captions[j - 1];
//textColumn.IsReadOnly = true;
textColumn.SortMemberPath = schema.ColumnName;
this.comboBoxGrid.Columns.Add(textColumn);
}
}
this.comboBoxGrid.Columns[j - 2].Width = new GridViewLength(1, GridViewLengthUnitType.Star);
this.txtSearch.Focus();
}
else
{
this.btnSelect.SetVisible(false);
CRUDButtonVisibility = false;
}
this.SetCRUDButtonVisibility(CRUDButtonVisibility);
}
public void UpdateGridCols(IList <GridColumn> gridCols)
{
GridViewDataColumn newCol = null;
if (this.gridView.Columns.Count != 0)
{
return;
}
foreach (GridColumn col in gridCols)
{
if (col.IsComboBox)
{
this.gridView.Columns.Add(this.CreateComboBoxGridColumn(col));
continue;
}
if (col.IsCheckBox)
{
this.gridView.Columns.Add(this.CreateCheckBoxGridColumn(col));
continue;
}
this.gridView.Columns.Add(this.CreateTextGridColumn(col));
}
}
protected void DDLDiagnosis_SelectedIndexChanged(object sender, EventArgs e)
{
lblmsg.Visible = false;
string selected_item = DDLDiagnosis.SelectedItem.Value.ToString();
Bill_Sys_Settings obj = new Bill_Sys_Settings();
DataSet ds = new DataSet();
ds = obj.GetDoctorNotes(selected_item, Company_id);
grdDoctorNotes.DataSource = ds;
grdDoctorNotes.DataBind();
for (int i = 0; i < grdDoctorNotes.VisibleRowCount; i++)
{
string speciality = selected_item;
//string speciality = obj.GetSpeciality(selected_item, Company_id);
GridViewDataColumn c = (GridViewDataColumn)grdDoctorNotes.Columns[0];
CheckBox checkBox = (CheckBox)grdDoctorNotes.FindRowCellTemplateControl(i, c, "chkall");
if ((ds.Tables[0].Rows[i]["i_mst_mandatory_id"].ToString() != "") && (ds.Tables[0].Rows[i]["sz_specialty_id"].ToString() == speciality))
{
checkBox.Checked = true;
}
}
if (grdDoctorNotes.VisibleRowCount == 0)
{
lblmsg.Visible = true;
lblmsg.Text = "No record found";
}
}
protected void grdBookingDetail_CellEditorInitialize(object sender, ASPxGridViewEditorEventArgs e)
{
if (e.Column.FieldName == "RowStatus")
{
e.Editor.Value = 1;
GridViewDataColumn col1 = ((ASPxGridView)sender).Columns["Credit"] as GridViewDataColumn;
ASPxSpinEdit spin1 = ((ASPxGridView)sender).FindEditRowCellTemplateControl(col1, "colBookingDetailCredit") as ASPxSpinEdit;
spin1.Value = 0;
GridViewDataColumn col2 = ((ASPxGridView)sender).Columns["Debit"] as GridViewDataColumn;
ASPxSpinEdit spin2 = ((ASPxGridView)sender).FindEditRowCellTemplateControl(col2, "colBookingDetailDebit") as ASPxSpinEdit;
spin1.Value = 0;
}
if (e.Column.FieldName == "AccountId!Key")
{
ASPxComboBox combo = (ASPxComboBox)e.Editor;
//combo.ItemsRequestedByFilterCondition += new ListEditItemsRequestedByFilterConditionEventHandler(AccountItemsRequestedByFilterCondition);
//combo.ItemRequestedByValue += new ListEditItemRequestedByValueEventHandler(AccountItemRequestedByValue);
ASPxComboBox accountCombobox = e.Editor as ASPxComboBox;
accountCombobox.TextField = "Code";
accountCombobox.DataSource = AccountingBO.getNotParentAccountList(session);
accountCombobox.DataBind();
e.Editor.Focus();
}
}
protected void GridViewDC_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
ASPxGridView gridView = (ASPxGridView)sender;
gridView.UpdateEdit();
string[] data = e.Parameters.Split(new char[] { '|' });
gridView.FocusedRowIndex = Convert.ToInt32(data[0]);
for (int i = 0; i < gridView.Columns.Count; i++)
{
GridViewDataColumn column = (GridViewDataColumn)gridView.Columns[i];
if (column != null)
{
if (column.FieldName != data[1])
{
column.EditItemTemplate = new MyTemplate();
}
else
{
Session["column"] = column.FieldName;
column.EditItemTemplate = null;
}
}
}
gridView.StartEdit(Convert.ToInt32(data[0]));
}
void Find(ASPxGridView gridView, string text, int rowIndex, int colIndex)
{
ReadOnlyCollection <GridViewDataColumn> groupedColumns = gridView.GetGroupedColumns();
for (int row = rowIndex; row < gridView.VisibleRowCount; row++)
{
for (int col = (row == rowIndex) ? colIndex : 0; col < gridView.Columns.Count; col++)
{
GridViewDataColumn dataColumn = gridView.Columns[col] as GridViewDataColumn;
if (dataColumn != null && dataColumn.Visible)
{
object cellValue = gridView.GetRowValues(row, dataColumn.FieldName);
if (cellValue != null && cellValue.ToString().Contains(text))
{
if ((gridView.GetRowLevel(row) == groupedColumns.Count && !groupedColumns.Contains(dataColumn)) || //Is data row cell
(gridView.IsGroupRow(row) && gridView.GetRowLevel(row) == dataColumn.GroupIndex)) //Is group row of the current dataColumn
{
gridView.MakeRowVisible(gridView.GetRowValues(row, gridView.KeyFieldName));
gridView.JSProperties["cpFindText"] = text;
gridView.JSProperties["cpFindPositionRow"] = row;
gridView.JSProperties["cpFindPositionColumn"] = col + 1;
gridView.JSProperties["cpFindSomehting"] = true;
return;
}
}
}
}
}
gridView.JSProperties["cpFindPositionRow"] = 0;
gridView.JSProperties["cpFindPositionColumn"] = 0;
gridView.JSProperties["cpFindSomehting"] = false;
}
public void SaveProcedureDiagnosisCode()
{
string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url);
using (Utils utility = new Utils())
{
utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod());
}
Bil_Sys_Associate_Diagnosis _dianosis_Association = new Bil_Sys_Associate_Diagnosis();
_dianosis_Association = (Bil_Sys_Associate_Diagnosis)Session["DIAGNOS_ASSOCIATION"];
Bill_Sys_AssociateDiagnosisCodeBO _associateDiagnosisCodeBO = new Bill_Sys_AssociateDiagnosisCodeBO();
DataSet _billDs = new DataSet();
ArrayList _arrayList;
try
{
string szDiagnosisCode = "";
for (int i = 0; i < grdDiagnosisCode.VisibleRowCount; i++)
{
ASPxGridView _ASPxGridView = (ASPxGridView)grdid.FindControl("grdDiagnosisCode");
GridViewDataColumn c = (GridViewDataColumn)grdDiagnosisCode.Columns[0];
CheckBox checkBox = (CheckBox)grdDiagnosisCode.FindRowCellTemplateControl(i, c, "chkall");
if (checkBox != null)
{
if (checkBox.Checked)
{
_arrayList = new ArrayList();
_arrayList.Add(txtEventProcID.Text);
_arrayList.Add(txtCaseID.Text);
_arrayList.Add(txtEventID.Text);
szDiagnosisCode = Convert.ToString(grdDiagnosisCode.GetRowValues(i, "SZ_DIAGNOSIS_CODE_ID"));
_arrayList.Add(szDiagnosisCode);
_arrayList.Add(extddlSpecialityDia.Text);
_arrayList.Add(txtCompanyID.Text);
_arrayList.Add("");
_associateDiagnosisCodeBO.SaveProcedureAssociateDignosisCode(_arrayList);
}
}
}
GetAssignedProcedureDiagnosisCode(txtCaseID.Text, txtCompanyID.Text, txtEventProcID.Text, "GET_PROCEDURE_ASSOCIATED_DIAGNOSIS_CODE");
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
using (Utils utility = new Utils())
{
utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
}
string str2 = "Error Request=" + id + ".Please share with Technical support.";
base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2);
}
//Method End
using (Utils utility = new Utils())
{
utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Session["UserName"] == null)
{
Response.Redirect("~/login.aspx");
}
if (!IsPostBack)
{
btnClear_Click(btnClear, EventArgs.Empty);
ResetDCItemsDataSet();
LoadGrid(ddDCNumber.Text, ddPONumber.Text, this.Session["DealerCode"].ToString());
}
ddPONumber.Text = this.Session["PONumber"].ToString();
if (ddDCNumber.Text == "")
{
ddDCNumber.Text = this.Session["DCNumber"].ToString();
}
//GridViewDC.SettingsEditing.BatchEditSettings.EditMode = (GridViewBatchEditMode)Enum.Parse(typeof(GridViewBatchEditMode), "Cell", true);
//GridViewDC.SettingsEditing.BatchEditSettings.StartEditAction = (GridViewBatchStartEditAction)Enum.Parse(typeof(GridViewBatchStartEditAction), "Click", true);
if (GridViewDC.IsEditing && Session["column"] != null)
{
string fieldName = Convert.ToString(Session["column"]);
for (int i = 0; i < GridViewDC.Columns.Count; i++)
{
GridViewDataColumn column = (GridViewDataColumn)GridViewDC.Columns[i];
if (column != null && column.FieldName != fieldName)
{
column.EditItemTemplate = new MyTemplate();
}
}
}
}
static GridViewDataControl ToPrintFriendlyGrid(GridViewDataControl source)
{
var grid = new RadGridView()
{
ItemsSource = source.ItemsSource,
RowIndicatorVisibility = Visibility.Collapsed,
ShowGroupPanel = false,
CanUserFreezeColumns = false,
IsFilteringAllowed = false,
AutoExpandGroups = true,
AutoGenerateColumns = false
};
foreach (var column in source.Columns.OfType <GridViewDataColumn>())
{
var newColumn = new GridViewDataColumn();
newColumn.DataMemberBinding = new System.Windows.Data.Binding(column.UniqueName);
grid.Columns.Add(newColumn);
}
StyleManager.SetTheme(grid, StyleManager.GetTheme(grid));
grid.SortDescriptors.AddRange(source.SortDescriptors);
grid.GroupDescriptors.AddRange(source.GroupDescriptors);
grid.FilterDescriptors.AddRange(source.FilterDescriptors);
return(grid);
}
protected void Page_Load(object sender, EventArgs e)
{
list = new Record[ASPxGridView1.SettingsPager.PageSize];
for (int i = 0; i < ASPxGridView1.SettingsPager.PageSize; i++)
{
list[i].id = -1;
int vi = ASPxGridView1.VisibleStartIndex + i;
ASPxTextBox txtBox1 = (ASPxTextBox)ASPxGridView1.FindRowCellTemplateControl(vi, (GridViewDataColumn)ASPxGridView1.Columns["Num"], "txtBox");
if (txtBox1 == null)
{
continue;
}
try
{
StringBuilder sb = new StringBuilder();
for (int j = 0; j < Codes.Length; j++)
{
string code = Codes.Substring(j, 1);
GridViewDataColumn col = (GridViewDataColumn)ASPxGridView1.Columns[code];
ASPxComboBox cbx = (ASPxComboBox)ASPxGridView1.FindRowCellTemplateControl(vi, col, "cbx_" + code);
if (Convert.ToBoolean(cbx.Value))
{
sb.Append(code);
}
}
list[i].id = Convert.ToInt32(ASPxGridView1.GetRowValues(vi, ASPxGridView1.KeyFieldName));
list[i].num = Convert.ToInt32(txtBox1.Text);
list[i].code = sb.ToString();
}
catch { }
}
BindGridToData(ASPxGridView1);
ASPxGridView1.JSProperties["cpCodes"] = Codes;
}
protected override bool OnLoad(object sender, EventArgs e)
{
if (masterGrid != null)
{
//configure column wrapping
for (int i = 0; i < masterGrid.Columns.Count; i++)
{
GridViewDataColumn col = masterGrid.Columns[i] as GridViewDataColumn;
if (col == null)
{
continue;
}
if (col.Name == "OldCode")
{
col.CellStyle.BorderRight.BorderColor = System.Drawing.Color.Black;
col.CellStyle.BorderRight.BorderWidth = new Unit("2px");
col.CellStyle.Wrap = DevExpress.Utils.DefaultBoolean.True;
col.CellStyle.CssClass = "wrapText";
}
else if (col.Name == "NewCode")
{
col.CellStyle.Wrap = DevExpress.Utils.DefaultBoolean.True;
col.CellStyle.CssClass = "wrapText";
}
else if (col.Name == "ModelId" || col.Name == "VariantId" || col.Name == "PackingMonth")
{
col.Visible = false;
}
}
}
return(true);
}
private void ValidarCelda(GridViewDataColumn Column, CellValidatingEventArgs e)
{
try
{
/* validacion en edicion de registro */
Int16 _Col = 10;
e.Row.ErrorText = string.Empty;
GridViewDataColumn column = e.Column as GridViewDataColumn;
var cell = e.Row.Cells[e.ColumnIndex];
if (e.Row is GridViewDataRowInfo)
{
switch (column.Index)
{
case 10: /* Pago */
if (((Decimal)e.Value) == 0)
{
e.Row.ErrorText = "Debe ingresar Pago ";
e.Row.Cells[_Col].ErrorText = "Debe ingresar Pago ";
e.Cancel = true;
e.Row.Cells[_Col].Style.DrawFill = true;
e.Row.Cells[_Col].Style.NumberOfColors = 1;
e.Row.Cells[_Col].Style.GradientStyle = GradientStyles.Solid;
e.Row.Cells[_Col].Style.CustomizeBorder = true;
e.Row.Cells[_Col].Style.DrawBorder = true;
e.Row.Cells[_Col].Style.BorderWidth = 2;
e.Row.Cells[_Col].Style.BorderGradientStyle = GradientStyles.Solid;
e.Row.Cells[_Col].Style.BorderColor = Color.Red;
}
else
{
if (Convert.ToDecimal(e.Row.Cells[_Col - 1].Value) < ((Decimal)e.Value))
{
if (Dialogos.MostrarMensajePregunta(Presenter.Title, "El pago es mayor que el saldo. Desea continuar?") == System.Windows.Forms.DialogResult.OK)
{
CalculaTotal();
NUDCAJA_Monto.Value = (NUDCAJA_Monto.Value - Convert.ToDecimal(e.Row.Cells[_Col].Value)) + ((Decimal)e.Value);
e.Row.Cells[_Col].Style.Reset();
}
else
{
e.Cancel = true;
e.Row.ErrorText = "El pago no puede ser mayor que el saldo ";
e.Row.Cells[_Col].Value = e.Row.Cells[_Col - 1].Value;
e.Row.Cells[_Col].Style.Reset();
e.Row.Cells[_Col].Style.Reset();
}
}
else
{
CalculaTotal();
NUDCAJA_Monto.Value = (NUDCAJA_Monto.Value - Convert.ToDecimal(e.Row.Cells[_Col].Value)) + ((Decimal)e.Value);
e.Row.Cells[_Col].Style.Reset();
}
}
break;
}
}
}
catch (Exception ex) { Dialogos.MostrarMensajeError("", "Ha ocurrido un error al validar el registro." + ex.Message); }
}
/// <summary>
/// 创建RadGridView
/// </summary>
/// <param name="structs">RadGridView列</param>
/// <param name="itemsSource">数据源</param>
/// <param name="headerName">RadGridView名称</param>
/// <returns></returns>
public static RadGridView CreatDataGridView(Dictionary<string, string> structs, IEnumerable<object> itemsSource, string headerName)
{
var rgView = new RadGridView
{
ShowGroupPanel = false,
AutoGenerateColumns = false,
IsReadOnly = true,
Name = headerName,
RowIndicatorVisibility = Visibility.Collapsed
};
foreach (var item in structs.Keys)
{
var gvColumn = new GridViewDataColumn
{
Header = structs[item],
IsFilterable = false,
IsSortable = false,
DataMemberBinding = new System.Windows.Data.Binding(item)
};
rgView.Columns.Add(gvColumn);
}
rgView.ItemsSource = itemsSource;
return rgView;
}
protected void ConnectionsGridView_DataBound(object sender, EventArgs e)
{
for (int i = 0; i < ConnectionsGridView.Columns.Count; i++)
{
GridViewColumn c = ConnectionsGridView.Columns[i];
GridViewDataColumn dataColumn = c as GridViewDataColumn;
if (dataColumn.FieldName == "Id")
{
c.Visible = false;
}
dataColumn.HeaderStyle.Wrap = DevExpress.Utils.DefaultBoolean.False;
GridViewDataDateColumn dateColumn = c as GridViewDataDateColumn;
if (dateColumn != null)
{
if (dateColumn.FieldName == "LastUpdate")
{
dateColumn.PropertiesDateEdit.DisplayFormatString = "G";
dateColumn.Width = new Unit("140px");
//29-04-2016 Durga Modified for VSPLUS-2908
dateColumn.VisibleIndex = ConnectionsGridView.Columns.Count - 1;
}
}
}
ConnectionsGridView.Width = System.Web.UI.WebControls.Unit.Percentage(100);
}
private void RadGridView1_DataLoading(object sender, GridViewDataLoadingEventArgs e)
{
GridViewDataControl dataControl = (GridViewDataControl) sender;
if (dataControl.ParentRow != null)
{
dataControl.BorderThickness = new Thickness(0, 1, 0, 1);
dataControl.GridLinesVisibility = GridLinesVisibility.None;
dataControl.ShowGroupPanel = false;
dataControl.AutoGenerateColumns = false;
dataControl.CanUserFreezeColumns = false;
dataControl.IsReadOnly = true;
dataControl.ChildTableDefinitions.Clear();
GridViewDataColumn column = new GridViewDataColumn();
column.DataMemberBinding = new Binding("EmployeeID");
dataControl.Columns.Add(column);
column = new GridViewDataColumn();
column.DataMemberBinding = new Binding("FirstName");
dataControl.Columns.Add(column);
column = new GridViewDataColumn();
column.DataMemberBinding = new Binding("LastName");
dataControl.Columns.Add(column);
column = new GridViewDataColumn();
column.DataMemberBinding = new Binding("Title");
dataControl.Columns.Add(column);
}
}
protected void gridBatchAES_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
List <string> RequiredFields = SetRequiredFields();
foreach (GridViewColumn column in gridBatchAES.Columns)
{
GridViewDataColumn dataColumn = column as GridViewDataColumn;
if (dataColumn == null)
{
continue;
}
for (int i = 0; i < RequiredFields.Count; i++)
{
if (RequiredFields[i] == dataColumn.FieldName)
{
if (e.NewValues[dataColumn.FieldName] == null)
{
e.Errors[dataColumn] = "Value can't be empty.";
}
}
}
}
if (string.IsNullOrEmpty(e.RowError) && e.Errors.Count > 0)
{
e.RowError = "Please, correct all errors.";
}
}
private void HistoGrid_AutoGeneratingColumn(object sender,
GridViewAutoGeneratingColumnEventArgs e)
{
e.Column.CellStyleSelector = System.Windows.Application.Current.Resources["recommandationStyleSelector2"] as StyleSelector;
GridViewDataColumn column = e.Column as GridViewDataColumn;
if (column.Header.ToString() == "Date")
{
column.DataFormatString = "dd/MM/yyyy";
}
if (column.Header.ToString() == "id_comment")
{
column.IsVisible = false;
}
if (column.Header.ToString() == "id_comment_change")
{
column.IsVisible = false;
}
if (column.Header.ToString() == "type")
{
column.IsVisible = false;
}
if (column.Header.ToString() == "ISIN")
{
column.IsVisible = false;
}
if (e.Column.Header.ToString() == "ID")
{
e.Column.IsVisible = false;
}
}
public void FillProductsRadGridView()
{
if (this.ProductsRadGridView.Rows.Count > 0)
{
this.ProductsRadGridView.DataSource = null;
}
this.ProductsRadGridView.DataSource = this._serviceProduct.SpGetAllProducts();
#region Columns of the GridView
try
{
GridViewColumnCollection columns = this.ProductsRadGridView.Columns;
//ProductID Column
GridViewDataColumn _productIDColumn = columns["ProductID"];
_productIDColumn.IsVisible = false;
//ProductCode Column
GridViewDataColumn _productCodeColumn = columns["ProductCode"];
_productCodeColumn.HeaderText = "Código";
_productCodeColumn.Width = 150;
//ProductName Column
GridViewDataColumn _productNameColumn = columns["ProductName"];
_productNameColumn.HeaderText = "Nombre Producto";
_productNameColumn.Width = 350;
//CategoryName Column
GridViewDataColumn _categoryNameColumn = columns["CategoryName"];
_categoryNameColumn.HeaderText = "Categoría";
_categoryNameColumn.Width = 200;
//UnitPrice1 Column
GridViewDataColumn _unitPrice1Column = columns["UnitPrice1"];
_unitPrice1Column.HeaderText = "Precio 1 RD$";
_unitPrice1Column.FormatString = "{0:C}";
_unitPrice1Column.Width = 200;
//ProductCost Column
GridViewDataColumn _productCostColumn = columns["ProductCost"];
_productCostColumn.HeaderText = "Costo";
_productCostColumn.FormatString = "{0:C}";
_productCostColumn.Width = 150;
//KardexStock Column
GridViewDataColumn _kardexStockColumn = columns["Stock"];
_kardexStockColumn.HeaderText = "Existencia";
_kardexStockColumn.FormatString = "{0:0,0.00}";
_kardexStockColumn.Width = 150;
//Clear Selection
ClearSelectionRadGridView();
}
catch (Exception) { }
#endregion
ClearSelectionRadGridView();
}
private void ValuesGrid_AutoGeneratingColumn(object sender,
Telerik.Windows.Controls.GridViewAutoGeneratingColumnEventArgs e)
{
e.Column.CellStyleSelector = System.Windows.Application.Current.Resources["recommandationStyleSelector"] as StyleSelector;
GridViewDataColumn column = e.Column as GridViewDataColumn;
if (column.Header.ToString() == "Date")
{
column.DataFormatString = "dd/MM/yyyy";
}
if (e.Column.Header.ToString() == "ISIN")
{
e.Column.IsVisible = false;
}
if (e.Column.Header.ToString() == "ID_ICB")
{
e.Column.IsVisible = false;
}
if (e.Column.Header.ToString() == "ID_FGA")
{
e.Column.IsVisible = false;
}
}
protected void grdRoles_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
GridViewDataColumn dc = grdRoles.Columns["RoleName"] as GridViewDataColumn;
string user = grdRoles.GetRowValues(grdRoles.EditingRowVisibleIndex, "UserName").ToString();
ASPxCheckBoxList cbl = grdRoles.FindEditRowCellTemplateControl(dc, "chlRoles") as ASPxCheckBoxList;
foreach (ListEditItem le in cbl.Items)
{
if (le.Selected)
{
if (!Roles.IsUserInRole(user, le.Text))
{
Roles.AddUserToRole(user, le.Text);
}
}
else
{
if (Roles.IsUserInRole(user, le.Text))
{
if (!((user == "Master") && (le.Text == "Master")))
{
Roles.RemoveUserFromRole(user, le.Text);
}
}
}
}
e.Cancel = true;
grdRoles.CancelEdit();
}
public static GridViewDataColumn GenerateGridviewColumn(string fieldName, string header, bool readOnly, int width, GridViewColumnType columnType)
{
var columnw = new GridViewHyperlinkColumn();
GridViewDataColumn column = null;
if (columnType == GridViewColumnType.Text)
{
column = new GridViewTextBoxColumn();
}
else if (columnType == GridViewColumnType.Numeric)
{
column = new GridViewTextBoxColumn();
}
else if (columnType == GridViewColumnType.CheckBox)
{
column = new GridViewCheckBoxColumn();
(column as GridViewCheckBoxColumn).ThreeState = true;
}
else if (columnType == GridViewColumnType.Command)
{
column = new GridViewCommandColumn();
}
else if (columnType == GridViewColumnType.Link)
{
column = new GridViewHyperlinkColumn();
}
column.Name = fieldName;
column.FieldName = fieldName;
column.HeaderText = header;
column.ReadOnly = readOnly;
column.Width = width;
return(column);
}
public static void TransferSizeToHorizontal(RadGridView gv)
{
System.ComponentModel.TypeDescriptor.GetProperties(gv)["ItemsSource"].AddValueChanged(gv, new EventHandler(gv_ItemsSourceChanged));
var skuCol = gv.Columns.FirstOrDefault <Telerik.Windows.Controls.GridViewColumn>(o => o.Header.ToString() == "SKU码");
if (skuCol != null)
{
gv.Columns.Remove(skuCol);
}
var sizeCol = gv.Columns.FirstOrDefault <Telerik.Windows.Controls.GridViewColumn>(o => o.Header.ToString() == "尺码");
if (sizeCol != null)
{
int index = gv.Columns.IndexOf(sizeCol);
gv.Columns.RemoveAt(index);
foreach (var size in VMGlobal.Sizes)
{
var col = new GridViewDataColumn()
{
Header = size.Name, DataMemberBinding = new Binding(size.Name), Tag = "SizeCol"
}; //, Name = size.Name
gv.Columns.Insert(index, col);
index++;
}
}
}
protected void gvAcreedores_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
//validar rut de acreedor
LogicaNegocio ln = new LogicaNegocio();
bool existe = false;
foreach (GridViewColumn column in gvAcreedores.Columns)
{
GridViewDataColumn dataColumn = column as GridViewDataColumn;
if (dataColumn == null)
{
continue;
}
if (dataColumn.FieldName == "Rut")
{
if (e.IsNewRow)
{
existe = ln.Acreedores(4, e.NewValues["Rut"].ToString(), 0, "", "", 0, 0, 0, 0, "");
if (existe)
{
e.Errors[dataColumn] = "El Rut Ingresado ya esta registrado como acreedor.";
}
}
}
}
}
protected void gvThiSinh_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
string strOldValues;
if (strMess != string.Empty)
{
AddError(e.Errors, gvThiSinh.Columns["Error"], strMess);
e.RowError = strMess;
return;
}
foreach (GridViewColumn column in gvThiSinh.Columns)
{
GridViewDataColumn dataColumn = column as GridViewDataColumn;
if (dataColumn == null || dataColumn.Caption == "Error")
{
continue;
}
if (e.NewValues[dataColumn.FieldName] == null || e.NewValues[dataColumn.FieldName].ToString().Trim() == string.Empty)
{
e.Errors[dataColumn] = "Vui lòng điền dữ liệu.";
}
}
if (e.Errors.Count > 0)
{
e.RowError = "Vui lòng điền đầy đủ thông tin trước khi lưu.";
return;
}
strOldValues = e.OldValues["MaTS"] == null ? string.Empty : e.OldValues["MaTS"].ToString();
if (e.NewValues["MaTS"].ToString() != strOldValues && thisinhDAL.Check_MaThiSinh(e.NewValues["MaTS"].ToString()) == 1)
{
AddError(e.Errors, gvThiSinh.Columns["MaTS"], "Đã tồn tại Mã điểm thi, không thể lưu");
e.RowError = "Trùng mã thi sinh, vui lòng kiểm tra lại";
return;
}
}
private void Form1_Load(object sender, EventArgs e)
{
this.screenTip.MainTextLabel.Padding = new Padding(2);
this.screenTip.CaptionLabel.Padding = new Padding(2);
this.screenTip.EnableCustomSize = true;
this.gridView.ShowGroupPanel = false;
this.gridView.MasterTemplate.AllowAddNewRow = false;
this.gridView.DataSource = Product.Generate();
this.gridView.Columns["ProductID"].IsVisible = false;
this.gridView.Columns["ProductName"].Width = 180;
this.gridView.Columns["Category"].NullValue = "Type product's category";
this.gridView.Columns["Category"].DataSourceNullValue = "Beverages";
this.gridView.Columns["Category"].Width = 130;
this.gridView.Columns["UnitPrice"].FormatString = "{0:c}";
this.gridView.Columns["UnitPrice"].Width = 100;
this.gridView.Columns["IsOrganic"].Width = 80;
((GridViewCheckBoxColumn)this.gridView.Columns["IsOrganic"]).ThreeState = true;
this.gridView.Columns["UnitsInStock"].FormatString = "Quantity: {0}";
this.gridView.Columns["UnitsInStock"].Width = 100;
this.gridView.Columns["DeliveryDate"].FormatString = "{0}";
this.gridView.Columns["DeliveryDate"].Width = 150;
this.radComboTimeZone.DataSource = Telerik.WinControls.UI.TimeZoneInfo.GetSystemTimeZones();
this.radComboTimeZone.DisplayMember = "DisplayName";
this.radComboTimeZone.ValueMember = "Id";
this.radComboTimeZone.SelectedValue = Telerik.WinControls.UI.TimeZoneInfo.Utc.Id;
this.radComboTimeZone.DropDownMinSize = new Size(100, 400);
this.radTextBox1.Text = "price + price * 0.20 + Math.Pow(price, 2)";
this.SetUnitPriceExpression(this.radTextBox1.Text);
this.changedColumn = null;
}
protected void gvDotThi_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
string strOldValues;
if (strMess != string.Empty)
{
AddError(e.Errors, gvDotThi.Columns["Error"], strMess);
e.RowError = strMess;
return;
}
foreach (GridViewColumn column in gvDotThi.Columns)
{
GridViewDataColumn dataColumn = column as GridViewDataColumn;
if (dataColumn == null || dataColumn.Caption == "Error" || dataColumn.Caption == "Mã Đợt Thi")
{
continue;
}
if (e.NewValues[dataColumn.FieldName] == null || e.NewValues[dataColumn.FieldName].ToString().Trim() == string.Empty)
{
e.Errors[dataColumn] = "Vui lòng điền dữ liệu.";
}
}
if (e.Errors.Count > 0)
{
e.RowError = "Vui lòng điền đầy đủ thông tin trước khi lưu.";
return;
}
strOldValues = e.OldValues["MaDotThi"] == null ? string.Empty : e.OldValues["MaDotThi"].ToString();
}
private void gridView_CellFormatting(object sender, CellFormattingEventArgs e)
{
GridCellElement cellElement = e.CellElement;
GridViewDataColumn columnInfo = e.CellElement.ColumnInfo as GridViewDataColumn;
if (cellElement is GridCheckBoxCellElement)
{
}
if (columnInfo != null && !cellElement.RowInfo.IsCurrent && !cellElement.RowInfo.IsSelected &&
cellElement.RowElement.RowVisualState != GridRowElement.RowVisualStates.Hovered &&
(columnInfo.Name == "Category" && Object.Equals(cellElement.Text, columnInfo.NullValue) ||
columnInfo == changedColumn))
{
e.CellElement.BackColor = columnInfo.Name == "Category" ? Color.Pink : Color.PaleGoldenrod;
e.CellElement.GradientStyle = GradientStyles.Solid;
e.CellElement.DrawFill = true;
}
else
{
e.CellElement.ResetValue(LightVisualElement.BackColorProperty, ValueResetFlags.Local);
e.CellElement.ResetValue(LightVisualElement.GradientStyleProperty, ValueResetFlags.Local);
e.CellElement.ResetValue(LightVisualElement.DrawFillProperty, ValueResetFlags.Local);
}
}
protected void GridViewExporter_RenderBrick(object sender, DevExpress.Web.ASPxGridView.Export.ASPxGridViewExportRenderingEventArgs e)
{
GridViewDataColumn datacolumn = e.Column as GridViewDataColumn;
if (e.RowType == GridViewRowType.Data && datacolumn.FieldName.Equals("BeginBalance"))
{
object value = e.GetValue("BeginBalance");
if (value != null && value is double)
{
if ((double)value == 0)
{
e.Text = "0";
}
}
}
if (e.RowType == GridViewRowType.Data && datacolumn.FieldName.Equals("EndBalance"))
{
object value = e.GetValue("EndBalance");
if (value != null && value is double)
{
if ((double)value == 0)
{
e.Text = "0";
}
}
}
}
protected override GridViewDataColumn CreateColumn(IModelColumn columnInfo)
{
GridViewDataColumn gridViewDataColumnWithInfo = base.CreateColumn(columnInfo);
OnColumnCreated(new ColumnCreatedEventArgs(gridViewDataColumnWithInfo));
return(gridViewDataColumnWithInfo);
}
private Telerik.Windows.Controls.GridViewColumnCollection CreateColumns()
{
int columnCount = 1000;
int rowCount = 1000000;
Items = new ObservableCollection<MyObject>(from i in Enumerable.Range(0, rowCount) select new MyObject(i));
MyConverter converter = new MyConverter();
Telerik.Windows.Controls.GridViewColumnCollection columns = new Telerik.Windows.Controls.GridViewColumnCollection();
for (int i = 0; i < columnCount; i++)
{
GridViewDataColumn column = new GridViewDataColumn();
column.Header = string.Format("Column {0}", i);
column.IsReadOnly = true;
column.ShowFieldFilters = false;
column.Width = 150;
Binding binding = new Binding("ID");
binding.Converter = converter;
binding.ConverterParameter = i;
column.DataMemberBinding = binding;
columns.Add(column);
}
return columns;
}
private void FillData(int ProfileId)
{
UserProfileMaster LocObject = new UserProfileMaster();
LocObject.ID = ProfileId;
//UserProfileMaster ProfileMasterDataTable = VSWebBL.SecurityBL.UserProfileMasterBL.Ins.GetData(LocObject);
//ProfileTextBox.Text = ProfileMasterDataTable.Name;
DataTable ProfileDtlDataTable = VSWebBL.SecurityBL.UserProfileMasterBL.Ins.GetUserProfileDetailedData(LocObject);
if (ProfileDtlDataTable.Rows.Count > 0)
{
tblServer.Style.Add("visibility", "visible");
ApplyServersButton.Style.Add("visibility", "visible");
ServerTypeComboBox.Text = ProfileDtlDataTable.Rows[0]["ServerType"].ToString();
FillProfilesGrid(ServerTypeComboBox.SelectedItem.Text);
fillServersTreeList();
GridViewDataColumn column2 = ProfilesGridView.Columns["DefaultValue"] as GridViewDataColumn;
for (int i = 0; i < ProfileDtlDataTable.Rows.Count; i++)
{
for (int j = 0; j < ProfilesGridView.VisibleRowCount; j++)
{
if (ProfilesGridView.GetRowValues(j, ProfilesGridView.KeyFieldName).ToString() == ProfileDtlDataTable.Rows[i]["ProfilesMasterId"].ToString())
{
ProfilesGridView.Selection.SelectRow(j);
ASPxTextBox txtValue = (ASPxTextBox)ProfilesGridView.FindRowCellTemplateControl(j, column2, "txtDefaultValue");
txtValue.Text = ProfileDtlDataTable.Rows[i]["DefaultValue"].ToString();
}
}
}
}
}
/// <summary>
/// Convert GridView to Printer-Friendly version of a GridView
/// </summary>
/// <param name="source">Input GridView</param>
/// <returns>Printer-Friendly version of source</returns>
static GridViewDataControl ToPrintFriendlyGrid(GridViewDataControl source)
{
RadGridView grid = new RadGridView();
grid.ItemsSource = source.ItemsSource;
grid.RowIndicatorVisibility = Visibility.Collapsed;
grid.ShowGroupPanel = false;
grid.CanUserFreezeColumns = false;
grid.IsFilteringAllowed = false;
grid.AutoExpandGroups = true;
grid.AutoGenerateColumns = false;
foreach (GridViewDataColumn column in source.Columns.OfType <GridViewDataColumn>())
{
GridViewDataColumn newColumn = new GridViewDataColumn();
newColumn.Width = column.ActualWidth;
newColumn.DisplayIndex = column.DisplayIndex;
//newColumn.DataMemberBinding = new System.Windows.Data.Binding(column.UniqueName);
newColumn.DataMemberBinding = column.DataMemberBinding; // Better to just copy the references to get all the custom formatting
newColumn.DataFormatString = column.DataFormatString;
newColumn.TextAlignment = column.TextAlignment;
newColumn.Header = column.Header;
newColumn.Footer = column.Footer;
grid.Columns.Add(newColumn);
}
StyleManager.SetTheme(grid, StyleManager.GetTheme(grid));
grid.SortDescriptors.AddRange(source.SortDescriptors);
grid.GroupDescriptors.AddRange(source.GroupDescriptors);
grid.FilterDescriptors.AddRange(source.FilterDescriptors);
return(grid);
}
protected void GridView_DataBound1(object sender, EventArgs e)
{
// Hiển thị Caption theo khai báo ở DatamodelVM
ASPxGridView gridView = sender as ASPxGridView;
foreach (GridViewColumn column in gridView.Columns)
{
//if (column.GetType().ToString() == "DevExpress.Web.GridViewDataTextColumn")
//{
GridViewDataColumn dataColumn = column as GridViewDataColumn;
if (dataColumn != null)
{
PropertyInfo MyPropertyInfo = typeof(StdTypeVM).GetProperty(dataColumn.FieldName);
if (MyPropertyInfo != null)
{
DisplayAttribute displayAtt = (DisplayAttribute)Attribute.GetCustomAttribute(MyPropertyInfo, typeof(DisplayAttribute));
if (displayAtt != null && displayAtt.Name != null)
{
column.Caption = displayAtt.Name;
}
}
}
//}
}
UpdateNavBarName();
}
public void MergeCells(GridViewDataColumn column, int visibleIndex, TableCell cell)
{
bool isNextTheSame = IsNextRowHasSameData(column, visibleIndex);
if (isNextTheSame)
{
if (!mergedCells.ContainsKey(column))
{
mergedCells[column] = cell;
}
}
if (IsPrevRowHasSameData(column, visibleIndex))
{
((TableRow)cell.Parent).Cells.Remove(cell);
if (mergedCells.ContainsKey(column))
{
TableCell mergedCell = mergedCells[column];
if (!cellRowSpans.ContainsKey(mergedCell))
{
cellRowSpans[mergedCell] = 1;
}
cellRowSpans[mergedCell] = cellRowSpans[mergedCell] + 1;
}
}
if (!isNextTheSame)
{
mergedCells.Remove(column);
}
}
private IFilterDescriptor CreateFilterForColumn(GridViewDataColumn column)
{
FilterOperator filterOperator = GetFilterOperatorForType(column.DataType);
FilterDescriptor descriptor = new FilterDescriptor(column.UniqueName, filterOperator, this.filterValue);
descriptor.MemberType = column.DataType;
return descriptor;
}
bool IsNextRowHasSameData(GridViewDataColumn column, int visibleIndex)
{
//is it the last visible row
if (visibleIndex >= Grid.VisibleRowCount - 1)
return false;
return IsSameData(column.FieldName, visibleIndex, visibleIndex + 1);
}
bool IsPrevRowHasSameData(GridViewDataColumn column, int visibleIndex)
{
ASPxGridView grid = column.Grid;
//is it the first visible row
if (visibleIndex <= Grid.VisibleStartIndex)
return false;
return IsSameData(column.FieldName, visibleIndex, visibleIndex - 1);
}
public void InitializeComponent() {
if (_contentLoaded) {
return;
}
_contentLoaded = true;
System.Windows.Application.LoadComponent(this, new System.Uri("/Procbel.Apps.Silverlight.Modules.Activities;component/Views/ActivitiesListUserCo" +
"ntrol.xaml", System.UriKind.Relative));
this.LayoutRoot = ((System.Windows.Controls.Grid)(this.FindName("LayoutRoot")));
this.activitiesGrid = ((RadGridView)(this.FindName("activitiesGrid")));
this.Status = ((GridViewDataColumn)(this.FindName("Status")));
}
public void InitializeComponent() {
if (_contentLoaded) {
return;
}
_contentLoaded = true;
System.Windows.Application.LoadComponent(this, new System.Uri("/Procbel.Apps.Silverlight.Modules.Companies;component/Views/CompanyActivitiesUser" +
"Control.xaml", System.UriKind.Relative));
this.uc = ((System.Windows.Controls.UserControl)(this.FindName("uc")));
this.LayoutRoot = ((System.Windows.Controls.Grid)(this.FindName("LayoutRoot")));
this.VisualStateGroup = ((System.Windows.VisualStateGroup)(this.FindName("VisualStateGroup")));
this.Normal = ((System.Windows.VisualState)(this.FindName("Normal")));
this.Add = ((System.Windows.VisualState)(this.FindName("Add")));
this.Edit = ((System.Windows.VisualState)(this.FindName("Edit")));
this.scheduleView = ((RadScheduleView)(this.FindName("scheduleView")));
this.activitiesGrid = ((RadGridView)(this.FindName("activitiesGrid")));
this.Status = ((GridViewDataColumn)(this.FindName("Status")));
this.overlayRectangle = ((System.Windows.Shapes.Rectangle)(this.FindName("overlayRectangle")));
this.border = ((System.Windows.Controls.Border)(this.FindName("border")));
this.dialog = ((Procbel.Apps.Silverlight.Helpers.ScheduleViewCustomDialogHost)(this.FindName("dialog")));
}
/// <summary>
/// 创建RadGridView
/// </summary>
/// <param name="structs">RadGridView列</param>
/// <param name="itemsSource">数据源</param>
/// <param name="itemsSource">RadGridView名称</param>
/// <returns></returns>
public static RadGridView CreatDataGridView(Dictionary<string, string> structs, IEnumerable<object> itemsSource, string headername)
{
RadGridView rgView = new RadGridView();
rgView.ShowGroupPanel = false;
rgView.AutoGenerateColumns = false;
rgView.IsReadOnly = true;
rgView.Name = headername;
rgView.RowIndicatorVisibility = Visibility.Collapsed;
foreach (var item in structs.Keys)
{
GridViewDataColumn gvColumn = new GridViewDataColumn();
gvColumn.Header = structs[item].ToString();
gvColumn.IsFilterable = false;
gvColumn.IsSortable = false;
gvColumn.DataMemberBinding = new System.Windows.Data.Binding(item);
rgView.Columns.Add(gvColumn);
}
rgView.ItemsSource = itemsSource;
return rgView;
}
private void AddColumn()
{
GridViewDataColumn column = new GridViewDataColumn();
column.Header = "Name" + count;
column.DataMemberBinding = new System.Windows.Data.Binding("Name") { Mode = System.Windows.Data.BindingMode.TwoWay };
column.DisplayIndex = count;
count++;
this.clubsGrid.Columns.Add(column);
RebindListBox();
}
public void ElementExporting_Cell()
{
// arrange
var exportUtility = new ExportUtility();
var exportViewModel = new ExportOptionsViewModel
{
ExportFileType = ExportFileType.Excel
};
var model = exportViewModel;
exportUtility.TheExportOptionsViewModel = new Lazy<ExportOptionsViewModel>(() => model);
var e = Mock.Create<GridViewElementExportingEventArgs>(Behavior.Loose);
var parameters = new GridViewHtmlVisualExportParameters();
Mock.Arrange(() => e.VisualParameters).Returns(parameters);
Mock.Arrange(() => e.Element).Returns(ExportElement.Cell);
var column = new GridViewDataColumn { UniqueName = "Notes" };
Mock.Arrange(() => e.Context).Returns(column);
var privateAccessor = new PrivateAccessor(exportUtility);
var accessDeniedProperties = new List<string> { "Notes" };
privateAccessor.SetField("_accessDeniedProperties", accessDeniedProperties);
// act
privateAccessor.CallMethod("ElementExporting", new[] { new object(), e });
// assert
Assert.AreEqual("<Blocked>", e.Value);
Assert.AreEqual(Colors.Red, parameters.Foreground);
// arrange
accessDeniedProperties.Clear();
e.Value = "<Rich Text>";
// act
privateAccessor.CallMethod("ElementExporting", new[] { new object(), e });
// assert
Assert.AreEqual(Colors.Blue, parameters.Foreground);
// arrage
e.Value = new byte[] { };
exportViewModel = new ExportOptionsViewModel
{
RowForeground = Colors.Yellow,
ExportFileType = ExportFileType.Excel
};
exportUtility.TheExportOptionsViewModel = new Lazy<ExportOptionsViewModel>(() => exportViewModel);
// act
privateAccessor.CallMethod("ElementExporting", new[] { new object(), e });
// assert
Assert.AreEqual("binary data", e.Value);
Assert.AreEqual(Colors.Yellow, parameters.Foreground);
}
public static void AddColumnToGrid(GridViewDataControl grid, IColumnItem column)
{
if (column == null)
return;
string fullName = column.IsBase ? string.Format(CultureInfo.InvariantCulture, "{0}.{1}", column.Prefix, column.ColumnName) : column.ColumnName;
if (column.Property == null)
{
var col = new GridViewDataColumn
{
Header = column.Header,
UniqueName = fullName,
DataType = column.DataType,
IsGroupable = column.IsGroupable,
Width = column.Width == 0.0 ? new GridViewLength(1, GridViewLengthUnitType.Auto) : column.Width
};
if (grid != null)
grid.Columns.Add(col);
return;
}
var converterInfo = GetConverterInfo(column);
var dict = Application.Current.Resources.MergedDictionaries.First(x => x.Source == new Uri("/Cebos.Veyron.Common.SL;component/Assets/RadGridViewStyles.xaml", UriKind.RelativeOrAbsolute));
if (IsImage(column.Property))
{
var imageWidth = 96;
var imageHeight = 96;
var pictureOptionsAttr = (PictureOptionsAttribute)(from d in column.Property.GetCustomAttributes(typeof(PictureOptionsAttribute), false) select d).FirstOrDefault();
if (pictureOptionsAttr != null)
{
imageWidth = pictureOptionsAttr.SearchWidth;
imageHeight = pictureOptionsAttr.SearchHeight;
}
var templateText = string.Format(
CultureInfo.InvariantCulture, @"
<DataTemplate
xmlns=""http://schemas.microsoft.com/client/2007""
xmlns:i=""http://schemas.microsoft.com/expression/2010/interactivity""
xmlns:Behaviors=""clr-namespace:Cebos.Common.Behaviors;assembly=Cebos.Veyron.Common.SL"">
<Image Height=""{0}""
Width=""{1}""
Stretch=""Uniform""
Source=""{{Binding {2}{3}, Converter={{StaticResource imageConverter}}}}"">
<i:Interaction.Behaviors>
<Behaviors:{4}
AccessDeniedPropertyList=""{{Binding Path=AccessDeniedProperties, Converter={{StaticResource {5}}}}}""
ColumnName=""{3}"" />
</i:Interaction.Behaviors>
</Image>
</DataTemplate>", imageHeight, imageWidth, string.IsNullOrWhiteSpace(column.Prefix) ? null : string.Format(CultureInfo.InvariantCulture, "{0}.", column.Prefix), column.ColumnName, typeof(HightlightImageBehavior).Name, typeof(
StringToHashSetConverter).Name);
var col = new GridViewDataColumn
{
Header = column.Header,
UniqueName = fullName,
DataMemberBinding = new Binding(fullName),
CellTemplate = (DataTemplate)XamlReader.Load(templateText),
FooterCellStyle = (Style)dict["footerCellStyle"],
GroupFooterCellStyle = (Style)dict["groupFooterCellStyle"],
IsGroupable = column.IsGroupable,
DataType = typeof(string),
Width = column.Width == 0.0 ? new GridViewLength(1, GridViewLengthUnitType.Auto) : column.Width
};
if (grid != null)
grid.Columns.Add(col);
return;
}
// if item have AdditionalDataPropertyName property equals column name + "Url",
// then this column will be hyperlink, else normal column.
if (column.AdditionalDataPropertyName != null)
{
var col = new GridViewDataColumn
{
Header = column.Header,
UniqueName = fullName,
DataMemberBinding =
new Binding(column.AdditionalDataPropertyName)
{
Converter = converterInfo.ConverterObject,
ConverterParameter = converterInfo.ConverterParameter
},
CellTemplate = GetCellTemplateHyperlink(column),
GroupFooterCellStyle = (Style)dict["groupFooterCellStyle"],
FooterCellStyle = (Style)dict["footerCellStyle"],
IsGroupable = column.IsGroupable,
DataType = column.Property.PropertyType,
Width = column.Width == 0.0 ? new GridViewLength(1, GridViewLengthUnitType.Auto) : column.Width
};
if (grid != null)
grid.Columns.Add(col);
}
else
{
if (column.IsBase && column.ColumnName == Constants.IdColumnName && column.Property.PropertyType == typeof(int))
{
return;
}
if (column.IsBase && column.ColumnName == Constants.VersionDate)
{
return;
}
if (column.IsBase && column.ColumnName == Constants.VersionNumber)
{
return;
}
if (column.IsBase && Constants.DerivedProcessDisplayNameColumnName.Equals(column.ColumnName))
{
return;
}
if (grid != null)
{
grid.Columns.Add(new GridViewDataColumn
{
Header = column.Header,
UniqueName = fullName,
DataMemberBinding = new Binding(fullName)
{
Converter = converterInfo.ConverterObject,
ConverterParameter = converterInfo.ConverterParameter
},
CellTemplate = GetCellTemplate(column, converterInfo, grid),
GroupFooterCellStyle = (Style)dict["groupFooterCellStyle"],
FooterCellStyle = (Style)dict["footerCellStyle"],
DataType = column.Property.PropertyType,
IsGroupable = true,
Width = column.Width == 0.0 ? new GridViewLength(1, GridViewLengthUnitType.Auto) : column.Width
});
}
}
}
void MergeCells(GridViewDataColumn column, int visibleIndex, TableCell cell)
{
bool isNextTheSame = IsNextRowHasSameData(column, visibleIndex);
if (isNextTheSame) {
if (!mergedCells.ContainsKey(column)) {
mergedCells[column] = cell;
}
}
if (IsPrevRowHasSameData(column, visibleIndex)) {
((TableRow)cell.Parent).Cells.Remove(cell);
if (mergedCells.ContainsKey(column)) {
TableCell mergedCell = mergedCells[column];
if (!cellRowSpans.ContainsKey(mergedCell)) {
cellRowSpans[mergedCell] = 1;
}
cellRowSpans[mergedCell] = cellRowSpans[mergedCell] + 1;
}
}
if (!isNextTheSame) {
mergedCells.Remove(column);
}
}
//end incremental filtering of company name
#endregion
#region database operations
/// <summary>
/// on databound check if publiship user of client
/// if client hide fields in edit form they do not have permission to edit
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void dxgrdorders_DataBound(object sender, EventArgs e)
{
Int32 _cid = Page.Session["user"] != null ? (Int32)((UserClass)Page.Session["user"]).CompanyId : -1;
GridViewDataColumn _c = new GridViewDataColumn();
if (_cid != -1)
{
string[] _f = { "OrderNumber", "CompanyID", "ConsigneeID", "OrderNumber", "CompanyID", "ConsigneeID", "PrinterID", "CustomerRef",
"PrintersRef", "ContactID","CargoReadyDate","CargoReceivedDate","OriginID","FinalDestID","Etd","Eta",
"ActualWeight","ActualVolume", "HAWBno", "HAWBAdded","RemarkstoAgent","RemarkstoCust","JobClosed","JobClosureDate",
"CompositeInvRef","InsuranceValue","CancelRequestRcd","OrderCancelled","CancelDate","CancelledByID" };
for (int _ix = 0; _ix < _f.Length; _ix++)
{
_c = (GridViewDataColumn)this.dxgrdorders.Columns[_f[_ix]];
if (_c != null) { _c.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False; }
//ASPxGridViewTemplateReplacement _r = new ASPxGridViewTemplateReplacement();
//_r.ColumnID = "col" + _f[_ix];
//_r.Visible = false;
}
} //end if
//hidden for all users as these are auto-updated
_c = (GridViewDataColumn)this.dxgrdorders.Columns["Titles"];
if (_c != null) { _c.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False; }
_c = (GridViewDataColumn)this.dxgrdorders.Columns["Cartons"];
if (_c != null) { _c.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False; }
}
public new bool AddGroupRowTemplateControl(int visibleIndex, GridViewDataColumn column, TableRow row, int spanCount)
{
var template = GetTemplate(Grid.Templates.GroupRow, column.GroupRowTemplate);
if (template == null || IsGridExported) return false;
AddTemplateToControl(
CreateTemplateCell(row, spanCount),
template,
new GridViewGroupRowTemplateContainer(
Grid,
column,
DataProxy.GetRowForTemplate(visibleIndex),
visibleIndex
),
GroupRowTemplates
);
return true;
}
public ASPxSmartGridViewEditorEventArgs(GridViewDataColumn column, int visibleIndex, ASPxEditBase editor, object keyValue, object value) : base(column, visibleIndex, editor, keyValue, value)
{
}
private void gridView_DataLoading(object sender, GridViewDataLoadingEventArgs e)
{
GridViewDataControl dataControl = (GridViewDataControl)sender;
if (dataControl.ParentRow != null)
{
dataControl.BorderThickness = new Thickness(0, 1, 0, 1);
dataControl.GridLinesVisibility = GridLinesVisibility.None;
dataControl.CanUserFreezeColumns = false;
dataControl.ShowGroupPanel = false;
dataControl.AutoGenerateColumns = false;
GridViewDataColumn column = new GridViewDataColumn();
column.Header = "Order ID";
column.DataMemberBinding = new System.Windows.Data.Binding("OrderID");
dataControl.Columns.Add(column);
column = new GridViewDataColumn();
column.Header = "Product ID";
column.DataMemberBinding = new System.Windows.Data.Binding("ProductID");
dataControl.Columns.Add(column);
column = new GridViewDataColumn();
column.Header = "Unit Price";
column.DataFormatString = "{0:c}";
column.DataMemberBinding = new System.Windows.Data.Binding("UnitPrice");
dataControl.Columns.Add(column);
column = new GridViewDataColumn();
column.Header = "Quantity";
column.DataMemberBinding = new System.Windows.Data.Binding("Quantity");
dataControl.Columns.Add(column);
}
}
public void SetupAxAttachment(string ParentType)
{
//Attachment has no layout and we arent showing it as a data form anyway
//so use the Sobject but don;t use AddFields and just build the object here
//should move to the SobjectDef class as a special case
_sObjectDef = new SForceEdit.SObjectDef("Attachment");
_sObjectDef.Parent = "Parent";
_sObjectDef.ParentType = ParentType;
//Set up the field in the grid
List<string> searchCols = new List<string>();
string settingColumns = Globals.ThisAddIn.GetSettings("Attachment", "Columns");
if (settingColumns == "")
{
settingColumns = "Name|Owner_Name|LastModifiedDate|LastModifiedBy_Name";
}
_sObjectDef.GridColumnFields = new List<string>();
this.radGridView1.Columns.Clear();
this.radGridView1.AutoGenerateColumns = false;
sfPartner.DescribeSObjectResult dsr = _d.GetSObject(_sObjectDef.Name);
_sObjectDef.Label = dsr.label;
_sObjectDef.PluralLabel = dsr.labelPlural;
// describe object doesn't have the url for attachment, get the url from the binding and add {ID}
_sObjectDef.Url = _d.GetURL() + "/{ID}";
_sObjectDef.AddField("Id","","Id","string",true,false,false,null);
_sObjectDef.AddField("ParentId", "", "ParentId", "string", true, false, false, null);
_sObjectDef.AddField("ContentType", "", "ContentType", "string", true, false, false, null);
foreach (string settingCol in settingColumns.Split('|'))
{
//Find the Field
sfPartner.Field f = null;
string fldname = settingCol;
if(settingCol.EndsWith("_Name")){
fldname = settingCol.Replace("_Name", "") + "Id" ; //dont have to worry about __c to __r can't have custom on attachment
}
for (int x = 0; x < dsr.fields.Length; x++)
{
if (dsr.fields[x].name == fldname)
{
f = dsr.fields[x];
}
}
if (f!=null)
{
//add the field
_sObjectDef.AddField(f.name,
f.relationshipName,
f.label,
f.type.ToString(),
true,
f.updateable,
f.createable,
f
);
//If this is a Relation add extra field to the field list with the Name
if (f.type == sfPartner.fieldType.reference)
{
_sObjectDef.AddField(f.relationshipName + ".Name",
f.relationshipName,
f.label,
f.type.ToString(),
true,
false,
false,
null);
}
//keep a list of columns
_sObjectDef.GridColumnFields.Add(settingCol);
SForceEdit.SObjectDef.FieldGridCol fgc = _sObjectDef.GetField(settingCol);
GridViewDataColumn column = new GridViewDataColumn();
column.DataMemberBinding = new Binding(fgc.Name);
column.Header = fgc.Header;
column.UniqueName = fgc.Name;
if (fgc.DataType == "date")
{
column.DataType = typeof(DateTime);
column.DataFormatString = "d";
column.TextAlignment = TextAlignment.Center;
}
if (fgc.DataType == "datetime")
{
column.DataType = typeof(DateTime);
column.DataFormatString = "g";
column.TextAlignment = TextAlignment.Center;
}
if (fgc.DataType == "double")
{
column.DataType = typeof(Double);
column.DataFormatString = "0";
column.TextAlignment = TextAlignment.Right;
}
column.MaxWidth = 300;
this.radGridView1.Columns.Add(column);
}
}
}
private IEnumerable GetData()
{
if (Type == null)
return null;
switch ((BindingType)Type.Value)
{
case BindingType.SimpleBindingToString:
{
Description = "This is a demonstration of GridViewComboBoxColumn binding to strings";
DescriptionHeader = "Simple Binding to Strings";
Columns.Clear();
List<Product> products = new List<Product>();
for (int i = 0; i < 10; i++)
{
Product product = new Product();
product.ID = i;
product.ProductName = String.Format("Product{0}", i);
products.Add(product);
}
GridViewComboBoxColumn column = new GridViewComboBoxColumn();
column.DataMemberBinding = new Binding("ProductName");
column.ItemsSource = from p in products
select p.ProductName;
column.Width = new GridViewLength(1, GridViewLengthUnitType.Star);
Columns.Add(column);
return products;
}
case BindingType.SimpleBindingToObject:
{
Description = "This is a demonstration of GridViewComboBoxColumn simple binding to objects";
DescriptionHeader = "Simple Binding to Objects";
Columns.Clear();
List<Employee> employees = new List<Employee>();
for (int i = 0; i < 10; i++)
{
Employee employee = new Employee();
employee.Name = String.Format("Name{0}", i);
employees.Add(employee);
}
List<Position> positions = new List<Position>();
for (int i = 0; i < 10; i++)
{
Position position = new Position();
position.Description = String.Format("Description{0}", i);
position.Employee = employees[i];
positions.Add(position);
}
GridViewComboBoxColumn comboColumn = new GridViewComboBoxColumn();
comboColumn.DataMemberBinding = new Binding("Employee");
comboColumn.DisplayMemberPath = "Name";
comboColumn.ItemsSource = employees;
comboColumn.Width = new GridViewLength(1, GridViewLengthUnitType.Star);
Columns.Add(comboColumn);
GridViewDataColumn column = new GridViewDataColumn();
column.DataMemberBinding = new Binding("Description");
column.Width = new GridViewLength(1, GridViewLengthUnitType.Star);
Columns.Add(column);
return positions;
}
case BindingType.SimpleBindingToEnum:
{
Description = "This is a demonstration of GridViewComboBoxColumn binding to enum";
DescriptionHeader = "Binding to Enum";
Columns.Clear();
List<Person> persons = new List<Person>();
Person person = new Person();
person.ID = 1;
person.Gender = Gender.Male;
persons.Add(person);
person = new Person();
person.ID = 2;
person.Gender = Gender.Female;
persons.Add(person);
List<Gender> AvailableGenders = new List<Gender>();
AvailableGenders.Add(Gender.Male);
AvailableGenders.Add(Gender.Female);
GridViewComboBoxColumn comboColumn = new GridViewComboBoxColumn();
comboColumn.DataMemberBinding = new Binding("Gender");
comboColumn.ItemsSource = AvailableGenders;
comboColumn.Width = new GridViewLength(1, GridViewLengthUnitType.Star);
Columns.Add(comboColumn);
return persons;
}
case BindingType.ClassicBindingToObject:
{
Description = "This is a demonstration of GridViewComboBoxColumn classic binding to objects";
DescriptionHeader = "Classic Binding to Objects";
Columns.Clear();
List<Location> locations = new List<Location>();
for (int i = 0; i < 10; i++)
{
Location location = new Location();
location.ID = i;
location.CountryID = i;
locations.Add(location);
}
List<Country> countries = new List<Country>();
for (int i = 0; i < 10; i++)
{
Country country = new Country();
country.ID = i;
country.Name = countryNames[i];
countries.Add(country);
}
GridViewComboBoxColumn comboColumn = new GridViewComboBoxColumn();
comboColumn.DataMemberBinding = new Binding("CountryID");
comboColumn.SelectedValueMemberPath = "ID";
comboColumn.DisplayMemberPath = "Name";
comboColumn.ItemsSource = countries;
comboColumn.Width = new GridViewLength(1, GridViewLengthUnitType.Star);
Columns.Add(comboColumn);
return locations;
}
case BindingType.MultiColumnComboBox:
{
Description = "This is a demonstration of how the ItemTemplate property of the column may be used to provide multicolumn layout for the lookup items";
DescriptionHeader = "MultiColumn ComboBox";
Columns.Clear();
List<Location> locations = new List<Location>();
for (int i = 0; i < 10; i++)
{
Location location = new Location();
location.ID = i;
location.CountryID = i;
locations.Add(location);
}
List<Country> countries = new List<Country>();
for (int i = 0; i < 10; i++)
{
Country country = new Country();
country.ID = i;
country.Name = countryNames[i];
countries.Add(country);
}
GridViewComboBoxColumn comboColumn = new GridViewComboBoxColumn();
comboColumn.Header = "Country ID & Name";
comboColumn.DataMemberBinding = new Binding("CountryID");
comboColumn.SelectedValueMemberPath = "ID";
comboColumn.DisplayMemberPath = "Name";
comboColumn.ItemsSource = countries;
comboColumn.ItemTemplate = ComboTemplate;
comboColumn.Width = new GridViewLength(1, GridViewLengthUnitType.Star);
Columns.Add(comboColumn);
return locations;
}
}
return null;
}
public ASPxSmartGridViewColumnDisplayTextEventArgs(GridViewDataColumn column, int visibleRowIndex, object _value) : base(column, visibleRowIndex, _value)
{
}
public override void ApplyEditorSettings(ASPxEditBase baseEditor, GridViewDataColumn column)
{
base.ApplyEditorSettings(baseEditor, column);
if (column.ReadOnly == false)
{
baseEditor.ReadOnly(false);
}
}
public new bool AddGroupFooterRowTemplateControl(TableRow row, GridViewDataColumn column, int spanCount, int visibleIndex)
{
var groupFooterRow = Grid.Templates.GroupFooterRow;
if (groupFooterRow == null || IsGridExported) return false;
AddTemplateToControl(
CreateTemplateCell(row, spanCount),
groupFooterRow,
new GridViewGroupFooterRowTemplateContainer(
Grid,
column,
DataProxy.GetRowForTemplate(visibleIndex),
visibleIndex
),
GroupFooterRowTemplates
);
return true;
}
/// <summary>
/// 创建计划历史
/// </summary>
public RadGridView CreatePlanHistorityGridView()
{
RadGridView rgView = new RadGridView();
rgView.ShowGroupPanel = true;
rgView.AutoGenerateColumns = false;
rgView.IsReadOnly = true;
rgView.Name = "planHistotry";
rgView.RowIndicatorVisibility = Visibility.Collapsed;
rgView.IsFilteringAllowed = true;
GridViewDataColumn gvColumn0 = new GridViewDataColumn();
gvColumn0.Header = "申报单位";
gvColumn0.DataMemberBinding = new System.Windows.Data.Binding("Plan.Airlines.ShortName");
//Telerik.Windows.Data.CountFunction cf = new Telerik.Windows.Data.CountFunction();
//cf.Caption = "总计(项)：";
//gvColumn0.AggregateFunctions.Add(cf);
GridViewDataColumn gvColumn1 = new GridViewDataColumn();
gvColumn1.Header = "执行年份";
gvColumn1.DataMemberBinding = new System.Windows.Data.Binding("Annual.Year");
GridViewDataColumn gvColumn2 = new GridViewDataColumn();
gvColumn2.Header = "执行月份";
gvColumn2.DataMemberBinding = new System.Windows.Data.Binding("PerformMonth");
GridViewDataColumn gvColumn3 = new GridViewDataColumn();
gvColumn3.Header = "活动类别";
gvColumn3.DataMemberBinding = new System.Windows.Data.Binding("ActionCategoryOperation");
GridViewDataColumn gvColumn4 = new GridViewDataColumn();
gvColumn4.Header = "引进/退出方式";
System.Windows.Data.Binding bingding4 = new System.Windows.Data.Binding("TargetCategory.ActionName");
gvColumn4.DataMemberBinding = bingding4;
GridViewDataColumn gvColumn5 = new GridViewDataColumn();
gvColumn5.Header = "机型";
gvColumn5.DataMemberBinding = new System.Windows.Data.Binding("AircraftType.Name");
GridViewDataColumn gvColumn6 = new GridViewDataColumn();
gvColumn6.Header = "净增座位(座)";
gvColumn6.DataMemberBinding = new System.Windows.Data.Binding("SeatingCapacity");
GridViewDataColumn gvColumn7 = new GridViewDataColumn();
gvColumn7.Header = "净增商载(吨)";
gvColumn7.DataMemberBinding = new System.Windows.Data.Binding("CarryingCapacity");
GridViewDataColumn gvColumn8 = new GridViewDataColumn();
gvColumn8.Header = "备注";
gvColumn8.DataMemberBinding = new System.Windows.Data.Binding("Note");
GridViewDataColumn gvColumn9 = new GridViewDataColumn();
gvColumn9.Header = "申请状态";
gvColumn9.DataMemberBinding = new System.Windows.Data.Binding("IsApply");
//默认分组
GroupDescriptor countryDescriptor = new GroupDescriptor();
countryDescriptor.Member = "IsApply";
countryDescriptor.DisplayContent = "申请状态";
rgView.GroupDescriptors.Add(countryDescriptor);
rgView.AutoExpandGroups = true;
SerialColumn gvColumn10 = new SerialColumn();
ResourceDictionary dictionary = new ResourceDictionary();
dictionary.Source = new Uri("/CAAC.Infrastructure;component/Resources/CafmStyle.xaml", UriKind.Relative);
gvColumn10.Header = "序号";
gvColumn10.CellStyle = (Style)dictionary["style"];
rgView.Columns.Add(gvColumn10);
rgView.Columns.Add(gvColumn0);
rgView.Columns.Add(gvColumn1);
rgView.Columns.Add(gvColumn2);
rgView.Columns.Add(gvColumn3);
rgView.Columns.Add(gvColumn4);
rgView.Columns.Add(gvColumn5);
rgView.Columns.Add(gvColumn6);
rgView.Columns.Add(gvColumn7);
rgView.Columns.Add(gvColumn8);
rgView.Columns.Add(gvColumn9);
return rgView;
}
/// <summary>
///创建运营飞机
/// </summary>
/// <returns></returns>
public RadGridView CreatOperationGridView()
{
RadGridView rgView = new RadGridView();
rgView.ShowGroupPanel = true;
rgView.AutoGenerateColumns = false;
rgView.IsReadOnly = true;
rgView.Name = "aircraftDetail";
rgView.RowIndicatorVisibility = Visibility.Collapsed;
rgView.IsFilteringAllowed = true;
GridViewDataColumn gvColumn1 = new GridViewDataColumn();
gvColumn1.Header = "航空公司";
gvColumn1.DataMemberBinding = new System.Windows.Data.Binding("Airlines.ShortName");
GridViewDataColumn gvColumn2 = new GridViewDataColumn();
gvColumn2.Header = "注册号";
gvColumn2.DataMemberBinding = new System.Windows.Data.Binding("RegNumber");
GridViewDataColumn gvColumn3 = new GridViewDataColumn();
gvColumn3.Header = "机型";
gvColumn3.DataMemberBinding = new System.Windows.Data.Binding("AircraftType.Name");
GridViewDataColumn gvColumn4 = new GridViewDataColumn();
gvColumn4.Header = "引进方式";
System.Windows.Data.Binding bingding4 = new System.Windows.Data.Binding("ImportCategory.ActionName");
gvColumn4.DataMemberBinding = bingding4;
GridViewDataColumn gvColumn5 = new GridViewDataColumn();
gvColumn5.Header = "引进日期";
gvColumn5.DataMemberBinding = new System.Windows.Data.Binding("ImportDate");
gvColumn5.DataFormatString = "yyyy/M/d";
GridViewDataColumn gvColumn6 = new GridViewDataColumn();
gvColumn6.Header = "出厂日期";
gvColumn6.DataMemberBinding = new System.Windows.Data.Binding("FactoryDate");
gvColumn6.DataFormatString = "yyyy/M/d";
SerialColumn gvColumn7 = new SerialColumn();
ResourceDictionary dictionary = new ResourceDictionary();
dictionary.Source = new Uri("/CAAC.Infrastructure;component/Resources/CafmStyle.xaml", UriKind.Relative);
gvColumn7.Header = "序号";
gvColumn7.CellStyle = (Style)dictionary["style"];
rgView.Columns.Add(gvColumn7);
rgView.Columns.Add(gvColumn1);
rgView.Columns.Add(gvColumn2);
rgView.Columns.Add(gvColumn3);
rgView.Columns.Add(gvColumn4);
rgView.Columns.Add(gvColumn5);
rgView.Columns.Add(gvColumn6);
return rgView;
}
/// <summary>
///创建运营飞机RadGridView
/// </summary>
/// <returns></returns>
public RadGridView CreatOperationGridView()
{
var rgView = new RadGridView
{
ShowGroupPanel = true,
AutoGenerateColumns = false,
IsReadOnly = true,
Name = "aircraftDetail",
RowIndicatorVisibility = Visibility.Collapsed,
IsFilteringAllowed = true
};
var gvColumn1 = new GridViewDataColumn
{
Header = "注册号",
HeaderTextAlignment = TextAlignment.Center,
MinWidth = 80,
DataMemberBinding = new System.Windows.Data.Binding("RegNumber")
};
var gvColumn2 = new GridViewDataColumn
{
Header = "运营权人",
HeaderTextAlignment = TextAlignment.Center,
MinWidth = 80,
DataMemberBinding =
new System.Windows.Data.Binding("AirlinesName")
};
var gvColumn3 = new GridViewDataColumn
{
Header = "所有权人",
HeaderTextAlignment = TextAlignment.Center,
MinWidth = 80,
DataMemberBinding = new System.Windows.Data.Binding("SupplierName")
};
var gvColumn4 = new GridViewDataColumn
{
Header = "制造商",
HeaderTextAlignment = TextAlignment.Center,
MinWidth = 80,
DataMemberBinding =
new System.Windows.Data.Binding("ManufacturerName")
};
var gvColumn5 = new GridViewDataColumn
{
Header = "座级",
HeaderTextAlignment = TextAlignment.Center,
MinWidth = 80,
DataMemberBinding = new System.Windows.Data.Binding("Regional")
};
var gvColumn6 = new GridViewDataColumn
{
Header = "机型",
HeaderTextAlignment = TextAlignment.Center,
MinWidth = 80,
DataMemberBinding =
new System.Windows.Data.Binding("AircraftTypeName")
};
var gvColumn7 = new GridViewDataColumn
{
Header = "引进方式",
HeaderTextAlignment = TextAlignment.Center,
MinWidth = 80,
DataMemberBinding =
new System.Windows.Data.Binding("ImportCategoryName")
};
var gvColumn8 = new GridViewDataColumn
{
Header = "出厂日期",
HeaderTextAlignment = TextAlignment.Center,
MinWidth = 80,
};
var bingding8 = new System.Windows.Data.Binding("FactoryDate") { StringFormat = "yyyy/M/d" };
gvColumn8.DataMemberBinding = bingding8;
var gvColumn9 = new GridViewDataColumn
{
Header = "座位数(座)",
HeaderTextAlignment = TextAlignment.Center,
MinWidth = 80,
DataMemberBinding =
new System.Windows.Data.Binding("SeatingCapacity")
};
var gvColumn10 = new GridViewDataColumn
{
Header = "商载量(吨)",
HeaderTextAlignment = TextAlignment.Center,
MinWidth = 80,
DataMemberBinding =
new System.Windows.Data.Binding("CarryingCapacity")
};
//System.Windows.Data.Binding bingding10 = new System.Windows.Data.Binding("AircraftBusinesses");
//bingding10.Converter = new SelectedTimeConverter();
//bingding10.ConverterParameter = "CarryingCapacity";
//gvColumn10.DataMemberBinding = bingding10;
var gvColumn11 = new DataPageSerialColumn();
var dictionary = new ResourceDictionary
{
Source = new Uri("/UniCloud.Presentation;component/Resources/UcStyles.xaml",
UriKind.Relative)
};
gvColumn11.Header = "序号";
gvColumn11.CellStyle = (Style)dictionary["style"];
rgView.Columns.Add(gvColumn11);
rgView.Columns.Add(gvColumn1);
rgView.Columns.Add(gvColumn2);
rgView.Columns.Add(gvColumn3);
rgView.Columns.Add(gvColumn4);
rgView.Columns.Add(gvColumn5);
rgView.Columns.Add(gvColumn6);
rgView.Columns.Add(gvColumn7);
rgView.Columns.Add(gvColumn8);
rgView.Columns.Add(gvColumn9);
rgView.Columns.Add(gvColumn10);
return rgView;
}
public ColumnCreatedEventArgs(GridViewDataColumn gridViewDataColumnWithInfo) {
_gridViewDataColumnWithInfo = gridViewDataColumnWithInfo;
}
/// <summary>
/// 初始化RadWindow控件的Content的值
/// </summary>
/// <returns></returns>
public RadGridView CreateGridView()
{
RadGridView gridview = new RadGridView();
gridview.ShowGroupPanel = false;
gridview.AutoGenerateColumns = false;
gridview.CanUserFreezeColumns = false;
gridview.CanUserResizeRows = false;
gridview.IsReadOnly = true;
gridview.IsFilteringAllowed = false;
gridview.RowIndicatorVisibility = Visibility.Collapsed;
GridViewDataColumn gv1 = new GridViewDataColumn();
gv1.Header = "运营开始";
System.Windows.Data.Binding bing1 = new System.Windows.Data.Binding("StartDate");
bing1.StringFormat = "yyyy/M/d";
gv1.DataMemberBinding = bing1;
GridViewDataColumn gv2 = new GridViewDataColumn();
gv2.Header = "运营结束";
System.Windows.Data.Binding bing2 = new System.Windows.Data.Binding("StartDate");
bing2.StringFormat = "yyyy/M/d";
gv2.DataMemberBinding = bing2;
GridViewDataColumn gv3 = new GridViewDataColumn();
gv3.Header = "航空公司";
gv3.DataMemberBinding = new System.Windows.Data.Binding("Airlines.ShortName");
GridViewDataColumn gv4 = new GridViewDataColumn();
gv4.Header = "飞机号";
gv4.DataMemberBinding = new System.Windows.Data.Binding("Aircraft.RegNumber");
GridViewDataColumn gv5 = new GridViewDataColumn();
gv5.Header = "机型";
gv5.DataMemberBinding = new System.Windows.Data.Binding("Aircraft.AircraftType.Name");
GridViewDataColumn gv6 = new GridViewDataColumn();
gv6.Header = "引进方式";
gv6.DataMemberBinding = new System.Windows.Data.Binding("ImportCategory.ActionName");
GridViewDataColumn gv7 = new GridViewDataColumn();
gv7.Header = "退出方式";
gv7.DataMemberBinding = new System.Windows.Data.Binding("ExportCategory.ActionName");
GridViewDataColumn gv8 = new GridViewDataColumn();
gv8.Header = "备注";
gv8.DataMemberBinding = new System.Windows.Data.Binding("Note");
gridview.Columns.Add(gv1);
gridview.Columns.Add(gv2);
gridview.Columns.Add(gv3);
gridview.Columns.Add(gv4);
gridview.Columns.Add(gv5);
gridview.Columns.Add(gv6);
gridview.Columns.Add(gv7);
gridview.Columns.Add(gv8);
return gridview;
}
public ColumnInfo(GridViewDataColumn gridViewColumn)
{
this.gridViewColumn = gridViewColumn;
}
/// <summary>
/// The generated columns for grid.
/// </summary>
/// <returns>
/// The <see cref="GridViewColumnCollection"/>.
/// </returns>
private GridViewColumnCollection GeneratedColumnsForGrid()
{
if (MembersTable == null)
{
return null;
}
var columns = new GridViewColumnCollection();
/*
// Toggle Row Details.
if (!string.IsNullOrEmpty(RowDetailTemplateKey))
{
GridViewToggleRowDetailsColumn toggleColumn = new GridViewToggleRowDetailsColumn();
toggleColumn.SetBinding(GridViewToggleRowDetailsColumn.IsVisibleProperty, new Binding
{
Path = new PropertyPath("IsShowToggleRowDetail"),
Mode = BindingMode.TwoWay
});
columns.Add(toggleColumn);
}
*/
// Get Data Template for Columns
DataTemplate columnSelectedHoverTemplate = (DataTemplate)Application.Current.Resources["ColumnSelectedHoverTemplate"];
DataTemplate columnCheckedTemplate = (DataTemplate)Application.Current.Resources["ColumnCheckedTemplate"];
DataTemplate columnRadioTemplate = (DataTemplate)Application.Current.Resources["ColumnRadioSelectedHoverTemplate"];
DataTemplate columnEditDelSelectedHoverTemplate = (DataTemplate)Application.Current.Resources["ColumnEditDelSelectedHoverTemplate"];
foreach (var dcolumn in MembersTable.Columns)
{
var gridColumn = new GridViewDataColumn { Header = dcolumn.Header, UniqueName = dcolumn.ColumnName };
DynamicColumn customColumn = GridColumns.FirstOrDefault(d => d.ColumnName == dcolumn.ColumnName);
var path = gridColumn.DataMemberBinding.Path.Path;
gridColumn.DataMemberBinding = new Binding
{
Path = new PropertyPath(path),
Mode = BindingMode.TwoWay
};
if (customColumn != null)
{
// Set Data Template for Columns
if (customColumn.IsSelectedColumn && columnSelectedHoverTemplate != null)
{
gridColumn.CellTemplate = columnSelectedHoverTemplate;
}
if (customColumn.IsRadioSelectedColumn && columnRadioTemplate != null)
{
gridColumn.CellTemplate = columnRadioTemplate;
}
if (customColumn.Width != 0)
{
gridColumn.Width = customColumn.Width;
}
if (customColumn.MinWidth != 0)
{
gridColumn.MinWidth = customColumn.MinWidth;
}
if (customColumn.DataFormatString != null)
{
gridColumn.DataFormatString = customColumn.DataFormatString;
}
if (!this.IsGridReadOnly)
{
gridColumn.IsReadOnly = customColumn.IsReadOnly;
}
gridColumn.TextAlignment = customColumn.TextAlignment;
gridColumn.HeaderTextAlignment = customColumn.HeaderTextAlignment;
if (FilteringGenerate)
{
switch (customColumn.FilteringTemplate)
{
case RadGridViewEnum.FilteringDataList:
gridColumn.IsFilterable = true;
gridColumn.FilterMemberPath = gridColumn.UniqueName;
//// column.DataMemberBinding = column.UniqueName;
gridColumn.FilteringControl = new FilteringDataList
{
ItemsSource = customColumn.FilteringDataSource,
IsMultiSelect = true,
Title = customColumn.FilteringTitle
};
break;
case RadGridViewEnum.TextFieldFilter:
gridColumn.IsFilterable = true;
gridColumn.FilterMemberPath = gridColumn.UniqueName;
gridColumn.FilteringControl = new TextFieldFilter
{
AllOperators1 = customColumn.AllOperators,
AllOperators2 = customColumn.AllOperators,
AllLogicalOperator = customColumn.LogicalOperators,
IsNumber = false
};
break;
case RadGridViewEnum.FilteringComparision:
gridColumn.IsFilterable = true;
gridColumn.FilterMemberPath = gridColumn.UniqueName;
gridColumn.FilteringControl = new FilteringComparision
{
AllOperators1 = customColumn.AllOperators,
AllOperators2 = customColumn.AllOperators,
AllLogicalOperator = customColumn.LogicalOperators,
IsNumber = false
};
break;
case RadGridViewEnum.TextFieldDataListFilter:
gridColumn.IsFilterable = true;
gridColumn.FilterMemberPath = gridColumn.UniqueName;
gridColumn.FilteringControl = new TextFieldDataListFilter
{
ItemsSource = customColumn.FilteringDataSource,
IsMultiSelect = true,
Title = customColumn.FilteringTitle,
AllOperators1 = customColumn.AllOperators,
AllOperators2 = customColumn.AllOperators,
AllLogicalOperator = customColumn.LogicalOperators,
IsNumber = false
};
break;
default:
gridColumn.IsFilterable = false;
break;
}
}
else
{
gridColumn.IsFilterable = false;
}
switch (customColumn.ColumnTemplate)
{
case RadGridViewEnum.ColumnCheckedTemplate:
if (columnCheckedTemplate != null)
{
gridColumn.CellTemplate = columnCheckedTemplate;
}
else
{
gridColumn.CellTemplate = columnRadioTemplate;
}
break;
case RadGridViewEnum.ColumnRadioSelectedHoverTemplate:
if (customColumn.IsRadioSelectedColumn)
{
gridColumn.CellTemplate = columnRadioTemplate;
}
break;
case RadGridViewEnum.ColumnSelectedHoverTemplate:
break;
case RadGridViewEnum.ColumnEditDelSelectedHoverTemplate:
if (columnEditDelSelectedHoverTemplate != null)
{
gridColumn.CellTemplate = columnEditDelSelectedHoverTemplate;
}
break;
}
}
columns.Add(gridColumn);
}
return columns;
}
