/// <summary> /// 修改目标的工作台编码 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnChangeGZT_Click(object sender, EventArgs e) { //修改工作台的操作 if (string.IsNullOrEmpty(txtPalletNo.Text) || string.IsNullOrEmpty(txtGZT.Text)) { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"托盘号或者是工作台必须要填写!\");", true); return; } else { //首先要提示这个托盘现在所在的工作台是哪一个或者是库区位置 BArrangeBillBoxBB bb = new BArrangeBillBoxBB(); DataTable dt = bb.GetList("PalletNo = '" + txtPalletNo.Text.Trim().ToUpper() + "'").Tables[0]; if(dt.Rows.Count==0) { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"系统当中没有此托盘!\");", true); return; } if (txtGZT.Text.Trim().ToUpper() != "X04" && txtGZT.Text.ToUpper() != "X02" && txtGZT.Text.ToUpper() != "X09" && txtGZT.Text.ToUpper() != "X07") { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"只能在X04和X02和X07和X09工作台之间进行修改!\");", true); return; } if (dt.Rows[0]["wareLocatorNo"].ToString() != "X04" && dt.Rows[0]["wareLocatorNo"].ToString() != "X02" && txtGZT.Text.ToUpper() != "X09" && txtGZT.Text.ToUpper() != "X07") { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"托盘只能在X04和X02和X07和X09工作台之间修改!\");", true); return; } if (dt.Rows[0]["wareLocatorNo"].ToString() == txtGZT.Text.Trim().ToUpper()) { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"修改后的工作台与原来的工作台是同一个工坐台!\");", true); return; } SCommBB comm = new SCommBB(); try { comm.ExecuteSql("Update BarrangeBillBox set wareLocatorNo = '" + txtGZT.Text.Trim().ToUpper() + "' where PalletNo = '" + txtPalletNo.Text.Trim().ToUpper() + "'"); this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"更新工作台成功 托盘 " + txtPalletNo.Text.Trim().ToUpper() + " 更新后的工作台是"+txtGZT.Text.Trim().ToUpper()+"!\");", true); } catch (Exception ee) { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"更新工作台失败 " + ee.Message + "!\");", true); } finally { comm.Dispose(); bb.Dispose(); } } }
public bool JudgeCheckPallet(string strPalletNo, out string strErrorInfo) { BArrangeBillBoxBB arrangeBillBoxBB = new BArrangeBillBoxBB(); try { strErrorInfo = ""; DataTable dt = new DataTable(); dt = arrangeBillBoxBB.GetList(" isnull(arrangeBillBox.wareNo,'')<>'' and arrangeBillBox.palletNo='" + strPalletNo + "'").Tables[0]; //判断托盘上的所有物料是否已经检测完成 if (dt.Rows.Count == 0) { strErrorInfo = "系统中不存在此托盘!"; return false; } foreach (DataRow row in dt.Rows) { //判断当前托盘放置的物料是否全为非标准箱 if (row["isStandardBox"].ToString() == "1" || row["isStandardBox"].ToString().ToUpper() == "Y") { strErrorInfo = "当前托盘放置标准箱物料!"; return false; } //判断是否全部判定合格 if (Convert.ToBoolean(row["checkResult"]) == false) { strErrorInfo = "当前托盘存在未判定或判定不合格产品!"; return false; } //判断当前托盘是否未放到质检区 if (row["wareType"].ToString() != "01") { strErrorInfo = "当前托盘不在质检区!"; return false; } } return true; } finally { arrangeBillBoxBB.Dispose(); } }
public bool IsExistsBox(string strBoxNo) { BArrangeBillBoxBB arrangeBillBoxBB = new BArrangeBillBoxBB(); try { DataTable dt = new DataTable(); dt = arrangeBillBoxBB.GetList("boxNo='" + strBoxNo + "'").Tables[0]; return dt.Rows.Count > 0 ? true : false; } finally { arrangeBillBoxBB.Dispose(); } }
public DataTable GetBoxByWareLocator(string strWareLocatorNo) { BArrangeBillBoxBB arrangeBillBoxBB = new BArrangeBillBoxBB(); try { DataTable dt = new DataTable(); dt = arrangeBillBoxBB.GetList("wareLocatorNo='" + strWareLocatorNo + "'").Tables[0]; return dt; } finally { arrangeBillBoxBB.Dispose(); } }
public DataTable GetArriveBoxDetail(string strArriveBillNo, string strFinanceBillNo, string strMaterialNo) { BArrangeBillBoxBB arrangeBillBoxBB = new BArrangeBillBoxBB(); try { DataTable dt = new DataTable(); string strWhere = "1=1"; //到货单号 if (strArriveBillNo != "") { strWhere += " and arriveBillNo like '%" + strArriveBillNo + "%'"; } //采购单号 if (strFinanceBillNo != "") { strWhere += " and financeBillNo like '%" + strFinanceBillNo + "%'"; } //物料编号 if (strMaterialNo != "") { strWhere += " and materialNo like '%" + strMaterialNo + "%'"; } dt = arrangeBillBoxBB.GetList(strWhere).Tables[0]; return dt; } finally { arrangeBillBoxBB.Dispose(); } }