private void StokListele()
{
using (ARAFEntities context = new ARAFEntities())
{
if (WORK_ORDER_TYPE_ == 0)
{
var Prd = from h in context.ARF_PLANNING_WORKSTATION_ITEMS
where h.WS_ID == MakineID
select new { h.ITEM_CODE, h.ITEM_NAME };
if (Prd != null)
{
gridControlStokListesi.DataSource = Prd.ToList();
}
}
else
{
var Prd = from h in context.ARF_PLANNING_WORKSTATION_ITEMS
where h.WSG_ID == WSG_ID_
select new { h.ITEM_CODE, h.ITEM_NAME };
if (Prd != null)
{
gridControlStokListesi.DataSource = Prd.ToList();
}
}
}
}
private void IsListele(string ITEM_CODE_)
{
using (ARAFEntities context = new ARAFEntities())
{
if (WORK_ORDER_TYPE_ == 0)
{
var Prd = from h in context.ARF_PLANNING
where h.WS_ID == MakineID && h.PLAN_STATUS != 2 && h.ITEM_CODE == ITEM_CODE_
select h;
if (Prd != null)
{
gridControlIsListesi.DataSource = Prd.ToList();
}
}
else
{
var Prd = from h in context.ARF_PLANNING
where h.WSG_ID == WSG_ID_ && h.PLAN_STATUS != 2 && h.ITEM_CODE == ITEM_CODE_
select h;
if (Prd != null)
{
gridControlIsListesi.DataSource = Prd.ToList();
}
}
}
}
private void simpleButtonseciliIsiBaslat_Click(object sender, EventArgs e)
{
int PLAN_ID_ = Convert.ToInt32(gridViewPlanListe.GetRowCellValue(gridViewPlanListe.FocusedRowHandle, "PLAN_ID").ToString());
using (ARAFEntities context = new ARAFEntities())
{
var query1 = from contact in context.ARF_TMP_PLANNING
where
contact.WS_ID == MakineID
select contact;
// Iterate through the collection of Contact items.
foreach (var result1 in query1)
{
uretimPlanEkle(result1.PLAN_ID, result1.WS_ID);
}
UretimEkle(MakineID);
if (PlanEkle_ == 0)
{
var query = (from contact1 in context.PRODUCTION_PLANNING
where contact1.WS_ID == MakineID && contact1.PLAN_ID == PLAN_ID_ && contact1.PROD_PLAN_STATUS == 0
select contact1).First();
query.PROD_PLAN_STATUS = 1;
context.SaveChanges();
}
}
simpleButtonKapat_Click(sender, e);
}
public void uretimPlanEkle(int PLAN_ID, int WS_ID)
{
int dd;
using (ARAFEntities context = new ARAFEntities())
{
dd = Convert.ToInt32(context.ARF_PRODUCTION_PLANNIG_INSERT(PLAN_ID, WS_ID).ToString());
}
}
public void UretimBitir(int _PROD_ID_, int _WS_ID)
{
int dd;
using (ARAFEntities context = new ARAFEntities())
{
dd = Convert.ToInt32(context.ARF_PRODUCTION_STOPP(_PROD_ID_, _WS_ID).ToString());
}
}
public void UretimEkle(int WS_ID)
{
int dd;
using (ARAFEntities context = new ARAFEntities())
{
dd = Convert.ToInt32(context.ARF_PRODUCTION_START(WS_ID).ToString());
}
}
private void EklenenPlanListesi()
{
using (ARAFEntities context = new ARAFEntities())
{
var Prd = from h in context.ARF_TMP_PLANNING where h.WS_ID == MakineID select h;
if (Prd != null)
{
gridControlPlanListe.DataSource = Prd.ToList();
}
}
}
private void Listele()
{
using (ARAFEntities context = new ARAFEntities())
{
var Prd = from h in context.ARF_PRODUCTION_OPERATOR where h.PRD_WS_ID == MakineID && h.PRD_STATUS == 0 select new { h.PRD_OPR_ID, h.OPR_NAME, h.WS_CODE, h.WS_NAME, h.COMPUTER_NAME };
if (Prd != null)
{
gridControlUretimOperator.DataSource = Prd.ToList();
}
}
}
private void Listele()
{
using (ARAFEntities context = new ARAFEntities())
{
var Prd = from h in context.ARF_OPERATOR_PANEL where h.WS_ID == MakineID select h;
if (Prd != null)
{
gridControlIslistesi.DataSource = Prd.ToList();
}
}
}
private void Listele()
{
using (ARAFEntities context = new ARAFEntities())
{
var Prd = from h in context.SHIFT select h;
if (Prd != null)
{
gridControlVardiyaListesi.DataSource = Prd.ToList();
}
}
}
private void Silme()
{
int ID = Convert.ToInt32(gridViewPlanListe.GetRowCellValue(gridViewPlanListe.FocusedRowHandle, "TMP_PLN_ID").ToString());
using (ARAFEntities context = new ARAFEntities())
{
context.TMP_PLANNING.RemoveRange(context.TMP_PLANNING.Where(u => u.TMP_PLN_ID == ID));
context.SaveChanges();
}
EklenenPlanListesi();
}
private void PlanDurumuListe()
{
using (ARAFEntities context = new ARAFEntities())
{
var Prd = from h in context.ARF_PLANNING_STATUS select h;
if (Prd != null)
{
// gridControlPlanDurumu.DataSource = Prd.ToList();
}
}
}
private void PlandakiIsler(int WSID_)
{
using (ARAFEntities context = new ARAFEntities())
{
var Prd = from h in context.ARF_OPERATOR_PANEL where h.WS_ID == MakineID && h.PLAN_STATUS != 2 && h.WS_ID == WSID_ && h.PROD_PLAN_STATUS == 0 select new { h.PLAN_ID, h.WORK_ORDER_NO, h.OP_NAME, h.PLAN_DATE, h.ITEM_CODE, h.ITEM_NAME, h.CUSTOMER_NAME, h.WORK_ORDER_QUANTITY };
if (Prd != null)
{
gridControlPlandakiIsler.DataSource = Prd.ToList();
}
}
}
private void Kaydet()
{
ARAFEntities db = new ARAFEntities();
TMP_PLANNING tmpP = new TMP_PLANNING();
tmpP.WS_ID = MakineID;
tmpP.PLAN_ID = Convert.ToInt32(gridViewIsListesi.GetRowCellValue(gridViewIsListesi.FocusedRowHandle, "PLAN_ID").ToString());
tmpP.MULTIPLIER = 1;
tmpP.DIVIDING = 1;
db.TMP_PLANNING.Add(tmpP);
db.SaveChanges();
EklenenPlanListesi();
}
private void Kaydet()
{
ARAFEntities db = new ARAFEntities();
PRODUCTION_OPERATOR opr = new PRODUCTION_OPERATOR();
opr.PROD_ID = ProductionID;
opr.OPR_ID = OperatorID_;
opr.ROT_ID = 1;
opr.PRD_WS_ID = MakineID;
opr.PRD_STATUS = 0;
opr.SHIFT_ID = Convert.ToInt32(edtVardiya.EditValue.ToString());
db.PRODUCTION_OPERATOR.Add(opr);
db.SaveChanges();
Listele();
}
private void DurusBaslat()
{
ARAFEntities db = new ARAFEntities();
PRODUCTION_SUSPEND PS = new PRODUCTION_SUSPEND();
PS.PROD_ID = ProductionID;
PS.OPR_ID = 0;
PS.SUSPEND_ID = Convert.ToInt32(textEditDurus_Adi.Tag.ToString());
PS.SUSPEND_START_TIME = DateTime.Now;
PS.SUSPEND_STATUS = 1;
PS.COMMENT = textEditAciklama.Text;
db.PRODUCTION_SUSPEND.Add(PS);
db.SaveChanges();
this.DialogResult = DialogResult.OK;
this.Close();
}
private void simpleButtonPlanEkle_Click(object sender, EventArgs e)
{
int ID = Convert.ToInt32(gridViewIsListesi.GetRowCellValue(gridViewIsListesi.FocusedRowHandle, "PLAN_ID").ToString());
using (ARAFEntities context = new ARAFEntities())
{
var Prd = from h in context.ARF_TMP_PLANNING where h.WS_ID == MakineID && h.PLAN_ID == ID select h;
if ((Prd != null) && (Prd.Count() != 0))
{
MessageBox.Show("Plan Eklenmiş.");
}
else
{
Kaydet();
}
}
}
private void ChardDoldur()
{
int i = 0;
XYDiagram diagram = (XYDiagram)chartControlDuruslar.Diagram;
using (ARAFEntities context = new ARAFEntities())
{
var query = from contact in context.ARF_PRODUCTION_SUSPEND
where
contact.PROD_ID == ProductionID
orderby contact.SUSPEND_TIME
select contact;
// Iterate through the collection of Contact items.
foreach (var result in query)
{
this.chartControlDuruslar.Titles.Clear(); //Chart da varsayılan olarak gelen başlıkları temizliyoruz.
this.chartControlDuruslar.Series.Clear(); //Chart da varsayılan olarak gelen series (Liste) temizliyoruz.
// Add two custom labels to the X-axis' collection.
diagram.AxisX.CustomLabels.Add(new CustomAxisLabel(result.SUSPEND_NAME.ToString()));
diagram.AxisX.CustomLabels[i].AxisValue = result.SUSPEND_NAME.ToString();
diagram.AxisX.Title.Text = "";
diagram.AxisX.Label.TextColor = Color.Red;
// diagram.AxisX.Label.Visible = true;
diagram.AxisX.Visibility = DevExpress.Utils.DefaultBoolean.True;
Series series1 = new Series("DURUŞ ADI", ViewType.Bar);
chartControlDuruslar.Series.Add(series1);
series1.DataSource = query.ToList();
series1.ArgumentScaleType = ScaleType.Qualitative;
series1.ArgumentDataMember = "SUSPEND_NAME";
series1.ValueScaleType = ScaleType.Numerical;
SideBySideBarSeriesView view = series1.View as SideBySideBarSeriesView;
view.BarWidth = 0.1;
series1.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
chartControlDuruslar.Legend.Visibility = DevExpress.Utils.DefaultBoolean.True;
series1.ValueDataMembers.AddRange(new string[] { "SUSPEND_TIME" });
//((pie)chartControl2.Diagram).AxisY.Visible = false;
i++;
}
}
}
private void simpleButtonTumunuBaslat_Click(object sender, EventArgs e)
{
using (ARAFEntities context = new ARAFEntities())
{
var query1 = from contact in context.ARF_TMP_PLANNING
where
contact.WS_ID == MakineID
select contact;
// Iterate through the collection of Contact items.
foreach (var result1 in query1)
{
uretimPlanEkle(result1.PLAN_ID, result1.WS_ID);
}
UretimEkle(MakineID);
}
simpleButtonKapat_Click(sender, e);
}
private void ArafFrmDurusInsert_Load(object sender, EventArgs e)
{
WorkStationPanel.Buttons.Clear();
using (ARAFEntities context = new ARAFEntities())
{
var query = from contact in context.ARF_SUSPEND_WORKSTATION
where
contact.WS_ID == MakineID orderby contact.BUTTON_QUEUE
select contact;
foreach (var result1 in query)
{
customBackButton = new DevExpress.XtraBars.Docking2010.WindowsUIButton();
customBackButton.Caption = result1.SUSPEND_NAME;
customBackButton.Tag = result1.SUSPEND_ID;
WorkStationPanel.Buttons.Add(customBackButton);
}
}
}
public int WORK_ORDER_TYPE(int WS_ID)
{
int sonuc = 0;
using (ARAFEntities context = new ARAFEntities())
{
var query = from contact in context.WORKSTATION
where
contact.WS_ID == WS_ID
select contact;
// Iterate through the collection of Contact items.
foreach (var result in query)
{
sonuc = Convert.ToInt32(result.WORK_ORDER_TYPE);
}
}
return(sonuc);
}
private void btnSil_ItemClick(object sender, ItemClickEventArgs e)
{
if (gridViewUretimOperator.RowCount != 0)
{
int PO_ID = Convert.ToInt32(gridViewUretimOperator.GetRowCellValue(gridViewUretimOperator.FocusedRowHandle, "PRD_OPR_ID").ToString());
using (ARAFEntities Context = new ARAFEntities())
{
PRODUCTION_OPERATOR po = new PRODUCTION_OPERATOR {
PRD_OPR_ID = PO_ID
};
Context.Entry(po).State = EntityState.Deleted;
Context.SaveChanges();
}
Listele();
}
else
{
MessageBox.Show("Silinecek Kayıt Yok");
}
}
private void simpleButtonPlandakiIsiBaslat_Click(object sender, EventArgs e)
{
int PLAN_ID_ = Convert.ToInt32(gridViewPlandakiIsler.GetRowCellValue(gridViewPlandakiIsler.FocusedRowHandle, "PLAN_ID").ToString());
using (ARAFEntities context = new ARAFEntities())
{
if (ProductionID != 0) //Üretim var ise mevcut üretimi bitirmektedir. Yeni üretim başlatmaktadır.
{
var query1 = (from contact1 in context.PRODUCTION_PLANNING
where contact1.WS_ID == MakineID && contact1.PROD_PLAN_STATUS == 1
select contact1).First();
query1.PROD_PLAN_STATUS = 2;
context.SaveChanges();
}
var query = (from contact1 in context.PRODUCTION_PLANNING
where contact1.WS_ID == MakineID && contact1.PLAN_ID == PLAN_ID_ && contact1.PROD_PLAN_STATUS == 0
select contact1).First();
query.PROD_PLAN_STATUS = 1;
context.SaveChanges();
}
PlandakiIsler(MakineID);
}
private void PanelTipiAyarla(int PanelTipi, DevExpress.XtraGrid.Views.Card.CardView cardTmp)
{
using (ARAFEntities context = new ARAFEntities())
{
RowLariGizle(cardTmp);
var query = from contact in context.PANEL_TYPE_DETAIL
where
contact.ACTIVE == 1 && contact.PANEL_ID == PanelTipi
orderby contact.QUEUE
select contact;
// Iterate through the collection of Contact items.
foreach (var result in query)
{
GridColumn column = new GridColumn();
column.FieldName = result.FIELD_NAME.ToString();
column.Caption = result.FIELD_CAPTION.ToString();
column.Visible = true;
cardTmp.Columns.Add(column);
}
}
}
private void ÜretmBilgileri(int WSID_)
{
textEditMakineAdi.Text = "";;
textEditVardiyaAdi.Text = "";
textEditOperatorAdi.Text = "";
gridControlSiparis_urun.DataSource = null;
gridControlMiktar.DataSource = null;
// this.arcScaleComponentVerimlilik.Value = 0;
ProductionID = 0;
SUSPEND_ACTIVE = 0;
using (ARAFEntities context = new ARAFEntities())
{
var query = (from contact in context.ARF_OPERATOR_PANEL
where
contact.WS_ID == WSID_ && contact.PROD_PLAN_STATUS == 1 orderby contact.PROD_PLAN_ID
select contact);
foreach (var result in query)
{
textEditVardiyaAdi.Text = result.SHIFT_CODE.ToString();
textEditMakineAdi.Text = result.WS_NAME.ToString();
textEditOperatorAdi.Text = result.OPR_NAME.ToString();
ProductionID = Convert.ToInt32(result.PROD_ID.ToString());
gridControlSiparis_urun.DataSource = query.ToList();
gridControlMiktar.DataSource = query.ToList();
SUSPEND_ACTIVE = result.ACTIVE_SUSPEND_TIME;
// this.arcScaleComponentVerimlilik.Value = Convert.ToSingle(result.PRODUCTIVITY.ToString());
if (result.PRODUCTION_STATUS.ToString() != "URETIM")
{
ribbonPage1.Appearance.BackColor = System.Drawing.ColorTranslator.FromHtml(result.COLOR.ToString());
}
else
{
ribbonPage1.Appearance.BackColor = Color.Transparent;
}
}
}
}
private void textEdit1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyValue == 13)
{
using (ARAFEntities context = new ARAFEntities())
{
var query11 = from contact in context.OPERATOR
where
contact.OPR_BARCODE == txtBarkodNo.Text
select contact;
// Iterate through the collection of Contact items.
foreach (var r in query11)
{
OperatorID_ = r.OPR_ID;
edtAdiSoyAdi.Text = r.OPR_NAME;
}
var Sections = from s in context.SHIFT
orderby s.SHIFT_ID
select new
{
SHIFT_ID = s.SHIFT_ID,
SHIFT_CODE = s.SHIFT_CODE
};
edtVardiya.Properties.DataSource = Sections.ToArray();
edtVardiya.Properties.DisplayMember = "SHIFT_CODE";
edtVardiya.Properties.ValueMember = "SHIFT_ID";
edtVardiya.EditValue = 1;
edtVardiya.Properties.ForceInitialize();
Kaydet();
foreach (var process in Process.GetProcessesByName("osk"))
{
process.Kill();
}
}
}
}
private void RibbonForm1_Load(object sender, EventArgs e)
{
WorkStationPanel.Buttons.Clear();
using (ARAFEntities context = new ARAFEntities())
{
string LastName = Environment.MachineName;
var query1 = from contact in context.WORKSTATION
where
contact.COMPUTER_NAME == LastName
select contact;
// Iterate through the collection of Contact items.
foreach (var result1 in query1)
{
customBackButton = new DevExpress.XtraBars.Docking2010.WindowsUIButton();
customBackButton.Caption = result1.WS_NAME;
customBackButton.Tag = result1.WS_ID;
WorkStationPanel.Buttons.Add(customBackButton);
}
}
df.RestoreLayout(gridViewPlandakiIsler, "gridViewPlandakiIsler_" + this.Name);
widthRatio = Screen.PrimaryScreen.Bounds.Width / 1024;
heightRatio = Screen.PrimaryScreen.Bounds.Height / 768;
SizeF scale = new SizeF(widthRatio, heightRatio);
this.Scale(scale);
foreach (Control control in this.Controls)
{
control.Font = new Font("Verdana", control.Font.SizeInPoints * heightRatio * widthRatio);
}
PanelTipiAyarla(1, cardViewSiparis_Urun);
PanelTipiAyarla(2, cardViewMiktar);
Makinebilgisi();
PlandakiIsler(MakineID);
ChardDoldur();
}
private void barButtonItemDurus_Bitir_ItemClick(object sender, ItemClickEventArgs e)
{
if (ProductionID == 0)
{
MessageBox.Show("Açık Üretim Yok. Duruş Bitirme İşlemi Yapamazsınız.");
return;
}
if (SUSPEND_ACTIVE == 0)
{
MessageBox.Show("Açık Duruş Yok. Duruş Bitirme İşlemi Yapamazsınız.");
return;
}
using (ARAFEntities context = new ARAFEntities())
{
var query1 = (from contact in context.PRODUCTION_SUSPEND
where
contact.PROD_ID == ProductionID && contact.SUSPEND_STATUS == 1
select contact).First();
query1.SUSPEND_END_TIME = DateTime.Now;
query1.SUSPEND_STATUS = 0;
context.SaveChanges();
}
}
