Esempio n. 1
0
 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);
 }
Esempio n. 2
0
        /// <summary>
        /// Returns <see cref="GridViewEditDataColumn"/> instance based on meta data passed in column argument.
        /// </summary>
        /// <param name="column">An instance of <see cref="ColumnMeta"/> containing meta data of column to be created.</param>
        /// <param name="connectionString">Connection string to underlying database.</param>
        /// <returns></returns>
        internal static GridViewEditDataColumn AddGridViewDataColumn(ColumnMeta column, string connectionString)
        {
            GridViewEditDataColumn dataColumn = null;

            // As per 11 Oct 2016, the following evaluation criteria for data type and its column editor are not yet complete.
            // We still has some works to do to deal with picture and blob/document. (--github.com/ganagus)
            // ---
            if ((new TypeCode[] { TypeCode.String, TypeCode.Int64, TypeCode.Int32, TypeCode.Single, TypeCode.Decimal })
                .Contains(column.DataType) && !column.IsForeignKey && string.IsNullOrEmpty(column.EnumTypeName))
            {
                // regular text column, editor => text box
                dataColumn = AddGridViewDataTextColumn(column, dataColumn);
            }
            else if (!string.IsNullOrEmpty(column.EnumTypeName))
            {
                // enum data type column, editor => check box
                dataColumn = AddGridViewEnumColumn(column, dataColumn);
            }
            // foreign key should be rendered in combo box column
            else if (column.IsForeignKey)
            {
                // foreign key column, it's a look up to other table, editor => combo box
                dataColumn = AddGridViewForeignKeyColumn(column, dataColumn, connectionString);
            }
            else if (column.DataType == TypeCode.DateTime)
            {
                // date / datetime column, editor => DevExpress date editor
                dataColumn = new GridViewDataDateColumn();
                if (column.Name.ToLower() == "createddate" || column.Name.ToLower() == "modifieddate")
                {
                    //hide createdby, createddate, modifiedby, modifieddate from edit form
                    //dataColumn.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False;
                }
            }
            else if (column.DataType == TypeCode.Boolean)
            {
                // boolean column, editor => check box
                dataColumn = new GridViewDataCheckColumn();
            }
            else
            {
                // other data type, default to text box
                dataColumn = new GridViewDataTextColumn();
            }

            if (column.IsIdentity)
            {
                dataColumn.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False;
            }

            dataColumn.FieldName    = column.Name;
            dataColumn.Caption      = column.Caption;
            dataColumn.VisibleIndex = column.OrderNo;

            return(dataColumn);
        }
Esempio n. 3
0
    protected void cmbDate1_SelectedIndexChanged(object sender, EventArgs e)
    {
        GridViewDataDateColumn column1 = grid1.Columns["BirthDate"] as GridViewDataDateColumn;

        column1.PropertiesDateEdit.DisplayFormatString = cmbDate1.Text;

        // grid1 hierarchy re-creation
        grid1.DataBind();

        // grid2 hierarchy re-creation
        grid2.DataBind();
    }
Esempio n. 4
0
    protected void Page_Load(Object sender, EventArgs e)
    {
        // grid1 initialization
        if (!IsPostBack)
        {
            GridViewDataDateColumn column1 = grid1.Columns["BirthDate"] as GridViewDataDateColumn;
            column1.PropertiesDateEdit.DisplayFormatString = cmbDate1.Text;
        }

        // grid2 initialization
        GridViewDataDateColumn column2 = grid2.Columns["BirthDate"] as GridViewDataDateColumn;

        column2.PropertiesDateEdit.DisplayFormatString = cmbDate2.Text;
    }
        public static void ASPxGridViewInit(this ASPxGridView grid)
        {
            grid.SettingsLoadingPanel.Text      = "加载中";
            grid.SettingsBehavior.ConfirmDelete = true;

            foreach (var col in grid.Columns)
            {
                if (col.GetType() == typeof(GridViewDataDateColumn))
                {
                    GridViewDataDateColumn cus_col = col as GridViewDataDateColumn;
                    cus_col.PropertiesDateEdit.CalendarProperties.ClearButtonText = "取消";
                    cus_col.PropertiesDateEdit.CalendarProperties.TodayButtonText = "今天";
                }
            }
        }
    private void InitializeControls()
    {
        GridViewDataDateColumn cDate = (GridViewDataDateColumn)gdvReleasedCredit.Columns[COLUMN_INIT_DATE];

        cDate.PropertiesDateEdit.DisplayFormatString = base.DateOutputFormat;
        cDate.FieldName = COLUMN_INIT_DATE;
        cDate.Caption   = "Initial Investment Date";

        cDate = (GridViewDataDateColumn)gdvReleasedCredit.Columns[COLUMN_TRADEDATE];
        cDate.PropertiesDateEdit.DisplayFormatString = base.DateOutputFormat;
        cDate.FieldName = COLUMN_TRADEDATE;
        cDate.Caption   = Resource_Global.TradeDate;

        GridViewDataTextColumn cRemainingUnits = (GridViewDataTextColumn)gdvReleasedCredit.Columns[COLUMN_REMAINING_UNITS];

        cRemainingUnits.PropertiesEdit.DisplayFormatString = "#,###.0000";
        cRemainingUnits.FieldName = COLUMN_REMAINING_UNITS;
        cRemainingUnits.Caption   = "Remaining Units";

        gdvReleasedCredit.TotalSummary.Add(new ASPxSummaryItem(COLUMN_REMAINING_UNITS, DevExpress.Data.SummaryItemType.Sum)
        {
            DisplayFormat = "#,###.0000", Tag = "Remaining Units"
        });
    }
