/// <summary> /// 判断物料编码是否合法 /// </summary> /// <param name="sMNo"></param> /// <returns></returns> private bool JudgeMNoIsOK(string sMNo) { bool bOK = false; string sSql = "select count(*) nCount from TPC_Material where cMNo='" + sMNo.Trim() + "'"; string sErr = ""; object objX = null; if (DBFuns.GetValueBySql(AppInformation.SvrSocket, sSql, "", "nCount", out objX, out sErr)) { if (sErr.Trim() != "" && sErr.Trim() != "0") { MessageBox.Show(sErr); return(false); } else { if (objX == null) { bOK = false; } else { bOK = objX.ToString() == "1"; } } } else { bOK = false; } return(bOK); }
private bool isBillOK() { string sSql = string.Format("select nbillstatus from TWB_BillIn where cBNo='{0}'", sBNo); if (DBFuns.GetValueBySql(AppInformation.SvrSocket, sSql, "", "nbillstatus", out objValue, out sErr)) { if (objValue != null && objValue.ToString() != "" && (sErr.Trim() == "" || sErr.Trim() == "0")) { if (Convert.ToInt32(objValue) == 1) { return(true); } } } return(false); }
private void btn_Dtl_InnerAccont_Click(object sender, EventArgs e) { if (isBillOK()) { sSql = "select count(0) num from TWB_WorkTaskDtl where cBNo='" + sBNo + "' and nItem=" + nItem.ToString() + " and nWorkId in (select nWorkId from TWB_WorkTask where nWKStatus <99)"; if (DBFuns.GetValueBySql(AppInformation.SvrSocket, sSql, "", "num", out objValue, out sErr)) { if (objValue != null && objValue.ToString() != "" && (sErr.Trim() == "" || sErr.Trim() == "0")) { if (Convert.ToInt32(objValue) == 0) { if (MessageBox.Show("确定整单无差异登记吗?", "WMS", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { int count = 0; int badcount = 0; foreach (DataGridViewRow item in dataGridView_HasPallet.Rows) { int pWorkId = Convert.ToInt32(item.Cells["nWorkId"].Value); if (PubDBCommFuns.sp_DoAccont(base.AppInformation.SvrSocket, pWorkId, 1, "WMS", out sErr) == "0") { count++; } else { badcount++; } } DoRefreshQty(); DoRefreshHasPallet(); MessageBox.Show("成功登记了 " + count.ToString() + " 条任务,失败" + badcount.ToString() + " 条任务!"); } } else { MessageBox.Show("对不起,该订单下还有没有上架完成的任务!"); } } } } else { MessageBox.Show("对不起,还没有收到PSCS发过来的收货入库单!"); } }
private int GetPosRowNo(string sPosId) { int num = 0; string sSql = "select nRow from TWC_WareCell where cPosId='" + sPosId.Trim() + "'"; object objValue = null; string sErr = ""; if (DBFuns.GetValueBySql(base.AppInformation.SvrSocket, sSql, "", "nRow", out objValue, out sErr)) { if (objValue != null) { num = Convert.ToInt16(objValue); } return(num); } MessageBox.Show("获取货位的行号时出错:" + sErr); return(num); }
private void DoRefreshQty() { sSql = "select fqty,fpallet,ffinished from TWB_BillInDtl where cBNo='" + sBNo + "' and nItem=" + nItem.ToString(); DataSet ds = PubDBCommFuns.GetDataBySql(base.AppInformation.SvrSocket, false, sSql, "TWB_BillInDtl", 0, 0, "", out sErr); if (sErr.Length > 0) { MessageBox.Show(sErr); } else if (ds == null) { MessageBox.Show("对不起,打开单据表数据失败!"); } else { DataRow dr = ds.Tables["TWB_BillInDtl"].Rows[0]; fqty = Convert.ToDouble(dr["fqty"]); lbfqty.Text = fqty.ToString(); string fpalletStr = dr["fpallet"].ToString(); fpalletStr = fpalletStr == "" ? "0" : fpalletStr; fpallet = Convert.ToDouble(fpalletStr); lbfpallet.Text = fpallet.ToString(); ffinished = Convert.ToDouble(dr["ffinished"]); lbffinished.Text = ffinished.ToString(); } sSql = "select sum(fQty) fQty from TWB_WorkTaskDtl where cBNo='" + sBNo + "' and nItem=" + nItem.ToString() + " and nWorkId in (select nWorkId from TWB_WorkTask where nWKStatus in (99,109))"; if (DBFuns.GetValueBySql(AppInformation.SvrSocket, sSql, "", "fQty", out objValue, out sErr)) { if (objValue != null && objValue.ToString() != "" && (sErr.Trim() == "" || sErr.Trim() == "0")) { taskFinNum = Convert.ToDouble(objValue); lbtaskFinNum.Text = taskFinNum.ToString(); } } }