/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">model</param> public bool ModifyRecord(CDEPickOutBoxData model) { bool ret = false; StringBuilder strSql = new StringBuilder(); strSql.Append("update CDEPickOutBox set "); strSql.Append("boxNo=@boxNo,"); strSql.Append("oldBoxNo=@oldBoxNo,"); strSql.Append("materialNo=@materialNo,"); strSql.Append("num=@num,"); strSql.Append("palletNo=@palletNo,"); strSql.Append("region=@region,"); strSql.Append("oldPalletNo=@oldPalletNo,"); strSql.Append("oldRegion=@oldRegion,"); strSql.Append("wareNo=@wareNo,"); strSql.Append("wareLocatorNo=@wareLocatorNo,"); strSql.Append("preWareNo=@preWareNo,"); strSql.Append("preWareLocatorNo=@preWareLocatorNo,"); strSql.Append("isOutStock=@isOutStock,"); strSql.Append("isrtEmpId=@isrtEmpId,"); strSql.Append("isrtDt=@isrtDt,"); strSql.Append("updtEmpId=@updtEmpId,"); strSql.Append("updtDt=@updtDt,"); strSql.Append("stockUpBillNo=@stockUpBillNo,"); strSql.Append("palletIndex=@palletIndex,"); strSql.Append("saleBillNo=@saleBillNo,"); strSql.Append("absEntry=@absEntry,"); strSql.Append("lineNum=@lineNum,"); strSql.Append("DocEntry=@DocEntry"); strSql.Append(" where id = @id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@boxNo", SqlDbType.VarChar,20), new SqlParameter("@oldBoxNo", SqlDbType.VarChar,20), new SqlParameter("@materialNo", SqlDbType.VarChar,20), new SqlParameter("@num", SqlDbType.Float), new SqlParameter("@palletNo", SqlDbType.VarChar,20), new SqlParameter("@region", SqlDbType.VarChar,10), new SqlParameter("@oldPalletNo", SqlDbType.VarChar,20), new SqlParameter("@oldRegion", SqlDbType.VarChar,10), new SqlParameter("@wareNo", SqlDbType.VarChar,20), new SqlParameter("@wareLocatorNo", SqlDbType.VarChar,20), new SqlParameter("@preWareNo", SqlDbType.VarChar,20), new SqlParameter("@preWareLocatorNo", SqlDbType.VarChar,20), new SqlParameter("@isOutStock", SqlDbType.Bit), new SqlParameter("@isrtEmpId", SqlDbType.Int), new SqlParameter("@isrtDt", SqlDbType.DateTime), new SqlParameter("@updtEmpId", SqlDbType.Int), new SqlParameter("@updtDt", SqlDbType.DateTime), new SqlParameter("@stockUpBillNo", SqlDbType.VarChar,20), new SqlParameter("@palletIndex", SqlDbType.Int), new SqlParameter("@saleBillNo", SqlDbType.VarChar,20), new SqlParameter("@absEntry", SqlDbType.Int), new SqlParameter("@lineNum", SqlDbType.Int), new SqlParameter("@DocEntry", SqlDbType.Int) }; parameters[0].Value = model.id; parameters[1].Value = model.boxNo; parameters[2].Value = model.oldBoxNo; parameters[3].Value = model.materialNo; parameters[4].Value = model.num; parameters[5].Value = model.palletNo; parameters[6].Value = model.region; parameters[7].Value = model.oldPalletNo; parameters[8].Value = model.oldRegion; parameters[9].Value = model.wareNo; parameters[10].Value = model.wareLocatorNo; parameters[11].Value = model.preWareNo; parameters[12].Value = model.preWareLocatorNo; parameters[13].Value = model.isOutStock; parameters[14].Value = model.isrtEmpId; parameters[15].Value = model.isrtDt == string.Empty ? null : model.isrtDt; parameters[16].Value = model.updtEmpId; parameters[17].Value = model.updtDt == string.Empty ? null : model.updtDt; parameters[18].Value = model.stockUpBillNo; parameters[19].Value = model.palletIndex; parameters[20].Value = model.saleBillNo; parameters[21].Value = model.absEntry; parameters[22].Value = model.lineNum; parameters[23].Value = model.DocEntry; try { SqlHelper.ExecuteNonQuery(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters); ret = true; } catch (Exception ex) { throw ex; } return ret; }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">model</param> public int AddRecord(CDEPickOutBoxData model) { StringBuilder strSql = new StringBuilder(); strSql.Append("set nocount on; "); strSql.Append("insert into CDEPickOutBox("); strSql.Append(@"boxNo,oldBoxNo,materialNo,num,palletNo,region,oldPalletNo,oldRegion,wareNo,wareLocatorNo, preWareNo,preWareLocatorNo,isOutStock,isrtEmpId,isrtDt,updtEmpId,updtDt,stockUpBillNo,palletIndex,saleBillNo, absEntry,lineNum,DocEntry)"); strSql.Append(" values ("); strSql.Append(@"@boxNo,@oldBoxNo,@materialNo,@num,@palletNo,@region,@oldPalletNo,@oldRegion,@wareNo,@wareLocatorNo, @preWareNo,@preWareLocatorNo,@isOutStock,@isrtEmpId,@isrtDt,@updtEmpId,@updtDt,@stockUpBillNo,@palletIndex,@saleBillNo, @absEntry,@lineNum,@DocEntry)"); strSql.Append("; select @@identity; set nocount off; "); SqlParameter[] parameters = { new SqlParameter("@boxNo", SqlDbType.VarChar,20), new SqlParameter("@oldBoxNo", SqlDbType.VarChar,20), new SqlParameter("@materialNo", SqlDbType.VarChar,20), new SqlParameter("@num", SqlDbType.Float), new SqlParameter("@palletNo", SqlDbType.VarChar,20), new SqlParameter("@region", SqlDbType.VarChar,10), new SqlParameter("@oldPalletNo", SqlDbType.VarChar,20), new SqlParameter("@oldRegion", SqlDbType.VarChar,10), new SqlParameter("@wareNo", SqlDbType.VarChar,20), new SqlParameter("@wareLocatorNo", SqlDbType.VarChar,20), new SqlParameter("@preWareNo", SqlDbType.VarChar,20), new SqlParameter("@preWareLocatorNo", SqlDbType.VarChar,20), new SqlParameter("@isOutStock", SqlDbType.Bit), new SqlParameter("@isrtEmpId", SqlDbType.Int), new SqlParameter("@isrtDt", SqlDbType.DateTime), new SqlParameter("@updtEmpId", SqlDbType.Int), new SqlParameter("@updtDt", SqlDbType.DateTime), new SqlParameter("@stockUpBillNo", SqlDbType.VarChar,20), new SqlParameter("@palletIndex", SqlDbType.Int), new SqlParameter("@saleBillNo", SqlDbType.VarChar,20), new SqlParameter("@absEntry", SqlDbType.Int), new SqlParameter("@lineNum", SqlDbType.Int), new SqlParameter("@DocEntry", SqlDbType.Int) }; parameters[0].Value = model.boxNo; parameters[1].Value = model.oldBoxNo; parameters[2].Value = model.materialNo; parameters[3].Value = model.num; parameters[4].Value = model.palletNo; parameters[5].Value = model.region; parameters[6].Value = model.oldPalletNo; parameters[7].Value = model.oldRegion; parameters[8].Value = model.wareNo; parameters[9].Value = model.wareLocatorNo; parameters[10].Value = model.preWareNo; parameters[11].Value = model.preWareLocatorNo; parameters[12].Value = model.isOutStock; parameters[13].Value = model.isrtEmpId; parameters[14].Value = model.isrtDt == string.Empty ? null : model.isrtDt; parameters[15].Value = model.updtEmpId; parameters[16].Value = model.updtDt == string.Empty ? null : model.updtDt; parameters[17].Value = model.stockUpBillNo; parameters[18].Value = model.palletIndex; parameters[19].Value = model.saleBillNo; parameters[20].Value = model.absEntry; parameters[21].Value = model.lineNum; parameters[22].Value = model.DocEntry; int id = 0; try { object ret = SqlHelper.ExecuteScalar(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters); if (ret != null && ret != DBNull.Value) { id = Convert.ToInt32(ret); } } catch (Exception ex) { throw ex; } return id; }
/// <summary> /// 得到一个model /// </summary> /// <param name="id">主键值</param> /// <returns>model</returns> public CDEPickOutBoxData GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select id,boxNo,oldBoxNo,materialNo,num,palletNo,region,oldPalletNo,oldRegion,wareNo,wareLocatorNo, preWareNo,preWareLocatorNo,isOutStock,isrtEmpId,isrtDt,updtEmpId,updtDt,stockUpBillNo,palletIndex,saleBillNo, absEntry,lineNum,DocEntry from CDEPickOutBox"); strSql.Append(" where id = @id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int) }; parameters[0].Value = id; CDEPickOutBoxData model = new CDEPickOutBoxData(); DataSet ds = SqlHelper.ExecuteDataset(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; if (row["id"] != DBNull.Value) { model.id = Convert.ToInt32(row["id"]); } if (row["boxNo"] != DBNull.Value) { model.boxNo = Convert.ToString(row["boxNo"]); } if (row["oldBoxNo"] != DBNull.Value) { model.oldBoxNo = Convert.ToString(row["oldBoxNo"]); } if (row["materialNo"] != DBNull.Value) { model.materialNo = Convert.ToString(row["materialNo"]); } if (row["num"] != DBNull.Value) { model.num = Convert.ToDouble(row["num"]); } if (row["palletNo"] != DBNull.Value) { model.palletNo = Convert.ToString(row["palletNo"]); } if (row["region"] != DBNull.Value) { model.region = Convert.ToString(row["region"]); } if (row["oldPalletNo"] != DBNull.Value) { model.oldPalletNo = Convert.ToString(row["oldPalletNo"]); } if (row["oldRegion"] != DBNull.Value) { model.oldRegion = Convert.ToString(row["oldRegion"]); } if (row["wareNo"] != DBNull.Value) { model.wareNo = Convert.ToString(row["wareNo"]); } if (row["wareLocatorNo"] != DBNull.Value) { model.wareLocatorNo = Convert.ToString(row["wareLocatorNo"]); } if (row["preWareNo"] != DBNull.Value) { model.preWareNo = Convert.ToString(row["preWareNo"]); } if (row["preWareLocatorNo"] != DBNull.Value) { model.preWareLocatorNo = Convert.ToString(row["preWareLocatorNo"]); } if (row["isOutStock"] != DBNull.Value) { model.isOutStock = Convert.ToBoolean(row["isOutStock"]); } if (row["isrtEmpId"] != DBNull.Value) { model.isrtEmpId = Convert.ToInt32(row["isrtEmpId"]); } if (row["isrtDt"] != DBNull.Value) { model.isrtDt = Convert.ToString(row["isrtDt"]); } if (row["updtEmpId"] != DBNull.Value) { model.updtEmpId = Convert.ToInt32(row["updtEmpId"]); } if (row["updtDt"] != DBNull.Value) { model.updtDt = Convert.ToString(row["updtDt"]); } if (row["stockUpBillNo"] != DBNull.Value) { model.stockUpBillNo = Convert.ToString(row["stockUpBillNo"]); } if (row["palletIndex"] != DBNull.Value) { model.palletIndex = Convert.ToInt32(row["palletIndex"]); } if (row["saleBillNo"] != DBNull.Value) { model.saleBillNo = Convert.ToString(row["saleBillNo"]); } if (row["absEntry"] != DBNull.Value) { model.absEntry = Convert.ToInt32(row["absEntry"]); } if (row["lineNum"] != DBNull.Value) { model.lineNum = Convert.ToInt32(row["lineNum"]); } if (row["DocEntry"] != DBNull.Value) { model.DocEntry = Convert.ToInt32(row["DocEntry"]); } return model; } else { return null; } }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">model</param> public bool ModifyRecord(CDEPickOutBoxData model) { return this.dEPickOutBoxDB.ModifyRecord(model); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">model</param> public int AddRecord(CDEPickOutBoxData model) { return this.dEPickOutBoxDB.AddRecord(model); }
/// <summary> /// 其他出入库 保存 /// 解决因为使用CpickoutPlan导致的保存不了DocEntry 从而导致拣货完成后 没有保存的时候 看到的数据有问题。 /// </summary> /// <param name="pickOutPlanID"></param> /// <param name="strStockUpBillNo"></param> /// <param name="palletIndex"></param> /// <param name="strNewPalletNo"></param> /// <param name="strOldBoxNo"></param> /// <param name="strNewBoxNo"></param> /// <param name="pickOutNum"></param> /// <param name="strOperType"></param> /// <returns></returns> public bool SaveOtherPickOutInfo_DE(int pickOutPlanID, string strStockUpBillNo, int palletIndex, string strNewPalletNo, string strOldBoxNo, string strNewBoxNo, int pickOutNum, string strOperType) { bool ret = false; SqlTransaction trans = null; SCommBB commBB = new SCommBB(this.connection); BArrangeBillBoxBB arrangeBillBoxBB = new BArrangeBillBoxBB(this.connection); CDEPickOutBoxBB DEPickOutBoxBB = new CDEPickOutBoxBB(this.connection); LMaterialBB materialBB = new LMaterialBB(); LWareBB wareBB = new LWareBB(); UStockOutInDetailBB stockOutInDetailBB = new UStockOutInDetailBB(this.connection); OtherOutInPickOutPlanBB pickOutPlanBB = new OtherOutInPickOutPlanBB(); try { if (this.transaction == null) { trans = this.connection.BeginTransaction("TranSave"); this.stockBB.Transaction = trans; commBB.Transaction = trans; arrangeBillBoxBB.Transaction = trans; DEPickOutBoxBB.Transaction = trans; stockOutInDetailBB.Transaction = trans; } else { this.stockBB.Transaction = this.transaction; commBB.Transaction = this.transaction; arrangeBillBoxBB.Transaction = this.transaction; DEPickOutBoxBB.Transaction = this.transaction; stockOutInDetailBB.Transaction = this.transaction; } DataTable dtArrangeBillBox = new DataTable(); DataTable dtPallet = new DataTable(); DataTable dtMaterial = new DataTable(); DataTable dtStock = new DataTable(); CDEPickOutBoxData DEPickOutBoxModel = new CDEPickOutBoxData(); UStockOutInDetailData stockOutInDetailModel = new UStockOutInDetailData(); UStockData stockModel = new UStockData(); OtherOutInPickOutPlanData pickOutPlanModel = new OtherOutInPickOutPlanData(); string strSql = "", strPreWareLocatorNo = ""; int stockNum = 0; object obj = null; //获取箱信息 dtArrangeBillBox = arrangeBillBoxBB.GetVList("boxNo='" + strOldBoxNo + "'").Tables[0]; if (dtArrangeBillBox.Rows.Count == 0) { return false; } //获取当前托盘上的库存明细 obj = commBB.ExecuteScalar("select count(1) from dbo.UStock where palletNo='" + strNewPalletNo + "' and num>0"); if (obj != null) { stockNum = Convert.ToInt32(obj); } //扫描箱所在库位 strPreWareLocatorNo = dtArrangeBillBox.Rows[0]["wareLocatorNo"].ToString(); //获取托盘上的正式物料箱 dtPallet = arrangeBillBoxBB.GetVList("palletNo='" + strNewPalletNo + "' and isnull(wareNo,'')<>''").Tables[0]; //获取箱内物料信息 dtMaterial = materialBB.GetList("materialNo='" + dtArrangeBillBox.Rows[0]["materialNo"].ToString() + "'").Tables[0]; //获取拣货计划实例 pickOutPlanModel = pickOutPlanBB.GetModel(pickOutPlanID); //增加出入库明细-原箱出库 dtStock = stockBB.GetList("boxNo='" + strOldBoxNo + "'").Tables[0]; if (dtStock.Rows.Count > 0)//原箱有库存 { //保存出入库明细数据-出库 stockOutInDetailModel = new UStockOutInDetailData(); stockOutInDetailModel.billNo = strStockUpBillNo;//单据编号 stockOutInDetailModel.outInType = "08";//拆托合托 stockOutInDetailModel.isOut = true;//是否出库 stockOutInDetailModel.stockDt = System.DateTime.Today.ToString();//库存日期 stockOutInDetailModel.dt = System.DateTime.Today.ToString();//操作日期 stockOutInDetailModel.wareNo = dtArrangeBillBox.Rows[0]["wareNo"].ToString();//仓库 stockOutInDetailModel.wareLocatorNo = dtArrangeBillBox.Rows[0]["wareLocatorNo"].ToString();//库位 stockOutInDetailModel.salverNo = dtArrangeBillBox.Rows[0]["palletNo"].ToString();//托盘号 stockOutInDetailModel.boxNo = strOldBoxNo;//箱号 stockOutInDetailModel.materialNo = dtArrangeBillBox.Rows[0]["materialNo"].ToString();//物料编号 stockOutInDetailModel.factMonomerNum = Convert.ToDouble(dtMaterial.Rows[0]["U_UintQty"]);//单体数量 stockOutInDetailModel.factPackNum = Convert.ToDouble(dtMaterial.Rows[0]["U_BoxQty"]);//整箱数量 stockOutInDetailModel.num = pickOutNum;//数量 stockOutInDetailModel.nextBoxNo = strNewBoxNo;//拆箱目的箱号 stockOutInDetailModel.isrtEmpId = this.empId; stockOutInDetailModel.isrtDt = System.DateTime.Now.ToString(); stockOutInDetailBB.AddRecord(stockOutInDetailModel); } //更改正式库存信息 commBB.ExecuteSql("update dbo.UStock set num=num-" + pickOutNum.ToString() + " where boxNo='" + strOldBoxNo + "'"); #region 拣货信息赋值 DEPickOutBoxModel = new CDEPickOutBoxData(); DEPickOutBoxModel.boxNo = strNewBoxNo;//新箱号 DEPickOutBoxModel.oldBoxNo = strOldBoxNo;//原箱号 DEPickOutBoxModel.materialNo = dtArrangeBillBox.Rows[0]["materialNo"].ToString();//物料编号 DEPickOutBoxModel.num = pickOutNum;//拣货数量 DEPickOutBoxModel.palletNo = strNewPalletNo;//新托盘号 DEPickOutBoxModel.region = "";//新区域 DEPickOutBoxModel.oldPalletNo = dtArrangeBillBox.Rows[0]["palletNo"].ToString();//原托盘号 DEPickOutBoxModel.oldRegion = dtArrangeBillBox.Rows[0]["region"].ToString();//原区域 DEPickOutBoxModel.preWareNo = dtArrangeBillBox.Rows[0]["wareNo"].ToString();//原库区 DEPickOutBoxModel.preWareLocatorNo = dtArrangeBillBox.Rows[0]["wareLocatorNo"].ToString(); //原库位 DEPickOutBoxModel.stockUpBillNo = strStockUpBillNo;//备货单编号 DEPickOutBoxModel.palletIndex = palletIndex;//托盘序号 if (pickOutPlanModel != null) { DEPickOutBoxModel.absEntry = 0;//此处暂时将提货单ID设为0 DEPickOutBoxModel.saleBillNo = pickOutPlanModel.saleBillNo; DEPickOutBoxModel.lineNum = pickOutPlanModel.lineNum; DEPickOutBoxModel.DocEntry = pickOutPlanModel.DocEntry; } DEPickOutBoxModel.isrtEmpId = this.EmpID;//添加人 DEPickOutBoxModel.isrtDt = System.DateTime.Now.ToString();//添加时间 #endregion 拣货信息赋值 //添加库存明细--高位货架上的托盘 if ((dtPallet.Rows.Count > 0 && dtPallet.Rows[0]["wareType"].ToString() == "03" && strOperType == "02" && dtPallet.Rows[0]["wareLocatorNo"].ToString() != "" && dtPallet.Rows[0]["wareSortNo"].ToString() != "D" && dtPallet.Rows[0]["wareSortNo"].ToString() != "E") || (stockNum > 0 && DEPickOutBoxModel.oldPalletNo != "")) { #region 放置托盘在正式库区 #region 保存拣货信息 DEPickOutBoxModel.wareNo = dtPallet.Rows[0]["wareNo"].ToString();//新库区 DEPickOutBoxModel.wareLocatorNo = dtPallet.Rows[0]["wareLocatorNo"].ToString();//新库位 DEPickOutBoxModel.isOutStock = true;//是否出库 DEPickOutBoxModel.updtDt = System.DateTime.Now.ToString();//更改时间 DEPickOutBoxModel.updtEmpId = this.EmpID;//更改人员 #endregion 保存拣货信息 #region 保存库存明细数据 dtStock = stockBB.GetList("boxNo='" + strNewBoxNo + "' and num>0").Tables[0]; if (dtStock.Rows.Count == 0)//没有库存 { //增加库存明细 stockModel = new UStockData(); stockModel.wareNo = dtPallet.Rows[0]["wareNo"].ToString();//仓库 stockModel.wareLocatorNo = dtPallet.Rows[0]["wareLocatorNo"].ToString();//库位 stockModel.stockDt = System.DateTime.Today.ToString();//库存日期 stockModel.palletNo = strNewPalletNo;//托盘号 stockModel.materialNo = dtArrangeBillBox.Rows[0]["materialNo"].ToString();//物料编号 stockModel.boxNo = strNewBoxNo;//箱号 stockModel.factMonomerNum = Convert.ToDouble(dtMaterial.Rows[0]["U_UintQty"]);//单体数量 stockModel.factPackNum = Convert.ToDouble(dtMaterial.Rows[0]["U_BoxQty"]);//整箱数量 stockModel.num = pickOutNum;//数量 stockModel.isOutStocking = false;//是否正在出库 stockModel.stockMark = "拆托合托"; stockBB.AddRecord(stockModel); } else//已有库存 { strSql = "update dbo.UStock set num=num+" + pickOutNum.ToString() + " where boxNo='" + strNewBoxNo + "'"; commBB.ExecuteSql(strSql); } //增加出入库明细-新箱入库 stockOutInDetailModel = new UStockOutInDetailData(); stockOutInDetailModel.billNo = strStockUpBillNo;//单据编号 stockOutInDetailModel.outInType = "08";//拆托合托 stockOutInDetailModel.isOut = false;//是否出库 stockOutInDetailModel.stockDt = System.DateTime.Today.ToString();//库存日期 stockOutInDetailModel.dt = System.DateTime.Today.ToString();//操作日期 stockOutInDetailModel.wareNo = dtPallet.Rows[0]["wareNo"].ToString();//仓库 stockOutInDetailModel.wareLocatorNo = dtPallet.Rows[0]["wareLocatorNo"].ToString();//库位 stockOutInDetailModel.salverNo = strNewPalletNo;//托盘号 stockOutInDetailModel.boxNo = strNewBoxNo;//箱号 stockOutInDetailModel.materialNo = dtArrangeBillBox.Rows[0]["materialNo"].ToString();//物料编号 stockOutInDetailModel.factMonomerNum = Convert.ToDouble(dtMaterial.Rows[0]["U_UintQty"]);//单体数量 stockOutInDetailModel.factPackNum = Convert.ToDouble(dtMaterial.Rows[0]["U_BoxQty"]);//整箱数量 stockOutInDetailModel.num = pickOutNum;//数量 stockOutInDetailModel.nextBoxNo = "";//拆箱目的箱号 stockOutInDetailModel.isrtEmpId = this.empId; stockOutInDetailModel.isrtDt = System.DateTime.Now.ToString(); stockOutInDetailBB.AddRecord(stockOutInDetailModel); #endregion 保存库存明细数据 //更改排托箱入库信息 commBB.ExecuteSql("update dbo.BArrangeBillBox set inStockDt=getDate(),inStockEmpId=" + this.EmpID.ToString() + ",inStockNum='" + stockOutInDetailModel.num.ToString() + "',isOutStocking=0 where boxNo='" + stockOutInDetailModel.boxNo + "' and isnull(wareNo,'')<>'' and inStockDt is null"); #endregion 放置托盘在正式库区 } else { #region 保存流利货架拣货或非正式库拆托组托信息或拆到空托盘 if (DEPickOutBoxModel.oldPalletNo != "")//非正式库拆托组托或拆到空托盘 { if (dtPallet.Rows.Count > 0 && dtPallet.Rows[0]["wareNo"].ToString().IndexOf("GLHJ") == -1 && dtPallet.Rows[0]["wareLocatorNo"].ToString() != "")//新托盘上已有物料箱,将物料放到原有托盘 { DEPickOutBoxModel.wareNo = dtPallet.Rows[0]["wareNo"].ToString();//新库区 DEPickOutBoxModel.wareLocatorNo = dtPallet.Rows[0]["wareLocatorNo"].ToString();//新库位 } else { DEPickOutBoxModel.wareNo = dtArrangeBillBox.Rows[0]["wareNo"].ToString();//新库区 DEPickOutBoxModel.wareLocatorNo = "";//放到空托盘 } //是否出库 if (DEPickOutBoxModel.wareLocatorNo != "")//非正式库拆托组托 { DEPickOutBoxModel.isOutStock = true;//是否出库 DEPickOutBoxModel.updtDt = System.DateTime.Now.ToString();//更改时间 DEPickOutBoxModel.updtEmpId = this.EmpID;//更改人员 } else { //拆到空托盘 DEPickOutBoxModel.isOutStock = false; } } else//流利货架拣货 { DEPickOutBoxModel.wareNo = dtArrangeBillBox.Rows[0]["wareNo"].ToString();//新库区 DEPickOutBoxModel.wareLocatorNo = dtArrangeBillBox.Rows[0]["wareLocatorNo"].ToString();//新库位 DEPickOutBoxModel.isOutStock = false;//是否出库 } #endregion 保存流利货架拣货或非正式库拆托组托信息或拆到空托盘 } //保存拣货信息 DEPickOutBoxBB.AddRecord(DEPickOutBoxModel); //拣货处理逻辑更改为:根据实际需要数量进行拣货 //处理情况分为:整箱拣货、拆箱拣货 if (strNewBoxNo == strOldBoxNo)//整箱拣货 { if (DEPickOutBoxModel.oldPalletNo != "" || dtArrangeBillBox.Rows[0]["wareNo"] == DBNull.Value || dtArrangeBillBox.Rows[0]["wareNo"].ToString() == "")//非流利货架或已出库箱重新入库 { //物料箱库位赋值 commBB.ExecuteSql("update dbo.BArrangeBillBox set oldPalletNo=palletNo,palletNo='" + strNewPalletNo + "',region=oldRegion,oldRegion='',preWareNo=wareNo,preWareLocatorNo=wareLocatorNo,wareNo='" + DEPickOutBoxModel.wareNo + "',wareLocatorNo='" + DEPickOutBoxModel.wareLocatorNo + "',stockUpBillNo='" + strStockUpBillNo + "' where boxNo='" + strOldBoxNo + "'"); } else { //流利货架,库位赋空值 commBB.ExecuteSql("update dbo.BArrangeBillBox set oldPalletNo=palletNo,palletNo='" + strNewPalletNo + "',region=oldRegion,oldRegion='',preWareNo=wareNo,preWareLocatorNo=wareLocatorNo,wareNo='" + DEPickOutBoxModel.wareNo + "',wareLocatorNo='',stockUpBillNo='" + strStockUpBillNo + "' where boxNo='" + strOldBoxNo + "'"); } } //如果原箱剩余数量为0,清空原箱的托盘号、库区、库位 dtArrangeBillBox = arrangeBillBoxBB.GetVList("boxNo='" + strOldBoxNo + "'").Tables[0]; if (Convert.ToInt32(dtArrangeBillBox.Rows[0]["leavingNum"]) == 0) { commBB.ExecuteSql(@"update dbo.BArrangeBillBox set oldPalletNo=palletNo,palletNo='',preWareNo=wareNo,preWareLocatorNo=wareLocatorNo, wareNo='',wareLocatorNo='',stockUpBillNo='" + strStockUpBillNo + "' where boxNo='" + strOldBoxNo + "'"); } #region 新增新的排托箱 DataTable dtArrangeBillBoxNew = new DataTable(); dtArrangeBillBoxNew = arrangeBillBoxBB.GetList("boxNo='" + strNewBoxNo + "'").Tables[0]; //新增新的排托箱 if (dtArrangeBillBoxNew.Rows.Count == 0) { BArrangeBillBoxData newArrangeBillBoxModel = new BArrangeBillBoxData(); newArrangeBillBoxModel.arriveBillNo = "";//到货单号 newArrangeBillBoxModel.financeBillNo = dtArrangeBillBox.Rows[0]["financeBillNo"].ToString();//采购订单号 newArrangeBillBoxModel.arrangeBillNo = "";//排托单号 newArrangeBillBoxModel.stockUpBillNo = strStockUpBillNo;//备货单编号 newArrangeBillBoxModel.boxNo = strNewBoxNo;//箱号 newArrangeBillBoxModel.oldBoxNo = strOldBoxNo;//原箱号 newArrangeBillBoxModel.materialNo = dtArrangeBillBox.Rows[0]["materialNo"].ToString();//物料编号 newArrangeBillBoxModel.factNum = 0;//数量,赋0值通过拣货清单计算实际数量 newArrangeBillBoxModel.palletNo = strNewPalletNo;//托盘号 newArrangeBillBoxModel.region = "";//区域 newArrangeBillBoxModel.oldPalletNo = dtArrangeBillBox.Rows[0]["palletNo"].ToString();//原托盘号 newArrangeBillBoxModel.oldRegion = dtArrangeBillBox.Rows[0]["region"].ToString();//原托内区域 newArrangeBillBoxModel.wareNo = dtArrangeBillBox.Rows[0]["wareNo"].ToString();//库区 if (DEPickOutBoxModel.oldPalletNo != "")//非流利货架 { newArrangeBillBoxModel.wareLocatorNo = DEPickOutBoxModel.wareLocatorNo;//库位 } else//流利货架 { newArrangeBillBoxModel.wareLocatorNo = "";//库位 } newArrangeBillBoxModel.preWareNo = dtArrangeBillBox.Rows[0]["wareNo"].ToString();//原库区 newArrangeBillBoxModel.preWareLocatorNo = dtArrangeBillBox.Rows[0]["wareLocatorNo"].ToString();//原库位 newArrangeBillBoxModel.isBoxArrange = true;//是否排托 newArrangeBillBoxModel.isPalletUsing = true;//托盘是否正在使用 newArrangeBillBoxModel.acceptEmpId = this.EmpID;//接收人 newArrangeBillBoxModel.acceptDt = System.DateTime.Now.ToString();//接收时间 newArrangeBillBoxModel.checkResult = Convert.ToBoolean(dtArrangeBillBox.Rows[0]["checkResult"]);//校验结果 newArrangeBillBoxModel.isOutStocking = false;//是否正在出库 newArrangeBillBoxModel.noPassReasonId = Convert.ToInt32(dtArrangeBillBox.Rows[0]["noPassReasonId"]);//不合格原因 newArrangeBillBoxModel.noPassMark = dtArrangeBillBox.Rows[0]["noPassMark"].ToString();//不合格备注 arrangeBillBoxBB.AddRecord(newArrangeBillBoxModel); } #endregion 新增新的排托箱 //库存明细数量为0,删除信息 strSql = "delete from dbo.UStock where num=0"; commBB.ExecuteSql(strSql); //更改库存中原箱的是否锁定状态 strSql = "update dbo.UStock set isOutStocking=0 where id in (select top 1 id from dbo.UStock where wareLocatorNo='" + strPreWareLocatorNo + "' and materialNo='" + dtArrangeBillBox.Rows[0]["materialNo"].ToString() + "' and isOutStocking=1 order by id)"; commBB.ExecuteSql(strSql); //更改原箱的是否锁定状态 strSql = "update dbo.BArrangeBillBox set isOutStocking=0 where id in (select top 1 id from dbo.BArrangeBillBox where wareLocatorNo='" + strPreWareLocatorNo + "' and materialNo='" + dtArrangeBillBox.Rows[0]["materialNo"].ToString() + "' and isOutStocking=1 order by id)"; commBB.ExecuteSql(strSql); //释放库位,首先判断原托盘上是否有物料 strSql = @"update dbo.LWareLocator set isUsing=0 where not exists(select 1 from dbo.BArrangeBillBox as t where t.wareLocatorNo=dbo.LWareLocator.wareLocatorNo) and isUsing=1 and isDel=0 and wareLocatorNo='" + strPreWareLocatorNo + "'"; commBB.ExecuteSql(strSql); if (this.transaction == null) trans.Commit(); ret = true; } catch { if (transaction == null) trans.Rollback("TranSave"); throw new Exception("保存信息失败!"); } finally { commBB.Dispose(); arrangeBillBoxBB.Dispose(); DEPickOutBoxBB.Dispose(); materialBB.Dispose(); wareBB.Dispose(); stockOutInDetailBB.Dispose(); pickOutPlanBB.Dispose(); } return ret; }
/// <summary> /// 合箱处理 /// </summary> /// <param name="strOldBoxNo">源箱号</param> /// <param name="strNewBoxNo">目的箱号</param> /// <param name="pickOutNum">合并数量</param> /// <returns></returns> public bool JoinBox(string strOldBoxNo, string strNewBoxNo, int pickOutNum) { bool ret = false; SqlTransaction trans = null; SCommBB commBB = new SCommBB(this.connection); BArrangeBillBoxBB arrangeBillBoxBB = new BArrangeBillBoxBB(this.connection); CDEPickOutBoxBB DEPickOutBoxBB = new CDEPickOutBoxBB(this.connection); LMaterialBB materialBB = new LMaterialBB(); UStockOutInDetailBB stockOutInDetailBB = new UStockOutInDetailBB(this.connection); try { if (this.transaction == null) { trans = this.connection.BeginTransaction("TranJoinBox"); this.stockBB.Transaction = trans; commBB.Transaction = trans; arrangeBillBoxBB.Transaction = trans; DEPickOutBoxBB.Transaction = trans; stockOutInDetailBB.Transaction = trans; } else { this.stockBB.Transaction = this.transaction; commBB.Transaction = this.transaction; arrangeBillBoxBB.Transaction = this.transaction; DEPickOutBoxBB.Transaction = this.transaction; stockOutInDetailBB.Transaction = this.transaction; } DataTable dtOldArrangeBillBox = new DataTable(); DataTable dtNewArrangeBillBox = new DataTable(); DataTable dtMaterial = new DataTable(); DataTable dtStock = new DataTable(); CDEPickOutBoxData DEPickOutBoxModel = new CDEPickOutBoxData(); UStockOutInDetailData stockOutInDetailModel = new UStockOutInDetailData(); UStockData stockModel = new UStockData(); string strSql = "", strPreWareLocatorNo = ""; //获取源箱信息 dtOldArrangeBillBox = arrangeBillBoxBB.GetVList("boxNo='" + strOldBoxNo + "'").Tables[0]; //获取新箱信息 dtNewArrangeBillBox = arrangeBillBoxBB.GetVList("boxNo='" + strNewBoxNo + "'").Tables[0]; //扫描箱所在库位 if (dtOldArrangeBillBox.Rows.Count > 0) { strPreWareLocatorNo = dtOldArrangeBillBox.Rows[0]["wareLocatorNo"].ToString(); } #region 增加拣货信息赋值 DEPickOutBoxModel = new CDEPickOutBoxData(); DEPickOutBoxModel.boxNo = strNewBoxNo;//新箱号 DEPickOutBoxModel.oldBoxNo = strOldBoxNo;//原箱号 DEPickOutBoxModel.materialNo = dtNewArrangeBillBox.Rows[0]["materialNo"].ToString();//物料编号 DEPickOutBoxModel.num = pickOutNum;//拣货数量 DEPickOutBoxModel.palletNo = dtNewArrangeBillBox.Rows[0]["palletNo"].ToString();//新托盘号 DEPickOutBoxModel.region = "";//新区域 if (dtOldArrangeBillBox.Rows.Count > 0) { DEPickOutBoxModel.oldPalletNo = dtOldArrangeBillBox.Rows[0]["palletNo"].ToString();//原托盘号 DEPickOutBoxModel.oldRegion = dtOldArrangeBillBox.Rows[0]["region"].ToString();//原区域 DEPickOutBoxModel.preWareNo = dtOldArrangeBillBox.Rows[0]["wareNo"].ToString();//原库区 DEPickOutBoxModel.preWareLocatorNo = dtOldArrangeBillBox.Rows[0]["wareLocatorNo"].ToString();//原库位 } else { DEPickOutBoxModel.oldPalletNo = "";//原托盘号 DEPickOutBoxModel.oldRegion = "";//原区域 DEPickOutBoxModel.preWareNo = "";//原库区 DEPickOutBoxModel.preWareLocatorNo = "";//原库位 } DEPickOutBoxModel.stockUpBillNo = "";//备货单编号 DEPickOutBoxModel.palletIndex = 0;//备货单内托盘序号 DEPickOutBoxModel.isrtEmpId = this.EmpID;//添加人 DEPickOutBoxModel.isrtDt = System.DateTime.Now.ToString();//添加时间 DEPickOutBoxModel.wareNo = dtNewArrangeBillBox.Rows[0]["wareNo"].ToString();//新库区 DEPickOutBoxModel.wareLocatorNo = dtNewArrangeBillBox.Rows[0]["wareLocatorNo"].ToString();//新库位 DEPickOutBoxModel.isOutStock = true;//是否出库 //保存拣货信息 DEPickOutBoxBB.AddRecord(DEPickOutBoxModel); #endregion 增加拣货信息赋值 #region 源箱处理 if (strOldBoxNo.Trim() != "")//源箱号在系统中已存在 { //增加出入库明细-原箱出库 dtStock = stockBB.GetList("boxNo='" + strOldBoxNo + "'").Tables[0]; if (dtStock.Rows.Count > 0)//原箱有库存 { //获取物料属性 dtMaterial = materialBB.GetList("materialNo='" + dtOldArrangeBillBox.Rows[0]["materialNo"].ToString() + "'").Tables[0]; //保存出入库明细数据-出库 stockOutInDetailModel = new UStockOutInDetailData(); stockOutInDetailModel.billNo = "";//单据编号 stockOutInDetailModel.outInType = "09";//合箱 stockOutInDetailModel.isOut = true;//是否出库 stockOutInDetailModel.stockDt = System.DateTime.Today.ToString();//库存日期 stockOutInDetailModel.dt = System.DateTime.Today.ToString();//操作日期 stockOutInDetailModel.wareNo = dtOldArrangeBillBox.Rows[0]["wareNo"].ToString();//仓库 stockOutInDetailModel.wareLocatorNo = dtOldArrangeBillBox.Rows[0]["wareLocatorNo"].ToString();//库位 stockOutInDetailModel.salverNo = dtOldArrangeBillBox.Rows[0]["palletNo"].ToString();//托盘号 stockOutInDetailModel.boxNo = strOldBoxNo;//箱号 stockOutInDetailModel.materialNo = dtOldArrangeBillBox.Rows[0]["materialNo"].ToString();//物料编号 stockOutInDetailModel.factMonomerNum = Convert.ToDouble(dtMaterial.Rows[0]["U_UintQty"]);//单体数量 stockOutInDetailModel.factPackNum = Convert.ToDouble(dtMaterial.Rows[0]["U_BoxQty"]);//整箱数量 stockOutInDetailModel.num = pickOutNum;//数量 stockOutInDetailModel.nextBoxNo = strNewBoxNo;//拆箱目的箱号 stockOutInDetailModel.isrtEmpId = this.empId; stockOutInDetailModel.isrtDt = System.DateTime.Now.ToString(); stockOutInDetailBB.AddRecord(stockOutInDetailModel); //更改正式库存信息 commBB.ExecuteSql("update dbo.UStock set num=num-" + pickOutNum.ToString() + " where boxNo='" + strOldBoxNo + "'"); } } #endregion 源箱处理 #region 目的箱处理 dtStock = stockBB.GetList("boxNo='" + strNewBoxNo + "'").Tables[0]; if (dtStock.Rows.Count > 0)//新箱已有库存 { //获取物料属性 dtMaterial = materialBB.GetList("materialNo='" + dtNewArrangeBillBox.Rows[0]["materialNo"].ToString() + "'").Tables[0]; //增加出入库明细-新箱入库 stockOutInDetailModel = new UStockOutInDetailData(); stockOutInDetailModel.billNo = "";//单据编号 stockOutInDetailModel.outInType = "09";//合箱 stockOutInDetailModel.isOut = false;//是否出库 stockOutInDetailModel.stockDt = System.DateTime.Today.ToString();//库存日期 stockOutInDetailModel.dt = System.DateTime.Today.ToString();//操作日期 stockOutInDetailModel.wareNo = dtNewArrangeBillBox.Rows[0]["wareNo"].ToString();//仓库 stockOutInDetailModel.wareLocatorNo = dtNewArrangeBillBox.Rows[0]["wareLocatorNo"].ToString();//库位 stockOutInDetailModel.salverNo = dtNewArrangeBillBox.Rows[0]["palletNo"].ToString(); ;//托盘号 stockOutInDetailModel.boxNo = strNewBoxNo;//箱号 stockOutInDetailModel.materialNo = dtNewArrangeBillBox.Rows[0]["materialNo"].ToString();//物料编号 stockOutInDetailModel.factMonomerNum = Convert.ToDouble(dtMaterial.Rows[0]["U_UintQty"]);//单体数量 stockOutInDetailModel.factPackNum = Convert.ToDouble(dtMaterial.Rows[0]["U_BoxQty"]);//整箱数量 stockOutInDetailModel.num = pickOutNum;//数量 stockOutInDetailModel.nextBoxNo = "";//拆箱目的箱号 stockOutInDetailModel.isrtEmpId = this.empId; stockOutInDetailModel.isrtDt = System.DateTime.Now.ToString(); stockOutInDetailBB.AddRecord(stockOutInDetailModel); //修改目的箱的库存数量 strSql = "update dbo.UStock set num=num+" + pickOutNum.ToString() + " where boxNo='" + strNewBoxNo + "'"; commBB.ExecuteSql(strSql); //更改排托箱入库信息 commBB.ExecuteSql("update dbo.BArrangeBillBox set inStockDt=getDate(),inStockEmpId=" + this.EmpID.ToString() + ",inStockNum='" + stockOutInDetailModel.num.ToString() + "' where boxNo='" + stockOutInDetailModel.boxNo + "' and isnull(wareNo,'')<>'' and inStockDt is null"); } #endregion 目的箱处理 //如果原箱剩余数量为0,清空原箱的托盘号、库区、库位 dtOldArrangeBillBox = arrangeBillBoxBB.GetVList("boxNo='" + strOldBoxNo + "'").Tables[0]; if (dtOldArrangeBillBox.Rows.Count > 0 && Convert.ToInt32(dtOldArrangeBillBox.Rows[0]["leavingNum"]) + Convert.ToInt32(dtOldArrangeBillBox.Rows[0]["DEPickOutNum"]) == 0) { commBB.ExecuteSql(@"update dbo.BArrangeBillBox set oldPalletNo=palletNo,palletNo='',preWareNo=wareNo,preWareLocatorNo=wareLocatorNo, wareNo='',wareLocatorNo='',stockUpBillNo='' where boxNo='" + strOldBoxNo + "'"); } //库存明细数量为0,删除信息 strSql = "delete from dbo.UStock where num=0"; commBB.ExecuteSql(strSql); //释放库位,首先判断原托盘上是否有物料 strSql = @"update dbo.LWareLocator set isUsing=0 where not exists(select 1 from dbo.BArrangeBillBox as t where t.wareLocatorNo=dbo.LWareLocator.wareLocatorNo) and isUsing=1 and isDel=0 and wareLocatorNo='" + strPreWareLocatorNo + "'"; commBB.ExecuteSql(strSql); if (this.transaction == null) trans.Commit(); ret = true; } catch { if (transaction == null) trans.Rollback("TranJoinBox"); throw new Exception("保存信息失败!"); } finally { commBB.Dispose(); arrangeBillBoxBB.Dispose(); DEPickOutBoxBB.Dispose(); materialBB.Dispose(); stockOutInDetailBB.Dispose(); } return ret; }