Esempio n. 7
0
 /// <summary>
 /// Ham tạo Column cho Gridview loại GridViewDataDateColumn
 /// </summary>
 /// <param name="Caption">Tiêu đề cho column</param>
 /// <param name="FieldName">FieldName cho column</param>
 /// <param name="Width">Độ rộng cho column</param>
 /// <param name="Format">Định dạng của column</param>
 /// <returns>GridViewDataDateColumn</returns>
 public GridViewDataDateColumn BuildDateColumn(string Caption, string FieldName, string Alias, int Width, string Format)
 {
     GridViewDataDateColumn dateColumn = new GridViewDataDateColumn();
     dateColumn.Caption = Caption;
     dateColumn.FieldName = Alias + FieldName;
     if (Width != 0)
         dateColumn.Width = Unit.Pixel(Width);
     else if (Utils.isMobileBrowser())
         dateColumn.MinWidth = 80;
     dateColumn.PropertiesDateEdit.DisplayFormatString = Format;
     return dateColumn;
 }
Esempio n. 8
0
        protected void ReCreateColumns()
        {
            gridLogRecords.Columns.Clear();
            //create columns
            switch (this.LogType)
            {
            case LogTypesEnum.ProductMappingHistory:
                gridLogRecords.KeyFieldName = "RecordId";
                GridViewDataDateColumn dateColumn = new GridViewDataDateColumn();
                dateColumn.Caption   = Utilities.GetResourceString("Common", "LogDate");
                dateColumn.FieldName = "LogDate";
                dateColumn.PropertiesDateEdit.DisplayFormatString = "dd.MM.yyyy HH:mm";
                dateColumn.VisibleIndex = 0;
                gridLogRecords.Columns.Add(dateColumn);
                GridViewDataTextColumn stateColumn = new GridViewDataTextColumn();
                stateColumn.Caption      = Utilities.GetResourceString("Common", "LogStatus");
                stateColumn.FieldName    = string.Format("Enum.Name{0}", SessionManager.CurrentShortLanguage);
                stateColumn.VisibleIndex = 1;
                gridLogRecords.Columns.Add(stateColumn);
                break;

            case LogTypesEnum.ChannelMonitoringHistory:
                gridLogRecords.KeyFieldName = "LogId";
                GridViewDataDateColumn logDateColumn = new GridViewDataDateColumn();
                logDateColumn.Caption   = Utilities.GetResourceString("Common", "LogDate");
                logDateColumn.FieldName = "LogDate";
                logDateColumn.PropertiesDateEdit.DisplayFormatString = "dd.MM.yyyy HH:mm";
                logDateColumn.VisibleIndex = 0;
                gridLogRecords.Columns.Add(logDateColumn);
                GridViewDataTextColumn statusColumn = new GridViewDataTextColumn();
                statusColumn.Caption      = Utilities.GetResourceString("Common", "LogStatus");
                statusColumn.FieldName    = string.Format("Enum.Name{0}", SessionManager.CurrentShortLanguage);
                statusColumn.VisibleIndex = 1;
                gridLogRecords.Columns.Add(statusColumn);
                break;

            case LogTypesEnum.ProductImportHistory:
                GridViewDataDateColumn impDateColumn = new GridViewDataDateColumn();
                impDateColumn.Caption   = Utilities.GetResourceString("Common", "LogDate");
                impDateColumn.FieldName = "LogDate";
                impDateColumn.PropertiesDateEdit.DisplayFormatString = "dd.MM.yyyy HH:mm";
                impDateColumn.VisibleIndex = 0;
                gridLogRecords.Columns.Add(impDateColumn);
                GridViewDataTextColumn userColumn = new GridViewDataTextColumn();
                userColumn.Caption      = Utilities.GetResourceString("Common", "FullName");
                userColumn.FieldName    = "FullName";
                userColumn.VisibleIndex = 1;
                gridLogRecords.Columns.Add(userColumn);
                break;

            case LogTypesEnum.RecommendedPriceHistory:
                gridLogRecords.KeyFieldName = "LogId";
                GridViewDataDateColumn recDateColumn = new GridViewDataDateColumn();
                recDateColumn.Caption   = Utilities.GetResourceString("Common", "LogDate");
                recDateColumn.FieldName = "RecomDate";
                recDateColumn.PropertiesDateEdit.DisplayFormatString = "dd.MM.yyyy";
                recDateColumn.VisibleIndex = 0;
                gridLogRecords.Columns.Add(recDateColumn);
                GridViewDataTextColumn recUserColumn = new GridViewDataTextColumn();
                recUserColumn.Caption      = Utilities.GetResourceString("Common", "FullName");
                recUserColumn.FieldName    = "User.FullName";
                recUserColumn.VisibleIndex = 1;
                gridLogRecords.Columns.Add(recUserColumn);
                GridViewDataTextColumn recTypeColumn = new GridViewDataTextColumn();
                recTypeColumn.Caption      = Utilities.GetResourceString("Common", "ChangeType");
                recTypeColumn.FieldName    = string.Format("Enum.Name{0}", SessionManager.CurrentShortLanguage);
                recTypeColumn.VisibleIndex = 2;
                gridLogRecords.Columns.Add(recTypeColumn);
                GridViewDataTextColumn recPriceColumn = new GridViewDataTextColumn();
                recPriceColumn.Caption      = Utilities.GetResourceString("Common", "NewPrice");
                recPriceColumn.FieldName    = "Price";
                recPriceColumn.VisibleIndex = 3;
                gridLogRecords.Columns.Add(recPriceColumn);
                break;

            case LogTypesEnum.ChannelLog:
                gridLogRecords.KeyFieldName = "ErrorId";
                GridViewDataTextColumn errorColumn = new GridViewDataTextColumn();
                errorColumn.Caption      = Utilities.GetResourceString("Common", "ErrorType");
                errorColumn.FieldName    = string.Format("Enum.Name{0}", SessionManager.CurrentShortLanguage);
                errorColumn.VisibleIndex = 0;
                gridLogRecords.Columns.Add(errorColumn);
                GridViewDataTextColumn prodColumn = new GridViewDataTextColumn();
                prodColumn.Caption      = Utilities.GetResourceString("Common", "ProductName");
                prodColumn.FieldName    = "ProductName";
                prodColumn.VisibleIndex = 1;
                gridLogRecords.Columns.Add(prodColumn);
                break;
            }
        }
