public ActionResult Create(WMS_CustomerModel vm)
{
IEnumerable <SelectListItem> cuslist = ApplicationConfigHelper.GetProjectUserCustomers(base.UserInfo.ProjectID, base.UserInfo.ID).Where(c => c.State && (c.StoreType == 2 || c.StoreType == 3))
.Select(c => new SelectListItem()
{
Value = c.CustomerID.ToString(), Text = c.CustomerName
});
WMS_CustomerService service = new WMS_CustomerService();
vm.StorerID = cuslist;
IList <WMS_Customer> customer = new List <WMS_Customer>();
//var segments = new SegmentService().GetSegmentsByCondition(new GetSegmentsByConditionRequest() { Name = "", State = true }).Result;
//vm.Segments = segments.Select(s => new SelectListItem() { Value = s.ID.ToString(), Text = s.Name + "------>>详情>>" + s.Description });
//vm.Types = vm.StoreStatus > 0 ? 1 : 0;
customer.Add(vm.Convert());
Response <IEnumerable <WMS_Customer> > response = service.AddCustomer(new AddWMS_CustomerRequest()
{
customers = customer
});
{
WMS_Customer cus = service.selectCustomer(vm.StorerKey, vm.CustomerID.ToString());
vm.ConvertDesc(cus);
if (response.IsSuccess)
{
//刷新缓存
//ApplicationConfigHelper.RefreshApplicationWMS_Customers();
//ApplicationConfigHelper.RefreshGetApplicationWMS_Customer();
vm.ViewType = 0;
ViewBag.Message = "0";
}
return(View(vm));
}
}
public string ExeclStorer(int StorerID)
{
if (Request.Files.Count > 0)
{
HttpPostedFileBase hpf = Request.Files[0] as HttpPostedFileBase;
if (hpf.ContentLength > 0)
{
//DataSet ds = this.GetDataFromExcel(hpf);
DataSet ds = EPPlusOperation.ReadExcelToDataSet(hpf);
IList <WMS_Customer> Info = new List <WMS_Customer>();
if (ds != null && ds.Tables[0] != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Info.Add(new WMS_Customer()
{
StorerKey = ds.Tables[0].Rows[i]["StorerKey"].ToString().Trim(),
Active = true,//1
Status = ds.Tables[0].Rows[i]["状态"].ToString().Trim(),
Company = ds.Tables[0].Rows[i]["店铺名称"].ToString().Trim(),
ReceiptPrefix = "",
OrderPrefix = "",
CompanyCode = ds.Tables[0].Rows[i]["SAP代码"].ToString().Trim(),
Type = ds.Tables[0].Rows[i]["类型"].ToString().Trim(),//SELLER
AddressLine1 = ds.Tables[0].Rows[i]["地址1"].ToString().Trim(),
AddressLine2 = ds.Tables[0].Rows[i]["地址2"].ToString().Trim(),
AddressLine3 = ds.Tables[0].Rows[i]["地址3"].ToString().Trim(),
AddressLine4 = ds.Tables[0].Rows[i]["地址4"].ToString().Trim(),
City = ds.Tables[0].Rows[i]["城市"].ToString().Trim(),
State = ds.Tables[0].Rows[i]["州"].ToString().Trim(),
PostCode = ds.Tables[0].Rows[i]["邮编"].ToString().Trim(),
Country = ds.Tables[0].Rows[i]["国家"].ToString().Trim(),
CountryCode = ds.Tables[0].Rows[i]["国家代码"].ToString().Trim(),//CN
Contact1 = ds.Tables[0].Rows[i]["联系人1"].ToString().Trim(),
Contact2 = ds.Tables[0].Rows[i]["联系人2"].ToString().Trim(),
PhoneNum1 = ds.Tables[0].Rows[i]["联系电话1"].ToString().Trim(),
PhoneNum2 = ds.Tables[0].Rows[i]["联系电话2"].ToString().Trim(),
FaxNum1 = ds.Tables[0].Rows[i]["传真1"].ToString().Trim(),
FaxNum2 = ds.Tables[0].Rows[i]["传真2"].ToString().Trim(),
Email1 = ds.Tables[0].Rows[i]["邮箱1"].ToString().Trim(),
Email2 = ds.Tables[0].Rows[i]["邮箱2"].ToString().Trim(),
TriggerDog = false,//0
CreateUser = ds.Tables[0].Rows[i]["创建人"].ToString().Trim(),
CreateDate = DateTime.Now,
UpdateUser = ds.Tables[0].Rows[i]["更新人"].ToString().Trim(),
UpdateDate = DateTime.Now,
CustomerID = StorerID
});
}
}
var groupedInfos = from g in Info
select new WMS_Customer()
{
StorerKey = g.StorerKey,
Active = g.Active,
Status = g.Status,
Company = g.Company,
ReceiptPrefix = g.ReceiptPrefix,
OrderPrefix = g.OrderPrefix,
CompanyCode = g.CompanyCode,
Type = g.Type,
AddressLine1 = g.AddressLine1,
AddressLine2 = g.AddressLine2,
AddressLine3 = g.AddressLine3,
AddressLine4 = g.AddressLine3,
City = g.City,
State = g.State,
PostCode = g.PostCode,
Country = g.Country,
CountryCode = g.CountryCode,
Contact1 = g.Contact1,
Contact2 = g.Contact2,
PhoneNum1 = g.PhoneNum1,
PhoneNum2 = g.PhoneNum2,
FaxNum1 = g.FaxNum1,
FaxNum2 = g.FaxNum2,
Email1 = g.Email1,
Email2 = g.Email2,
TriggerDog = g.TriggerDog,
CreateUser = g.CreateUser,
CreateDate = g.CreateDate,
UpdateUser = g.UpdateUser,
UpdateDate = g.UpdateDate,
CustomerID = g.CustomerID
};
var repeat = groupedInfos.GroupBy(a => a.StorerKey).Where(g => g.Count() >= 2);
if (repeat.Count() > 0)
{
return(new { result = "有重复店铺！", IsSuccess = false }.ToJsonString());
}
WMS_CustomerService service = new WMS_CustomerService();
Response <IEnumerable <WMS_Customer> > response = service.AddCustomer(new AddWMS_CustomerRequest()
{
customers = groupedInfos
});
if (response.IsSuccess)
{
if (response.Result.Count() > 0)
{
//ApplicationConfigHelper.RefreshGetProductStorerList(StorerID.ToString());
return(new { result = "导入成功！", IsSuccess = true }.ToJsonString());
}
else
{
return(new { result = "<h3>导入失败!</h3><br/>excel内容有误！", IsSuccess = false }.ToString());
}
}
return(new { result = "<h3>导入失败!</h3><br/>excel内容有误！", IsSuccess = false }.ToString());
}
return(new { result = "文件内容为空", IsSuccess = false }.ToString());
}
return(new { result = "请选择文件", IsSuccess = false }.ToString());
}
