private void CbKat_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { ComboBox cb = (ComboBox)sender; KatModel km = (KatModel)cb.SelectedItem; CreateKatDetay(km, _DepoOrtalama); } catch (Exception ex) { MessageBox.Show("CbKat_SelectionChanged\n" + ex.Message); } }
private void SetDepoLblValues(Guid depoID, Guid katID) { try { double toplam = 0; _DepoOrtalama = 0; _DtDepoToplamPalet = _data.DepoDoluBosBilgiGetir(depoID); int depoDoluPalet = 0; if (_DtDepoToplamPalet.Rows.Count > 0) { foreach (DataRow row in _DtDepoToplamPalet.Rows) { double oran = row["oran"].To <double>(); if (oran > 0) { depoDoluPalet++; } } lblDepoBosDolu.Content = ("" + depoDoluPalet + " / " + _DtDepoToplamPalet.Rows.Count).ToString(); } DataTable katDt = _data.KatDetayGetir(katID, depoID); double katOran = katDt.AsEnumerable() .Sum(r => r["oran"].ToString().To <double>()); if (katOran > 0) { toplam += (katOran) / katDt.Rows.Count; } ToolTip tt = new ToolTip() { Placement = System.Windows.Controls.Primitives.PlacementMode.Mouse, }; _DepoOrtalama = (toplam) / _DtKat.Rows.Count; string ttString = Math.Round(_DepoOrtalama, 3).ToString(); _DepoOrtalama = Math.Round(_DepoOrtalama, 0); lblDepoDolulukOran.Content = "% " + _DepoOrtalama.ToString(); tt.Content = ttString; lblDepoDolulukOran.ToolTip = tt; lblDepoDolulukOran.Background = UIOperation.GetScaleColor(_DepoOrtalama); KatModel newKm = new KatModel(depoID, _CurrentKatModel.Name, katID, katOran / katDt.Rows.Count, katDt); _CurrentKatModel = newKm; } catch (Exception ex) { MessageBox.Show("SetDepoLblValues\n" + ex.Message); } }
private void SetKatLblValues(KatModel km) { try { int KatToplamPalet = 0; int katToplamDoluPalet = 0; double katOrtalama = Math.Round(km.KatOran, 0); foreach (DataRow row in _DtDepoToplamPalet.Rows) { Guid KatId = new Guid(row["DepoKatID"].ToString()); if (KatId.Equals(km.Id)) { double oran = row["oran"].To <double>(); if (oran > 0) { katToplamDoluPalet++; } KatToplamPalet++; } } lblKatBosDolu.Content = ("" + katToplamDoluPalet + " / " + KatToplamPalet).ToString(); ToolTip tt = new ToolTip() { Placement = System.Windows.Controls.Primitives.PlacementMode.Mouse, }; string ttStringKatoran = Math.Round(km.KatOran, 3).ToString(); tt.Content = ttStringKatoran; lblKatDolulukOran.ToolTip = tt; lblKatDolulukOran.Content = "% " + katOrtalama.ToString(); lblKatDolulukOran.Background = UIOperation.GetScaleColor(katOrtalama); } catch (Exception ex) { MessageBox.Show("SetKatLblValues\n" + ex.Message); } }
public RefreshData(KatModel km) { _data = new Data(); _KatModel = km; }
private void CreateKatDetay(KatModel km, double DepoOrtalama) { try { this.Dispatcher.Invoke((Action)(() => { //int KatToplamPalet = 0; //int katToplamDoluPalet = 0; //foreach (DataRow row in _DtDepoToplamPalet.Rows) //{ // Guid KatId = new Guid(row["DepoKatID"].ToString()); // if (KatId.Equals(km.Id)) // { // double oran = row["oran"].To<double>(); // if (oran > 0) // { // katToplamDoluPalet++; // } // KatToplamPalet++; // } //} //lblKatBosDolu.Content = ("" + katToplamDoluPalet + " / " + KatToplamPalet).ToString(); _gridColors = UIOperation.CreateColorsGrid(GridColor, 0, 1); Grid.SetRow(_gridColors, 0); Grid.SetColumn(_gridColors, 1); GridColor.Children.Remove(_gridColors); GridColor.Children.Add(_gridColors); // DataTable dt = _data.KatDetayGetir(new Guid()); _CurrentDataList = new List <KatDetayModel>(); MyGrid.GetColAndRowSize(out int b, out int a, 0, 1); DataTable dt = _data.KatBoyutGetir(km.Id); int katx = 0, katy = 0; if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; katx = row["X"].ToString().ToInt(); katy = row["Y"].ToString().ToInt(); } // MessageBox.Show("height="+ a.ToString()+"\n width="+b.ToString()); KatDetayShape kds = new KatDetayShape(b, a, katx, katy); foreach (DataRow row in km.KatData.Rows) { Guid id = new Guid(row["AdresId"].ToString()); Guid UlId = new Guid(row["RafID"].ToString()); string name = row["Raf"].ToString(); int x = row["KX"].ToInt(); int y = row["KY"].ToInt(); string koy = row["Koy"].ToString(); double oran = row["oran"].To <double>(); //if (oran > 0) //{ // toplam += (1 / oran) * 100; //} int sira = row["Sira"].ToInt(); _CurrentDataList.Add(new KatDetayModel(id, UlId, new Point(x, y), name, oran, sira, koy, km.Id, km.UlId)); } SetKatLblValues(km); CreateRafOranGrid(GetRafOran(km.KatData, _CurrentDataList)); // ortalama = (100 * toplam) / dt.Rows.Count; // string ttString = Math.Round(DepoOrtalama, 3).ToString(); // string ttStringKatoran = Math.Round(km.KatOran, 3).ToString(); //ToolTip tt = new ToolTip() //{ // Placement = System.Windows.Controls.Primitives.PlacementMode.Mouse, //}; //DepoOrtalama = Math.Round(DepoOrtalama, 0); //double katOrtalama = Math.Round(km.KatOran, 0); //lblDepoDolulukOran.Content = "% " + DepoOrtalama.ToString(); //tt.Content = ttString; //lblDepoDolulukOran.ToolTip = tt; //tt.Content = ttStringKatoran; //lblKatDolulukOran.ToolTip = tt; //lblKatDolulukOran.Content = "% " + katOrtalama.ToString(); //lblDepoDolulukOran.Background = UIOperation.GetScaleColor(DepoOrtalama); //lblKatDolulukOran.Background = UIOperation.GetScaleColor(katOrtalama); _canvas.Tag = _CurrentDataList; _canvas = kds.DrawCanvas((List <KatDetayModel>)_canvas.Tag); _canvas.MouseLeftButtonDown += CanvasClick; _canvas.MouseMove += CanvasOver; _canvas.MouseRightButtonDown += CanvasRightClick; Grid.SetRow(_canvas, 1); Grid.SetColumn(_canvas, 0); _canvas.Background = (SolidColorBrush) new BrushConverter().ConvertFrom("#ccccff"); MyGrid.Children.Add(_canvas); })); } catch (Exception ex) { MessageBox.Show("CreateKatDetay\n" + ex.Message); } }
private void KatDoldur(Guid depoId) { try { this.Dispatcher.Invoke((Action)(() => { _DtKat = _data.KatGetir(depoId); double toplam = 0; _DepoOrtalama = 0; if (_DtKat.Rows.Count > 0) { //_DtDepoToplamPalet = _data.DepoDoluBosBilgiGetir(depoId); //int depoDoluPalet = 0; //if (_DtDepoToplamPalet.Rows.Count > 0) //{ // foreach (DataRow row in _DtDepoToplamPalet.Rows) // { // double oran = row["oran"].To<double>(); // if (oran > 0) // { // depoDoluPalet++; // } // } // lblDepoBosDolu.Content = ("" + depoDoluPalet + " / " + _DtDepoToplamPalet.Rows.Count).ToString(); //} List <KatModel> listKat = new List <KatModel>(); foreach (DataRow row in _DtKat.Rows) { Guid ulId = new Guid(row["UlId"].ToString()); Guid id = new Guid(row["Id"].ToString()); string isim = row["Isim"].ToString(); DataTable katDt = _data.KatDetayGetir(id, ulId); if (katDt.Rows.Count == 0) { RemoveControls(); MessageBox.Show("BU DEPOYA AİT FİZİKSEL ADRES TANIMLAMASI YOKTUR"); return; } double katOran = katDt.AsEnumerable() .Sum(r => r["oran"].ToString().To <double>()); if (katOran > 0) { toplam += (katOran) / katDt.Rows.Count; } listKat.Add(new KatModel(ulId, isim, id, (katOran) / katDt.Rows.Count, katDt)); } _CurrentKatModel = listKat[0]; SetDepoLblValues(depoId, _CurrentKatModel.Id); //_DepoOrtalama = (toplam) / _DtKat.Rows.Count; //_DepoOrtalama = Math.Round(_DepoOrtalama, 0); CbKat.DisplayMemberPath = "Name"; CbKat.SelectedValuePath = "Id"; CbKat.SelectedIndex = 0; CbKat.ItemsSource = listKat; CbKat.SelectionChanged += CbKat_SelectionChanged; } else { RemoveControls(); MessageBox.Show("BU DEPO İÇİN TANIMLI BİR KAT YOKTUR"); } })); } catch (Exception ex) { MessageBox.Show("KatDoldur\n" + ex.Message); } }