Esempio n. 9
0
        internal static void BuildColumnsByEntity(BusinessMapper.eEntities entidad, ASPxGridView gv)
        {
            if (BusinessMapper.AbmConfigXmlPath == null || BusinessMapper.AbmConfigXmlPath == string.Empty)
                throw new Exception("Path del archivo AbmConfig.xml sin definir.");

            XmlDocument xDoc = new XmlDocument();

            xDoc.Load(BusinessMapper.AbmConfigXmlPath);

            gv.Columns.Clear();

            if (xDoc.SelectSingleNode(
                "Entities/Entity[@EntityName='" + entidad.ToString() + "']") == null)
                throw new AbmConfigXMLException("No existe la configuración de mapeo para la entidad: " + entidad.ToString());

            foreach (XmlNode nodeControl in xDoc.SelectSingleNode(
                "Entities/Entity[@EntityName='" + entidad.ToString() + "']").ChildNodes)
            {

                if (nodeControl.Attributes["ControlType"].Value == "ComboBox")
                {
                    GridViewDataComboBoxColumn gvc = new GridViewDataComboBoxColumn();

                    gvc.Name = nodeControl.Attributes["FieldName"].Value;
                    gvc.Caption = nodeControl.Attributes["Title"].Value;
                    gvc.FieldName = nodeControl.Attributes["FieldName"].Value;

                    var mapInfo = BusinessMapper.GetMapInfo(nodeControl.Attributes["EntityName"].Value);

                    gvc.PropertiesComboBox.TextField = mapInfo.EntityTextField;
                    gvc.PropertiesComboBox.ValueField = mapInfo.EntityValueField;
                    gvc.PropertiesComboBox.DataSource = mapInfo.DAOHandler.ReadAll("");

                    gv.Columns.Add(gvc);
                }
                else if (nodeControl.Attributes["ControlType"].Value == "RadioButtonList")
                {
                    GridViewDataComboBoxColumn gvc = new GridViewDataComboBoxColumn();

                    gvc.Name = nodeControl.Attributes["FieldName"].Value;
                    gvc.Caption = nodeControl.Attributes["Title"].Value;
                    gvc.FieldName = nodeControl.Attributes["FieldName"].Value;

                    gvc.PropertiesComboBox.Items.Clear();
                    foreach (XmlNode item in nodeControl.ChildNodes[0].ChildNodes)
                    {
                        gvc.PropertiesComboBox.Items.Add(item.Attributes["Name"].Value, item.Attributes["Value"].Value);
                    }

                    gv.Columns.Add(gvc);
                }
                else if (nodeControl.Attributes["ControlType"].Value == "TextBox"
                    || nodeControl.Attributes["ControlType"].Value == "SpinEdit"
                    || nodeControl.Attributes["ControlType"].Value == "TimeEdit")
                {
                    GridViewDataTextColumn gvc = new GridViewDataTextColumn();

                    gvc.Name = nodeControl.Attributes["FieldName"].Value;
                    gvc.Caption = nodeControl.Attributes["Title"].Value;
                    gvc.FieldName = nodeControl.Attributes["FieldName"].Value;

                    gv.Columns.Add(gvc);
                }
                else if (nodeControl.Attributes["ControlType"].Value == "DateEdit")
                {
                    GridViewDataDateColumn gvc = new GridViewDataDateColumn();

                    gvc.Name = nodeControl.Attributes["FieldName"].Value;
                    gvc.Caption = nodeControl.Attributes["Title"].Value;
                    gvc.FieldName = nodeControl.Attributes["FieldName"].Value;

                    gv.Columns.Add(gvc);
                }
                else if (nodeControl.Attributes["ControlType"].Value == "CheckBox")
                {
                    GridViewDataCheckColumn gvc = new GridViewDataCheckColumn();

                    gvc.Name = nodeControl.Attributes["FieldName"].Value;
                    gvc.Caption = nodeControl.Attributes["Title"].Value;
                    gvc.FieldName = nodeControl.Attributes["FieldName"].Value;

                    gv.Columns.Add(gvc);
                }
            }
        }
