public IEnumerable <WayBillTemplateExt> GetWayBillTemplateList(IEnumerable <int> shippingMethodIds,
string templateTypeId)
{
var ctx = this.UnitOfWork as LMS_DbContext;
Check.Argument.IsNotNull(ctx, "数据库对象");
Check.Argument.IsNullOrWhiteSpace(templateTypeId, "模板类型Id");
Check.Argument.IsNotNull(shippingMethodIds, "运输方式列表为空");
var methodIds = shippingMethodIds as int[] ?? shippingMethodIds.ToArray();
int enable = WayBillTemplateInfo.StatusToValue(WayBillTemplateInfo.StatusEnum.Enable);
var list =
ctx.WayBillTemplates.Where(
w =>
methodIds.Contains(w.ShippingMethodId) && w.TemplateTypeId == templateTypeId &&
w.Status == enable)
.Select(w => new WayBillTemplateExt
{
WayBillTemplateId = w.WayBillTemplateId,
TemplateName = w.TemplateName,
TemplateTypeId = w.TemplateTypeId,
ShippingMethodId = w.ShippingMethodId,
Status = w.Status,
TemplateContent = w.TemplateContent,
Remark = w.Remark,
RowNumber = w.RowNumber,
ColumnNumber = w.ColumnNumber,
TemplateHeadId = w.TemplateHeadId,
TemplateContentId = w.TemplateContentId,
LinkMode = w.LinkMode,
Countries = w.Countries,
CreatedOn = w.CreatedOn,
LastUpdatedOn = w.LastUpdatedOn,
TemplateBodyContent = (from wino in ctx.WayBillTemplateInfos
where
wino.TemplateModelId == w.TemplateContentId &&
wino.Status == enable
select wino.TemplateContent).FirstOrDefault(),
TemplateHead = (from wino in ctx.WayBillTemplateInfos
where wino.TemplateModelId == w.TemplateHeadId && wino.Status == enable
select wino.TemplateContent).FirstOrDefault(),
});
return(list.ToList());
}
public List <WayBillTemplate> GetWayBillTemplateByNameAndShippingMethod(string templateName, int shippingMethodId)
{
int disable = WayBillTemplateInfo.StatusToValue(WayBillTemplateInfo.StatusEnum.Disable);
return(_wayBillTemplateRepository.GetList(p => p.TemplateName == templateName && p.ShippingMethodId == shippingMethodId && p.Status != disable));
}
public List <WayBillTemplate> GetList()
{
int disable = WayBillTemplateInfo.StatusToValue(WayBillTemplateInfo.StatusEnum.Disable);
return(_wayBillTemplateRepository.GetList(p => p.Status != disable));
}