/// <summary>
/// 根据ID获取站点信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public LogisticsSite GetLogisticsSiteById(string id = "")
{
var site = new LogisticsSite();
if (id != "")
{
site = _context.LogisticsSite.Where(p => p.Id == id && p.IsDeleted != 1).First();
}
return(site);
}
public ActionResult GetAllLogisticsSite(LogisticsSite site, int page = 1, int rows = 10)
{
if (site != null)
{
int count = 0;
var data = service.GetLogisticsSites(site, out count, page, rows);
if (count != 0)
{
return(Json(new { total = count, rows = data }));
}
}
return(View());
}
/// <summary>
/// 更新自提站点的信息
/// </summary>
/// <param name="site"></param>
/// <returns></returns>
public OpResult UpdateLogisticsSite(LogisticsSite site)
{
OpResult result = new OpResult();
try
{
var ishas = _context.LogisticsSite.Any(p => !p.Id.Equals(site.Id) && p.SiteProvince.Equals(site.SiteProvince) && p.SiteCity.Equals(site.SiteCity) && p.SiteArea.Equals(site.SiteArea) && p.SiteAddress.Equals(site.SiteAddress));
if (ishas)
{
result.Message = "添加失败：该地址站点已存在";
return(result);
}
if (site.IsDef == 1)
{
bool res = UpdateIsdef(site.SiteCity);
if (!res)
{
result.Successed = true;
result.Message = "更新失败：更改默认地址时失败";
return(result);
}
}
var data = _context.LogisticsSite.Where(p => p.Id == site.Id && p.IsDeleted != 1).First();
data.SiteCode = site.SiteCode;
data.SiteName = site.SiteName;
data.SiteProvince = site.SiteProvince;
data.SiteCity = site.SiteCity;
data.SiteArea = site.SiteArea;
data.SiteAddress = site.SiteAddress;
data.IsDef = site.IsDef;
data.Status = site.Status;
data.SiteProvince = site.SiteProvince;
var save = _context.SaveChanges();
if (save > 0)
{
result.Successed = true;
result.Message = "更新成功";
}
else
{
result.Successed = false;
result.Message = "更新失败";
}
}
catch (Exception e)
{
result.Successed = false;
result.Message = "更新失败：" + e.Message;
}
return(result);
}
public ActionResult SaveLogistics(LogisticsSite site)
{
OpResult result = new OpResult();
if (site.SiteName == null || site.SiteName.Trim() == "" || site.SiteAddress == null || site.SiteAddress.Trim() == "")
{
result.Successed = false;
result.Message = "站点信息不完整，保存失败！";
return(Json(result));
}
result = service.SaveLogisticsSite(site);
return(Json(result));
}
/// <summary>
/// 站点信息保存
/// </summary>
/// <param name="site"></param>
/// <returns></returns>
public OpResult SaveLogisticsSite(LogisticsSite site)
{
OpResult result = new OpResult();
var hasany = _context.LogisticsSite.Any(p => p.Id == site.Id && p.IsDeleted != 1);
if (hasany)
{
result = UpdateLogisticsSite(site);
}
else
{
result = CreateLogisticsSite(site);
}
return(result);
}
/// <summary>
/// 创建一个新的自提站点
/// </summary>
/// <param name="site"></param>
/// <returns></returns>
public OpResult CreateLogisticsSite(LogisticsSite site)
{
OpResult result = new OpResult();
result.Successed = false;
try
{
var ishas = _context.LogisticsSite.Any(p => p.SiteProvince.Equals(site.SiteProvince) && p.SiteCity.Equals(site.SiteCity) && p.SiteArea.Equals(site.SiteArea) && p.SiteAddress.Equals(site.SiteAddress));
if (ishas)
{
result.Message = "添加失败：该地址站点已存在";
return(result);
}
if (site.IsDef == 1)
{
bool res = UpdateIsdef(site.SiteCity);
if (!res)
{
result.Successed = true;
result.Message = "添加失败：更改默认地址时失败";
return(result);
}
}
site.Id = Guid.NewGuid().ToString().Replace("-", "").ToUpper();
_context.LogisticsSite.Add(site);
if (_context.SaveChanges() > 0)
{
result.Successed = true;
result.Message = "添加成功";
}
else
{
result.Message = "添加失败";
}
}
catch (Exception e)
{
result.Message = "添加失败:" + e.Message;
}
return(result);
}
/// <summary>
/// 根据条件获取站点信息
/// </summary>
/// <param name="site"></param>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <returns></returns>
public List <LogisticsSite> GetLogisticsSites(LogisticsSite site, out int count, int page = 1, int rows = 10)
{
if (site != null)
{
var data = _context.LogisticsSite.Where(p => p.IsDeleted != 1);
if (site.SiteCode != null)
{
data = data.Where(p => p.SiteCode == site.SiteCode);
}
if (site.SiteName != null)
{
data = data.Where(p => p.SiteName.Contains(site.SiteName));
}
if (site.SiteProvince != null)
{
data = data.Where(p => p.SiteProvince == site.SiteProvince);
}
if (site.SiteCity != null)
{
data = data.Where(p => p.SiteCity == site.SiteCity);
}
if (site.SiteArea != null)
{
data = data.Where(p => p.SiteArea == site.SiteArea);
}
if (site.SiteAddress != null)
{
data = data.Where(p => p.SiteAddress == site.SiteAddress);
}
page = page < 1 ? 1 : page;
var temp = data.OrderBy(p => p.SiteProvince).Skip((page - 1) * rows).Take(rows).ToList();
count = temp.Count();
if (temp != null)
{
return(temp.ToList());
}
}
count = 0;
return(new List <LogisticsSite>());
}
public LogisticsSiteVModel(string id)
{
this.LogisticsSiteVM = new LogisticsSite();
}
