public void CancelTransportationBill(string billNo, User user) { TransportationBill oldTransportationBill = this.CheckAndLoadTransportationBill(billNo); #region 检查状态 if (oldTransportationBill.Status != BusinessConstants.CODE_MASTER_STATUS_VALUE_SUBMIT) { throw new BusinessErrorException("TransportationBill.Error.StatusErrorWhenCancel", oldTransportationBill.Status, oldTransportationBill.BillNo); } #endregion if (oldTransportationBill.TransportationBillDetails != null && oldTransportationBill.TransportationBillDetails.Count > 0) { foreach (TransportationBillDetail newTransportationBillDetail in oldTransportationBill.TransportationBillDetails) { TransportationBillDetail oldTransportationBillDetail = this.transportationBillDetailMgr.LoadTransportationBillDetail(newTransportationBillDetail.Id); //反向更新TransportationActBill this.transportationActBillMgr.ReverseUpdateTransportationActBill(oldTransportationBillDetail, null, user); #region 记录开票事务 /*20110422 Tag 先做标记,后期补充 * this.billTransactionMgr.RecordBillTransaction(oldTransportationBillDetail, user, true); */ #endregion } } oldTransportationBill.Status = BusinessConstants.CODE_MASTER_STATUS_VALUE_CANCEL; oldTransportationBill.LastModifyUser = user; oldTransportationBill.LastModifyDate = DateTime.Now; this.UpdateTransportationBill(oldTransportationBill); }
public void ReleaseTransportationBill(string billNo, User user) { TransportationBill oldTransportationBill = this.CheckAndLoadTransportationBill(billNo); #region 检查状态 if (oldTransportationBill.Status != BusinessConstants.CODE_MASTER_STATUS_VALUE_CREATE) { throw new BusinessErrorException("TransportationBill.Error.StatusErrorWhenRelease", oldTransportationBill.Status, oldTransportationBill.BillNo); } #endregion #region 检查明细不能为空 if (oldTransportationBill.TransportationBillDetails == null || oldTransportationBill.TransportationBillDetails.Count == 0) { throw new BusinessErrorException("TransportationBill.Error.EmptyBillDetail", oldTransportationBill.BillNo); } #endregion #region 记录开票事务 /*20110422 Tag 先做标记,后期补充 * foreach (TransportationBillDetail transportationBillDetail in oldTransportationBill.TransportationBillDetails) * { * this.billTransactionMgr.RecordBillTransaction(transportationBillDetail, user, false); * } */ #endregion oldTransportationBill.Status = BusinessConstants.CODE_MASTER_STATUS_VALUE_SUBMIT; oldTransportationBill.LastModifyUser = user; oldTransportationBill.LastModifyDate = DateTime.Now; this.UpdateTransportationBill(oldTransportationBill); }
/// <summary> /// 运单导出 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnExport_Click(object sender, EventArgs e) { TransportationBill tb = TheTransportationBillMgr.LoadTransportationBill(this.BillNo, true); IList <TransportationBillDetail> detail = tb.TransportationBillDetails; getExcel(tb, detail, true); }
protected void btnSave_Click(object sender, EventArgs e) { try { IList <TransportationBillDetail> transportationBillDetailList = PopulateData(false); TransportationBill transportationBill = this.TheTransportationBillMgr.LoadTransportationBill(this.BillNo); TextBox tbExternalBillNo = this.FV_TransportationBill.FindControl("tbExternalBillNo") as TextBox; if (tbExternalBillNo.Text.Trim() != string.Empty) { transportationBill.ExternalBillNo = tbExternalBillNo.Text.Trim(); } else { transportationBill.ExternalBillNo = null; } if (this.tbTotalDiscount.Text.Trim() != string.Empty) { transportationBill.Discount = decimal.Parse(this.tbTotalDiscount.Text.Trim()); } else { transportationBill.Discount = null; } transportationBill.TransportationBillDetails = transportationBillDetailList; this.TheTransportationBillMgr.UpdateTransportationBill(transportationBill, this.CurrentUser); this.ShowSuccessMessage("Transportation.TransportationBill.UpdateSuccessfully", this.BillNo); this.FV_TransportationBill.DataBind(); } catch (BusinessErrorException ex) { this.ShowErrorMessage(ex); } }
public void AddTransportationBillDetail(string billNo, IList <TransportationActBill> transportationActBillList, User user) { TransportationBill oldTransportationBill = this.CheckAndLoadTransportationBill(billNo, true); #region 检查状态 if (oldTransportationBill.Status != BusinessConstants.CODE_MASTER_STATUS_VALUE_CREATE) { throw new BusinessErrorException("TransportationBill.Error.StatusErrorWhenAddDetail", oldTransportationBill.Status, oldTransportationBill.BillNo); } #endregion if (transportationActBillList != null && transportationActBillList.Count > 0) { foreach (TransportationActBill transportationActBill in transportationActBillList) { TransportationActBill oldTransportationActBill = this.transportationActBillMgr.LoadTransportationActBill(transportationActBill.Id); oldTransportationActBill.CurrentBillQty = transportationActBill.CurrentBillQty; oldTransportationActBill.CurrentDiscount = transportationActBill.CurrentDiscount; TransportationBillDetail transportationBillDetail = this.transportationBillDetailMgr.TransferTransportationActBill2TransportationBillDetail(oldTransportationActBill); transportationBillDetail.Bill = oldTransportationBill; oldTransportationBill.AddTransportationBillDetail(transportationBillDetail); this.transportationBillDetailMgr.CreateTransportationBillDetail(transportationBillDetail); //扣减TransportationActBill数量和金额 this.transportationActBillMgr.ReverseUpdateTransportationActBill(null, transportationBillDetail, user); } oldTransportationBill.LastModifyDate = DateTime.Now; oldTransportationBill.LastModifyUser = user; this.UpdateTransportationBill(oldTransportationBill); } }
public void DeleteTransportationBill(string billNo, User user) { TransportationBill oldTransportationBill = this.CheckAndLoadTransportationBill(billNo, true); #region 检查状态 if (oldTransportationBill.Status != BusinessConstants.CODE_MASTER_STATUS_VALUE_CREATE) { throw new BusinessErrorException("TransportationBill.Error.StatusErrorWhenDelete", oldTransportationBill.Status, oldTransportationBill.BillNo); } #endregion if (oldTransportationBill.TransportationBillDetails != null && oldTransportationBill.TransportationBillDetails.Count > 0) { foreach (TransportationBillDetail transportationBillDetail in oldTransportationBill.TransportationBillDetails) { TransportationBillDetail oldTransportationBillDetail = this.transportationBillDetailMgr.LoadTransportationBillDetail(transportationBillDetail.Id); //扣减TransportationActBill数量和金额 this.transportationActBillMgr.ReverseUpdateTransportationActBill(oldTransportationBillDetail, null, user); this.transportationBillDetailMgr.DeleteTransportationBillDetail(oldTransportationBillDetail); } } this.DeleteTransportationBill(oldTransportationBill); }
/// <summary> /// 金董春:添加打印功能,添加了TransportationBill.xls模板打印功能 2012-5-28 /// </summary> /// <param name="list"></param> /// <returns></returns> public string WriteToFile(IList <object> list) { TransportationBill tb = (TransportationBill)list[0]; return(getExcel(tb, tb.TransportationBillDetails, false).ToString()); // Response.AddHeader("Content-Disposition", string.Format("attachment;filename=TempWorkBook.xls")); // Response.BinaryWrite(ms.ToArray());Reports/Templates/TempFiles }
protected void GV_List_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { TransportationBill transportationBill = (TransportationBill)e.Row.DataItem; if (transportationBill.Status != BusinessConstants.CODE_MASTER_STATUS_VALUE_CREATE) { com.Sconit.Control.LinkButton lbtnDelete = e.Row.FindControl("lbtnDelete") as com.Sconit.Control.LinkButton; lbtnDelete.Visible = false; } } }
public TransportationBill CheckAndLoadTransportationBill(string billNo) { TransportationBill transportationBill = this.LoadTransportationBill(billNo); if (transportationBill != null) { return(transportationBill); } else { throw new BusinessErrorException("TransportationBill.Error.BillNoNotExist", billNo); } }
public TransportationBill CheckAndLoadTransportationBill(string billNo, bool includeBillDetail) { TransportationBill transportationBill = this.CheckAndLoadTransportationBill(billNo); if (includeBillDetail) { if (transportationBill.TransportationBillDetails != null && transportationBill.TransportationBillDetails.Count > 0) { } } return(transportationBill); }
public void InitPageParameter(bool isPopup, TransportationBill transportationBill) { if (isPopup) { this.billNo = transportationBill.BillNo; this.tbPartyCode.Visible = false; this.ltlParty.Text = transportationBill.BillAddress.Party.Name; this.ltlParty.Visible = true; this.IsRelease.Visible = false; this.btnConfirm.Visible = false; this.btnBack.Visible = false; this.btnAddDetail.Visible = true; this.btnClose.Visible = true; } }
public void CloseTransportationBill(string billNo, User user) { TransportationBill oldTransportationBill = this.CheckAndLoadTransportationBill(billNo); #region 检查状态 if (oldTransportationBill.Status != BusinessConstants.CODE_MASTER_STATUS_VALUE_SUBMIT) { throw new BusinessErrorException("TransportationBill.Error.StatusErrorWhenClose", oldTransportationBill.Status, oldTransportationBill.BillNo); } #endregion oldTransportationBill.Status = BusinessConstants.CODE_MASTER_STATUS_VALUE_CLOSE; oldTransportationBill.LastModifyUser = user; oldTransportationBill.LastModifyDate = DateTime.Now; this.UpdateTransportationBill(oldTransportationBill); }
protected void btnPrint_Click(object sender, EventArgs e) { TransportationBill transportationBill = this.TheTransportationBillMgr.LoadTransportationBill(this.BillNo, true); IList <object> list = new List <object>(); if (transportationBill != null) { list.Add(transportationBill); list.Add(transportationBill.TransportationBillDetails); } string barCodeUrl = WriteToFile(list); // barCodeUrl = TheReportMgr.WriteToFile("TransportationBill.xls", list);/*20110420 Tag 先做标记,后期补充 TransportationBill.xls没有开发*/ Page.ClientScript.RegisterStartupScript(GetType(), "method", " <script language='javascript' type='text/javascript'>PrintOrder('" + barCodeUrl + "'); </script>"); this.ShowSuccessMessage("Transportation.TransportationBill.Print.Successful"); }
public void DeleteTransportationBillDetail(IList <TransportationBillDetail> transportationBillDetailList, User user) { if (transportationBillDetailList != null && transportationBillDetailList.Count > 0) { IDictionary <string, TransportationBill> cachedBillDic = new Dictionary <string, TransportationBill>(); foreach (TransportationBillDetail transportationBillDetail in transportationBillDetailList) { TransportationBillDetail oldTransportationBillDetail = this.transportationBillDetailMgr.LoadTransportationBillDetail(transportationBillDetail.Id); TransportationBill transportationBill = oldTransportationBillDetail.Bill; #region 缓存TransportationBill if (!cachedBillDic.ContainsKey(transportationBill.BillNo)) { cachedBillDic.Add(transportationBill.BillNo, transportationBill); #region 检查状态 if (transportationBill.Status != BusinessConstants.CODE_MASTER_STATUS_VALUE_CREATE) { throw new BusinessErrorException("TransportationBill.Error.StatusErrorWhenDeleteDetail", transportationBill.Status, transportationBill.BillNo); } #endregion } #endregion //扣减TransportationActBill数量和金额 this.transportationActBillMgr.ReverseUpdateTransportationActBill(oldTransportationBillDetail, null, user); this.transportationBillDetailMgr.DeleteTransportationBillDetail(oldTransportationBillDetail); } #region 更新TransportationBill DateTime dateTimeNow = DateTime.Now; foreach (TransportationBill transportationBill in cachedBillDic.Values) { transportationBill.LastModifyDate = dateTimeNow; transportationBill.LastModifyUser = user; this.UpdateTransportationBill(transportationBill); } #endregion } }
private void UpdateView(TransportationBill transportationBill) { #region 根据状态显示按钮 if (transportationBill.Status == BusinessConstants.CODE_MASTER_STATUS_VALUE_CREATE) { //this.btnSave.Visible = true; //this.btnSubmit.Visible = true; //this.btnDelete.Visible = true; //this.btnClose.Visible = false; //this.btnCancel.Visible = false; //this.btnVoid.Visible = false; // this.btnAddDetail.Visible = true; // this.btnDeleteDetail.Visible = true; //this.btnPrint.Visible = false; } else if (transportationBill.Status == BusinessConstants.CODE_MASTER_STATUS_VALUE_SUBMIT) { //this.btnSave.Visible = false; //this.btnSubmit.Visible = false; //this.btnDelete.Visible = false; //this.btnClose.Visible = true; //this.btnCancel.Visible = true; //this.btnVoid.Visible = false; // this.btnAddDetail.Visible = false; // this.btnDeleteDetail.Visible = false; //this.btnPrint.Visible = true; } else if (transportationBill.Status == BusinessConstants.CODE_MASTER_STATUS_VALUE_CANCEL) { //this.btnSave.Visible = false; //this.btnSubmit.Visible = false; //this.btnDelete.Visible = false; //this.btnClose.Visible = false; //this.btnCancel.Visible = false; //this.btnVoid.Visible = false; // this.btnAddDetail.Visible = false; // this.btnDeleteDetail.Visible = false; //this.btnPrint.Visible = false; } else if (transportationBill.Status == BusinessConstants.CODE_MASTER_STATUS_VALUE_CLOSE) { //this.btnSave.Visible = false; //this.btnSubmit.Visible = false; //this.btnDelete.Visible = false; //this.btnClose.Visible = false; //this.btnCancel.Visible = false; //this.btnPrint.Visible = false; if (transportationBill.BillType == BusinessConstants.CODE_TRANSPORTATION_TRANSPORTATIONBILL_TYPE_VALUE_CANCEL) { //this.btnVoid.Visible = false; ; } else { //this.btnVoid.Visible = true; } // this.btnAddDetail.Visible = false; // this.btnDeleteDetail.Visible = false; } else if (transportationBill.Status == BusinessConstants.CODE_MASTER_STATUS_VALUE_VOID) { //this.btnSave.Visible = false; //this.btnSubmit.Visible = false; //this.btnDelete.Visible = false; //this.btnClose.Visible = false; //this.btnCancel.Visible = false; //this.btnVoid.Visible = false; // this.btnAddDetail.Visible = false; //this.btnDeleteDetail.Visible = false; //this.btnPrint.Visible = false; } #endregion #region 根据状态隐藏/显示字段 if (transportationBill.Status != BusinessConstants.CODE_MASTER_STATUS_VALUE_CREATE) { this.Gv_List.Columns[0].Visible = false; this.tbTotalDiscountRate.ReadOnly = true; this.tbTotalDiscount.ReadOnly = true; TextBox tbExternalBillNo = this.FV_TransportationBill.FindControl("tbExternalBillNo") as TextBox; tbExternalBillNo.ReadOnly = true; } else { this.Gv_List.Columns[0].Visible = true; this.tbTotalDiscountRate.ReadOnly = false; this.tbTotalDiscount.ReadOnly = false; TextBox tbExternalBillNo = this.FV_TransportationBill.FindControl("tbExternalBillNo") as TextBox; tbExternalBillNo.ReadOnly = false; } #endregion #region 给总金额和折扣赋值 this.tbTotalDetailAmount.Text = transportationBill.TotalBillDetailAmount.ToString("F2"); this.tbTotalAmount.Text = transportationBill.TotalBillAmount.ToString("F2"); this.tbTotalDiscount.Text = (transportationBill.Discount.HasValue ? transportationBill.Discount.Value : 0).ToString("F2"); this.tbTotalDiscountRate.Text = transportationBill.TotalBillDiscountRate.ToString("F2"); #endregion #region 初始化弹出窗口 this.PartyCode = transportationBill.BillAddress.Party.Code; // this.ucNewSearch.InitPageParameter(true, transportationBill); #endregion UpdateDetailView(transportationBill.TransportationBillDetails); }
public void AddTransportationBillDetail(TransportationBill transportationBill, IList <TransportationActBill> transportationActBillList, User user) { this.AddTransportationBillDetail(transportationBill.BillNo, transportationActBillList, user); }
protected void FV_TransportationBill_DataBound(object sender, EventArgs e) { TransportationBill transportationBill = (TransportationBill)((FormView)(sender)).DataItem; UpdateView(transportationBill); }
public void UpdateTransportationBill(TransportationBill transportationBill, string userCode) { this.UpdateTransportationBill(transportationBill, this.userMgr.CheckAndLoadUser(userCode)); }
public void CloseTransportationBill(TransportationBill transportationBill, User user) { this.CloseTransportationBill(transportationBill.BillNo, user); }
public void UpdateTransportationBill(TransportationBill transportationBill, User user) { TransportationBill oldTransportationBill = this.CheckAndLoadTransportationBill(transportationBill.BillNo, true); oldTransportationBill.Discount = transportationBill.Discount; oldTransportationBill.ExternalBillNo = transportationBill.ExternalBillNo; #region 检查状态 if (oldTransportationBill.Status != BusinessConstants.CODE_MASTER_STATUS_VALUE_CREATE) { throw new BusinessErrorException("TransportationBill.Error.StatusErrorWhenUpdate", oldTransportationBill.Status, oldTransportationBill.BillNo); } #endregion #region 更新明细 if (transportationBill.TransportationBillDetails != null && transportationBill.TransportationBillDetails.Count > 0) { foreach (TransportationBillDetail newTransportationBillDetail in transportationBill.TransportationBillDetails) { TransportationBillDetail oldTransportationBillDetail = this.transportationBillDetailMgr.LoadTransportationBillDetail(newTransportationBillDetail.Id); newTransportationBillDetail.ActBill = oldTransportationBillDetail.ActBill; newTransportationBillDetail.UnitPrice = oldTransportationBillDetail.UnitPrice; newTransportationBillDetail.Currency = oldTransportationBillDetail.Currency; newTransportationBillDetail.IsIncludeTax = oldTransportationBillDetail.IsIncludeTax; newTransportationBillDetail.TaxCode = oldTransportationBillDetail.TaxCode; /* * * 1.TransType=Transportation 价格单明细(承运商) 或 短拨费(区域)时 * a.PricingMethod=M3或KG 按数量 * b.SHIPT 按金额 * 2.TransType=WarehouseLease(固定费用) 按金额 * 3.TransType=Operation(操作费) 按数量 */ if (oldTransportationBillDetail.TransType == BusinessConstants.TRANSPORTATION_PRICELIST_DETAIL_TYPE_OPERATION || (oldTransportationBillDetail.TransType == BusinessConstants.TRANSPORTATION_PRICELIST_DETAIL_TYPE_TRANSPORTATION && (oldTransportationBillDetail.ActBill.PricingMethod == BusinessConstants.TRANSPORTATION_PRICING_METHOD_M3 || oldTransportationBillDetail.ActBill.PricingMethod == BusinessConstants.TRANSPORTATION_PRICING_METHOD_KG) ) ) { //反向更新TransportationActBill,会重新计算开票金额 if (oldTransportationBillDetail.BilledQty != newTransportationBillDetail.BilledQty) { this.transportationActBillMgr.ReverseUpdateTransportationActBill( oldTransportationBillDetail, newTransportationBillDetail, user); } oldTransportationBillDetail.Amount = newTransportationBillDetail.Amount; oldTransportationBillDetail.BilledQty = newTransportationBillDetail.BilledQty; oldTransportationBillDetail.Discount = newTransportationBillDetail.Discount; } else { //反向更新TransportationActBill,会重新计算开票金额 if (oldTransportationBillDetail.Amount != newTransportationBillDetail.Amount) { this.transportationActBillMgr.ReverseUpdateTransportationActBill( oldTransportationBillDetail, newTransportationBillDetail, user); } oldTransportationBillDetail.UnitPrice = newTransportationBillDetail.Amount; oldTransportationBillDetail.Amount = newTransportationBillDetail.Amount; oldTransportationBillDetail.BilledQty = 1; oldTransportationBillDetail.Discount = newTransportationBillDetail.Discount; } this.transportationBillDetailMgr.UpdateTransportationBillDetail(oldTransportationBillDetail); } } #endregion oldTransportationBill.LastModifyUser = user; oldTransportationBill.LastModifyDate = DateTime.Now; this.UpdateTransportationBill(oldTransportationBill); }
public void ReleaseTransportationBill(TransportationBill transportationBill, User user) { this.ReleaseTransportationBill(transportationBill.BillNo, user); }
public void CloseTransportationBill(TransportationBill transportationBill, string userCode) { this.CloseTransportationBill(transportationBill.BillNo, this.userMgr.CheckAndLoadUser(userCode)); }
public void CancelTransportationBill(TransportationBill transportationBill, User user) { this.CancelTransportationBill(transportationBill.BillNo, user); }
public virtual void UpdateTransportationBill(TransportationBill entity) { Update(entity); }
/// <summary> /// 金董春:添加打印功能,添加了TransportationBill.xls模板打印功能 2012-5-28 /// </summary> /// <param name="list"></param> /// <returns></returns> public string WriteToFile(IList <object> list) { string path = Server.MapPath(".") + @"\Reports\Templates\YFKExcelTemplates\TransportationBill.xls"; if (File.Exists(path)) { TransportationBill tb = (TransportationBill)list[0]; string filename = @"/Reports/Templates/TempFiles/temp_" + DateTime.Now.ToString("yyyyMMddhhmmss") + tb.BillNo + ".xls"; string _wpath = Server.MapPath(".") + filename; File.Copy(path, _wpath); FileStream file = new FileStream(_wpath, FileMode.Open, FileAccess.ReadWrite, FileShare.Read); HSSFWorkbook hssfworkbook = new HSSFWorkbook(file); Sheet sheet = hssfworkbook.GetSheet("sheet1"); NPOI.SS.UserModel.CellStyle normalStyle = setCellstyle(hssfworkbook, new string[] { "Border", "Center" }); NPOI.SS.UserModel.CellStyle dateStyle = setCellstyle(hssfworkbook, new string[] { "Border", "Center", "DateTime" }); Cell cell = sheet.GetRow(2).GetCell(1); cell.SetCellValue(tb.BillNo); cell = sheet.GetRow(2).GetCell(6); cell.SetCellValue(tb.ReferenceBillNo); cell = sheet.GetRow(3).GetCell(1); cell.SetCellValue(tb.Status); int i = 10; decimal cnt = 0; foreach (TransportationBillDetail tbd in tb.TransportationBillDetails) { Row row = sheet.CreateRow(i); TransportationOrder tord = TheTransportationOrderMgr.LoadTransportationOrder(tbd.ActBill.OrderNo); row.CreateCell(0).SetCellValue(tord.CreateDate); //运输日期 row.CreateCell(1).SetCellValue(tord.TransportationRoute != null ? tord.TransportationRoute.Description : ""); //运输路线 row.CreateCell(2).SetCellValue(tbd.ActBill.PricingMethod != null ? tbd.ActBill.PricingMethod : ""); //运输形式 row.CreateCell(3).SetCellValue(tord.OrderNo); //运单号码 row.CreateCell(4).SetCellValue(tbd.ActBill.EffectiveDate); //生效日期 row.CreateCell(5).SetCellValue(tbd.ActBill.UnitPrice.ToString("F2")); //单价 row.CreateCell(6).SetCellValue(tbd.ActBill.Currency.Name); //币种 row.CreateCell(7).SetCellValue(tbd.ActBill.BillQty.ToString("F0")); //开票数 row.CreateCell(8).SetCellValue(tbd.ActBill.BillAmount.ToString("F2")); //金额 cnt = Convert.ToInt32(tbd.ActBill.BillAmount) + cnt; for (int y = 0; y < 9; y++) { row.GetCell(y).CellStyle = normalStyle; } row.GetCell(0).CellStyle = dateStyle; row.GetCell(4).CellStyle = dateStyle; i++; } if (i <= 20) { for (int j = i; j < 21; j++) { Row row = sheet.CreateRow(j); for (int y = 0; y < 9; y++) { row.CreateCell(y).CellStyle = normalStyle; } } i = 20; } Row _row = sheet.CreateRow(i + 1); sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(i + 1, i + 1, 6, 7)); _row.CreateCell(6).SetCellValue("合计发票金额:"); _row.GetCell(6).CellStyle.Alignment = HorizontalAlignment.RIGHT; _row.CreateCell(8).SetCellValue(cnt.ToString("F2")); MemoryStream ms = new MemoryStream(); hssfworkbook.Write(ms); // Response.AddHeader("Content-Disposition", string.Format("attachment;filename=TempWorkBook.xls")); // Response.BinaryWrite(ms.ToArray());Reports/Templates/TempFiles FileStream f = new FileStream(_wpath, FileMode.Open, FileAccess.Write); byte[] data = ms.ToArray(); f.Write(data, 0, data.Length); f.Close(); f.Dispose(); hssfworkbook = null; ms.Close(); ms.Dispose(); return("http://" + Request.Url.Authority + filename); } return(""); }
public TransportationBill VoidTransportationBill(string billNo, User user) { TransportationBill oldTransportationBill = this.CheckAndLoadTransportationBill(billNo, true); DateTime dateTimeNow = DateTime.Now; #region 检查状态 if (oldTransportationBill.Status != BusinessConstants.CODE_MASTER_STATUS_VALUE_CLOSE) { throw new BusinessErrorException("TransportationBill.Error.StatusErrorWhenVoid", oldTransportationBill.Status, oldTransportationBill.BillNo); } #endregion #region 创建作废账单 TransportationBill voidTransportationBill = new TransportationBill(); CloneHelper.CopyProperty(oldTransportationBill, voidTransportationBill, this.TransportationBillCloneField); voidTransportationBill.BillNo = this.numberControlMgr.GenerateNumber(BusinessConstants.CODE_PREFIX_TRANSPORTATIONBILL_RED); voidTransportationBill.Status = BusinessConstants.CODE_MASTER_STATUS_VALUE_CLOSE; if (oldTransportationBill.Discount.HasValue) { voidTransportationBill.Discount = 0 - oldTransportationBill.Discount.Value; } voidTransportationBill.ReferenceBillNo = oldTransportationBill.BillNo; voidTransportationBill.BillType = BusinessConstants.CODE_TRANSPORTATION_TRANSPORTATIONBILL_TYPE_VALUE_CANCEL; voidTransportationBill.CreateDate = dateTimeNow; voidTransportationBill.CreateUser = user; voidTransportationBill.LastModifyDate = dateTimeNow; voidTransportationBill.LastModifyUser = user; this.CreateTransportationBill(voidTransportationBill); #endregion #region 创建作废账单明细 foreach (TransportationBillDetail oldTransportationBillDetail in oldTransportationBill.TransportationBillDetails) { TransportationBillDetail voidTransportationBillDetail = new TransportationBillDetail(); CloneHelper.CopyProperty(oldTransportationBillDetail, voidTransportationBillDetail, this.TransportationBillDetailCloneField); voidTransportationBillDetail.BilledQty = 0 - oldTransportationBillDetail.BilledQty; voidTransportationBillDetail.Discount = 0 - oldTransportationBillDetail.Discount; voidTransportationBillDetail.Amount = 0 - oldTransportationBillDetail.Amount; voidTransportationBillDetail.Bill = voidTransportationBill; this.transportationBillDetailMgr.CreateTransportationBillDetail(voidTransportationBillDetail); voidTransportationBill.AddTransportationBillDetail(voidTransportationBillDetail); //反向更新TransportationActBill this.transportationActBillMgr.ReverseUpdateTransportationActBill(null, voidTransportationBillDetail, user); } #endregion #region 记录开票事务 /*20110422 Tag 先做标记,后期补充 * foreach (TransportationBillDetail transportationBillDetail in oldTransportationBill.TransportationBillDetails) * { * this.billTransactionMgr.RecordBillTransaction(transportationBillDetail, user, true); * } */ #endregion #region 更新原账单 oldTransportationBill.ReferenceBillNo = voidTransportationBill.BillNo; oldTransportationBill.Status = BusinessConstants.CODE_MASTER_STATUS_VALUE_VOID; oldTransportationBill.LastModifyDate = dateTimeNow; oldTransportationBill.LastModifyUser = user; this.UpdateTransportationBill(oldTransportationBill); #endregion return(voidTransportationBill); }
public virtual void CreateTransportationBill(TransportationBill entity) { Create(entity); }
public TransportationBill VoidTransportationBill(TransportationBill transportationBill, string userCode) { return(this.VoidTransportationBill(transportationBill.BillNo, this.userMgr.CheckAndLoadUser(userCode))); }
public virtual void DeleteTransportationBill(TransportationBill entity) { Delete(entity); }
public TransportationBill VoidTransportationBill(TransportationBill transportationBill, User user) { return(this.VoidTransportationBill(transportationBill.BillNo, user)); }