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