void SaveOpration() { try { foreach (var _opration in lstTempOpration) { GenaricRepository<OperationPool> _ORepository = new GenaricRepository<OperationPool>(new ItrackContext()); foreach (var item in _CompanyRepository.GetAll().Where(x => x.isDefaultCompany == true)) { _Company.CompanyID = item.CompanyID; } _Operation.CompanyID = _Company.CompanyID; _Operation.OperationPoolID = _opration.OprationID; _Operation.OpationName = _opration.OparationName; _Operation.SMV = _opration.SMV; _Operation.SMVType = _opration.SMVType; _Operation.MachineType = _opration.MachineType; _Operation.Remark = _opration.Remark; _Operation.OprationRole = _opration.OprationRole; _Operation.OprationGrade = _opration.OprationGrade; _Operation.PartName = _opration.PartName; _ORepository.Insert(_Operation); GenaricRepository<TempOpration> _tOpration = new GenaricRepository<TempOpration>(new ItrackContext()); TempOpration t = new TempOpration(); t.TempOprationID = _opration.TempOprationID; _tOpration.Delete(t); } } catch(Exception ex){ Debug.WriteLine(ex.Message); } }
void getUpdatedList() { foreach (var item in lst.Where(x => x.Selected == true)) { //lstselected.Add(new OperationListSelection(item.OprationNo, item.OprationName, item.SMV, item.WorkstationNo,item.Selected)); MessageBox.Show(item.OprationNo); DividingPlanItem _item = new DividingPlanItem(); if (_item.DividingPlanHeaderID != 0) { _item.DividingPlanHeaderID = Convert.ToInt16(this.DividingPlanHeader); } else { _item.DividingPlanHeaderID = DividingPlanHeader; } _item.OprationNo = item.OprationNo; _item.OprationName = item.OprationName; _item.MachineType = item.MachineType; _item.SMVType = item.SMVType; _item.SMV = item.SMV; _item.PartName = item.PartName; _item.OperationRole = item.OperationRole; _item.WorkstationNo = item.WorkstationNo; GenaricRepository<DividingPlanItem> _pDidingItemRepository = new GenaricRepository<DividingPlanItem>(new ItrackContext()); _item.OpNo = _pDidingItemRepository.GetAll().ToList().Where(X => X.DividingPlanHeaderID == _item.DividingPlanHeaderID).Count(); if (_pDidingItemRepository.Insert(_item) == true) { } } MessageBox.Show("Save Sucessfully !", "Done", MessageBoxButtons.OK, MessageBoxIcon.Information); }
public BindingList<OperationPool> ReadMyExcel(DevExpress.XtraEditors.ProgressBarControl bar ) { TempOpration t = new TempOpration(); bar.Show(); bar.Properties.Maximum = lastRow; bar.Properties.Step = 1; oprationList.Clear(); // EmpList.Clear(); for (int index = 5; index <= lastRow; index++) { System.Array MyValues = (System.Array)MySheet.get_Range("A" + index.ToString(), "G" + index.ToString()).Cells.Value; string opration = ""; string _OprationName = ""; string _MachineType = "None"; string _SMVtype = "none"; string _SMV = ""; string _PartName = "None"; string _OprationRole = "None"; string _OprationGrade = "None"; bool _hasData = false; if (MySheet.Cells[index, 1].Value != null) { opration = (string)(MySheet.Cells[index, 1].Value.ToString()); t.OprationID = opration; _hasData = true; // Debug.WriteLine(opration); } if (MySheet.Cells[index, 2].Value != null) { _OprationName = (string)(MySheet.Cells[index, 2].Value.ToString()); t.OparationName = _OprationName; if (MySheet.Cells[index, 1].Value != null) { } else { t.PartName = t.OparationName; } } if (MySheet.Cells[index, 3].Value != null) { _MachineType = (string)(MySheet.Cells[index, 3].Value.ToString()); t.MachineType = _MachineType; // Debug.WriteLine(opration); } if (MySheet.Cells[index, 4].Value != null) { _SMVtype = (string)(MySheet.Cells[index, 4].Value.ToString()); t.SMVType = _SMVtype; // D ebug.WriteLine(opration); } if (MySheet.Cells[index, 6].Value != null) { _SMV = (string)(MySheet.Cells[index, 6].Value.ToString()); _SMVtype = "M/C"; try { t.SMV = Convert.ToDouble(_SMV); t.SMVType = _SMVtype; } catch(Exception ex){ t.SMV = 0; t.SMVType = _SMVtype; Debug.WriteLine(ex.Message); } // D ebug.WriteLine(opration); } if (MySheet.Cells[index, 7].Value != null) { _SMV = (string)(MySheet.Cells[index, 7].Value.ToString()); _SMVtype = "M/A"; try { t.SMV = Convert.ToDouble(_SMV); t.SMVType = _SMVtype; } catch(Exception ex){ t.SMV = 0; t.SMVType = _SMVtype; Debug.WriteLine(ex.Message); } // D ebug.WriteLine(opration); } if (MySheet.Cells[index, 8].Value != null) { _OprationRole = (string)(MySheet.Cells[index, 8].Value.ToString()); t.OprationRole = _OprationRole; // D ebug.WriteLine(opration); } else { t.OprationRole ="None"; } if (MySheet.Cells[index, 9].Value != null) { _OprationGrade = (string)(MySheet.Cells[index, 9].Value.ToString()); t.OprationGrade = _OprationGrade; // D ebug.WriteLine(opration); } else { t.OprationGrade = "None"; } GenaricRepository<TempOpration> _TempOprationRepository = new GenaricRepository<TempOpration>(new ItrackContext()); bar.PerformStep(); if (_hasData == true && GetoprationByID(t.OprationID).Count == 0) { _TempOprationRepository.Insert(t); } //oprationList.Add(new OperationPool // { // OperationPoolID = MyValues.GetValue(1, 1).ToString(), // OpationName = MyValues.GetValue(1, 2).ToString(), // MachineType = MyValues.GetValue(1, 3).ToString(), // SMVType = MyValues.GetValue(1, 4).ToString(), // SMV = Convert.ToDouble(MyValues.GetValue(1, 4).ToString()) // }); } bar.Hide(); return oprationList; }
public static async Task<bool> ReadDevidingPlan() { try { DividingPlanTemp temp = new DividingPlanTemp(); bool _hasData= false; if (MySheet.Cells[4, 2].Value != null) { temp.StyleID = (string)(MySheet.Cells[4, 2].Value.ToString()); _hasData = true; // Debug.WriteLine(opration); } if (MySheet.Cells[4, 4].Value != null) { temp.LineNo = (string)(MySheet.Cells[4, 4].Value.ToString()); _hasData = true; // Debug.WriteLine(opration); } if (MySheet.Cells[5, 6].Value != null) { temp.Target = (string)(MySheet.Cells[5, 6].Value.ToString()); _hasData = true; } if (MySheet.Cells[4, 6].Value != null) { string i = (string)(MySheet.Cells[4, 6].Value.ToString()); temp.TotalEmployee = i; // Debug.WriteLine(opration); } if (MySheet.Cells[6, 6].Value != null) { temp.ProductionPerHour = (string)(MySheet.Cells[6, 6].Value.ToString()); _hasData = true; // Debug.WriteLine(opration); } for (int index = 9; index <= lastRow; index++) { if (MySheet.Cells[index, 1].Value != null) { temp.OprationNo = (string)(MySheet.Cells[index, 1].Value.ToString()); _hasData = true; // Debug.WriteLine(opration); } else { temp.OprationNo = ""; _hasData = false; } if (MySheet.Cells[index, 2].Value != null) { temp.OprationName = (string)(MySheet.Cells[index, 2].Value.ToString()); // Debug.WriteLine(opration); } else { temp.OprationName = ""; } if (MySheet.Cells[index, 3].Value != null) { temp.MachineType = (string)(MySheet.Cells[index, 3].Value.ToString()); // Debug.WriteLine(opration); } else { temp.MachineType = ""; } if (MySheet.Cells[index, 4].Value != null) { temp.SMV = (string)(MySheet.Cells[index, 4].Value.ToString()); temp.SMVType = "M/C"; try { temp.SMV = temp.SMV; temp.SMVType = temp.SMVType; } catch (Exception ex) { temp.SMV = "0"; temp.SMVType = temp.SMVType; Debug.WriteLine(ex.Message); } // D ebug.WriteLine(opration); } if (MySheet.Cells[index, 5].Value != null) { temp.SMV = (string)(MySheet.Cells[index, 5].Value.ToString()); temp.SMVType = "M/A"; temp.MachineType ="None"; try { temp.SMV = temp.SMV; temp.SMVType = temp.SMVType; } catch (Exception ex) { temp.SMV = "0"; temp.SMVType = temp.SMVType; Debug.WriteLine(ex.Message); } // D ebug.WriteLine(opration); } GenaricRepository<DividingPlanTemp> _DevidingPlanRepository = new GenaricRepository<DividingPlanTemp>(new ItrackContext()); if (_hasData) { _DevidingPlanRepository.Insert(temp); Debug.WriteLine(temp.OprationNo + " | " + temp.OprationName + " | " + temp.MachineType + " | " + temp.SMVType + " | " + temp.SMV); } } return true; } catch(Exception ex){ Debug.WriteLine(ex.Message); return false; } }
/// <summary> /// /// </summary> /// <returns></returns> public bool addBundleDetails(BundleDetails _bandle,Int64 _bundleHeaderID) { try { GenaricRepository<BundleDetails> _BundleDetails = new GenaricRepository<BundleDetails>(new ItrackContext()); _bandle.BundleHeaderID = _bundleHeaderID; _bandle.BundleTagPrintedBy = "None"; _bandle.BundleTagPrintedTime = "None"; _bandle.isBundleTagsPrinted = false; _bandle.BundleStickerPrintedBy = "None"; _bandle.BundleStickerPrintedTime = "None"; _bandle.BundleTagPrintedBy = "None"; _BundleDetails.Insert(_bandle); return true; } catch(Exception ex){ Debug.WriteLine(ex.Message); return false; } }
public void genarateTestData() { try { for(int i = 0 ; i <6000000; i++){ GenaricRepository<OprationBarcodes> _OprationTagsRepo = new GenaricRepository<OprationBarcodes>(new ItrackContext()); _barcode.OprationBarcodesID = i.ToString().PadLeft(14, '0'); _barcode.OprationNO = "A"; _barcode.OprationRole = ""; _barcode.OprationGrade = "A"; _barcode.PartName = ""; _barcode.OparationName = "A"+i; _barcode.EmployeeID = "None"; _barcode.isOparationComplete = false; _barcode.OprationComplteAt = Convert.ToDateTime(DateTime.Now.ToShortDateString()); _barcode.BundleDetailsID = 449; _OprationTagsRepo.Insert(_barcode); } } catch(Exception ex){ Debug.WriteLine(ex.Message); } }
public static async Task<bool> AddIndividualProductionSummary(DateTime dayendDate,string _HourNo) { try { GenaricRepository<OprationBarcodes> _OperationBarcode = new GenaricRepository<OprationBarcodes>(new ItrackContext()); GenaricRepository<IndividualProductionSummery> _IndivialProudctionRepo = new GenaricRepository<IndividualProductionSummery>(new ItrackContext()); IndividualProductionSummery _individualProductionSummary = new IndividualProductionSummery(); var itemList = from items in _OperationBarcode.GetAll().ToList() where items.isOparationComplete == true && items.OprationComplteAt.Day == dayendDate.Day && items.OprationComplteAt.Month == dayendDate.Month && items.OprationComplteAt.Year == dayendDate.Year && items.HourNo == _HourNo group items by new { items.OprationComplteAt.Date, items.LineNo, items.EmployeeID, items.OprationNO, items.OparationName } into ItemG select new { ItemG.Key.Date, ItemG.Key.LineNo, ItemG.Key.EmployeeID, ItemG.Key.OprationNO, ItemG.Key.OparationName, TotalItem = ItemG.Sum(c => c.BundleDetails.NoOfItem), SMV = ItemG.Sum(c => c.OperationPool.SMV * c.BundleDetails.NoOfItem) }; foreach (var summary in itemList) { Debug.WriteLine("Employee Name -" + summary.EmployeeID + " opration Name" + summary.OparationName + " No Of Item - " + summary.TotalItem + " Total SAH - " + summary.SMV / 60); GenaricRepository<IndividualProductionSummery> _IndivialRepo = new GenaricRepository<IndividualProductionSummery>(new ItrackContext()); _individualProductionSummary.EmployeeID = summary.EmployeeID; _individualProductionSummary.OprationNo = summary.OprationNO; _individualProductionSummary.Pcs = Convert.ToInt16(summary.TotalItem); _individualProductionSummary.EarnSAH = Convert.ToDouble((summary.SMV / 60).ToString("G7", CultureInfo.InvariantCulture)); _individualProductionSummary.Effiency = summary.SMV; _individualProductionSummary.DayendHeaderID = Convert.ToString(dayendDate.Year + dayendDate.Month + dayendDate.Day); _individualProductionSummary.IndividualProductionSummeryID = _individualProductionSummary.DayendHeaderID + summary.EmployeeID; _IndivialRepo.Insert(_individualProductionSummary); } return true; } catch (Exception ex) { Debug.WriteLine(ex.Message); return false; } }
public static async Task<bool> AddIndividualProductionSummary(DateTime dayendDate, string _HourNo,string In,string _Out) { try { GenaricRepository<OprationBarcodes> _OperationBarcode = new GenaricRepository<OprationBarcodes>(new ItrackContext()); GenaricRepository<IndividualProductionSummery> _IndivialProudctionRepo = new GenaricRepository<IndividualProductionSummery>(new ItrackContext()); IndividualProductionDetails _individualProductionSummary = new IndividualProductionDetails(); var itemList = from items in _OperationBarcode.GetAll().ToList() where items.isOparationComplete == true && items.OprationComplteAt.Day == dayendDate.Day && items.OprationComplteAt.Month == dayendDate.Month && items.OprationComplteAt.Year == dayendDate.Year && items.HourNo ==_HourNo group items by new {items.BundleDetails.BundleHeader.CuttingItem.CuttingHeader.StyleID, items.OprationComplteAt.Date, items.LineNo, items.EmployeeID,items.WorkstationNo,items.OprationNO, items.OparationName,items.HourNo } into ItemG select new {ItemG.Key.StyleID, ItemG.Key.Date, ItemG.Key.LineNo, ItemG.Key.EmployeeID,ItemG.Key.WorkstationNo,ItemG.Key.OprationNO, ItemG.Key.HourNo, ItemG.Key.OparationName,TotalItem = ItemG.Sum(c => c.BundleDetails.NoOfItem), SMV = ItemG.Sum(c => c.OperationPool.SMV*c.BundleDetails.NoOfItem) }; GenaricRepository<Company> _CompanyRepository = new GenaricRepository<Company>(new ItrackContext()); foreach (var item in _CompanyRepository.GetAll().Where(x => x.isDefaultCompany == true)) { _individualProductionSummary.CompanyID = item.CompanyID; } foreach (var summary in itemList) { Debug.WriteLine("Employee Name -" +summary.EmployeeID +" opration Name"+ summary.OparationName +" No Of Item - " + summary.TotalItem + " Total SAH - " + summary.SMV/60); GenaricRepository<IndividualProductionDetails> _IndivialRepo = new GenaricRepository<IndividualProductionDetails>(new ItrackContext()); _individualProductionSummary.EmployeeID = summary.EmployeeID; _individualProductionSummary.Date = summary.Date; _individualProductionSummary.SMV = summary.SMV/summary.TotalItem; _individualProductionSummary.OperationNo = summary.OprationNO; _individualProductionSummary.OperationName = summary.OparationName; _individualProductionSummary.Pcs =Convert.ToInt16( summary.TotalItem); _individualProductionSummary.SAH = Convert.ToDouble((_individualProductionSummary.SMV * summary.TotalItem / 60).ToString("G7", CultureInfo.InvariantCulture)); _individualProductionSummary.SAH =Convert.ToDouble( String.Format("{0:0.00}", _individualProductionSummary.SAH)); _individualProductionSummary.Efficiency = _individualProductionSummary.SAH / 1 * 100; _individualProductionSummary.Efficiency = Convert.ToDouble(String.Format("{0:0.00}", _individualProductionSummary.Efficiency)); _individualProductionSummary.HourNo =Convert.ToInt16( _HourNo); _individualProductionSummary.WorkstationNo = summary.WorkstationNo; _individualProductionSummary.StyleNo = summary.StyleID; if (summary.EmployeeID != null) { _IndivialRepo.Insert(_individualProductionSummary); } } int i = 9; //------------------------------------------------------------------------------------------------------------------------------------------- //--------------------------------------------------------------------------------------------------------------------------------------------- var SizeList = from items in _OperationBarcode.GetAll().ToList() where items.isOparationComplete == true && items.OprationComplteAt.Day == dayendDate.Day && items.OprationComplteAt.Month == dayendDate.Month && items.OprationComplteAt.Year == dayendDate.Year && items.HourNo == _HourNo && (items.OprationNO == In || items.OprationNO == _Out) group items by new { items.OprationComplteAt.Date, items.StyleNo, items.LineNo, items.BundleDetails.BundleHeader.CuttingItem.PoNo, items.HourNo, items.OprationNO, items.OprationRole, items.BundleDetails.BundleHeader.CuttingItem.Color, items.BundleDetails.BundleHeader.CuttingItem.Size } into ItemG select new { ItemG.Key.Date, ItemG.Key.StyleNo, ItemG.Key.LineNo, ItemG.Key.PoNo, ItemG.Key.HourNo, ItemG.Key.OprationNO, ItemG.Key.OprationRole, ItemG.Key.Color, ItemG.Key.Size, TotalItem = ItemG.Sum(c => c.BundleDetails.NoOfItem), SMV = ItemG.Sum(c => c.OperationPool.SMV * c.BundleDetails.NoOfItem) }; DailyProduction _production =new DailyProduction(); foreach (var sizeItem in SizeList) { GenaricRepository<DailyProduction> _Indivial = new GenaricRepository<DailyProduction>(new ItrackContext()); _production.PoNo = sizeItem.PoNo; _production.Date = sizeItem.Date; _production.HourNo = Convert.ToInt16(sizeItem.HourNo); _production.LineNo = sizeItem.LineNo; _production.Color = sizeItem.Color; _production.Size = sizeItem.Size; _production.Type = sizeItem.OprationRole; _production.Qty = Convert.ToInt16(sizeItem.TotalItem); _production.StyleID = sizeItem.StyleNo; _Indivial.Insert(_production); } return true; } catch(Exception ex){ Debug.WriteLine(ex.Message); return false; } }
void saveOparation() { try { GenaricRepository<DividingPlanHeader> _dHeaderRepo = new GenaricRepository<DividingPlanHeader>(new ItrackContext()); DividingPlanHeader dHeader = new DividingPlanHeader(); dHeader.LineNo = txtLineNo.Text; dHeader.ProductionPerHour =Convert.ToInt16( txtProductionPerHour.Text); dHeader.StyleID = txtStyleNo.Text; dHeader.TotalEmployee =Convert.ToInt16( txtTotalEmployee.Text); dHeader.Target =Convert.ToInt16(txtTarget.Text); _dHeaderRepo.Add(dHeader); dHeader.DividingPlanheaderID = _dHeaderRepo.GetAll().ToList().Last().DividingPlanheaderID; for (int i = 0; i < gridView3.RowCount; i++) { GenaricRepository<DividingPlanItem> _dItemRepo = new GenaricRepository<DividingPlanItem>(new ItrackContext()); DividingPlanItem dItem = new DividingPlanItem(); dItem.OprationNo = gridView3.GetRowCellValue(i, "OprationNo").ToString(); dItem.OprationName = gridView3.GetRowCellValue(i, "OprationName").ToString(); dItem.SMVType = gridView3.GetRowCellValue(i, "SMVType").ToString(); dItem.MachineType = gridView3.GetRowCellValue(i, "MachineType").ToString(); dItem.SMV =Convert.ToDouble( gridView3.GetRowCellValue(i, "SMV").ToString()); dItem.DividingPlanHeaderID = dHeader.DividingPlanheaderID; dItem.PartName = gridView3.GetRowCellValue(i, "PartName").ToString(); string status = gridView3.GetRowCellValue(i, "Selected").ToString(); GenaricRepository<DividingPlanTemp> _dItemTempRepo = new GenaricRepository<DividingPlanTemp>(new ItrackContext()); DividingPlanTemp dTemp = new DividingPlanTemp(); dTemp.DividingPlanTempID = Convert.ToInt16(gridView3.GetRowCellValue(i, "DividingPlanTempID").ToString()); if (status == "True") { _dItemRepo.Insert(dItem); _dItemTempRepo.Delete(dTemp); } else { } } } catch(Exception ex){ Debug.WriteLine(ex.Message); } }