private void FrmReportErrorOfLineByHours_Load(object sender, EventArgs e) { try { errors.AddRange(BLLError.GetAll()); lines.AddRange(BLLLine.GetLines(AccountSuccess.strListChuyenId.Split(',').Select(x => Convert.ToInt32(x)).ToList())); if (lines != null && lines.Count > 0) { GetDataForCbbHours(); if (times != null && times.Count > 0) { cbbHours.DataSource = times; cbbHours.DisplayMember = "Name"; GetDataChart(); } } else { MessageBox.Show("Lỗi: Không có thông tin Chuyền", "Thông Báo Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show("Lỗi: " + ex.Message, "Thông Báo Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void LoadError() { cbError.DataSource = null; var err = BLLError.GetAll(); cbError.DataSource = err; cbError.DisplayMember = "Name"; cbError.ValueMember = "Id"; }
private void LoadDataForGridError() { try { gridError.DataSource = BLLError.GetAll(); } catch (Exception ex) { throw ex; } }
private void FormSanLuongLoiChuyen_Load(object sender, EventArgs e) { try { listError = BLLError.GetAll();//errorDAO.GetListError(); BuildGridView(); LoadData(); } catch (Exception ex) { MessageBox.Show("Lỗi: " + ex.Message); } }
private void FrmReportCountErrorHours_Load(object sender, EventArgs e) { try { listError = BLLError.GetAll(); // errorDAO.GetListError(); GetDataForCbbLine(); GetDataChart(); } catch (Exception ex) { MessageBox.Show("Lỗi: " + ex.Message); } }
public bool AddNangSuatCumLoiOfChuyen(int sttChuyenSanPham, int maChuyen) { try { bool result = false; string dateNow = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year; var listCluster = clusterDAO.GetCumOfChuyen(maChuyen); if (listCluster != null && listCluster.Count > 0) { List <string> listQuery = new List <string>(); foreach (var cluster in listCluster) { var listError = BLLError.GetAll(); // errorDAO.GetListError(); if (listError != null && listError.Count > 0) { foreach (var error in listError) { string strSQLCheckExist = "Select Id From NangSuat_CumLoi Where STTChuyenSanPham=" + sttChuyenSanPham + " and IsDeleted=0 and CumId=" + cluster.Id + " and Ngay ='" + dateNow + "' and ErrorId=" + error.Id; DataTable dtCheckExist = dbclass.TruyVan_TraVe_DataTable(strSQLCheckExist); if (dtCheckExist == null || (dtCheckExist != null && dtCheckExist.Rows.Count == 0)) { listQuery.Add("Insert Into NangSuat_CumLoi(Ngay, STTChuyenSanPham, CumId, ErrorId) Values('" + dateNow + "'," + sttChuyenSanPham + ", " + cluster.Id + ", " + error.Id + ")"); } } } } if (listQuery.Count > 0) { int rs = dbclass.ExecuteSqlTransaction(listQuery); if (rs > 0) { result = true; } } else { result = true; } } return(result); } catch (Exception ex) { throw ex; } }
private void FrmCauHinhDocSo_Load(object sender, EventArgs e) { try { LoadDataToGridView(); //LoadCbbSoundInt(); EnableControlSend(true, false, false, false, false); ClearInput(); EnableInputMSend(false); var listError = BLLError.GetAll(); // errorDAO.GetListError(); cbbError1.DataSource = listError; cbbError1.DisplayMember = "Name"; cbbError2.DataSource = listError; cbbError2.DisplayMember = "Name"; } catch (Exception ex) { MessageBox.Show("Lỗi: " + ex.Message); } }
/// <summary> /// khoi tao lai thong tin keypad cho chuyen /// </summary> /// <param name="lineId"></param> /// <param name="IsResetAllToZero">= true neu reset tat ca ve 0 else neu lay thong tin nang suat hien tai</param> /// <param name="frmMainNew"></param> /// <returns></returns> public static bool ResetKeypad_Moi(int lineId, bool IsResetAllToZero, FrmMainNew frmMainNew) { try { var listMapIdSanPhamNgay = new List <PMS.Data.MapIdSanPhamNgay>(); string ngay = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year; var listStrProductConfig = new List <string>(); var errors = BLLError.GetAll(); string strListChuyen = lineId + ","; var assigns = BLLProductivity.GetProductivitiesInDay(ngay, lineId); if (assigns != null && assigns.Count > 0) { var listStrSend = new List <string>(); var listStrSetSanLuong = new List <string>(); var sanluongs = new List <string>(); var sttCSP = new List <int>(); int stt = 0; foreach (var item in assigns) { var mapIdSanPhamNgay = new PMS.Data.MapIdSanPhamNgay(); mapIdSanPhamNgay.MaChuyen = item.LineId; mapIdSanPhamNgay.STTChuyenSanPham = item.STTCHuyen_SanPham; mapIdSanPhamNgay.MaSanPham = item.productId; stt += 1; mapIdSanPhamNgay.STT = stt; mapIdSanPhamNgay.Ngay = ngay; listMapIdSanPhamNgay.Add(mapIdSanPhamNgay); string strSend = mapIdSanPhamNgay.STT.ToString() + ","; string tenSanPham = item.ProductName; if (!string.IsNullOrEmpty(tenSanPham)) { if (tenSanPham.Length > 10) { strSend += tenSanPham.Substring(0, 10); } else { strSend += tenSanPham; } } listStrSend.Add(strSend); listStrSetSanLuong.Add(mapIdSanPhamNgay.STT.ToString()); sttCSP.Add(item.STTCHuyen_SanPham); } // var keypads = BLLKeyPad.GetKeyPadInfoByLineId(lineId); if (keypads != null && keypads.Count > 0) { if (listStrSend.Count > 0 || listStrSetSanLuong.Count > 0) { foreach (var kp_Obj in keypads) { if (kp_Obj.UseTypeId == (int)eUseKeyPadType.OneKeyPadOneObject) { frmMainNew.listDataSendKeyPad.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ClearData + ",,"); Thread.Sleep(500); foreach (var strSend in listStrSend) { listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ProductConfig + "," + strSend); } if (IsResetAllToZero) // reset keypad + reset so lieu ve 0 { #region foreach (var strSend in listStrSetSanLuong) { // listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ChangeBTPQuantities + "," + strSend + ",0,1,"); if (errors != null && errors.Count > 0) { foreach (var error in errors) { listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ChangeProductError + "," + strSend + ",0," + error.Code); } } switch (kp_Obj.TypeOfKeypad) { case (int)eTypeOfKeypad.All: listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ChangeProductQuantity + "," + strSend + ",0," + (int)eProductOutputType.KCS); listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ChangeProductQuantity + "," + strSend + ",0," + (int)eProductOutputType.TC); listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ChangeBTPQuantities + "," + strSend + ",0,,"); listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ChangeBTPQuantities + "," + strSend + ",0,1,"); break; case (int)eTypeOfKeypad.KCS: listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ChangeProductQuantity + "," + strSend + ",0," + (int)eProductOutputType.KCS); break; case (int)eTypeOfKeypad.TC: listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ChangeProductQuantity + "," + strSend + ",0," + (int)eProductOutputType.TC); break; case (int)eTypeOfKeypad.BTP: listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ChangeBTPQuantities + "," + strSend + ",0,,"); listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ChangeBTPQuantities + "," + strSend + ",0,1,"); break; } } #endregion } else // chi reset keypad van giu so lieu cũ { for (int i = 0; i < listStrSetSanLuong.Count; i++) { var nxInDay = BLLProductivity.GetProductivitiesInDay(DateTime.Now, sttCSP[i]); if (nxInDay != null) { var tdns = BLLDayInfo.GetByCommoId(sttCSP[i], nxInDay.productId, frmMainNew.todayStr).Where(x => x.EquipmentId == kp_Obj.EquipmentId).ToList(); var btps = BLLDayInfo.GetBTPNgay(sttCSP[i], frmMainNew.todayStr).Where(x => x.EquipmentId == kp_Obj.EquipmentId).ToList(); var quantities = 0; if (errors != null && errors.Count > 0) { foreach (var error in errors) { quantities = tdns.Where(c => c.CommandTypeId == (int)eCommandRecive.ErrorIncrease && c.ErrorId.HasValue && c.ErrorId.Value == error.Id).Sum(c => c.ThanhPham); quantities -= tdns.Where(c => c.CommandTypeId == (int)eCommandRecive.ErrorReduce && c.ErrorId.HasValue && c.ErrorId.Value == error.Id).Sum(c => c.ThanhPham); listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ChangeProductError + "," + listStrSetSanLuong[i] + "," + (quantities < 0 ? 0 : quantities) + "," + error.Code); } } switch (kp_Obj.TypeOfKeypad) { case (int)eTypeOfKeypad.All: quantities = tdns.Where(c => c.CommandTypeId == (int)eCommandRecive.ProductIncrease && c.ProductOutputTypeId == (int)eProductOutputType.KCS).Sum(c => c.ThanhPham); quantities -= tdns.Where(c => c.CommandTypeId == (int)eCommandRecive.ProductReduce && c.ProductOutputTypeId == (int)eProductOutputType.KCS).Sum(c => c.ThanhPham); listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ChangeProductQuantity + "," + listStrSetSanLuong[i] + "," + (quantities < 0 ? 0 : quantities) + "," + (int)eProductOutputType.KCS); quantities = tdns.Where(c => c.CommandTypeId == (int)eCommandRecive.ProductIncrease && c.ProductOutputTypeId == (int)eProductOutputType.TC).Sum(c => c.ThanhPham); quantities -= tdns.Where(c => c.CommandTypeId == (int)eCommandRecive.ProductReduce && c.ProductOutputTypeId == (int)eProductOutputType.TC).Sum(c => c.ThanhPham); listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ChangeProductQuantity + "," + listStrSetSanLuong[i] + "," + (quantities < 0 ? 0 : quantities) + "," + (int)eProductOutputType.TC); quantities = btps.Where(c => c.CommandTypeId == (int)eCommandRecive.BTPIncrease).Sum(c => c.BTPNgay); quantities -= btps.Where(c => c.CommandTypeId == (int)eCommandRecive.BTPReduce).Sum(c => c.BTPNgay); listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ChangeBTPQuantities + "," + listStrSetSanLuong[i] + "," + (quantities < 0 ? 0 : quantities) + ",,"); listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ChangeBTPQuantities + "," + listStrSetSanLuong[i] + "," + 0 + ",1"); break; case (int)eTypeOfKeypad.KCS: quantities = tdns.Where(c => c.CommandTypeId == (int)eCommandRecive.ProductIncrease && c.ProductOutputTypeId == (int)eProductOutputType.KCS).Sum(c => c.ThanhPham); quantities -= tdns.Where(c => c.CommandTypeId == (int)eCommandRecive.ProductReduce && c.ProductOutputTypeId == (int)eProductOutputType.KCS).Sum(c => c.ThanhPham); listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ChangeProductQuantity + "," + listStrSetSanLuong[i] + "," + (quantities < 0 ? 0 : quantities) + "," + (int)eProductOutputType.KCS); break; case (int)eTypeOfKeypad.TC: quantities = tdns.Where(c => c.CommandTypeId == (int)eCommandRecive.ProductIncrease && c.ProductOutputTypeId == (int)eProductOutputType.TC).Sum(c => c.ThanhPham); quantities -= tdns.Where(c => c.CommandTypeId == (int)eCommandRecive.ProductReduce && c.ProductOutputTypeId == (int)eProductOutputType.TC).Sum(c => c.ThanhPham); listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ChangeProductQuantity + "," + listStrSetSanLuong[i] + "," + (quantities < 0 ? 0 : quantities) + "," + (int)eProductOutputType.TC); break; case (int)eTypeOfKeypad.BTP: quantities = 0; quantities = btps.Where(c => c.CommandTypeId == (int)eCommandRecive.BTPIncrease).Sum(c => c.BTPNgay); quantities -= btps.Where(c => c.CommandTypeId == (int)eCommandRecive.BTPReduce).Sum(c => c.BTPNgay); listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ChangeBTPQuantities + "," + listStrSetSanLuong[i] + "," + (quantities < 0 ? 0 : quantities) + ",,"); listStrProductConfig.Add(kp_Obj.EquipmentId.ToString() + "," + (int)eCommandSend.ChangeBTPQuantities + "," + listStrSetSanLuong[i] + "," + 0 + ",1"); break; } } } } } } } } } if (!string.IsNullOrEmpty(strListChuyen) && listMapIdSanPhamNgay.Count > 0) { #region var resultAdd = BLLMapCommoIdForDay.AddMapIdSanPhamNgay(strListChuyen.Substring(0, strListChuyen.Length - 1).Split(',').Select(x => Convert.ToInt32(x)).ToList(), listMapIdSanPhamNgay);; if (resultAdd) { if (listStrProductConfig.Count > 0) { frmMainNew.listDataSendKeyPad.AddRange(listStrProductConfig); } if (frmMainNew.listMapIdSanPhamNgay != null) { var olds = frmMainNew.listMapIdSanPhamNgay.Where(x => x.MaChuyen == lineId).ToList(); if (olds.Count > 0) { foreach (var item in olds) { frmMainNew.listMapIdSanPhamNgay.Remove(item); } } } else if (frmMainNew.listMapIdSanPhamNgay == null) { frmMainNew.listMapIdSanPhamNgay = new List <PMS.Data.MapIdSanPhamNgay>(); } frmMainNew.listMapIdSanPhamNgay.AddRange(listMapIdSanPhamNgay); // Reset lai thong tin ngay ve 0 if (IsResetAllToZero) { BLLProductivity.ResetDayInforByDate(DateTime.Now, assigns.Select(x => x.STTCHuyen_SanPham).ToList(), frmMainNew.getBTPInLineByType); } return(true); } #endregion } } catch (Exception) { } return(false); }