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