public object GetDetails(int page, int rows, string DeliverLineCode, string CustomCode, string DeliverLineName, string DistCode, string DeliverOrder, string IsActive)
{
IQueryable <DeliverLine> deliverLineQuery = DeliverLineRepository.GetQueryable();
var deliverLine = deliverLineQuery.Where(c => c.DeliverLineCode.Contains(DeliverLineCode) &&
c.DeliverLineName.Contains(DeliverLineName) &&
c.IsActive.Contains(IsActive) &&
c.IsActive.Contains(IsActive));
if (!CustomCode.Equals(string.Empty))
{
deliverLine = deliverLine.Where(d => d.CustomCode == CustomCode);
}
if (!DistCode.Equals(string.Empty))
{
deliverLine = deliverLine.Where(d => d.DistCode == DistCode);
}
deliverLine = deliverLine.OrderBy(h => h.DeliverLineCode);
int total = deliverLine.Count();
deliverLine = deliverLine.Skip((page - 1) * rows).Take(rows);
var temp = deliverLine.ToArray().Select(c => new
{
DeliverLineCode = c.DeliverLineCode,
CustomCode = c.CustomCode,
DeliverLineName = c.DeliverLineName,
DistCode = c.DistCode,
DeliverOrder = c.DeliverOrder,
Description = c.Description,
IsActive = c.IsActive == "1" ? "可用" : "不可用",
UpdateTime = c.UpdateTime.ToString("yyyy-MM-dd HH:mm:ss")
});
return(new { total, rows = temp.ToArray() });
}
public bool Add(DeliverLine deliverLine, out string strResult)
{
strResult = string.Empty;
bool result = false;
var deliver_line = new DeliverLine();
if (deliverLine != null)
{
try
{
deliver_line.DeliverLineCode = deliverLine.DeliverLineCode;
deliver_line.CustomCode = deliverLine.CustomCode;
deliver_line.DeliverLineName = deliverLine.DeliverLineName;
deliver_line.DistCode = deliverLine.DistCode;
deliver_line.DeliverOrder = deliverLine.DeliverOrder;
deliver_line.Description = deliverLine.Description;
deliver_line.IsActive = deliverLine.IsActive;
deliver_line.UpdateTime = DateTime.Now;
DeliverLineRepository.Add(deliver_line);
DeliverLineRepository.SaveChanges();
result = true;
}
catch (Exception ex)
{
strResult = "原因：" + ex.InnerException;
}
}
return(result);
}
public bool Delete(string DeliverLineCode)
{
var deliver_Line = DeliverLineRepository.GetQueryable()
.FirstOrDefault(i => i.DeliverLineCode == DeliverLineCode);
if (DeliverLineCode != null)
{
DeliverLineRepository.Delete(deliver_Line);
DeliverLineRepository.SaveChanges();
}
else
{
return(false);
}
return(true);
}
public bool Edit(DeliverLine deliverLine, out string strResult)
{
strResult = string.Empty;
try
{
var deliver_line = DeliverLineRepository.GetQueryable().FirstOrDefault(i => i.DeliverLineCode == deliverLine.DeliverLineCode);
deliver_line.DeliverLineCode = deliverLine.DeliverLineCode;
deliver_line.CustomCode = deliverLine.CustomCode;
deliver_line.DeliverLineName = deliverLine.DeliverLineName;
deliver_line.DistCode = deliverLine.DistCode;
deliver_line.DeliverOrder = deliverLine.DeliverOrder;
deliver_line.Description = deliverLine.Description;
deliver_line.IsActive = deliverLine.IsActive;
deliver_line.UpdateTime = DateTime.Now;
DeliverLineRepository.SaveChanges();
return(true);
}
catch (Exception ex)
{
strResult = "原因：" + ex.InnerException;
return(false);
}
}
public bool DownDeliverLine(out string errorInfo)
{
errorInfo = string.Empty;
bool result = false;
try
{
var deliverLineCodes = DeliverLineRepository.GetQueryable().Where(d => d.DeliverLineCode == d.DeliverLineCode).Select(s => new { s.DeliverLineCode }).ToArray();
string deliverStrs = "";
for (int i = 0; i < deliverLineCodes.Length; i++)
{
deliverStrs += deliverLineCodes[i].DeliverLineCode + ",";
}
DeliverLine[] deliverLines = DeliverLineDownService.GetDeliverLine(deliverStrs);
foreach (var item in deliverLines)
{
var deliverLine = new DeliverLine();
deliverLine.DeliverLineCode = item.DeliverLineCode;
deliverLine.DeliverLineName = item.DeliverLineName;
deliverLine.DeliverOrder = item.DeliverOrder;
deliverLine.Description = item.Description;
deliverLine.DistCode = item.DistCode;
deliverLine.CustomCode = item.CustomCode;
deliverLine.IsActive = item.IsActive;
deliverLine.UpdateTime = item.UpdateTime;
DeliverLineRepository.Add(deliverLine);
}
DeliverLineRepository.SaveChanges();
result = true;
}
catch (Exception e)
{
errorInfo = "出错，原因:" + e.Message;
}
return(result);
}
