private void DoMckey() { _hanso = DbAccess.GetHanSo(_mckey); if (_hanso == null) { msgBox.Text = "没有搬送数据"; return; } if (_hanso.SAGYOKBN == "5") { setStatusBox("盘库"); } _bucket = DbAccess.GetBucket(_hanso.BUCKET_NO); if (_bucket == null) { setStatusBox("空箱未登录"); return; } List <FNSIJIEntity> sijis = DbAccess.GetSiJis(_mckey); if (sijis != null && sijis.Count > 0) { _zKey = DbAccess.GetManagedZKey(sijis[0].ZAIKEY); bucketNoBox.Text = _bucket.BUCKET_NO; bucketWeightBox.Text = _bucket.PACKING_WEIGHT.ToString(); ticketNoBox.Text = sijis[0].TICKET_NO; //colorCodeBox.Text = sijis[0].COLOR_CODE; itemCodeBox.Text = _zKey.ZAIKEY; itemNameBox1.Text = _zKey.ZKNAME1; itemNameBox2.Text = _zKey.ZKNAME2; itemNameBox3.Text = _zKey.ZKNAME3; FNZAIKOEntity zaiKo = DbAccess.GetZaiKoByTicketNo(sijis[0].TICKET_NO); if (zaiKo == null) { msgBox.Text = "没有库存数据"; return; } unitWeightBox.Text = (zaiKo.REAL_UNIT_WEIGHT * 1000).ToString(); sectionBox.Text = zaiKo.MADE_SECTION; lineBox.Text = zaiKo.MADE_LINE; colorCodeBox.Text = zaiKo.COLOR_CODE; planCountBox.Text = zaiKo.ZAIKOSU.ToString(); planWeightBox.Text = (zaiKo.ZAIKOSU * zaiKo.REAL_UNIT_WEIGHT).ToString();// zaiKo.PLAN_WEIGHT.ToString(); plasticBagStatusBox.Text = zaiKo.BAG_FLAG == "1" ? "有" : "无"; chkUsingPlasticBag.Checked = zaiKo.BAG_FLAG == "1"; fixedWeightBox.Text = (GlobalAccess.FixedWeight * 1000).ToString(); setStatusBox("正常"); } else { msgBox.Text = "无数据"; return; } }
private void oldUnitWeightBtn_Click(object sender, EventArgs e) { try { FNZAIKOEntity zaikoEntity = DbAccess.GetZaiKoByTicketNo(ticketNoBox.Text); if (zaikoEntity == null) { msgBox.Text = "库存数据不存在,不能更改单位重量"; return; } else { msgBox.Text = string.Empty; UnitWeightChange uwc = new UnitWeightChange(zaikoEntity); if (uwc.ShowDialog(this) == DialogResult.OK) { zaikoEntity = DbAccess.GetZaiKoByTicketNo(ticketNoBox.Text); //FMBUCKETEntity bucket = DbAccess.GetBucket(newBucketNoBox.Text); unitWeightBox.Text = (zaikoEntity.REAL_UNIT_WEIGHT * 1000).ToString(); planWeightBox.Text = (zaikoEntity.ZAIKOSU * zaikoEntity.REAL_UNIT_WEIGHT).ToString(); } } } catch (Exception ex) { msgBox.Text = ex.Message; } }
private void unitWeightBtn_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(ticketNoBox.Text)) { msgBox.Text = "没有对应的作业数据"; return; } FNZAIKOEntity zaikoEntity = DbAccess.GetZaiKoByTicketNo(ticketNoBox.Text); if (zaikoEntity == null) { msgBox.Text = "库存数据不存在,不能更改单位重量"; return; } else { msgBox.Text = string.Empty; UnitWeightChange uwc = new UnitWeightChange(zaikoEntity); if (uwc.ShowDialog(this) == DialogResult.OK) { zaikoEntity = DbAccess.GetZaiKoByTicketNo(ticketNoBox.Text); unitWeightBox.Text = (zaikoEntity.REAL_UNIT_WEIGHT * 1000).ToString(); sendMessageBtn.PerformClick(); } } } catch (Exception ex) { msgBox.Text = ex.Message; } }
private void setBtn_Click(object sender, EventArgs e) { string schno = string.Empty; try { if (statusBox.Text == "系统Offline") { return; } if (statusBox.Text == "通过") { return; } if (_isOperating == false) { return; } if (_touCyaKu == null) { msgBox.Text = "没有到达报告"; return; } if (statusBox.Text == "空箱登录模式" || statusBox.Text == "正常") { if (statusBox.Text == "正常") { FNSTATIONEntity station = DbAccess.GetStation(GlobalAccess.StationNo); if (station == null) { msgBox.Text = "无法取得站台信息"; return; } if (station.NYUSYUMODE == Nyusyumode.Empty_Bucket) { setStatusBox("空箱登录模式"); setUIOnEmptyBucketMode(); return; } if (ticketNoBox.Text.Trim() == string.Empty) { msgBox.Text = "TicketNo不能为空"; ticketNoBox.Focus(); ticketNoBox.SelectAll(); return; } if (effectiveTicketNo != ticketNoBox.Text) { msgBox.Text = "TicketNo无效"; ticketNoBox.Focus(); ticketNoBox.SelectAll(); return; } if (string.IsNullOrEmpty(unitWeightBox.Text)) { msgBox.Text = "请先获得单位重量"; unitWeightLoadBtn.Focus(); return; } if (decimal.Parse(unitWeightBox.Text) == 0) { msgBox.Text = "单位重量必须大于0"; unitWeightBox.Focus(); unitWeightBox.SelectAll(); return; } if (string.IsNullOrEmpty(itemWeightBox.Text)) { msgBox.Text = "请先读取Item重量"; weightLoadBtn.Focus(); return; } if (itemCountBox.Value <= 0) { msgBox.Text = "Item数量必须大于0"; itemCountBox.Focus(); itemCountBox.Select(); return; } if (Encoding.Default.GetByteCount(this.memoBox.Text) > memoBox.MaxLength) { msgBox.Text = "备注超长(规定长度是100个半角字符,1个汉字等于2个半角字符)"; memoBox.Focus(); memoBox.SelectAll(); return; } } else if (statusBox.Text == "空箱登录模式") { FNSTATIONEntity station = DbAccess.GetStation(GlobalAccess.StationNo); if (station == null) { msgBox.Text = "无法取得站台信息"; return; } if (station.NYUSYUMODE == Nyusyumode.Normal) { setStatusBox("空箱登录模式"); setUIOnNormalMode(); return; } if (string.IsNullOrEmpty(itemWeightBox.Text)) { msgBox.Text = "请先读取Item重量"; weightLoadBtn.Focus(); return; } if (decimal.Parse(itemWeightBox.Text) == 0) { msgBox.Text = "Item重量不可为0"; weightLoadBtn.Focus(); return; } } schno = DbAccess.generateScheduleNo(); FNGSETEntity fngset = new FNGSETEntity(); fngset.SCHNO = schno; fngset.MOTOSTNO = GlobalAccess.StationNo; fngset.SYORIFLG = "0"; fngset.USERID = GlobalAccess.UserId; fngset.USERNAME = GlobalAccess.UserName; if (statusBox.Text == "正常") { fngset.UNIT_WEIGHT = Convert.ToDecimal(unitWeightBox.Text) / 1000; fngset.MEASURE_WEIGHT = Convert.ToDecimal(itemWeightBox.Text); fngset.NYUSYUSU = itemCountBox.Value; fngset.MEMO = string.IsNullOrEmpty(memoBox.Text.Trim()) ? " " : memoBox.Text; fngset.TICKET_NO = effectiveTicketNo; fngset.SAINYUKBN = chkReStockIn.Checked ? "1" : " "; fngset.BAG_FLAG = chkUsingPlasticBag.Checked ? "1" : "0"; } else if (statusBox.Text == "空箱登录模式") { fngset.PACKING_WEIGHT = Convert.ToDecimal(itemWeightBox.Text); } fngset.Save(); DbAccess.callProcedure(schno, "stockin_1"); if (statusBox.Text == "正常") { FNZAIKOEntity zaikoEntity = DbAccess.GetZaiKoByTicketNo(effectiveTicketNo); _preZaiKey = zaikoEntity.ZAIKEY; _preColorCode = zaikoEntity.COLOR_CODE; _preUnitWeight = decimal.Parse(unitWeightBox.Text); DbAccess.callAfterStockin(zaikoEntity.WEIGHT_REPORT_COMPLETE_FLAG); } else if (statusBox.Text == "空箱登录模式") { DbAccess.callAfterStockin(string.Empty); } msgBox.Text = "设定成功"; ClearAll(); ticketNoBox.Focus(); ticketNoBox.SelectAll(); _isOperating = false; isRangeError = false; } else { exportBtn.PerformClick(); } } catch (Exception ex) { msgBox.Text = ex.Message; } finally { DbAccess.UpdateFngset(schno); } }
private void DoTicketNo() { string ticketNo = ticketNoBox.Text; if (string.IsNullOrEmpty(ticketNo.Trim())) { return; } _zaiKo = DbAccess.GetZaiKoByTicketNo(ticketNo); if (_zaiKo == null) { DbAccess.callSwitchOnLight(GlobalAccess.StationNo, LightType.Data_Error); msgBox.Text = "库存未登录"; itemCodeBox.Text = string.Empty; itemNameBox1.Text = string.Empty; itemNameBox2.Text = string.Empty; itemNameBox3.Text = string.Empty; colorCodeBox.Text = string.Empty; sectionBox.Text = string.Empty; lineBox.Text = string.Empty; planCountBox.Text = string.Empty; planWeightBox.Text = string.Empty; unitWeightBox.Text = string.Empty; measureFlagBox.Text = string.Empty; ticketNoBox.Focus(); ticketNoBox.SelectAll(); return; } if (_zaiKo.STORAGE_PLACE_FLAG == "0") //非平库 { DbAccess.callSwitchOnLight(GlobalAccess.StationNo, LightType.Data_Error); msgBox.Text = "库存已存在"; itemCodeBox.Text = string.Empty; itemNameBox1.Text = string.Empty; itemNameBox2.Text = string.Empty; itemNameBox3.Text = string.Empty; colorCodeBox.Text = string.Empty; sectionBox.Text = string.Empty; lineBox.Text = string.Empty; planCountBox.Text = string.Empty; planWeightBox.Text = string.Empty; unitWeightBox.Text = string.Empty; measureFlagBox.Text = string.Empty; ticketNoBox.Focus(); ticketNoBox.SelectAll(); return; } _zKey = DbAccess.GetManagedZKey(_zaiKo.ZAIKEY); if (_zKey == null) { DbAccess.callSwitchOnLight(GlobalAccess.StationNo, LightType.Data_Error); msgBox.Text = "没有此Item主数据"; itemCodeBox.Text = string.Empty; itemNameBox1.Text = string.Empty; itemNameBox2.Text = string.Empty; itemNameBox3.Text = string.Empty; colorCodeBox.Text = string.Empty; sectionBox.Text = string.Empty; lineBox.Text = string.Empty; planCountBox.Text = string.Empty; planWeightBox.Text = string.Empty; unitWeightBox.Text = string.Empty; measureFlagBox.Text = string.Empty; ticketNoBox.Focus(); ticketNoBox.SelectAll(); return; } msgBox.Clear(); itemCodeBox.Text = _zKey.ZAIKEY; itemNameBox1.Text = _zKey.ZKNAME1; itemNameBox2.Text = _zKey.ZKNAME2; itemNameBox3.Text = _zKey.ZKNAME3; colorCodeBox.Text = _zaiKo.COLOR_CODE; sectionBox.Text = _zaiKo.MADE_SECTION; lineBox.Text = _zaiKo.MADE_LINE; planCountBox.Text = _zaiKo.PLAN_QTY.ToString(); planWeightBox.Text = _zaiKo.PLAN_WEIGHT.ToString(); unitWeightBox.Text = (_zKey.MASTER_UNIT_WEIGHT * 1000).ToString(); checkCountBox.Value = _zKey.MEASURE_QTY; measureFlagBox.Text = _zKey.MEASURE_FLAG.Trim() == "0" ? "不要" : "要"; memoBox.Text = _zaiKo.MEMO; chkUsingPlasticBag.Checked = _zKey.BAG_FLAG.Trim() == "1"; fixedWeightBox.Text = (GlobalAccess.FixedWeight * 1000).ToString(); DoRange(_zaiKo); //处理原单位,入库许可上下限 if (_preZaiKey != _zKey.ZAIKEY || _preColorCode != _zaiKo.COLOR_CODE) { if (_zKey.MEASURE_FLAG.Trim() != "0") { unitWeightBox.Text = string.Empty; } } else { unitWeightBox.Text = _preUnitWeight.ToString(); } }
private void setBtn_Click(object sender, EventArgs e) { string schno = string.Empty; try { if (statusBox.Text == "系统Offline") { return; } if (!DoBucketNo()) { bucketNoBox.Focus(); bucketNoBox.SelectAll(); return; } if (statusBox.Text == "正常") { if (ticketNoBox.Text.Trim() == string.Empty) { msgBox.Text = "TicketNo不能为空"; ticketNoBox.Focus(); ticketNoBox.SelectAll(); return; } if (effectiveTicketNo != ticketNoBox.Text) { msgBox.Text = "TicketNo无效"; ticketNoBox.Focus(); ticketNoBox.SelectAll(); return; } if (string.IsNullOrEmpty(unitWeightBox.Text)) { msgBox.Text = "单位重量不能为空"; unitWeightLoadBtn.Focus(); return; } if (Encoding.Default.GetByteCount(this.memoBox.Text) > memoBox.MaxLength) { msgBox.Text = "备注超长(规定长度是100个半角字符,1个汉字等于2个半角字符)"; memoBox.Focus(); memoBox.SelectAll(); return; } schno = DbAccess.generateScheduleNo(); FNGSETEntity fngset = new FNGSETEntity(); fngset.SCHNO = schno; fngset.MOTOSTNO = GlobalAccess.StationNo; fngset.UNIT_WEIGHT = Convert.ToDecimal(unitWeightBox.Text) / 1000; fngset.MEMO = string.IsNullOrEmpty(memoBox.Text.Trim()) ? " " : memoBox.Text; fngset.USERID = GlobalAccess.UserId; fngset.USERNAME = GlobalAccess.UserName; fngset.SYORIFLG = "0"; fngset.TICKET_NO = effectiveTicketNo; fngset.BUCKET_NO = bucketNoBox.Text; fngset.SAINYUKBN = chkReStockIn.Checked ? "1" : " "; fngset.BAG_FLAG = chkUsingPlasticBag.Checked ? "1" : "0"; fngset.Save(); DbAccess.callProcedure(schno, "stockin_2"); DbAccess.callAfterStockin(string.Empty); msgBox.Text = "设定成功"; bucketNoBox.Focus(); bucketNoBox.SelectAll(); FNZAIKOEntity zaikoEntity = DbAccess.GetZaiKoByTicketNo(effectiveTicketNo); _preZaiKey = _zKey.ZAIKEY; _preColorCode = zaikoEntity.COLOR_CODE; _preUnitWeight = decimal.Parse(unitWeightBox.Text); ClearAll(); bucketNoBox.Focus(); bucketNoBox.SelectAll(); } else { msgBox.Text = "非正常模式下不能进行设定"; } } catch (Exception ex) { msgBox.Text = ex.Message; } finally { DbAccess.UpdateFngset(schno); } }