{
var projectName = WMModelManager.ProjectDAO.RetrieveInstance(item.ProjectID).ProjectName;
var projectConfig = WMModelManager.ProjectConfigDAO.RetrieveInstance(item.ProjectConfigID).ConfigName;
xmlDetail += string.Format(xmlDetailTemplate
, rowNo
, CommonFunction.FilterXMLStr("")
, CommonFunction.FilterXMLStr(item.Order.OrderNumber)
, CommonFunction.FilterXMLStr(item.CustomerProject)
, CommonFunction.FilterXMLStr(projectName)
, CommonFunction.FilterXMLStr(item.Order.CreateDate.ToString("yyyy-MM-dd"))
, CommonFunction.FilterXMLStr(item.Order.PlanDeliveryDate.ToString("yyyy-MM-dd"))
, CommonFunction.FilterXMLStr(item.Quantity.ToString("n0"))
, CommonFunction.FilterXMLStr(item.Quantity.ToString("n0"))
, CommonFunction.FilterXMLStr(item.Remark));
rowNo++;
totalAmount += item.Quantity * item.Price;
}
var dataList = from item in customerInfoList
select new
{
CustomerID = item.CustomerID,
CustomerCode = item.CustomerCode,
CustomerName = item.CustomerName,
SalesMan = item.SalesMan,
OrderQuantity = WMCommonHelper.GetOrderQuantityByCustomerID(item.CustomerID, WMOrderTypeEnum.MachineOrder).ToString("n0")
+ "+" + WMCommonHelper.GetOrderQuantityByCustomerID(item.CustomerID, WMOrderTypeEnum.MaterialOrder).ToString("n0"),
UnPayedOrder = WMCommonHelper.GetUnpayedQuantityByCustomerID(item.CustomerID, WMOrderTypeEnum.MachineOrder).ToString("n0")
+ "+" + WMCommonHelper.GetUnpayedQuantityByCustomerID(item.CustomerID, WMOrderTypeEnum.MaterialOrder).ToString("n0"),
USDAmount = item.USDAmount,
RMBAmount = item.RMBAmount
};