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);
}
}