Esempio n. 10
0
        internal static void BuildColumnsByEntity(BusinessMapper.eEntities entidad, ASPxGridView gv)
        {
            if (BusinessMapper.AbmConfigXmlPath == null || BusinessMapper.AbmConfigXmlPath == string.Empty)
            {
                throw new Exception("Path del archivo AbmConfig.xml sin definir.");
            }

            XmlDocument xDoc = new XmlDocument();

            xDoc.Load(BusinessMapper.AbmConfigXmlPath);

            gv.Columns.Clear();

            if (xDoc.SelectSingleNode(
                    "Entities/Entity[@EntityName='" + entidad.ToString() + "']") == null)
            {
                throw new AbmConfigXMLException("No existe la configuración de mapeo para la entidad: " + entidad.ToString());
            }


            foreach (XmlNode nodeControl in xDoc.SelectSingleNode(
                         "Entities/Entity[@EntityName='" + entidad.ToString() + "']").ChildNodes)
            {
                if (nodeControl.Attributes["ControlType"].Value == "ComboBox")
                {
                    GridViewDataComboBoxColumn gvc = new GridViewDataComboBoxColumn();

                    gvc.Name      = nodeControl.Attributes["FieldName"].Value;
                    gvc.Caption   = nodeControl.Attributes["Title"].Value;
                    gvc.FieldName = nodeControl.Attributes["FieldName"].Value;

                    var mapInfo = BusinessMapper.GetMapInfo(nodeControl.Attributes["EntityName"].Value);

                    gvc.PropertiesComboBox.TextField  = mapInfo.EntityTextField;
                    gvc.PropertiesComboBox.ValueField = mapInfo.EntityValueField;
                    gvc.PropertiesComboBox.DataSource = mapInfo.DAOHandler.ReadAll("");

                    gv.Columns.Add(gvc);
                }
                else if (nodeControl.Attributes["ControlType"].Value == "RadioButtonList")
                {
                    GridViewDataComboBoxColumn gvc = new GridViewDataComboBoxColumn();

                    gvc.Name      = nodeControl.Attributes["FieldName"].Value;
                    gvc.Caption   = nodeControl.Attributes["Title"].Value;
                    gvc.FieldName = nodeControl.Attributes["FieldName"].Value;

                    gvc.PropertiesComboBox.Items.Clear();
                    foreach (XmlNode item in nodeControl.ChildNodes[0].ChildNodes)
                    {
                        gvc.PropertiesComboBox.Items.Add(item.Attributes["Name"].Value, item.Attributes["Value"].Value);
                    }

                    gv.Columns.Add(gvc);
                }
                else if (nodeControl.Attributes["ControlType"].Value == "TextBox" ||
                         nodeControl.Attributes["ControlType"].Value == "SpinEdit" ||
                         nodeControl.Attributes["ControlType"].Value == "TimeEdit")
                {
                    GridViewDataTextColumn gvc = new GridViewDataTextColumn();

                    gvc.Name      = nodeControl.Attributes["FieldName"].Value;
                    gvc.Caption   = nodeControl.Attributes["Title"].Value;
                    gvc.FieldName = nodeControl.Attributes["FieldName"].Value;

                    gv.Columns.Add(gvc);
                }
                else if (nodeControl.Attributes["ControlType"].Value == "DateEdit")
                {
                    GridViewDataDateColumn gvc = new GridViewDataDateColumn();

                    gvc.Name      = nodeControl.Attributes["FieldName"].Value;
                    gvc.Caption   = nodeControl.Attributes["Title"].Value;
                    gvc.FieldName = nodeControl.Attributes["FieldName"].Value;

                    gv.Columns.Add(gvc);
                }
                else if (nodeControl.Attributes["ControlType"].Value == "CheckBox")
                {
                    GridViewDataCheckColumn gvc = new GridViewDataCheckColumn();

                    gvc.Name      = nodeControl.Attributes["FieldName"].Value;
                    gvc.Caption   = nodeControl.Attributes["Title"].Value;
                    gvc.FieldName = nodeControl.Attributes["FieldName"].Value;

                    gv.Columns.Add(gvc);
                }
            }
        }
