protected void btnUpload_Click(object sender, EventArgs e)
{
HSSFWorkbook excel = new HSSFWorkbook(fileUpload.PostedFile.InputStream);
Sheet sheet = excel.GetSheetAt(0);
IEnumerator rows = sheet.GetRowEnumerator();
ImportHelper.JumpRows(rows, 1);
IList <TransportationActBill> tactbillList = new List <TransportationActBill>();
IList <string> orderNos = new List <string>();
string supply = string.Empty;
while (rows.MoveNext())
{
Row curow = (HSSFRow)rows.Current;
string orderNo = curow.GetCell(0).StringCellValue;
// decimal cur = decimal.Parse(curow.GetCell(1).NumericCellValue.ToString());
if (string.IsNullOrEmpty(orderNo))
{
break;
}
else
{
if (orderNos.Contains(orderNo))
{
continue;//避免重复
}
else
{
orderNos.Add(orderNo);
}
}
}
string successMessage = "计价成功的单号：";
string errorMessage = "计价失败的单号：";
if (orderNos.Count > 0)
{
foreach (var orderNo in orderNos)
{
try
{
TheTransportationOrderMgr.ValuateTransportationOrder(orderNo, this.CurrentUser);
successMessage += orderNo + ",";
}
catch (Exception ex)
{
errorMessage += orderNo + ",";
}
}
ShowErrorMessage(successMessage + " </br> " + errorMessage);
}
else
{
ShowErrorMessage(" 导入的有效数据为0行！");
}
}
public void ValuateOrder(IList <TransportationOrder> transportationOrderList)
{
try
{
if (transportationOrderList != null && transportationOrderList.Count > 0)
{
TheTransportationOrderMgr.ValuateTransportationOrder(transportationOrderList, this.CurrentUser);
DoSearch();
ShowSuccessMessage("Transportation.TransportationOrder.ValuateTransportationOrder.Successfully");
}
}
catch (BusinessErrorException ex)
{
ShowErrorMessage(ex);
}
}
protected void btnValuate_Click(object sender, EventArgs e)
{
try
{
ds = needCaluate();
if (onlyWSNFlag == false)
{
TheTransportationOrderMgr.ValuateTransportationOrder(this.OrderNo, this.CurrentUser);
}
else
{
createTBill();
}
if (ds != null)//djin
{
Caluate();
}
ShowSuccessMessage("Transportation.TransportationOrder.ValuateTransportationOrder.Successfully", this.OrderNo);
if (ds != null)
{
Restore(ds);
}
UpdateView();
UpdateViewButton();
TransportationOrder to = TheTransportationOrderMgr.LoadTransportationOrder(OrderNo);
to.Status = "Close";
to.Remark = ((TextBox)(this.FV_Order.FindControl("tbRemark"))).Text.Trim();
to.IsValuated = true;
TheTransportationOrderMgr.UpdateTransportationOrder(to);
}
//BusinessErrorException
catch (BusinessErrorException ex)
{
Restore(ds);
ShowErrorMessage(ex);
}
}