using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using System.ComponentModel.DataAnnotations; using WalkingTec.Mvvm.Core; using WalkingTec.Mvvm.Core.Extensions; using cy_scdz.Model.Oder; using cy_scdz.Model.Set; using Microsoft.EntityFrameworkCore; using NPOI.SS.Formula.Functions; namespace cy_scdz.ViewModel.Order.OrderProductionVMs { public partial class OrderProductionVM : BaseCRUDVM { /// /// 供货学期 /// public List AllSemesters { get; set; } /// /// 供应商 /// public List AllSuppliers { get; set; } /// /// 订单类别 /// public List AllBidTypes { get; set; } /// /// 封面纸张 /// public List AllCoverPaperTypes { get; set; } /// /// 内页纸张 /// public List AllInnerPaperTypes { get; set; } /// /// 内页颜色 /// public List AllColorTypes { get; set; } /// /// 装订方式 /// public List AllBindingTypes { get; set; } /// /// 印刷厂 /// public List AllManufacturers { get; set; } /// /// 页码 /// public List AllInnerPaperCodes { get; set; } public List AllOders { get; set; } /// /// 当前学期 /// [Display(Name ="当前学期")] public string Delivery { get;set; } /// /// 订单类型 /// [Display(Name ="订单类型")] public string BidType { get;set; } /// /// 学期总数 /// [Display(Name = "学期总数")] public string Semester { get;set; } /// /// 中标供应商 /// [Display(Name = "中标供应商")] public string Supplier { get;set; } /// /// 作业本封面纸张 /// [Display(Name = "封面纸张")] public string WorkbookCoverPaperType { get;set; } /// /// 作业本内页纸张 /// [Display(Name = "内页纸张")] public string WorkbookInnerPaperTyp { get; set; } /// /// 作业本内页页码 /// [Display(Name = "内页页码")] public string WorkbookInnerPageCode { get; set; } /// /// 作业本内页颜色 /// [Display(Name = "内页颜色")] public string WorkbookColorType { get; set; } /// /// 作业本装订方式 /// [Display(Name = "装订方式")] public string WorkbookBindingType { get; set; } /// /// 图画本封面纸张 /// [Display(Name = "封面纸张")] public string PictureBookCoverPaperType { get; set; } /// /// 图画本内页纸张 /// [Display(Name = "内页纸张")] public string PictureBookInnerPaperTyp { get; set; } /// /// 图画本内页页码 /// [Display(Name = "内页页码")] public string PictureBookInnerPageCode { get; set; } /// /// 图画本内页颜色 /// [Display(Name = "内页颜色")] public string PictureBookColorType { get; set; } /// /// 图画本装订方式 /// [Display(Name = "装订方式")] public string PictureBookBindingType { get; set; } /// /// 大字本封面纸张 /// [Display(Name = "封面纸张")] public string LargeCharacterBookCoverPaperType { get; set; } /// /// 大字本内页纸张 /// [Display(Name = "内页纸张")] public string LargeCharacterBookInnerPaperTyp { get; set; } /// /// 大字本内页页码 /// [Display(Name = "内页页码")] public string LargeCharacterBookInnerPageCode { get; set; } /// /// 大字本内页颜色 /// [Display(Name = "内页颜色")] public string LargeCharacterBookColorType { get; set; } /// /// 大字本装订方式 /// [Display(Name = "装订方式")] public string LargeCharacterBookBindingType { get; set; } public OrderProductionVM() { SetInclude(x => x.Oder); SetInclude(x => x.Oder.Semester); SetInclude(x => x.Oder.Supplier); SetInclude(x => x.Oder.BidType); SetInclude(x => x.Oder.WorkbookCoverPaperType); SetInclude(x => x.Oder.WorkbookInnerPaperType); SetInclude(x => x.Oder.WorkbookColorType); SetInclude(x => x.Oder.WorkbookBindingType); SetInclude(x => x.Oder.PictureBookCoverPaperType); SetInclude(x => x.Oder.PictureBookInnerPaperType); SetInclude(x => x.Oder.PictureBookColorType); SetInclude(x => x.Oder.PictureBookBindingType); SetInclude(x => x.Oder.LargeCharacterBookCoverPaperType); SetInclude(x => x.Oder.LargeCharacterBookInnerPaperType); SetInclude(x => x.Oder.LargeCharacterBookColorType); SetInclude(x => x.Oder.LargeCharacterBookBindingType); SetInclude(x => x.Oder.OrderReceivablesStatus); SetInclude(x => x.Oder.Sures); SetInclude(x => x.Oder.AdvancePayments); } protected override void InitVM() { AllOders = DC.Set().GetSelectListItems(Wtm, y => y.Title); AllSemesters = DC.Set().Include(x => x.Parent).Where(x => x.Parent.Key == "ghxq").GetSelectListItems(Wtm, y => y.Name); AllSuppliers = DC.Set().Include(x => x.Parent).Where(x => x.Parent.Key == "zbgys").GetSelectListItems(Wtm, y => y.Name); AllBidTypes = DC.Set().Include(x => x.Parent).Where(x => x.Parent.Key == "ddlb").GetSelectListItems(Wtm, y => y.Name); AllCoverPaperTypes = DC.Set().Include(x => x.Parent).Where(x => x.Parent.Key == "fmzz").GetSelectListItems(Wtm, y => y.Name); AllInnerPaperTypes = DC.Set().Include(x => x.Parent).Where(x => x.Parent.Key == "nyzz").GetSelectListItems(Wtm, y => y.Name); AllColorTypes = DC.Set().Include(x => x.Parent).Where(x => x.Parent.Key == "nyys").GetSelectListItems(Wtm, y => y.Name); AllBindingTypes = DC.Set().Include(x => x.Parent).Where(x => x.Parent.Key == "zdfs").GetSelectListItems(Wtm, y => y.Name); AllManufacturers = DC.Set().Include(x => x.Parent).Where(x => x.Parent.Key == "yscs").GetSelectListItems(Wtm, y => y.Name); AllInnerPaperCodes = DC.Set().Include(x => x.Parent).Where(x => x.Parent.Key == "nyym").GetSelectListItems(Wtm, y => y.Name); if(!string.IsNullOrEmpty( Entity.Oder.Title)) { Delivery= Entity.DeliveryTime.ToString("yyyy")+"年 "+Entity.Chunqiuji.GetEnumDisplayName(); Semester = DC.Set().Where(x => x.ID == Entity.Oder.SemesterId).Select(x => x.Name).FirstOrDefault(); Supplier = DC.Set().Where(x => x.ID == Entity.Oder.SupplierId).Select(x => x.Name).FirstOrDefault(); BidType = DC.Set().Where(x => x.ID == Entity.Oder.BidTypeId).Select(x => x.Name).FirstOrDefault(); //WorkbookCoverPaperType = DC.Set().Where(x => x.ID == Entity.Oder.WorkbookCoverPaperTypeId).Select(x => x.Name).FirstOrDefault(); //WorkbookCoverPaperType = DC.Set().Where(x => x.ID == Entity.Oder.WorkbookCoverPaperTypeId).Select(x => x.Name).FirstOrDefault(); //WorkbookCoverPaperType = DC.Set().Where(x => x.ID == Entity.Oder.WorkbookCoverPaperTypeId).Select(x => x.Name).FirstOrDefault(); //WorkbookCoverPaperType = DC.Set().Where(x => x.ID == Entity.Oder.WorkbookCoverPaperTypeId).Select(x => x.Name).FirstOrDefault(); //WorkbookCoverPaperType = DC.Set().Where(x => x.ID == Entity.Oder.WorkbookCoverPaperTypeId).Select(x => x.Name).FirstOrDefault(); } } public override void DoAdd() { base.DoAdd(); } public override void DoEdit(bool updateAllFields = false) { base.DoEdit(updateAllFields); } public override void DoDelete() { base.DoDelete(); } } }