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 UpdateTransportationBill(TransportationBill transportationBill, string userCode)
{
this.UpdateTransportationBill(transportationBill, this.userMgr.CheckAndLoadUser(userCode));
}
public void ReleaseTransportationBill(TransportationBill transportationBill, User user)
{
this.ReleaseTransportationBill(transportationBill.BillNo, user);
}
public void ReleaseTransportationBill(TransportationBill transportationBill, string userCode)
{
this.ReleaseTransportationBill(transportationBill.BillNo, this.userMgr.CheckAndLoadUser(userCode));
}
public void DeleteTransportationBill(TransportationBill transportationBill, User user)
{
this.DeleteTransportationBill(transportationBill.BillNo, user);
}
public IList<TransportationBill> CreateTransportationBill(IList<TransportationActBill> transportationActBillList, User user, string status, decimal discount)
{
if (status != BusinessConstants.CODE_MASTER_STATUS_VALUE_CREATE
&& status != BusinessConstants.CODE_MASTER_STATUS_VALUE_SUBMIT
&& status != BusinessConstants.CODE_MASTER_STATUS_VALUE_CLOSE)
{
throw new TechnicalException("status specified is not valided");
}
if (transportationActBillList == null || transportationActBillList.Count == 0)
{
throw new BusinessErrorException("TransportationBill.Error.EmptyBillDetails");
}
DateTime dateTimeNow = DateTime.Now;
IList<TransportationBill> transportationBillList = new List<TransportationBill>();
foreach (TransportationActBill transportationActBill in transportationActBillList)
{
TransportationActBill oldTransportationActBill = this.transportationActBillMgr.LoadTransportationActBill(transportationActBill.Id);
oldTransportationActBill.CurrentBillQty = transportationActBill.CurrentBillQty;
oldTransportationActBill.CurrentBillAmount = transportationActBill.CurrentBillAmount;
oldTransportationActBill.CurrentDiscount = transportationActBill.CurrentDiscount;
TransportationBill transportationBill = null;
#region ���Һʹ�����ϸ��billAddress��currencyһ�µ�TransportationBillMstr
foreach (TransportationBill thisTransportationBill in transportationBillList)
{
if (thisTransportationBill.BillAddress.Code == oldTransportationActBill.BillAddress.Code
&& thisTransportationBill.Currency.Code == oldTransportationActBill.Currency.Code)
{
transportationBill = thisTransportationBill;
break;
}
}
#endregion
#region û���ҵ�ƥ���TransportationBill���½�
if (transportationBill == null)
{
#region ���Ȩ��
bool hasPermission = false;
foreach (Permission permission in user.OrganizationPermission)
{
if (permission.Code == oldTransportationActBill.BillAddress.Party.Code)
{
hasPermission = true;
break;
}
}
if (!hasPermission)
{
throw new BusinessErrorException("TransportationBill.Create.Error.NoAuthrization", oldTransportationActBill.BillAddress.Party.Code);
}
#endregion
#region ����TransportationBill
transportationBill = new TransportationBill();
transportationBill.BillNo = numberControlMgr.GenerateNumber(BusinessConstants.CODE_PREFIX_TRANSPORTATIONBILL);
transportationBill.Status = status;
transportationBill.BillAddress = oldTransportationActBill.BillAddress;
transportationBill.Currency = oldTransportationActBill.Currency;
transportationBill.Discount = discount; //����������
transportationBill.BillType = BusinessConstants.CODE_TRANSPORTATION_TRANSPORTATIONBILL_TYPE_VALUE_NORMAL;
transportationBill.CreateDate = dateTimeNow;
transportationBill.CreateUser = user;
transportationBill.LastModifyDate = dateTimeNow;
transportationBill.LastModifyUser = user;
this.CreateTransportationBill(transportationBill);
transportationBillList.Add(transportationBill);
#endregion
}
#endregion
TransportationBillDetail transportationBillDetail = this.transportationBillDetailMgr.TransferTransportationActBill2TransportationBillDetail(oldTransportationActBill);
transportationBillDetail.Bill = transportationBill;
transportationBill.AddTransportationBillDetail(transportationBillDetail);
this.transportationBillDetailMgr.CreateTransportationBillDetail(transportationBillDetail);
//�ۼ�TransportationActBill�����ͽ��
this.transportationActBillMgr.ReverseUpdateTransportationActBill(null, transportationBillDetail, user);
}
return transportationBillList;
}
public object getExcel(TransportationBill tb, IList<TransportationBillDetail> detailList, bool isExportExcel)
{
string path = Server.MapPath(".") + @"\Reports\Templates\YFKExcelTemplates\TransportationBill.xls";
if (File.Exists(path))
{
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(8).GetCell(2);
cell.SetCellValue(tb.BillAddress.Party.Name);
cell = sheet.GetRow(8).GetCell(8);
cell.SetCellValue(tb.BillNo);
int i = 10;
decimal cnt = 0;
foreach (TransportationBillDetail tbd in detailList)
{
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);
if (!isExportExcel)
{
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;
}
else
{
Response.AddHeader("Content-Disposition", string.Format("attachment;filename=TBillResult.xls"));
Response.BinaryWrite(ms.ToArray());
hssfworkbook = null;
ms.Close();
ms.Dispose();
return null;
}
}
else
return null;
}
public TransportationBill VoidTransportationBill(TransportationBill transportationBill, string userCode)
{
return this.VoidTransportationBill(transportationBill.BillNo, this.userMgr.CheckAndLoadUser(userCode));
}
public void AddTransportationBillDetail(TransportationBill transportationBill, IList<TransportationActBill> transportationActBillList, User user)
{
this.AddTransportationBillDetail(transportationBill.BillNo, transportationActBillList, user);
}
public void AddTransportationBillDetail(TransportationBill transportationBill, IList<TransportationActBill> transportationActBillList, string userCode)
{
this.AddTransportationBillDetail(transportationBill.BillNo, transportationActBillList, this.userMgr.CheckAndLoadUser(userCode));
}
public virtual void UpdateTransportationBill(TransportationBill entity)
{
entityDao.UpdateTransportationBill(entity);
}
public virtual void DeleteTransportationBill(TransportationBill entity)
{
entityDao.DeleteTransportationBill(entity);
}
public virtual void CreateTransportationBill(TransportationBill entity)
{
entityDao.CreateTransportationBill(entity);
}
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 CancelTransportationBill(TransportationBill transportationBill, User user)
{
this.CancelTransportationBill(transportationBill.BillNo, user);
}
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 void CloseTransportationBill(TransportationBill transportationBill, User user)
{
this.CloseTransportationBill(transportationBill.BillNo, user);
}
public TransportationBill VoidTransportationBill(TransportationBill transportationBill, User user)
{
return this.VoidTransportationBill(transportationBill.BillNo, user);
}
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);
}