Esempio n. 11
0
        public void CrearColumnas(string strTipoDato, string strColumna, ASPxGridView grvGrilla, bool bolVisible, DataTable dtbCombo,
                                  string strCampoClave, string strCampoTexto, string srEtiqueta, string strFormato)
        {
            switch (strTipoDato)
            {
            case "String":
                // columna normal
                GridViewDataTextColumn colText = new GridViewDataTextColumn();
                colText.FieldName = strColumna;
                colText.Visible   = bolVisible;
                //colText.Caption = srEtiqueta;
                grvGrilla.Columns.Add(colText);
                break;

            case "Int32":
                // columna normal
                if (!bolVisible)
                {
                    GridViewDataTextColumn colInt = new GridViewDataTextColumn();
                    colInt.FieldName = strColumna;
                    //colInt.Caption = srEtiqueta;
                    colInt.Visible = false;
                    grvGrilla.Columns.Add(colInt);
                }
                else
                {
                    GridViewDataSpinEditColumn colInt1 = new GridViewDataSpinEditColumn();
                    colInt1.FieldName = strColumna;
                    //colInt1.Caption = srEtiqueta;
                    colInt1.Visible = bolVisible;
                    colInt1.PropertiesSpinEdit.SpinButtons.ShowIncrementButtons = false;
                    colInt1.PropertiesEdit.DisplayFormatString = "N0";
                    grvGrilla.Columns.Add(colInt1);
                }
                break;

            case "Double":
                GridViewDataSpinEditColumn colDouble = new GridViewDataSpinEditColumn();
                colDouble.FieldName = strColumna;
                //colDouble.Caption = srEtiqueta;
                colDouble.Visible = bolVisible;
                colDouble.PropertiesSpinEdit.SpinButtons.ShowIncrementButtons = false;
                colDouble.PropertiesEdit.DisplayFormatString = "N4";
                grvGrilla.Columns.Add(colDouble);
                break;

            case "Time":
                GridViewDataTimeEditColumn colTime = new GridViewDataTimeEditColumn();
                colTime.FieldName = strColumna;
                //colTime.Caption = srEtiqueta;
                colTime.Visible = bolVisible;
                colTime.PropertiesTimeEdit.DisplayFormatString = "HH:mm";
                colTime.PropertiesTimeEdit.EditFormat          = EditFormat.Custom;
                colTime.PropertiesTimeEdit.EditFormatString    = "HH:mm";
                colTime.PropertiesTimeEdit.SpinButtons.ShowIncrementButtons = false;
                colTime.PropertiesTimeEdit.DisplayFormatInEditMode          = true;
                grvGrilla.Columns.Add(colTime);

                break;

            case "Date":
                // columna normal
                GridViewDataDateColumn colDate = new GridViewDataDateColumn();
                colDate.FieldName = strColumna;
                //colDate.Caption = srEtiqueta;
                colDate.Visible = bolVisible;
                colDate.PropertiesDateEdit.DisplayFormatString = "dd-MM-yyyy";
                //colDate.PropertiesDateEdit.ValidationSettings.RequiredField.IsRequired = ValidationSettings.;
                grvGrilla.Columns.Add(colDate);
                break;

            case "DateTime":
                // columna normal
                GridViewDataDateColumn colDateTime = new GridViewDataDateColumn();
                colDateTime.FieldName = strColumna;
                //colDateTime.Caption = srEtiqueta;
                colDateTime.Visible = bolVisible;
                colDateTime.PropertiesDateEdit.DisplayFormatString = "dd-MM-yyyy HH:mm";
                grvGrilla.Columns.Add(colDateTime);
                break;

            case "ComboBox":
                GridViewDataComboBoxColumn colCbo = new GridViewDataComboBoxColumn();
                colCbo.FieldName = strColumna;
                //colCbo.Caption = srEtiqueta;
                colCbo.PropertiesComboBox.ValueType        = typeof(int);
                colCbo.PropertiesComboBox.ValueField       = strCampoClave;
                colCbo.PropertiesComboBox.TextField        = strCampoTexto;
                colCbo.PropertiesComboBox.TextFormatString = "{0}";     // imprime la columna con indice 0
                                                                        //colCbo.PropertiesComboBox.EnableSynchronization = DevExpress.Utils.DefaultBoolean.True;
                colCbo.PropertiesComboBox.DataSource = dtbCombo;
                grvGrilla.Columns.Add(colCbo);
                break;
            }
        }
