/// <summary> /// 构造函数 /// </summary> /// <param name="connection">数据连接</param> public BArrangeBillFactBC(SqlConnection connection) { this.connection = connection; this.arrangeBillFactBB = new BArrangeBillFactBB(this.connection); this.errorDiaryBB = new SErrorDiaryBB(this.connection); this.operatDiaryBB = new SOperatDiaryBB(this.connection); }
/// <summary> /// 构造函数 /// </summary> public BArrangeBillFactBC() { this.selfConn = true; this.connection = new SqlConnection(HS.Config.SqlDataObject.GetSqlConnectionString); this.connection.Open(); this.arrangeBillFactBB = new BArrangeBillFactBB(this.connection); this.errorDiaryBB = new SErrorDiaryBB(this.connection); this.operatDiaryBB = new SOperatDiaryBB(this.connection); }
//***************************************************************************** //do it later do it later do it later //***************************************************************************** /// <summary> /// 保存扫描箱体信息 /// </summary> /// <param name="strArriveBillNo">到货单号</param> /// <param name="strFinanceBillNo">采购订单号</param> /// <param name="strPalletIndex">托盘序号</param> /// <param name="strRegion">托内区域</param> /// <param name="strBoxNo">箱号</param> /// <param name="strMaterialNo">物料号</param> /// <returns></returns> public bool SaveRecord(string strArriveBillNo, string strFinanceBillNo, string strPalletIndex, string strRegion, string strBoxNo, string strMaterialNo) { bool ret = false; SqlTransaction trans = null; LWareLocatorBB wareLocatorBB = new LWareLocatorBB(); BArrangeBillFactBB arrangeBillFactBB = new BArrangeBillFactBB(); BArrangeBillBoxBB arrangeBillBoxBB = new BArrangeBillBoxBB(this.connection); SCommBB commBB = new SCommBB(this.connection); try { if (this.transaction == null) { trans = this.connection.BeginTransaction("TransSave"); this.arrangeBillFactDetailBB.Transaction = trans; arrangeBillBoxBB.Transaction = trans; commBB.Transaction = trans; } else { this.arrangeBillFactDetailBB.Transaction = this.transaction; arrangeBillBoxBB.Transaction = this.transaction; commBB.Transaction = this.transaction; } BArrangeBillFactDetailData arrangeBillFactDetailModel = new BArrangeBillFactDetailData(); BArrangeBillBoxData arrangeBillBoxModel = new BArrangeBillBoxData(); DataSet ds = new DataSet(); DataTable dtWareLocator = new DataTable(); string mainId = "0", strPalletNo = ""; StringBuilder strSql = new StringBuilder(); //获取排托实际信息 ds = arrangeBillFactBB.GetList("arriveBillNo='" + strArriveBillNo + "' and financeBillNo='" + strFinanceBillNo + "' and palletIndex='" + strPalletIndex + "'"); if (ds.Tables[0].Rows.Count > 0) { mainId = ds.Tables[0].Rows[0]["id"].ToString(); strPalletNo = ds.Tables[0].Rows[0]["palletNo"].ToString(); } //获取排托区下线库位信息 strSql.Append(@"select wareLocator.wareNo,wareLocator.downWareLocatorNo as wareLocatorNo "); strSql.Append(@"from dbo.BArrangeBillBox as arriveBox "); strSql.Append(@"left join dbo.LWareLocator as wareLocator on wareLocator.wareLocatorNo=arriveBox.wareLocatorNo "); strSql.Append(@"where arriveBox.boxNo='" + strBoxNo + "'"); dtWareLocator = commBB.Query(strSql.ToString()).Tables[0]; //保存排托收货单明细信息 arrangeBillFactDetailModel.mainId = mainId;//排托收货单ID arrangeBillFactDetailModel.boxNo = strBoxNo;//箱号 arrangeBillFactDetailModel.region = strRegion;//区域 arrangeBillFactDetailModel.isrtEmpId = this.empId; arrangeBillFactDetailModel.isrtDt = System.DateTime.Now.ToString(); arrangeBillFactDetailBB.AddRecord(arrangeBillFactDetailModel); //更改扫描箱信息 commBB.ExecuteSql("update dbo.BArrangeBillBox set arrangeBillNo='" + "PT" + strArriveBillNo + "',preWareNo=wareNo,preWareLocatorNo=wareLocatorNo,oldPalletNo=palletNo,oldRegion=region,palletNo='" + strPalletNo + "',region='" + strRegion + "',wareNo='" + dtWareLocator.Rows[0]["wareNo"].ToString() + "',wareLocatorNo='" + dtWareLocator.Rows[0]["wareLocatorNo"].ToString() + "',isrtEmpId='" + this.empId.ToString() + "',isrtDt='" + System.DateTime.Now.ToString() + "',isBoxArrange=1 where boxNo='" + strBoxNo + "'"); if (this.transaction == null) trans.Commit(); ret = true; } catch (Exception ex) { if (this.transaction == null) trans.Rollback("TransSave"); throw ex; } finally { wareLocatorBB.Dispose(); arrangeBillFactBB.Dispose(); arrangeBillBoxBB.Dispose(); commBB.Dispose(); } return ret; }