//***************************************************************************** //do it later do it later do it later //***************************************************************************** /// <summary> /// 保存退货单信息 /// </summary> /// <param name="dtBox">退货箱</param> /// <param name="strFinanceBillNo">采购订单编号</param> /// <param name="strCustNo">供应商编码</param> /// <param name="strMaterialNo">物料编码</param> /// <returns></returns> public bool SaveRecord(DataTable dtBox, string strFinanceBillNo, string strCustNo, string strMaterialNo,string checkRemark) { bool ret = false; BBackDetailBB backDetailBB = new BBackDetailBB(this.connection); SqlTransaction trans = null; try { if (this.transaction == null) { trans = this.connection.BeginTransaction("TransSave"); this.backBillBB.Transaction = trans; backDetailBB.Transaction = trans; } else { this.backBillBB.Transaction = this.transaction; backDetailBB.Transaction = this.transaction; } BBackBillData backBillModel = new BBackBillData(); BBackDetailData backDetailModel = new BBackDetailData(); //保存退货单信息 backBillModel.backBillNo = this.backBillBB.GetCurrentBackBillNoByPreBillNo();//退货单编号 backBillModel.financeBillNo = strFinanceBillNo;//采购订单号 backBillModel.custNo = strCustNo;//供应商 backBillModel.materialNo = strMaterialNo;//物料编号 backBillModel.backDt = System.DateTime.Today.ToString();//退货日期 backBillModel.isrtDt = System.DateTime.Now.ToString();//添加时间 backBillModel.isrtEmpId = this.empId;//添加人 backBillModel.instantState = "01";//状态:01 未提交 //2015-07-28 修改 增加质检的remark //this.backBillBB.AddRecord(backBillModel); this.backBillBB.AddRecordWihtRemark(backBillModel, checkRemark); //保存退货单明细信息 foreach (DataRow dataRow in dtBox.Rows) { backDetailModel = new BBackDetailData(); backDetailModel.backBillNo = backBillModel.backBillNo;//退货单编号 backDetailModel.boxNo = dataRow["boxNo"].ToString();//箱号 backDetailModel.backNum = Convert.ToInt32(dataRow["num"]);//退货数量 backDetailBB.AddRecord(backDetailModel); } if (this.transaction == null) trans.Commit(); ret = true; } catch (Exception ex) { if (this.transaction == null) trans.Rollback("TransSave"); throw ex; } finally { backDetailBB.Dispose(); } return ret; }
/// <summary> /// 修改退货单信息 /// 2015-07-28 新增修改remark的功能 /// </summary> /// <param name="backBillModel">备货单实例</param> /// <param name="dtBox">退货箱</param> /// <returns></returns> public bool ModityRecord(BBackBillData backBillModel, DataTable dtBox,string fukingbuyerRemark) { bool ret = false; BBackDetailBB backDetailBB = new BBackDetailBB(this.connection); SqlTransaction trans = null; try { if (this.transaction == null) { trans = this.connection.BeginTransaction("TransSave"); this.backBillBB.Transaction = trans; backDetailBB.Transaction = trans; } else { this.backBillBB.Transaction = this.transaction; backDetailBB.Transaction = this.transaction; } BBackDetailData backDetailModel = new BBackDetailData(); //保存退货单信息 //2015-07-28修改 // this.backBillBB.ModifyRecord(backBillModel); this.backBillBB.ModifyRecord(backBillModel,fukingbuyerRemark); //保存退货单明细信息 foreach (DataRow dataRow in dtBox.Rows) { if (Convert.ToBoolean(dataRow["isDel"]) == true) { backDetailBB.DeleteRecord(Convert.ToInt32(dataRow["id"])); } } if (this.transaction == null) trans.Commit(); ret = true; } catch (Exception ex) { if (this.transaction == null) trans.Rollback("TransSave"); throw ex; } finally { backDetailBB.Dispose(); } return ret; }