private void btn_Qry_Click(object sender, EventArgs e) { string sErr = ""; string sql = this.GetSql(); DataSet set = null; Cursor.Current = Cursors.WaitCursor; try { set = DBFuns.GetDataBySql(base.AppInformation.SvrSocket, false, sql, "IOStoreDtl", 0, 0, "", out sErr); Cursor.Current = Cursors.Default; } catch (Exception exception) { Cursor.Current = Cursors.Default; MessageBox.Show(exception.Message); return; } if ((sErr.Trim() != "") && (sErr.Trim() != "0")) { MessageBox.Show(sErr); } else if (set != null) { this.bds_Data.DataSource = set.Tables["IOStoreDtl"].Copy(); set.Clear(); } }
private void LoadBaseItem() { string sErr = ""; string sSql = "select cTypeId,cTypeName from TPC_MaterialType where cTypeMode = 0 "; DataSet set = null; set = DBFuns.GetDataBySql(base.AppInformation.SvrSocket, false, sSql, "MatType", 0, 0, "", out sErr); if ((sErr.Trim() != "0") && (sErr.Trim() != "")) { MessageBox.Show(sErr); } if (set != null) { DataTable table = set.Tables["MatType"]; this.cmb_cTypeId1.DisplayMember = "cTypeName"; this.cmb_cTypeId1.ValueMember = "cTypeId"; this.cmb_cTypeId1.DataSource = table; table.Clear(); } set.Clear(); sSql = "select cTypeId,cTypeName from TPC_MaterialType where cTypeMode = 1 "; set = DBFuns.GetDataBySql(base.AppInformation.SvrSocket, false, sSql, "ACNTType", 0, 0, "", out sErr); if ((sErr.Trim() != "0") && (sErr.Trim() != "")) { MessageBox.Show(sErr); } if (set != null) { set.Tables["ACNTType"].Clear(); } set.Clear(); }
private void btn_Qry_Click(object sender, EventArgs e) { string sErr = ""; string sSql = GetSql(); DataSet dsX = null; Cursor.Current = Cursors.WaitCursor; try { dsX = DBFuns.GetDataBySql(AppInformation.SvrSocket, false, sSql, "IOStoreDtl", 0, 0, "", out sErr); Cursor.Current = Cursors.Default; } catch (Exception err) { Cursor.Current = Cursors.Default; MessageBox.Show(err.Message); return; } if (sErr.Trim() != "" && sErr.Trim() != "0") { MessageBox.Show(sErr); return; } if (dsX != null) { DataTable tbX = dsX.Tables["IOStoreDtl"]; bds_Data.DataSource = tbX.Copy(); dsX.Clear(); } }
private DataTable GetStoreDtlToByPalletId(string sPalletId) { string sSql = "select * from V_StoreItemList where nPalletId='" + sPalletId.Trim() + "'"; DataTable tbY = null; string sErr = ""; tbY = DBFuns.GetDataTableBySql(AppInformation.SvrSocket, false, sSql, "tbStoreDtlTo", 0, 0, "", out sErr); if (sErr.Trim() != "" && sErr.Trim() != "0") { MessageBox.Show(sErr); } return(tbY); }
private void btnOK_Click(object sender, EventArgs e) { string strBId = ""; #region 检查完整性 //检测是否录入全 if (txt_cMNo.Text.Trim() == "") { MessageBox.Show("对不起,物料编码不能为空!", "", MessageBoxButtons.OK, MessageBoxIcon.Information); txt_cMNo.Focus(); return; } if (this.txt_fQty.Text.Trim() == "") { MessageBox.Show("对不起,物料数量不能为空!", "", MessageBoxButtons.OK, MessageBoxIcon.Information); txt_fQty.Focus(); return; } if (!IsNumberic(txt_fQty.Text.Trim())) { MessageBox.Show("对不起,物料数量为非法数值!", "", MessageBoxButtons.OK, MessageBoxIcon.Information); txt_fQty.SelectAll(); txt_fQty.Focus(); return; } if (txt_cUnit.Text.Trim() == "") { MessageBox.Show("对不起,单位不能为空!", "", MessageBoxButtons.OK, MessageBoxIcon.Information); txt_cUnit.SelectAll(); txt_cUnit.Focus(); return; } #endregion strBId = drvItem["cBNo"].ToString(); UIToDataRowView(drvItem, grdEdit); string sErr = ""; string sX = DBFuns.sp_Chk_WriteAjustDtl(AppInformation.SvrSocket, UserInformation.UserName, UserInformation.UnitId, "WMS", strBId, txt_cWHId.Text.Trim(), txt_cPosId.Text.Trim(), txt_nPalletId.Text.Trim(), txt_cBoxId.Text.Trim(), txt_cMNo.Text.Trim(), double.Parse(txt_fQty.Text.Trim()), txt_cBNoIn.Text.Trim(), int.Parse(txt_nItemIn.Text.Trim()), "", txt_cWHIdErp.Text.Trim(), txt_cAreaIdErp.Text.Trim(), txt_cPosIdErp.Text.Trim(), out sErr); if (sX.Trim() != "" && sX.Trim() != "0" && sErr.Trim() != "") { MessageBox.Show(sErr); } else { Close(); } }
private void btn_Qry_From_Click(object sender, EventArgs e) { StringBuilder sSql = new StringBuilder("select * from V_WARECELLSTATUS where 1=1 "); #region 获取查询条件 if (cmb_Area_From.Text.Trim() != "" && cmb_Area_From.SelectedValue != null) { sSql.Append(" and cAreaId = '" + cmb_Area_From.SelectedValue.ToString() + "'"); } if (txt_Row_From.Text.Trim() != "") { sSql.Append(" and nRow=" + txt_Row_From.Text.Trim()); } if (txt_Col_From.Text.Trim() != "") { sSql.Append(" and nCol=" + txt_Col_From.Text.Trim()); } if (txt_Layer_From.Text.Trim() != "") { sSql.Append(" and nLayer=" + txt_Layer_From.Text.Trim()); } if (txt_PltId_From.Text.Trim() != "") { sSql.Append(" and isnull(nPalletId,' ') like '%" + txt_PltId_From.Text.Trim() + "%'"); } if (txt_Mat_From.Text.Trim() != "") { sSql.Append(" and ( isnull(nPalletId,' ') in ( select distinct nPalletId from V_StoreItemList where (cMNo like '%" + txt_Mat_From.Text.Trim() + "%') or (cMName like '%" + txt_Mat_From.Text.Trim() + "%') or (cPYJM like '%" + txt_Mat_From.Text.Trim() + "%') or (cWBJM like '%" + txt_Mat_From.Text.Trim() + "%') ))"); } #endregion DataTable tbPosFrom = null; string sErr = ""; tbPosFrom = DBFuns.GetDataTableBySql(AppInformation.SvrSocket, false, sSql.ToString(), "PosList", 0, 0, "", out sErr); if (sErr.Trim() != "" && sErr.Trim() != "0") { MessageBox.Show(sErr); } bIsOpenPosFrom = false; bds_Pos_From.DataSource = tbPosFrom; grd_Pos_From.DataSource = bds_Pos_From; //MessageBox.Show(bds_Pos_From.Count.ToString()); bIsOpenPosFrom = true; }
private void btn_Chg_Do_Click(object sender, EventArgs e) { string sErr = ""; int pIsDoNow = 0; if (this.chk_DoNow.Checked) { pIsDoNow = 1; } if ((DBFuns.sp_Pack_DoWareCellMove(base.AppInformation.SvrSocket, "WMS", this.txt_chg_CellFrom.Text.Trim(), this.txt_chg_CellTo.Text.Trim(), base.UserInformation.UserName, base.UserInformation.UnitId, pIsDoNow, out sErr) == "0") || (sErr.Trim().Length == 0)) { MessageBox.Show("下发执行操作成功!"); base.Close(); } else { MessageBox.Show(sErr); } }
private void btnOK_Click(object sender, EventArgs e) { string pAjustNo = ""; if (this.txt_cMNo.Text.Trim() == "") { MessageBox.Show("对不起,物料编码不能为空!", "", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.txt_cMNo.Focus(); } else if (this.txt_fQty.Text.Trim() == "") { MessageBox.Show("对不起,物料数量不能为空!", "", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.txt_fQty.Focus(); } else if (!FrmSTable.IsNumberic(this.txt_fQty.Text.Trim())) { MessageBox.Show("对不起,物料数量为非法数值!", "", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.txt_fQty.SelectAll(); this.txt_fQty.Focus(); } else if (this.txt_cUnit.Text.Trim() == "") { MessageBox.Show("对不起,单位不能为空!", "", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.txt_cUnit.SelectAll(); this.txt_cUnit.Focus(); } else { pAjustNo = this.drvItem["cBNo"].ToString(); this.UIToDataRowView(this.drvItem, this.grdEdit); string sErr = ""; string str3 = DBFuns.sp_Chk_WriteAjustDtl(base.AppInformation.SvrSocket, base.UserInformation.UserName, base.UserInformation.UnitId, "WMS", pAjustNo, this.txt_cWHId.Text.Trim(), this.txt_cPosId.Text.Trim(), this.txt_nPalletId.Text.Trim(), this.txt_cBoxId.Text.Trim(), this.txt_cMNo.Text.Trim(), double.Parse(this.txt_fQty.Text.Trim()), this.txt_cBNoIn.Text.Trim(), int.Parse(this.txt_nItemIn.Text.Trim()), "", out sErr); if (((str3.Trim() != "") && (str3.Trim() != "0")) && (sErr.Trim() != "")) { MessageBox.Show(sErr); } else { base.Close(); } } }
private void btn_Chg_Do_Click(object sender, EventArgs e) { //if (txt_chg_CellFrom.Text.Trim() == "") //{ // MessageBox.Show("对不起,源货位号不能为空!"); // txt_chg_CellFrom.Focus(); // return; //} //if (txt_chg_CellTo.Text.Trim() == "") //{ // MessageBox.Show("对不起,目标位号不能为空!"); // txt_chg_CellTo.Focus(); // return; //} string sX = ""; string sErr = ""; /* * sp_Pack_DoWareCellMove * (pSysType varchar2,pPosIdFrom varchar2, * pPosIdTo varchar2,pUser varchar2,pCmptId varchar2:='101', * Cur_Result out sys_refCursor * ) */ int nIsDoNow = 0; if (chk_DoNow.Checked) { nIsDoNow = 1; } sX = DBFuns.sp_Pack_DoWareCellMove(AppInformation.SvrSocket, "WMS", txt_chg_CellFrom.Text.Trim(), txt_chg_CellTo.Text.Trim(), UserInformation.UserName, UserInformation.UnitId, nIsDoNow, out sErr); if (sX == "0" || sErr.Trim().Length == 0) { MessageBox.Show("下发执行操作成功!"); Close(); } else { MessageBox.Show(sErr); } }
private void btn_Qry_Click(object sender, EventArgs e) { string sErr = ""; StringBuilder builder = new StringBuilder(""); builder.Append("select mat.cMNo,mat.cName,mat.cSpec,mat.cMatStyle,mat.cMatQCLevel,mat.cMatOther,mat.cRemark,"); builder.Append("mat.fQtyBox,mat.fSafeQtyDn,mat.fSafeQtyUp,mat.fWeight,mat.cUnit,mat.cTypeId1,mat.cTypeId2,isnull(mat.cABC,'C') cABC,"); builder.Append("mt.cTypeName cType1,atp.cTypeName cType2,sum(isnull(st.fQty,0)) fQty,mat.nKeepDay,isnull(st.cDtlSupplier,' ') cSupplier,isnull(st.cDtlCSId,' ') cCSId,isnull(mat.nMatClass,0) nMatClass,isnull(isnull(st.cDtlRemark,st.cStoreRemark),' ') cDtlRemark "); builder.Append("\tfrom TPC_Material mat "); builder.Append(" left join V_MaterialMatType mt on mat.cTypeId1=mt.cTypeId "); builder.Append(" left join V_MaterialAcntType atp on mat.cTypeId2=atp.cTypeId "); builder.Append(" left join V_StoreItemList st on mat.cMNo=st.cMNo "); builder.Append(" where 1=1 "); builder.Append(this.GetCondition()); builder.Append(" group by mat.cMNo,mat.cName,mat.cSpec,mat.cMatStyle,mat.cMatQCLevel,mat.cMatOther,mat.cRemark, "); builder.Append(" mat.fQtyBox,mat.fSafeQtyDn,mat.fSafeQtyUp,mat.fWeight,mat.cUnit,mat.cTypeId1,mat.cTypeId2,mt.cTypeName,"); builder.Append(" atp.cTypeName,mat.cABC,mat.nKeepDay,isnull(st.cDtlSupplier,' '),isnull(st.cDtlCSId,' ') ,isnull(mat.nMatClass,0),isnull(isnull(st.cDtlRemark,st.cStoreRemark),' ')"); DataSet set = null; Cursor.Current = Cursors.WaitCursor; try { set = DBFuns.GetDataBySql(base.AppInformation.SvrSocket, false, builder.ToString(), "TPC_Material", 0, 0, "", out sErr); Cursor.Current = Cursors.Default; } catch (Exception exception) { Cursor.Current = Cursors.Default; MessageBox.Show(exception.Message); return; } if ((sErr.Trim() != "") && (sErr.Trim() != "0")) { MessageBox.Show(sErr); } else { DataTable table = set.Tables["TPC_Material"]; this.bds_Data.DataSource = table; } }
private void tlb_M_Delete_Click(object sender, EventArgs e) { if (bdsMain.Count == 0) { MessageBox.Show("对不起,无数据可删除!"); return; } DataRowView drvX = (DataRowView)bdsMain.Current; if (drvX == null) { return; } string sBNo = drvX["cBNo"].ToString(); if (drvX["bIsChecked"].ToString() == "1") { MessageBox.Show("对不起,改单已经审核,不能删除!"); return; } if (MessageBox.Show("您确定要删除该单号:" + sBNo + " 吗 ?", "询问", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.No) { return; } string sErr = ""; if (!DBFuns.DoExecSql(AppInformation.SvrSocket, "delete TWB_BillMergePltDtl where cBNo='" + sBNo + "'", "", out sErr)) { MessageBox.Show("删除单据明细数据失败:" + sErr); return; } if (!DBFuns.DoExecSql(AppInformation.SvrSocket, "delete TWB_BillMergePlt where cBNo='" + sBNo + "'", "", out sErr)) { MessageBox.Show("删除单据数据失败:" + sErr); return; } MessageBox.Show("删除单据数据成功!"); btnQry_Click(null, null); }
private void LoadBaseItem() { string sErr = ""; //物料属性分类 string sSql = "select cTypeId,cTypeName from TPC_MaterialType where cTypeMode = 0 "; DataSet dsX = null; dsX = DBFuns.GetDataBySql(AppInformation.SvrSocket, false, sSql, "MatType", 0, 0, "", out sErr); if (sErr.Trim() != "0" && sErr.Trim() != "") { MessageBox.Show(sErr); } if (dsX != null) { DataTable tbX = dsX.Tables["MatType"]; cmb_cTypeId1.DisplayMember = "cTypeName"; cmb_cTypeId1.ValueMember = "cTypeId"; cmb_cTypeId1.DataSource = tbX; tbX.Clear(); } dsX.Clear(); sSql = "select cTypeId,cTypeName from TPC_MaterialType where cTypeMode = 1 "; dsX = DBFuns.GetDataBySql(AppInformation.SvrSocket, false, sSql, "ACNTType", 0, 0, "", out sErr); if (sErr.Trim() != "0" && sErr.Trim() != "") { MessageBox.Show(sErr); } if (dsX != null) { DataTable tbX = dsX.Tables["ACNTType"]; //cmb_cTypeId2.DisplayMember = "cTypeName"; //cmb_cTypeId2.ValueMember = "cTypeId"; //cmb_cTypeId2.DataSource = tbX; tbX.Clear(); } dsX.Clear(); }
private void btnQry_Click(object sender, EventArgs e) { if (dtpFind_B.Value > dtpFind_E.Value) { MessageBox.Show("对不起,起始时间不能大于截止时间!"); dtpFind_B.Focus(); return; } StringBuilder strSql = new StringBuilder("select * from V_TWB_BillMergePlt where (dCreateDate >='" + dtpFind_B.Value.ToString("yyyy-MM-dd 00:00:00") + "' and dCreateDate <='" + dtpFind_E.Value.ToString("yyyy-MM-dd 23:59:59") + "')"); #region 条件 if (cmbFindUser.Text.Trim() != "" && cmbFindUser.Text.Trim() != "全部" && cmbFindUser.SelectedValue != null) { strSql.Append(" and cCreator='" + cmbFindUser.SelectedValue.ToString().Trim() + "'"); } if (txtFindBillNo.Text.Trim() != "") { strSql.Append(" and cBNo like '%" + txtFindBillNo.Text.Trim() + "%'"); } if (this.cmbFindCheck.Text.Trim() != "" && cmbFindCheck.Text.Trim() != "全部" && cmbFindCheck.SelectedIndex >= 0 && cmbFindCheck.SelectedIndex <= 1) { strSql.Append(" and isnull(bIsChecked,0)='" + cmbFindCheck.SelectedIndex.ToString().Trim() + "'"); } if (this.cmb_FinishedStatus.Text.Trim() != "" && cmb_FinishedStatus.Text.Trim() != "全部" && cmb_FinishedStatus.SelectedIndex >= 0 && cmb_FinishedStatus.SelectedIndex <= 1) { strSql.Append(" and isnull(bIsFinished,0)='" + cmb_FinishedStatus.SelectedIndex.ToString().Trim() + "'"); } #endregion DataSet dsX = null; string sErr = ""; Cursor.Current = Cursors.WaitCursor; dsX = DBFuns.GetDataBySql(AppInformation.SvrSocket, false, strSql.ToString(), strTbNameMain, 0, 0, "dCreateDate,dCheckDate", out sErr); Cursor.Current = Cursors.Default; if (sErr.Trim() != "" && sErr.Trim() != "0") { MessageBox.Show(sErr); return; } if (dsX == null) { MessageBox.Show("获取数据时失败!"); return; } DataTable tbData = null; if (dsX.Tables.Count > 0) { if (dsX.Tables[0].Rows[0][0].ToString() == "-1") { MessageBox.Show(dsX.Tables[0].Rows[0][1].ToString()); return; } if (dsX.Tables[strTbNameMain] != null) { tbData = dsX.Tables[strTbNameMain].Copy(); } if (tbData == null) { MessageBox.Show("获取数据时失败!"); return; } } Cursor.Current = Cursors.WaitCursor; bDSIsOpenForMain = false; bdsMain.DataSource = tbData; grdList.DataSource = bdsMain; bDSIsOpenForMain = true; lbl_M_Count.Text = bdsMain.Count.ToString(); Cursor.Current = Cursors.Default; bdsMain_PositionChanged(null, null); }
private void btn_OK_Click(object sender, EventArgs e) { if (!bCheckIsOK()) { return; } string sPosFrom = ""; string sPosTo = ""; string sPltFrom = ""; string sPltTo = ""; #region DataRowView drvX = null; drvX = (DataRowView)bds_Pos_From.Current; if (drvX != null) { sPosFrom = drvX["cPosId"].ToString(); sPltFrom = drvX["nPalletId"].ToString();; } drvX = (DataRowView)bds_Pos_To.Current; if (drvX != null) { sPosTo = drvX["cPosId"].ToString(); sPltTo = drvX["nPalletId"].ToString();; } if (sPosFrom.Trim() == "" || sPltFrom.Trim() == "" || sPosTo.Trim() == "" || sPltTo.Trim() == "") { MessageBox.Show("对不起,合盘操作的源货位和托盘或者目标货位和托盘数据不能为空!"); return; } if (sPltFrom.Trim() == sPltTo.Trim()) { MessageBox.Show("对不起,合盘操作的源货位和目标货位不能相同!"); return; } if (MessageBox.Show("您确定将 " + sPosFrom + " 里的所选物料合盘到 " + sPosTo + " 里去吗?", "询问", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.No) { return; } #endregion #region StringBuilder sSql = new StringBuilder(""); #region 主表 //获取单号 string sErr = ""; string sBNo = ""; sBNo = DBFuns.GetNewId(AppInformation.SvrSocket, "TWB_BillMergePlt", "cBNo", 12, ("BMP" + DateTime.Now.ToString("yyMMdd")), out sErr); if (sErr.Trim() != "" && sErr.Trim() != "0") { MessageBox.Show(sErr); return; } if (sBNo.Trim() == "") { MessageBox.Show("对不起,获取单号失败!"); return; } sSql.Append("insert into TWB_BillMergePlt(cBNo,nBClass, cPosIdFrom, cPosIdTo, nPalletIdFrom, nPalletIdTo,"); sSql.Append(" nWorkIdFrom, nWorkIdTo, nWkTskFromIsEmptyOut, nWorkFromStatus, nWorkToStatus, cCreatorId,"); sSql.Append(" cCreator, dCreateDate, bIsChecked, dCheckDate, cChecker, bIsFinished)"); sSql.Append("Values('" + sBNo + "',12,'" + sPosFrom + "','" + sPosTo + "','" + sPltFrom + "','" + sPltTo + "',"); sSql.Append("0,0,0,0,0,'" + UserInformation.UserId + "','" + UserInformation.UserName + "',getdate(),0,null,'',0 ) "); if (!DBFuns.DoExecSql(AppInformation.SvrSocket, sSql.ToString(), "dCreateDate,dCheckDate", out sErr)) { MessageBox.Show("新建主表数据时,失败:" + sErr); return; } #endregion #region 明细表 int nX = 0; grd_StockDtl_From.EndEdit(); foreach (DataGridViewRow grdvr in grd_StockDtl_From.Rows) { object objX = null; objX = grdvr.Cells[col_From_Selected.Name].Value; if (Convert.ToBoolean(objX)) { nX++; sSql.Remove(0, sSql.Length); sSql.Append("insert into TWB_BillMergePltDtl(cBNo,nItem,nPalletId,cPosId,cBoxId,cMNo,cBatchNo,cBNoIn,nItemIn,dProdDate,nQCStatus,"); sSql.Append("dValiDate,cUNit,bIsSample,cCSId,cSuppler,cDtlRemark,nStatus,cWHIdErp,cWHId,fQty,fFinished,bIsOut,cRemark)"); sSql.Append("select '" + sBNo + "'," + nX.ToString() + ",nPalletId,cPosId,cBoxId,cMNo,cBatchNo,cBNoIn,nItemIn,dProdDate,nQCStatus,"); sSql.Append("dBadDate,cUnit,0,cDtlCSId,cDtlSupplier,cDtlRemark,1,cWHIdErp,cWHId,fQty,0,1,'' cRemark from V_StoreItemList "); sSql.Append(" where nPalletId='" + sPltFrom.Trim() + "' and cPosId='" + sPosFrom.Trim() + "' and cMNo='" + grdvr.Cells[col_From_MNo.Name].Value.ToString() + "'"); sSql.Append(" and cBNoIn='" + grdvr.Cells[col_From_BNOIn.Name].Value.ToString() + "' "); sSql.Append(" and nItemIn=" + grdvr.Cells[col_From_ItemIn.Name].Value.ToString()); if (!DBFuns.DoExecSql(AppInformation.SvrSocket, sSql.ToString(), "", out sErr)) { MessageBox.Show("新建明细表数据时,失败:" + sErr); MessageBox.Show("成功增加了 " + (nX - 1).ToString() + " 条明细数据!"); return; } } } #endregion #endregion MessageBox.Show("保存合盘单据数据成功!"); Close(); }
private void btnOK_Click(object sender, EventArgs e) { string sErr = ""; double fQty = 0; double fRQty = 0; double fDiff = 0; double fBad = 0; if (txt_Qty.Text.Trim() != "") { fQty = double.Parse(txt_Qty.Text.Trim()); } if (txt_RQty.Text.Trim() != "") { try { fRQty = double.Parse(txt_RQty.Text.Trim()); } catch (Exception err) { MessageBox.Show("实盘数录入有误,数值非法!"); txt_RQty.SelectAll(); txt_RQty.Focus(); return; } } else { MessageBox.Show("对不起,实盘数不能为空!"); txt_RQty.Focus(); return; } if (txt_fBad.Text.Trim() != "") { try { fBad = double.Parse(txt_fBad.Text.Trim()); } catch (Exception err) { MessageBox.Show("不良品数录入有误,数值非法!"); txt_fBad.SelectAll(); txt_fBad.Focus(); return; } } else { MessageBox.Show("对不起,不良品数不能为空!"); txt_fBad.Focus(); return; } if (fBad < 0) { MessageBox.Show("对不起不良品数不能为负数!"); txt_fBad.SelectAll(); txt_fBad.Focus(); return; } if (txt_fDiff.Text.Trim() == "") { MessageBox.Show("对不起,损溢数不能为空!"); txt_fDiff.Focus(); return; } else { if (IsNumberic(txt_fDiff.Text.Trim())) { fDiff = double.Parse(txt_fDiff.Text.Trim()); } else { MessageBox.Show("损溢数录入有误,数值非法!"); txt_fDiff.SelectAll(); txt_fDiff.Focus(); return; } } if (fRQty != (fQty + fDiff)) { MessageBox.Show("对不起,实盘数 不等于 帐面数 + 损溢数"); txt_fDiff.SelectAll(); txt_fDiff.Focus(); return; } _WHIdErp = txt_WHIdErp.Text.Trim(); _AreaIdErp = txt_AreaIdErp.Text.Trim(); _PosIdErp = txt_PosIdErp.Text.Trim(); string sX = DBFuns.sp_Chk_WriteChkDtl(AppInformation.SvrSocket, UserInformation.UserName, UserInformation.UnitId, "WMS", txt_cWHId.Text.Trim(), txt_cPosId.Text.Trim(), txt_nPalletId.Text.Trim(), txt_cBoxId.Text.Trim(), txt_cMNo.Text.Trim(), fDiff, fBad, txt_cUnit.Text.Trim(), txt_cBNoIn.Text.Trim(), int.Parse(txt_nItemIn.Text.Trim()), _CheckNo.Trim(), _WHIdErp, _AreaIdErp, _PosIdErp, out sErr); if (sX.Trim() != "0" && sX.Trim() != "B" && sErr.Trim() != "") { MessageBox.Show(sErr); } else { MessageBox.Show("登记成功!"); _IsOK = true; Close(); } }