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 }
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 }
public Document(Object dbobject, string docType) { _db = (DBManager)dbobject; Id = -1; DocType = docType; _description = null; Saved = false; _db.DocChanged += DocChanged; }
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. }
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 }
/// <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; }
public static void LogHeadCreate(DBManager db) { Call(db, AssortmentProcedure.LogHeadCreate); }
public static void LogHeadUpdate(DBManager db, char status) { AssortmentProcedure.LogHeadUpdate.Parameters["i_status"].Value = status; Call(db, AssortmentProcedure.LogHeadUpdate); }
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); }
/* 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; }
/// <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 }
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; }
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 }