private void CanvasRightClick(object sender, MouseButtonEventArgs e)
{
try
{
if (e.Source is FrameworkElement o && o is Polygon)
{
Polygon p = (Polygon)o;
KatDetayModel km = (KatDetayModel)p.Tag;
WindowRafGenelDurum wrgd = new WindowRafGenelDurum();
RafOran oran = new RafOran();
for (int i = 0; i < _ro.Count; i++)
{
if (_ro[i].RafName == km.Name)
{
oran = _ro[i];
break;
}
}
this.Cursor = Cursors.Wait;
wrgd.Init(km, oran.Oran);
Cursor = Cursors.AppStarting;
_Timer.Stop();
wrgd.WindowStartupLocation = WindowStartupLocation.CenterScreen;
wrgd.ShowDialog();
_Timer.Start();
}
}
catch (Exception ex)
{
MessageBox.Show("CanvasRightClick\n" + ex.Message);
}
}
private Polygon DrawPolygon(PointModel points, KatDetayModel raf)
{
// SolidColorBrush s = new SolidColorBrush();
string ttString = "";
// s = UIOperation.GetScaleColor(raf.Oran);
ttString = "Raf = " + raf.Name + "\nKoy = " + raf.Koy + "\nSıra = " + raf.Sira + "\nDoluluk Oranı = % " + Math.Round(raf.Oran, 1) + "";
ToolTip tt = new ToolTip()
{
Placement = System.Windows.Controls.Primitives.PlacementMode.Mouse,
Content = ttString
};
Polygon polygon = new Polygon()
{
Tag = raf,
ToolTip = tt,
Stroke = Brushes.Black,
StrokeThickness = 0.2,
VerticalAlignment = VerticalAlignment.Stretch,
HorizontalAlignment = HorizontalAlignment.Left
};
polygon.Fill = ((KatDetayModel)polygon.Tag).Color;
PointCollection polygonPoints = new PointCollection
{
points.P1,
points.P2,
points.P3,
points.P4
};
polygon.Points = polygonPoints;
return(polygon);
}
public void Init(KatDetayModel kdm, double oran)
{
try
{
_oran = oran;
_kdm = kdm;
_rafIsim = kdm.Name;
_rafGenelBilgi = new DataTable();
_data = new Data();
this.Title = "RAF -" + kdm.Name;
LblRafGenelDurum.Content = "RAF - " + kdm.Name + " = % " + Math.Round(oran, 1) + "";
LblRafGenelDurum.Background = UIOperation.GetScaleColor(oran);
_rafGenelBilgi = _data.RafGenelBilgiGetir(kdm);
SetOranLabelsValues(_rafGenelBilgi);
}
catch (Exception ex)
{
MessageBox.Show("Init\n" + ex.Message);
}
}
public void Init(DataTable dt, KatDetayModel kdm, double genOrt)
{
try
{
_Kdm = kdm;
// _RafIsim = kdm.Name;
// _depoId = kdm.DepoId;
// _katId = kdm.KatId;
_dt = dt;
_genelOrtalama = genOrt;
this.Title = "RAF - " + _Kdm.Name + " TÜM PALETLER";
int maxYukseklik = _dt.AsEnumerable()
.Max(row => row["Yukseklik"]).ToString().ToInt();
int count = dt.Rows.Count;
_ListTip = SelectTips();
_rows = ClassifyingTips(_ListTip);
var datas = _dt.Select("Yukseklik=" + 1);
int c = ((DataRow[])datas).Length;
_hucreRowCount = maxYukseklik;
_hucreColCount = c;
GridOran.CreateGridRowsColoums(1, _hucreColCount, _width, _height);
GridHucre.CreateGridRowsColoums(_hucreRowCount, _hucreColCount, _width, _height);
CreateHucre();
_Timer = new Timer(10000);
_Timer.Elapsed += new ElapsedEventHandler(StartRefreshData);
_Timer.Start();
}
catch (Exception ex)
{
MessageBox.Show("Init\n" + ex.Message);
}
}
/// <summary>
/// Canvas içerisindeki polygonları güncelleyen metot
/// </summary>
/// <param name="canvas"></param>
private void RefrashCanvas(Canvas canvas)
{
try
{
int i = 0;
foreach (object poly in canvas.Children)
{
if (poly is Polygon)
{
KatDetayModel raf = _CurrentDataList[i];
string ttString = "";
ttString = "Raf = " + raf.Name + "\nKoy = " + raf.Koy + "\nSıra = " + raf.Sira + "\nDoluluk Oranı = % " + Math.Round(raf.Oran, 1) + "";
((Polygon)poly).Tag = raf;
((Polygon)poly).Fill = raf.Color;
((Polygon)poly).ToolTip = ttString;
i++;
}
}
}
catch (Exception ex)
{
MessageBox.Show("RefrashCanvas\n" + ex.Message);
}
}
public RefreshData(KatDetayModel kdm)
{
_data = new Data();
_KatDetayModel = kdm;
}
/// <summary>
/// Bir rafa ait genel durum bilgisini getirir.
/// </summary>
/// <param name="rafSira"></param>
/// <returns></returns>
public DataTable RafGenelBilgiGetir(KatDetayModel rafSira)
{
try
{
string cmdText =
";with adresStoklar AS( " + Environment.NewLine +
"select " + Environment.NewLine +
"adr.AdresId " + Environment.NewLine +
",ISNULL(X.StokId,CAST(0X0 AS uniqueidentifier)) AS StokId" + Environment.NewLine +
",ISNULL(X.Miktar,0) AS Miktar " + Environment.NewLine +
",ISNULL(ISNULL(p.Miktar,X.Miktar),1) AS paletMiktar" + Environment.NewLine +
"from ne_V_DepoAdresListe as adr " + Environment.NewLine +
"left outer join ne_DepoXStokMiktar as x " + Environment.NewLine +
"on x.AdresId = adr.AdresId" + Environment.NewLine +
"left outer join ne_StokPaletMiktar as p on p.StokId = x.StokId " + Environment.NewLine +
"where" + Environment.NewLine +
"DepoId = @DepoId"+ Environment.NewLine +
"and DepoKatId = @KatId"+ Environment.NewLine +
"and RafId =@RafId"+ Environment.NewLine +
")," + Environment.NewLine +
"adresStokOran as (" + Environment.NewLine +
"select AdresId,stokId,sum(ISNULL(miktar/NULLIF(paletmiktar,0),0))*100 oran from adresStoklar" + Environment.NewLine +
"GROUP BY AdresId,StokId)," + Environment.NewLine +
"AdresDoluluk AS(" + Environment.NewLine +
"select AdresId,round(sum(oran) / count(*),1) as oran from adresStokOran" + Environment.NewLine +
"GROUP BY AdresId)," + Environment.NewLine +
"KusBakisiDoluluk AS(" + Environment.NewLine +
"select adrs.rafId,adrs.raf,adrs.X,adrs.KoyId, sum(dl.oran)/count(*) As Oran from ne_V_DepoAdresListe AS adrs" + Environment.NewLine +
"inner JOIN AdresDoluluk as dl" + Environment.NewLine +
"ON adrs.AdresId=dl.AdresId" + Environment.NewLine +
"group by adrs.X,adrs.KoyId,adrs.rafId,adrs.raf)" + Environment.NewLine +
"select" + Environment.NewLine +
"adr.Adres" + Environment.NewLine +
",adr.RafId" + Environment.NewLine +
",adr.Koy as Koy" + Environment.NewLine +
",adr.X As Sira" + Environment.NewLine +
",adr.Raf" + Environment.NewLine +
",adr.Koy "+ Environment.NewLine +
",adr.AdresId" + Environment.NewLine +
",dl.oran" + Environment.NewLine +
",adr.Tip" + Environment.NewLine +
",adr.TipIsim" + Environment.NewLine +
",adr.Yukseklik" + Environment.NewLine +
"from AdresDoluluk as dl " + Environment.NewLine +
"inner join ne_V_DepoAdresListe as adr " + Environment.NewLine +
"on adr.AdresId = dl.AdresId" + Environment.NewLine +
"order by adr.Koy,adr.X,adr.AdresXY desc";
return(DBDataTable(cmdText, new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@RafId", Value = rafSira.UlId
},
new SqlParameter()
{
ParameterName = "@DepoId", Value = rafSira.DepoId
},
new SqlParameter()
{
ParameterName = "@KatId", Value = rafSira.KatId
}
}));
}
catch (Exception ex)
{
throw new Exception("\nRafGenelBilgiGetir\n" + ex.Message);
}
}
