Ejemplo n.º 1
0
        public WindowSupplier(Object dbObject)
        {
            InitializeComponent();

            Width = 600;
            Height = 650;            

            _db = (DBManager)dbObject;
            dv = _db.DataTableGet("sups").DefaultView;
            dv.RowFilter = null;


            #region Initialize Control

            gridControl1.DataSource = dv;

            gridControl1.Columns.Add(new GridColumn { FieldName = "SUPPLIER", Header="Код", AllowEditing = DefaultBoolean.False });
            gridControl1.Columns.Add(new GridColumn { FieldName = "SUP_NAME", Header="Наименование", Width = 400, AllowEditing = DefaultBoolean.False });

            //gridControl1.View.FilterEditorCreated += ViewFilterEditorCreated;
            gridControl1.MouseDoubleClick += GridControl1MouseDoubleClick;

            lblFilter.Text = "Фильтр по коду:";
            tbFilter.Focus();

            #endregion
        }
Ejemplo n.º 2
0
 public Session(string login, string password, OperationModes data, OperationModes database)
 {
     _db = new DBManager();
     _merch = new Merchant(login, password);
     _doc = new Document(_db, null);
     _database = database;
     _data = data;
 }
        public WindowAuthorization()
        {
            InitializeComponent();
            labelVersion.Content = "Версия: " + new DateTime(2000, 1, 1).AddDays(Application.ResourceAssembly.GetName().Version.Build).ToShortDateString();

            #region Preliminary Connection for merch list load

            using (var db = new DBManager())
            {
                //var db = new DbManagerDynamic("rmstst", "rmstst", true);

                try
                {
                    db.ConnectionOpen("rmsprd", "golive104");
                }
                catch (ConnectionException e)
                {
                    MessageBox.Show(e.Message, "Ошибка подключения", MessageBoxButton.OK, MessageBoxImage.Error);
                    Close();
                    return;
                }
                catch (AuthorizationException e)
                {
                    MessageBox.Show(e.Message, "Ошибка авторизации", MessageBoxButton.OK, MessageBoxImage.Error);
                    Close();
                    return;
                }

                try
                {
                    _merchList = Merchant.GetMerchList(db);
                }
                catch (AssortmentException e)
                {
                    MessageBox.Show(e.Message, "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
                    Close();
                    return;
                }
                
                listLogin.ItemsSource = _merchList.Keys;
                listLogin.SelectedIndex = 0;

                db.ConnectionClose();

            }

            #endregion

            #region Initialize Background Worker

            _worker = new BackgroundWorker();
            _worker.DoWork += WorkerDoWork;
            _worker.RunWorkerCompleted += WorkerRunWorkerCompleted;
            _worker.ProgressChanged += WorkerProgressChanged;
            _worker.WorkerSupportsCancellation = true;

            #endregion
        }
Ejemplo n.º 4
0
 public Document(Object dbobject, string docType)
 {
     _db = (DBManager)dbobject;
     Id = -1;
     DocType = docType;
     _description = null;
     Saved = false;
     _db.DocChanged += DocChanged;
 }
Ejemplo n.º 5
0
 private static void Call(DBManager db, AssortmentProcedure proc)
 {
     try
     {
         var parameters = db.CallProcedure(proc);
     }
     catch (AssortmentException e)
     {
         Console.Error.WriteLine("Log Write Error: " + proc.Name + "; Message: " + e.Message);
     }
 }
        public WindowChainNative(Object dbObject, List<Chain> chainGroup)
        {
            InitializeComponent();

            _chainGroup = chainGroup;
            WindowState = WindowState.Maximized;

            _db = (DBManager)dbObject;
            dataGrid1.ItemsSource = _db.DataTableGet("chain").DefaultView;

            //dataGrid1.
        }
Ejemplo n.º 7
0
        public WindowCheck(Session session, CheckTypes checkType)
        {
            InitializeComponent();

            #region Initialize

            _session = session;
            _db = session.GetDbManager();
            _checkType = checkType;

            listBoxCheck.MouseDoubleClick += ListBoxCheckMouseDoubleClick;
            listBoxCheck.SelectionChanged += ListBoxCheckSelectionChanged;
            buttonCancel.Click += ButtonCancelClick;
            buttonSubmit.Click += ButtonSubmitClick;
            _session.GetDocument().DocProjected += DbDocProjected;

            _checkList = new List<Check>();

            try
            {
                _checkList.AddRange(_session.GetDocument().GetCheckList(_checkType));
            }
            catch (AssortmentDBException e)
            {
                MessageBox.Show(e.Message, "Ошибка", MessageBoxButton.OK, MessageBoxImage.Warning);
            }

            listBoxCheck.ItemsSource = _checkList;

            #endregion

            #region Initialize Background Worker

            _worker = new BackgroundWorker();
            _worker.DoWork += WorkerDoWork;
            _worker.RunWorkerCompleted += WorkerRunWorkerCompleted;
            _worker.ProgressChanged += WorkerProgressChanged;

            #endregion

            if (_checkList.Count == 0) return;

            _checkList[0].Status = CheckStatuses.Executing;
            _nCheck = 0;
            if (!_worker.IsBusy)
                _worker.RunWorkerAsync();
            else
            {
                MessageBox.Show("Проверки уже запущены", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Warning);
            }
        }
        public void InitializeControl(List<Column> dimensions, Object db)
        {
            _db = (DBManager)db;
            InitializeFields(dimensions);
            //SetFieldListSize(Size.Empty, new Size(250, 600));

            CellArgs = new CellInputDataEventArgs();

            #region Initialize Event Handlers

            FieldAreaChanging += PivotGridControlModifiedFieldAreaChanging;
            FieldFilterChanged += PivotGridControlModifiedFieldFilterChanged;
            CustomSummary += PivotGridControlRowOrientedCustomSummary;
            CellClick += PivotGridControlRowOrientedCellClick;

            #endregion
        }
Ejemplo n.º 9
0
        /// <summary>
        /// Gets merch list
        /// </summary>
        /// <exception cref="AssortmentException"></exception>
        /// <param name="db">DbManager object</param>
        /// <returns>Merch list</returns>
        public static SortedList<string, string> GetMerchList(DBManager db)
        {
            var parameters = db.CallProcedure(AssortmentProcedure.GetMerchList);

            var merchList = new SortedList<string, string>();
            var merches = parameters["o_recordset"] as List<Dictionary<string, object>>;
            if (merches != null)
            {
                if (merches.Count == 0) throw new AssortmentException("Список менеджеров пуст");
                foreach (var t in merches)
                {
                    merchList.Add(t["MERCH_NAME"].ToString(), t["MERCH_FAX"].ToString());
                }
            }
            else
            {
                throw new AssortmentException("Ошибка при получении списка пользователей");
            }
            return merchList;            
        }
Ejemplo n.º 10
0
 public static void LogHeadCreate(DBManager db)
 {
     Call(db, AssortmentProcedure.LogHeadCreate);
 }
Ejemplo n.º 11
0
 public static void LogHeadUpdate(DBManager db, char status)
 {
     AssortmentProcedure.LogHeadUpdate.Parameters["i_status"].Value = status;
     Call(db, AssortmentProcedure.LogHeadUpdate);
 }
Ejemplo n.º 12
0
 public static void LogDetailAdd(DBManager db, string eventType, string eventDesc)
 {
     AssortmentProcedure.LogDetailAdd.Parameters["i_event_type"].Value = eventType;
     AssortmentProcedure.LogDetailAdd.Parameters["i_event_desc"].Value = eventDesc.Substring(0, eventDesc.Length < 4000 ? eventDesc.Length : 4000);
     Call(db, AssortmentProcedure.LogDetailAdd);
 }
Ejemplo n.º 13
0
        /*
                public bool SetT(DbManagerDynamic db, List<ChainRec> buffer, int index, int wh)
                {
                    if (0 > index || index > Nodes.Count) return false;
                    if (Nodes[index].SourceWhNew.State == ValueState.Valid)
                    {
                        if (Nodes[index].SourceWhNew.Value.Equals(wh)) return true;
                    }

                    if (RecExists(Nodes, Nodes[0].Item, wh)) return false;

                    Nodes[index].SourceWhNew = new ChainValue(wh);

                    for (int i = index + 1; i < Nodes.Count; i++)
                    {
                        Nodes.RemoveAt(i);
                        i--;
                    }

                    int loc = wh;
                    while (loc != 0 && loc != -2)
                    {
                        var chainRec = FindRec(buffer, Nodes[0].Item, loc);
                        if (chainRec == null)
                        {
                            var chainRecNew = db.LogisticChainGetRec(Nodes[0].Item, loc);
                            if (chainRecNew == null) break;
                            buffer.Add(chainRecNew);
                            chainRec = chainRecNew;
                        }
                        chainRec.Id = Nodes[0].Id;
                        Nodes.Add(chainRec);
                        loc = Convert.ToInt32(chainRec.SourceWhNew.Value);
                        if (RecExists(Nodes, Nodes[0].Item, loc))
                        {
                            break;
                        }
                    }
                    UpdateSequence();
                    return true;
                }
        */
        public bool SetW(DBManager db, List<ChainRec> buffer, int index, int wh)
        {
            if (0 > index || index > Nodes.Count) return false;
            if (Nodes[index].SourceWhNew != null)
                if (Nodes[index].SourceWhNew.State == ValueStates.Valid)
                {
                    if (Nodes[index].SourceWhNew.Value.Equals(wh)) return true;
                }

            if (RecExists(Nodes, Nodes[0].Item, wh)) return false;

            Nodes[index].SourceWhNew = new ChainValue(wh);

            for (int i = index + 1; i < Nodes.Count; i++)
            {
                Nodes.RemoveAt(i);
                i--;
            }

            int loc = wh;
            while (loc != 0 && loc != -2)
            {
                var chainRec = FindRec(buffer, Nodes[0].Item, loc);
                if (chainRec == null)
                {
                    var chainRecNew = db.LogisticChainGetRec(Nodes[0].Item, loc);
                    if (chainRecNew == null) break;
                    buffer.Add(chainRecNew);
                    chainRec = chainRecNew;
                }
                chainRec.Id = Nodes[0].Id;
                Nodes.Add(chainRec);
                loc = Convert.ToInt32(chainRec.SourceWhNew.Value);
                if (RecExists(Nodes, Nodes[0].Item, loc))
                {
                    break;
                }
            }
            var cnt = Nodes.Count;
            var supplier = Nodes[cnt - 1].SupplierNew;
            if (supplier.State == ValueStates.Valid)
                SetSupplier(/*Nodes[cnt - 1].Seq*/cnt, Convert.ToInt32(supplier.Value),
                            Nodes[cnt - 1].SupplierDescNew.Value.ToString());
            UpdateSequence();
            return true;
        }
Ejemplo n.º 14
0
 /// <summary>
 /// Gets merch info
 /// </summary>
 /// <exception cref="AssortmentException"></exception>
 /// <param name="db">DbManager object</param>
 public void GetMerchInfo(DBManager db)
 {
     var parameters = db.CallProcedure(AssortmentProcedure.GetMerch);
     ID = Convert.ToInt32(parameters["o_merch"].ToString());
     MerchName = parameters["o_merch_name"].ToString();
 }
        public WindowRowOriented(Session session, PivotGridControl pivotGridControl1)
        {
            InitializeComponent();

            #region Initialize

            _session = session;
            _closeWithoutCheck = false;
            _db = _session.GetDbManager();
            _doc = _session.GetDocument();
            //ThemeManager.SetThemeName(this, "Office2007Silver");
            ThemeManager.SetThemeName(this, "DeepBlue");
            WindowState = WindowState.Maximized;
            Closing += WindowSecondaryClosing;
            _doc.DocProjected += DbDocProjected;
            var desc = _doc.Description;
            Title = "Документ: " + (desc ?? "не создан") + " (" + _doc.Id + ", " + DocTypes.Description(_doc.DocType) + ")";
            //Title = "Документ: " + (desc.Equals("") ? "не создан" : desc) + " (" + _doc.Id + ", " + (_doc.DocType == DocTypes.Operative ? "Оперативный" : "Обычный") + ")";

            try
            {
                _db.FillDataTableCustom(Table.TableSupplier.Name, Table.TableSupplier.SelectClause, Table.TableSupplier.KeyFields, false);
            }
            catch (AssortmentException ex)
            {
                MessageBox.Show(Table.TableSupplier + ": " + ex.Message, "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
                return;
            }
/*
            if (_db.FillDataTableCustom(Table.TableSupplier.Name, Table.TableSupplier.SelectClause, Table.TableSupplier.KeyFields, false) == false)
            {
                MessageBox.Show("Ошибка при формировании источника: " + _db.Error, "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
            }
*/
            #endregion

            #region Initialize PivotGrid Control

            try
            {
                _db.FillDataTableCustom(Table.TableRowSource);
            }
            catch (AssortmentException ex)
            {
                MessageBox.Show(Table.TableRowSource + ": " + ex.Message, "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
                return;
            }
/*
            if (_db.FillDataTableCustom(Table.TableRowSource) == false)
            {
                MessageBox.Show("Ошибка при формировании источника: " + _db.Error, "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
            }
*/
            _pivotGridControl2.DataSource = _db.DataTableGet(Table.TableRowSource.Name).DefaultView;
            _pivotGridControl2.HiddenFieldList += PivotGridControl2HiddenFieldList;

            var dimensions = _db.GetTableDefinition(Table.TableRowSource.DBName);

            if (dimensions == null)
            {
                MessageBox.Show("Список измерений для данной таблицы пуст", "Ошибка", MessageBoxButton.OK,
                                MessageBoxImage.Error);
            }
            else
            {
                _pivotGridControl2.InitializeControl(dimensions, _db);
            }

            _pivotGridControl2.InitializeLayout(pivotGridControl1);

            _pivotGridControl2.ShowRowTotals = false;
            _pivotGridControl2.ShowColumnTotals = false;
            _pivotGridControl2.ShowColumnGrandTotals = false;
            _pivotGridControl2.ShowRowGrandTotals = false;

            _pivotGridControl2.CellClickInputData += PivotGridControl2CellClickInputData;

            _pivotGridControl2.BestFit();

            #endregion
        }
        public WindowCheckError(Session session, CheckTypes checkType, Check check)
        {
            WhRestExistsCheckNewDoc += WhRestExistsCheckNewDocHandler;
            _session = session;
            _check = check;
            InitializeComponent();
            this.DataContext = check;
            Title = check.Desc;
            if (_check.ProcedureName == "global_wh_rest_exists")
            {
                var menuItemSaveDoc = new MenuItem{Header="Создать документ"};
                menuItemSaveDoc.Click += menuItemSaveDoc_Click;
                menuMain.Items.Add(menuItemSaveDoc);
            }

            Width = 750;
            Height = 650;

            _db = session.GetDbManager();

            #region Initialize Control

            //gridControl1.AutoPopulateColumns = true;
            gridControl1.DataSource = _db.DataTableGet(check.ProcedureName).DefaultView;

            if (check.TableName != null)
            {
                List<Column> columns;

                try
                {

                    columns =
                        _db.GetTableDefinition(check.TableName);
                    /*
                                        columns =
                                            _db.GetTableDefinition(check.TableName ??
                                                                   (checkType == CheckTypes.Local
                                                                        ? "y_assortment_doc_detail"
                                                                        : "y_assortment_united_sec_gtt"));
                    */

                }
                catch (AssortmentException e)
                {
                    MessageBox.Show(e.Message, "Ошибка детализации", MessageBoxButton.OK, MessageBoxImage.Error);
                    return;
                }

                //var src = new DataTable("SRC");

                foreach (var column in columns)
                {
                    if (column.Name == "PARAMS")
                    {
                        var table = _db.DataTableGet(check.ProcedureName);
                        var maxColumn = 0;
                        /*
                                                foreach (DataColumn col in table.Columns)
                                                {
                                                    if (col.ColumnName != "PARAMS" && col.ColumnName.Contains("PARAM"))table.Columns.Remove(col);
                                                }
                        */


                        for (int i = 1; i < 30; i++)
                        {
                            try
                            {
                                table.Columns.Remove("PARAM" + i);
                            }
                            catch { }
                        }

                        foreach (DataRow row in table.Rows)
                        {
                            var rowParams = row["PARAMS"].ToString();
                            var qty = rowParams.Split(';').Length;
                            if (qty > maxColumn) maxColumn = qty;
                        }
                        for (int i = 1; i <= maxColumn; i++)
                        {
                            table.Columns.Add("PARAM" + i);

                            gridControl1.Columns.Add(new GridColumn
                            {
                                FieldName = "PARAM" + i,
                                Header = "Параметр " + i,
                                AllowEditing = DefaultBoolean.False
                            });
                        }
                        foreach (DataRow row in table.Rows)
                        {
                            var rowParams = row["PARAMS"].ToString();
                            var rowParamsArray = rowParams.Split(';');
                            for (int i = 1; i <= rowParamsArray.Length; i++)
                            {
                                row["PARAM" + i] = rowParamsArray[i - 1];
                            }
                        }
                    }
                    else
                    {
                        //src.Columns.Add(new DataColumn(column.Name));
                        gridControl1.Columns.Add(new GridColumn
                                                     {
                                                         FieldName = column.Name,
                                                         Header = column.Desc,
                                                         AllowEditing = DefaultBoolean.False
                                                     });
                    }
                }
            }
            else
            {

                switch (checkType)
                {
                    case CheckTypes.Local:
                        {
                            gridControl1.Columns.Add(new GridColumn { FieldName = "ITEM", Header = "Товар", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "DIM_ITEM_DESC", Header = "Наименование", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "LOC", Header = "Магазин", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "DIM_LOC_DESC", Header = "Название", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "ACTION", Header = "Действие", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "SUPPLIER", Header = "Поставщик", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "DIM_ITEMLOC_SUPPLIER_DESC", Header = "Название", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "SUPPLIER_NEW", Header = "Поставщик (новый)", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "DIM_ITEMLOC_SUPPLIER_DESC_NEW", Header = "Название", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "ORDERPLACE", Header = "Место заказа", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "ORDERPLACE_NEW", Header = "Место заказа (новое)", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "SOURCEMETHOD", Header = "Тип поставки", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "SOURCEMETHOD_NEW", Header = "Тип поставки (новый)", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "SOURCEWH", Header = "Склад поставки", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "SOURCEWH_NEW", Header = "Склад поставки (новый)", AllowEditing = DefaultBoolean.False });
                            break;
                        }
                    case CheckTypes.Global:
                        {
                            gridControl1.Columns.Add(new GridColumn { FieldName = "ITEM", Header = "Товар", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "DIM_ITEM_DESC", Header = "Наименование", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "LOC", Header = "Магазин", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "DIM_LOC_DESC", Header = "Название", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "DIM_ITEMLOC_SUPPLIER_NEW", Header = "Поставщик", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "DIM_ITEMLOC_SUPPLIER_DESC_NEW", Header = "Имя", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "DIM_ITEMLOC_SOURCEMETHOD_NEW", Header = "Способ поставки", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "DIM_ITEMLOC_SOURCEWH_NEW", Header = "Склад поставки", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "DIM_ITEMLOC_ORDERPLACE_NEW", Header = "Место заказа", AllowEditing = DefaultBoolean.False });
                            gridControl1.Columns.Add(new GridColumn { FieldName = "ACTION", Header = "Действие", AllowEditing = DefaultBoolean.False });

                            break;
                        }
                }

            }

            #endregion
        }
Ejemplo n.º 17
0
        public WindowChain(Object dbObject, List<Chain> chainGroup, SortedSet<IL> setIL, bool isSourceTransit)
        {
            InitializeComponent();

            _isSourceTransit = isSourceTransit;
            _db = (DBManager)dbObject;
            _setIL = setIL;
            _chainGroup = chainGroup;
            _recBuffer = new List<ChainRec>();

            for (int index = 0; index < _chainGroup.Count; index++)
            {
                var chain = _chainGroup[index];
                foreach (var rec in chain.Nodes)
                {
                    _recBuffer.Add(rec);
                }
                comboBox1.Items.Add(index + 1);
            }

            WindowState = WindowState.Maximized;

            var source = new List<ChainRec>();
            foreach (var chain in chainGroup)
            {
                source.AddRange(chain.Nodes);
            }

            gridControl1.DataSource = source;
            gridControl1.Columns.Add(new GridColumn { FieldName = "Id", Width = 80, Header = "Цепочка", AllowEditing = DefaultBoolean.False });
            gridControl1.Columns.Add(new GridColumn { FieldName = "Seq", Width = 50, Header = "Узел", AllowEditing = DefaultBoolean.False });
            gridControl1.Columns.Add(new GridColumn { FieldName = "Loc", Width = 70, Header = "Склад", AllowEditing = DefaultBoolean.False });
            gridControl1.Columns.Add(new GridColumn { FieldName = "SourceMethod", Header = "Метод поставки", AllowEditing = DefaultBoolean.False });
            gridControl1.Columns.Add(new GridColumn { FieldName = "SourceWh", Header = "Склад поставки", AllowEditing = DefaultBoolean.False });
            gridControl1.Columns.Add(new GridColumn { FieldName = "SourceMethodNew", Header = "(NEW)Метод поставки", AllowEditing = DefaultBoolean.False, CellTemplate = (DataTemplate)FindResource("CellTemplateChain") });
            gridControl1.Columns.Add(new GridColumn { FieldName = "SourceWhNew", Header = "(NEW)Склад поставки", AllowEditing = DefaultBoolean.False, CellTemplate = (DataTemplate)FindResource("CellTemplateChain") });
            gridControl1.Columns.Add(new GridColumn { FieldName = "Supplier", Header = "Поставщик", AllowEditing = DefaultBoolean.False });
            gridControl1.Columns.Add(new GridColumn { FieldName = "SupplierDesc", Header = "Поставщик.Название", AllowEditing = DefaultBoolean.False });
            gridControl1.Columns.Add(new GridColumn { FieldName = "SupplierNew", Header = "(NEW)Поставщик", AllowEditing = DefaultBoolean.False, CellTemplate = (DataTemplate)FindResource("CellTemplateChain") });
            gridControl1.Columns.Add(new GridColumn { FieldName = "SupplierDescNew", Header = "(NEW)Поставщик.Название", AllowEditing = DefaultBoolean.False });
            gridControl1.Columns.Add(new GridColumn { FieldName = "Status", Width = 70, Header = "Статус", AllowEditing = DefaultBoolean.False });
            gridControl1.Columns.Add(new GridColumn { FieldName = "StatusNew", Width = 100, Header = "(NEW)Статус", AllowEditing = DefaultBoolean.False/*, CellTemplate = (DataTemplate)FindResource("CellTemplateChain")*/ });
            gridControl1.Columns.Add(new GridColumn { FieldName = "Action", Width = 100, Header = "Действие", AllowEditing = DefaultBoolean.False, CellTemplate = (DataTemplate)FindResource("CellTemplateChainAction") });
            /*            
                        gridControl1.DataSource = source;
                        gridControl1.Columns.Add(new GridColumn { FieldName = "Id", Width = 80, Header = "Цепочка", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "Seq", Width = 50, Header = "Узел", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "Loc", Width = 70, Header = "Склад", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "SourceMethod", Header = "Метод поставки", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "SourceWh", Header = "Склад поставки", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "SourceMethodNew", Header = "(NEW)Метод поставки", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "SourceWhNew", Header = "(NEW)Склад поставки", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "Supplier", Header = "Поставщик", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "SupplierDesc", Header = "Поставщик.Название", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "SupplierNew", Header = "(NEW)Поставщик", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "SupplierDescNew", Header = "(NEW)Поставщик.Название", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "Status", Width = 70, Header = "Статус", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "StatusNew", Width = 100, Header = "(NEW)Статус", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "Action", Width = 100, Header = "Действие", AllowEditing = DefaultBoolean.False });
            */

            /*
                        var chains = new List<ChainRow>();
                        chains.Add(new ChainRow { Id = 1, Seq = 1, Loc = 44 });
                        chains.Add(new ChainRow { Id = 1, Seq = 2, Loc = 44 });
                        chains.Add(new ChainRow { Id = 1, Seq = 3, Loc = 44 });

                        gridControl1.DataSource = chains;

                        _db = (DbManagerDynamic)dbObject;
                        //gridControl1.DataSource = _db.DataTableGet("chain").DefaultView;
                        gridControl1.Columns.Add(new GridColumn { FieldName = "Id", Width = 80, Header = "Цепочка", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "Seq", Width = 50, Header = "Узел", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "Loc", Width = 70, Header = "Склад", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "DIM_ITEMLOC_SOURCEMETHOD", Header = "Метод поставки", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "DIM_ITEMLOC_SOURCEWH", Header = "Склад поставки", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "DIM_ITEMLOC_SOURCEMETHOD_NEW", Header = "(NEW)Метод поставки", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "DIM_ITEMLOC_SOURCEWH_NEW", Header = "(NEW)Склад поставки", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "DIM_ITEMLOC_SUPPLIER", Header = "Поставщик", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "DIM_ITEMLOC_SUPPLIER_DESC", Header = "Поставщик.Название", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "DIM_ITEMLOC_SUPPLIER_NEW", Header = "(NEW)Поставщик", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "DIM_ITEMLOC_SUPPLIER_DESC_NEW", Header = "(NEW)Поставщик.Название", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "MEASURE_STATUS", Width = 70, Header = "Статус", AllowEditing = DefaultBoolean.False });
                        gridControl1.Columns.Add(new GridColumn { FieldName = "MEASURE_STATUS_NEW", Width = 100, Header = "(NEW)Статус", AllowEditing = DefaultBoolean.False });
            */
            gridControl1.MouseDown += GridControl1MouseClick;
            comboBox1.SelectionChanged += ComboBox1SelectionChanged;
            buttonApply.Click += ButtonApplyClick;
            //gridControl1.Columns["DIM_ITEMLOC_SUPPLIER_NEW"].MouseDown += WindowChainMouseDown;
            //_db.DataTableGet("chain").RowChanged += WindowChainRowChanged;
        }
Ejemplo n.º 18
0
        public WindowWhRowEdit(Object dbobject, ChainRec row)
        {
            InitializeComponent();
            _db = (DBManager)dbobject;
            _row = row;

            try
            {
                _db.FillDataTableCustom(Table.TableSupplier.Name, Table.TableSupplier.SelectClause, Table.TableSupplier.KeyFields, false);
            }
            catch (AssortmentException ex)
            {
                MessageBox.Show(Table.TableSupplier + ": " + ex.Message, "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
                return;
            }
/*
            if (_db.FillDataTableCustom(Table.TableSupplier.Name, Table.TableSupplier.SelectClause, Table.TableSupplier.KeyFields, false) == false)
            {
                MessageBox.Show("Ошибка при формировании источника: "+_db.Error,"Ошибка",MessageBoxButton.OK,MessageBoxImage.Error);
            }
*/
            #region Initialize Events

            sourceMethodNew.SelectionChanged += SourceMethodNewSelectionChanged;
            cancel.Click += CancelClick;
            supplierNewSelect.Click += SupplierNewSelectClick;

            border1.MouseEnter += BorderMouseEnter;
            border1.MouseLeave += BorderMouseLeave;
            border2.MouseEnter += BorderMouseEnter;
            border2.MouseLeave += BorderMouseLeave;
            border3.MouseEnter += BorderMouseEnter;
            border3.MouseLeave += BorderMouseLeave;

            #endregion

            #region Initialize Controls

            sourceMethodNew.Items.Add((char)SourceMethods.S);
            sourceMethodNew.Items.Add((char)SourceMethods.W);

            for (var i = 0; i < _db.UserWhList.Count; i++)
            {
                sourceWhNew.Items.Add(_db.UserWhList[i]);
            }
            //sourceWhNew.Items.Add(44);
            //sourceWhNew.Items.Add(121);
            //sourceWhNew.Items.Add(174);

            //sourceMethod.Text = row.SourceMethod.ToString();
            //sourceWh.Text = row.SourceWh.ToString();
            //sourceMethodNew.SelectedItem = row.SourceMethodNew;
            //sourceWhNew.SelectedItem = row.SourceWhNew;
            //supplier.Text = row.Supplier.ToString();
            //supplierDesc.Text = row.SupplierDesc;
            //supplierNew.Text = row.SupplierNew.ToString();
            //supplierDescNew.Text = row.SupplierDescNew;
            //status.Text = row.Status.ToString();
            //statusNew.Text = row.StatusNew.ToString();

            #endregion
        }