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