Esempio n. 12
0
        private void DefineColumns()
        {
            foreach (SubjectFieldDto field in CurrentSubject.SubjectFields)
            {
                if (field.IsShowInGrid)
                {
                    if (field.FieldKey.Equals(ControlledFieldName, StringComparison.OrdinalIgnoreCase))
                    {
                        continue;
                    }
                    // Todo: implement multi-language
                    string headerText = field.GetFieldLabelByLanguage(CurrentUserContext.CurrentLanguage.Id);
                    if (field.IsLinkInGrid && field.DucType != DucTypes.Lookup && field.DucType != DucTypes.Pickup)
                    {
                        GridViewLinkButtonColumn hc = new GridViewLinkButtonColumn(headerText, field.FieldKey);
                        ucListManager.Columns.Add(hc);
                        hc.EditColumnIndex             = field.ColIndex;
                        hc.DataNavigateUrlFormatString = ServerPath + field.LookupSubjectManageUrlFormatString;
                        if (field.DucType == DucTypes.Lookup && field.LookupSubjectId != null)
                        {
                            // Link to another subject by LookupSubjectId
                            hc.DataNavigateUrlField = field.FieldKey;
                        }
                        else
                        {
                            // Link to current subject
                            if (MasterInstance != null)
                            {
                                // Add MasterInstance
                                hc.DataNavigateUrlFormatString += string.Format("&{0}={1}", QryMasterInstanceId, MasterInstance.Id);
                            }
                            hc.DataNavigateUrlField = BaseDto.FLD_StringId;
                        }
                    }
                    else
                    {
                        switch (field.DucType)
                        {
                        case DucTypes.Lookup:
                        case DucTypes.Pickup:
                            GridViewDropDownListColumn ddlCol = new GridViewDropDownListColumn(headerText, field.FieldKey, field.ListDataSource);
                            ucListManager.Columns.Add(ddlCol);
                            ddlCol.IsReadOnly      = field.IsReadonly;
                            ddlCol.enableEmptyItem = !field.IsRequired;
                            ddlCol.EditColumnIndex = field.ColIndex;
                            ddlCol.DropDownHeight  = WebContext.Current.ApplicationOption.DropDownHeight;
                            break;

                        case DucTypes.Text:
                        case DucTypes.TextArea:
                        case DucTypes.Currency:
                        case DucTypes.Email:
                        case DucTypes.Formula:
                        case DucTypes.Integer:
                        case DucTypes.Number:
                        case DucTypes.Percentage:
                            GridViewDataTextColumn textCol = new GridViewDataTextColumn(headerText, field.FieldKey);
                            ucListManager.Columns.Add(textCol);
                            textCol.IsReadOnly      = field.IsReadonly;
                            textCol.EditColumnIndex = field.ColIndex;
                            if (field.MaxLength.HasValue)
                            {
                                textCol.MaxLength = field.MaxLength.Value;
                            }
                            break;

                        case DucTypes.Date:
                            GridViewDataDateColumn dateCol = new GridViewDataDateColumn(headerText, field.FieldKey);
                            ucListManager.Columns.Add(dateCol);
                            dateCol.IsReadOnly      = field.IsReadonly;
                            dateCol.EditColumnIndex = field.ColIndex;
                            break;

                        case DucTypes.Datetime:
                            GridViewDataDateTimeColumn dateTimeCol = new GridViewDataDateTimeColumn(headerText, field.FieldKey);
                            ucListManager.Columns.Add(dateTimeCol);
                            dateTimeCol.IsReadOnly      = field.IsReadonly;
                            dateTimeCol.EditColumnIndex = field.ColIndex;
                            break;

                        case DucTypes.Time:
                            GridViewDataTimeColumn timeCol = new GridViewDataTimeColumn(headerText, field.FieldKey);
                            ucListManager.Columns.Add(timeCol);
                            timeCol.IsReadOnly      = field.IsReadonly;
                            timeCol.EditColumnIndex = field.ColIndex;
                            break;

                        case DucTypes.Image:
                            GridViewBinaryImageColumn ic = new GridViewBinaryImageColumn(headerText, field.FieldKey);
                            ucListManager.Columns.Add(ic);
                            ic.IsReadOnly      = field.IsReadonly;
                            ic.EditColumnIndex = field.ColIndex;
                            ic.ImageWidth      = 60;
                            ic.ImageHeight     = 80;
                            break;

                        case DucTypes.Attachment:
                            GridViewAttachmentColumn ac = new GridViewAttachmentColumn(headerText, field.FieldKey);
                            ucListManager.Columns.Add(ac);
                            ac.IsReadOnly              = field.IsReadonly;
                            ac.EditColumnIndex         = field.ColIndex;
                            ac.NavigateUrlFormatString = ServerPath + field.NavigateUrlFormatString;
                            ac.NavigateUrlField        = BaseDto.FLD_StringId;
                            ac.LinkTextField           = BA.Core.UIConst.FLD_LinkText;
                            break;

                        default:
                            GridViewDataColumn c = new GridViewDataColumn(headerText, field.FieldKey);
                            ucListManager.Columns.Add(c);
                            c.IsReadOnly      = field.IsReadonly;
                            c.EditColumnIndex = field.ColIndex;
                            if (field.MaxLength.HasValue)
                            {
                                c.MaxLength = field.MaxLength.Value;
                            }
                            break;
                        }
                    }
                }
            }

            if (AllowEdit)
            {
                GridViewEditCommandColumn editColumn = new GridViewEditCommandColumn();
                ucListManager.Columns.Add(editColumn);
                editColumn.UniqueName    = "edt0001";
                editColumn.NonExportable = true;
            }
            if (AllowDelete)
            {
                GridViewDeleteButtonColumn deleteColumn = new GridViewDeleteButtonColumn();
                ucListManager.Columns.Add(deleteColumn);
                deleteColumn.UniqueName              = "del0001";
                deleteColumn.NonExportable           = true;
                deleteColumn.ConfirmTextFormatString = "Are you sure to delete {0}";
                deleteColumn.ConfirmTextFields       = new string[] { BaseDto.FLD_Display };
            }
        }
