public void ExportRetailOrderListTest()
{
/*NameValueCollection nvc = new NameValueCollection();
* nvc.Add("dealerCode", "2250010");
* nvc.Add("regionCode", "2256666");
* nvc.Add("startIndex", "0");
* nvc.Add("pageSize", "3");
* nvc.Add("startDateCreate", "2017-09-01");
* nvc.Add("endDateCreate", "2017-09-21");
* nvc.Add("remark", "Y");
* byte[] result = retailQueryService.ExportRetailOrderList(nvc);*/
IDictionary <string, string> salesPersonDic = RetailCache.GetSalesPersonDic();
}
public PageResult <RetailOrderQueryListVo> QueryRetailOrderList(QueryCriteria queryCriteria)
{
PageResult <RetailOrderQueryListVo> result = doFindRetailOrderByCondition(queryCriteria);
if (result.Content.Count > 0)
{
IDictionary <string, ModelGroup> modelGroupDic = ProductCache.GetModelGroupDic();
foreach (var item in result.Content)
{
string key = item.ModelCode + item.Interior + item.PrList;
if (modelGroupDic.ContainsKey(key))
{
item.ModelYear = modelGroupDic[key].ModelYear.ToString();
item.ModelVersion = modelGroupDic[key].ModelVersion;
item.PrList = modelGroupDic[key].PrList;
}
else
{
item.ModelYear = "数据错误";
item.ModelVersion = "数据错误";
item.PrList = item.PrList + "数据错误";
}
IDictionary <string, string> colorDic = ProductCache.GetColorDic();
if ((item.Color != null) && colorDic.ContainsKey(item.Color))
{
item.Color = item.Color + "(" + item.Color1 + ")" + '-' + colorDic[item.Color];
}
else
{
item.Color = item.Color + "(" + item.Color1 + ")";
}
item.SalesSource = RetailCache.GetSalesSource(item.SalesSource);
item.OrderStatus = RetailCache.GetOrderStatus(item.OrderStatus);
item.Accessory = RetailCache.GetYesNo(item.Accessory);
item.Club = RetailCache.GetYesNo(item.Club);
}
}
return(result);
}
public byte[] ExportRetailOrderList(NameValueCollection queryString)
{
List <RetailOrderQueryExportVo> list = doFindRetailOrderByCondition(queryString);
foreach (var item in list)
{
IDictionary <string, string> regionDic = CommonCache.GetRegionDic();
if (item.Region != null && regionDic.ContainsKey(item.Region))
{
item.Region = regionDic[item.Region];
}
IDictionary <string, Dealer> dealerDic = SystemCache.GetDealerDic();
if (item.DealerCode != null && dealerDic.ContainsKey(item.DealerCode))
{
item.DealerName = dealerDic[item.DealerCode].DealerName;
item.NetCode = dealerDic[item.DealerCode].NetCode;
}
IDictionary <string, string> seriesDic = ProductCache.GetSeriesDic();
if (item.Series != null && seriesDic.ContainsKey(item.Series))
{
item.Series = seriesDic[item.Series];
}
IDictionary <string, ModelGroup> modelGroupDic = ProductCache.GetModelGroupDic();
string key = item.ModelCode + item.InteriorCode + item.PrList;
if (modelGroupDic.ContainsKey(key))
{
item.ModelYear = modelGroupDic[key].ModelYear.ToString();
item.ModelVersion = modelGroupDic[key].ModelVersion;
item.PrList = modelGroupDic[key].PrList;
}
IDictionary <string, Model> modelDic = ProductCache.GetModelDic();
if (item.ModelCode != null && modelDic.ContainsKey(item.ModelCode))
{
item.ModelName = modelDic[item.ModelCode].ModelName;
}
IDictionary <string, string> colorDic = ProductCache.GetColorDic();
if (item.ColorCode != null && colorDic.ContainsKey(item.ColorCode))
{
item.ColorName = colorDic[item.ColorCode];
}
IDictionary <string, string> interiorDic = ProductCache.GetInteriorDic();
if (item.InteriorCode != null && interiorDic.ContainsKey(item.InteriorCode))
{
item.InteriorName = interiorDic[item.InteriorCode];
}
IDictionary <string, County> countyDic = CommonCache.GetCountyDic();
if (item.County != null && countyDic.ContainsKey(item.County))
{
item.Provice = countyDic[item.County].ProvinceName;
item.City = countyDic[item.County].CityName;
item.County = countyDic[item.County].CountyName;
}
IDictionary <string, string> salesPersonDic = RetailCache.GetSalesPersonDic();
if (item.SalesPerson != null && salesPersonDic.ContainsKey(item.SalesPerson))
{
item.SalesPerson = salesPersonDic[item.SalesPerson];
}
IDictionary <string, string> insuranceCompanyDic = RetailCache.GetInsuranceCompanyDic();
if (item.InsuranceCompany != null && insuranceCompanyDic.ContainsKey(item.InsuranceCompany))
{
item.InsuranceCompany = insuranceCompanyDic[item.InsuranceCompany];
}
item.Gender = RetailCache.GetGender(item.Gender);
item.InvoiceType = RetailCache.GetInvoiceType(item.InvoiceType);
item.CustomerType = RetailCache.GetCustomerType(item.CustomerType);
item.VehiclePurpose = RetailCache.GetVehiclePurpose(item.VehiclePurpose);
item.CertificateType = RetailCache.GetVehiclePurpose(item.CertificateType);
item.Duty = RetailCache.GetVehiclePurpose(item.Duty);
item.CompanyProperty = RetailCache.GetVehiclePurpose(item.CompanyProperty);
item.CompanyIndustry = RetailCache.GetVehiclePurpose(item.CompanyIndustry);
item.SalesType = RetailCache.GetVehiclePurpose(item.SalesType);
item.SalesSource = RetailCache.GetSalesSource(item.SalesSource);
item.OutStockStatus = RetailCache.GetOutStockStatus(item.OutStockStatus);
item.OrderStatus = RetailCache.GetOrderStatus(item.OrderStatus);
item.Accessory = RetailCache.GetYesNo(item.Accessory);
item.PaymentType = RetailCache.GetPaymentType(item.PaymentType);
item.UsedCar = RetailCache.GetYesNo(item.UsedCar);
item.LongStorage = RetailCache.GetYesNo(item.LongStorage);
item.Club = RetailCache.GetYesNo(item.Club);
item.ThreeGuarantees = RetailCache.GetYesNo(item.ThreeGuarantees);
}
StringBuilder sb = new StringBuilder();
sb.Append("零售订单号码,分销中心,经销商代码,经销商名称,网络代码,登记日期,登记时间,零售日期,零售时间,发票号码,车辆代码,车辆名称,");
sb.Append("颜色代码,颜色名称,内饰,内饰名称,车型年,版本号,选装包,销售类型,车型分类,零售单价,用户名称,联系人,性别,省市,地极市,县,");
sb.Append("联系地址,邮政编码,车辆用途,发票类型,客户类别,公司性质,职务,电话号码,手机号码,电子邮件,证件类型,证件号码,从事行业,");
sb.Append("销售员,销售来源,配车处理,操作日期,订单状态,发动机号,VIN,零售数量,作废日期,出库日期,备注,礼品类型,发票日期,");
sb.Append("是否装配原装附件包,车主,被保险人,保险公司,保险单,保险起始日期,保险终止日期,支付方式,金融机构,贷款类型,支付备注,");
sb.Append("二手车置换,长库龄车,加入会员俱乐部,三包车辆,网外二网名称");
sb.AppendLine();
foreach (var item in list)
{
sb.Append(item.OrderNo + ",");
sb.Append(item.Region + ",");
sb.Append(item.DealerCode + ",");
sb.Append(item.DealerName + ",");
sb.Append(item.NetCode + ",");
sb.Append(item.CreateDate + ",");
sb.Append(item.CreateTime + ",");
sb.Append(item.RetailDate + ",");
sb.Append(item.RetailTime + ",");
sb.Append(item.InvoiceNo + ",");
sb.Append(item.ModelCode + ",");
sb.Append(item.ModelName + ",");
sb.Append(item.ColorCode + ",");
sb.Append(item.ColorName + ",");
sb.Append(item.InteriorCode + ",");
sb.Append(item.InteriorName + ",");
sb.Append(item.ModelYear + ",");
sb.Append(item.ModelVersion + ",");
sb.Append(item.PrList + ",");
sb.Append(item.SalesType + ",");
sb.Append(item.Series + ",");
sb.Append(item.Price + ",");
sb.Append(FileHelper.FilterSpecialChar(item.CustomerName) + ",");
sb.Append(FileHelper.FilterSpecialChar(item.Contact) + ",");
sb.Append(item.Gender + ",");
sb.Append(item.Provice + ",");
sb.Append(item.City + ",");
sb.Append(item.County + ",");
sb.Append(FileHelper.FilterSpecialChar(item.Address) + ",");
sb.Append(FileHelper.FilterSpecialChar(item.ZipCode) + ",");
sb.Append(item.VehiclePurpose + ",");
sb.Append(item.InvoiceType + ",");
sb.Append(item.CustomerType + ",");
sb.Append(item.CompanyProperty + ",");
sb.Append(item.Duty + ",");
sb.Append(FileHelper.FilterSpecialChar(item.Telephone) + ",");
sb.Append(FileHelper.FilterSpecialChar(item.Mobile) + ",");
sb.Append(FileHelper.FilterSpecialChar(item.Email) + ",");
sb.Append(item.CertificateType + ",");
sb.Append(FileHelper.FilterSpecialChar(item.CertificateNo) + ",");
sb.Append(item.CompanyIndustry + ",");
sb.Append(FileHelper.FilterSpecialChar(item.SalesPerson) + ",");
sb.Append(item.SalesSource + ",");
sb.Append(item.OutStockStatus + ",");
sb.Append(item.MatchedDate + ",");
sb.Append(item.OrderStatus + ",");
sb.Append(item.EngineNo + ",");
sb.Append(item.Vin + ",");
sb.Append(item.Quantity + ",");
sb.Append(item.DeleteDate + ",");
sb.Append(item.OutStockDate + ",");
sb.Append(FileHelper.FilterSpecialChar(item.Remark) + ",");
sb.Append(item.Prize + ",");
sb.Append(item.InvoiceDate + ",");
sb.Append(item.Accessory + ",");
sb.Append(FileHelper.FilterSpecialChar(item.Owner) + ",");
sb.Append(FileHelper.FilterSpecialChar(item.Insured) + ",");
sb.Append(item.InsuranceCompany + ",");
sb.Append(item.InsuranceBillNo + ",");
sb.Append(item.InsuranceBeginDate + ",");
sb.Append(item.InsuranceEndDate + ",");
sb.Append(item.PaymentType + ",");
sb.Append(item.FinancialInstitution + ",");
sb.Append(item.LoanType + ",");
sb.Append(FileHelper.FilterSpecialChar(item.PaymentRemark) + ",");
sb.Append(item.UsedCar + ",");
sb.Append(item.LongStorage + ",");
sb.Append(item.Club + ",");
sb.Append(item.ThreeGuarantees + ",");
sb.Append(item.OutSource + ",");
sb.AppendLine();
}
return(FileHelper.CsvFormat(sb));
}
public RetailOrderQueryDetailsVo QueryRetailOrderDetails(string orderNo, string remarkFlag)
{
RetailOrderQueryDetailsVo result = doFindRetailOrderById(orderNo, remarkFlag);
if (result != null)
{
IDictionary <string, ModelGroup> modelGroupDic = ProductCache.GetModelGroupDic();
string key = result.Model + result.Interior + result.PrList;
if (modelGroupDic.ContainsKey(key))
{
result.ModelYear = modelGroupDic[key].ModelYear.ToString();
result.ModelVersion = modelGroupDic[key].ModelVersion;
result.PrList = modelGroupDic[key].PrList;
}
else
{
result.ModelYear = "数据错误";
result.ModelVersion = "数据错误";
result.PrList = result.PrList + "数据错误";
}
IDictionary <string, Model> modelDic = ProductCache.GetModelDic();
if (result.Model != null && modelDic.ContainsKey(result.Model))
{
result.Model = result.Model + "-" + modelDic[result.Model].ModelName;
}
else
{
result.Model = result.Model + "数据错误";
}
IDictionary <string, string> colorDic = ProductCache.GetColorDic();
if ((result.Color != null) && colorDic.ContainsKey(result.Color))
{
result.Color = result.Color + "(" + result.Color1 + ")" + '-' + colorDic[result.Color];
}
else
{
result.Color = result.Color + "(" + result.Color1 + ")";
}
IDictionary <string, string> interiorDic = ProductCache.GetInteriorDic();
if (result.Interior != null && interiorDic.ContainsKey(result.Interior))
{
result.Interior = result.Interior + '-' + interiorDic[result.Interior];
}
else
{
result.Interior = result.Interior + "数据错误";
}
IDictionary <string, County> countyDic = CommonCache.GetCountyDic();
if (result.County != null && countyDic.ContainsKey(result.County))
{
result.County = result.County + '-' + countyDic[result.County].ProvinceName + '-' + countyDic[result.County].CityName +
'-' + countyDic[result.County].CountyName;
}
else
{
result.County = result.County + "数据错误";
}
DealerStockVehicleInfo vehicleInfo = doFindDealerStockVehicleInfoById(result.Vin);
if (vehicleInfo != null)
{
result.VehicleInStockDate = vehicleInfo.VehicleInStockDate;
result.VehicleOutStockDate = vehicleInfo.VehicleOutStockDate;
result.EngineNo = vehicleInfo.EngineNo;
}
result.SalesSource = RetailCache.GetSalesSource(result.SalesSource);
result.OrderStatus = RetailCache.GetOrderStatus(result.OrderStatus);
result.Accessory = RetailCache.GetYesNo(result.Accessory);
result.Club = RetailCache.GetYesNo(result.Club);
result.Gender = RetailCache.GetGender(result.Gender);
result.InvoiceType = RetailCache.GetInvoiceType(result.InvoiceType);
result.VehiclePurpose = RetailCache.GetVehiclePurpose(result.VehiclePurpose);
result.CertificateType = RetailCache.GetVehiclePurpose(result.CertificateType);
result.Duty = RetailCache.GetVehiclePurpose(result.Duty);
result.CompanyProperty = RetailCache.GetVehiclePurpose(result.CompanyProperty);
result.CompanyIndustry = RetailCache.GetVehiclePurpose(result.CompanyIndustry);
result.SalesType = RetailCache.GetVehiclePurpose(result.SalesType);
result.UsePoint = RetailCache.GetYesNo(result.UsePoint);
result.ThreeGuarantees = RetailCache.GetYesNo(result.ThreeGuarantees);
result.CustomerType = RetailCache.GetCustomerType(result.CustomerType);
}
return(result);
}
