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