Esempio n. 13
0
 protected void ReCreateColumns()
 {
     gridLogRecords.Columns.Clear();
     //create columns
     switch (this.LogType)
     {
         case LogTypesEnum.ProductMappingHistory:
             gridLogRecords.KeyFieldName = "RecordId";
             GridViewDataDateColumn dateColumn = new GridViewDataDateColumn();
             dateColumn.Caption = Utilities.GetResourceString("Common", "LogDate");
             dateColumn.FieldName = "LogDate";
             dateColumn.PropertiesDateEdit.DisplayFormatString = "dd.MM.yyyy HH:mm";
             dateColumn.VisibleIndex = 0;
             gridLogRecords.Columns.Add(dateColumn);
             GridViewDataTextColumn stateColumn = new GridViewDataTextColumn();
             stateColumn.Caption = Utilities.GetResourceString("Common", "LogStatus");
             stateColumn.FieldName = string.Format("Enum.Name{0}", SessionManager.CurrentShortLanguage);
             stateColumn.VisibleIndex = 1;
             gridLogRecords.Columns.Add(stateColumn);
             break;
         case LogTypesEnum.ChannelMonitoringHistory:
             gridLogRecords.KeyFieldName = "LogId";
             GridViewDataDateColumn logDateColumn = new GridViewDataDateColumn();
             logDateColumn.Caption = Utilities.GetResourceString("Common", "LogDate");
             logDateColumn.FieldName = "LogDate";
             logDateColumn.PropertiesDateEdit.DisplayFormatString = "dd.MM.yyyy HH:mm";
             logDateColumn.VisibleIndex = 0;
             gridLogRecords.Columns.Add(logDateColumn);
             GridViewDataTextColumn statusColumn = new GridViewDataTextColumn();
             statusColumn.Caption = Utilities.GetResourceString("Common", "LogStatus");
             statusColumn.FieldName = string.Format("Enum.Name{0}", SessionManager.CurrentShortLanguage);
             statusColumn.VisibleIndex = 1;
             gridLogRecords.Columns.Add(statusColumn);
             break;
         case LogTypesEnum.ProductImportHistory:
             GridViewDataDateColumn impDateColumn = new GridViewDataDateColumn();
             impDateColumn.Caption = Utilities.GetResourceString("Common", "LogDate");
             impDateColumn.FieldName = "LogDate";
             impDateColumn.PropertiesDateEdit.DisplayFormatString = "dd.MM.yyyy HH:mm";
             impDateColumn.VisibleIndex = 0;
             gridLogRecords.Columns.Add(impDateColumn);
             GridViewDataTextColumn userColumn = new GridViewDataTextColumn();
             userColumn.Caption = Utilities.GetResourceString("Common", "FullName");
             userColumn.FieldName = "FullName";
             userColumn.VisibleIndex = 1;
             gridLogRecords.Columns.Add(userColumn);
             break;
         case LogTypesEnum.RecommendedPriceHistory:
             gridLogRecords.KeyFieldName = "LogId";
             GridViewDataDateColumn recDateColumn = new GridViewDataDateColumn();
             recDateColumn.Caption = Utilities.GetResourceString("Common", "LogDate");
             recDateColumn.FieldName = "RecomDate";
             recDateColumn.PropertiesDateEdit.DisplayFormatString = "dd.MM.yyyy";
             recDateColumn.VisibleIndex = 0;
             gridLogRecords.Columns.Add(recDateColumn);
             GridViewDataTextColumn recUserColumn = new GridViewDataTextColumn();
             recUserColumn.Caption = Utilities.GetResourceString("Common", "FullName");
             recUserColumn.FieldName = "User.FullName";
             recUserColumn.VisibleIndex = 1;
             gridLogRecords.Columns.Add(recUserColumn);
             GridViewDataTextColumn recTypeColumn = new GridViewDataTextColumn();
             recTypeColumn.Caption = Utilities.GetResourceString("Common", "ChangeType");
             recTypeColumn.FieldName = string.Format("Enum.Name{0}", SessionManager.CurrentShortLanguage);
             recTypeColumn.VisibleIndex = 2;
             gridLogRecords.Columns.Add(recTypeColumn);
             GridViewDataTextColumn recPriceColumn = new GridViewDataTextColumn();
             recPriceColumn.Caption = Utilities.GetResourceString("Common", "NewPrice");
             recPriceColumn.FieldName = "Price";
             recPriceColumn.VisibleIndex = 3;
             gridLogRecords.Columns.Add(recPriceColumn);
             break;
         case LogTypesEnum.ChannelLog:
             gridLogRecords.KeyFieldName = "ErrorId";
             GridViewDataTextColumn errorColumn = new GridViewDataTextColumn();
             errorColumn.Caption = Utilities.GetResourceString("Common", "ErrorType");
             errorColumn.FieldName = string.Format("Enum.Name{0}", SessionManager.CurrentShortLanguage);
             errorColumn.VisibleIndex = 0;
             gridLogRecords.Columns.Add(errorColumn);
             GridViewDataTextColumn prodColumn = new GridViewDataTextColumn();
             prodColumn.Caption = Utilities.GetResourceString("Common", "ProductName");
             prodColumn.FieldName = "ProductName";
             prodColumn.VisibleIndex = 1;
             gridLogRecords.Columns.Add(prodColumn);
             break;
     }
 }