public static object GetSample(string styleId) { using (SunginDataContext sc = new SunginDataContext()) { ISampleBaseInfo s = sc.SampleBaseInfos.SingleOrDefault(p => p.StyleId == styleId); if (s != null) { return(SampleHelper.GetEditObj(s)); } else { return(null); } } }
public static object GetPrintSample(string styleId) { using (SunginDataContext sc = new SunginDataContext()) { ISampleBaseInfo s = sc.SampleBaseInfos.SingleOrDefault(p => p.StyleId == styleId); if (s != null) { var re = SampleHelper.GetEditObj(s); return(new { re.PicList, re.StyleId, re.StyleNo, re.Material, re.HaveStock, re.CanLendOut, re.SalePrice, re.Counts }); } else { return(null); } } }
/// <summary> /// 直接入库 /// </summary> /// <param name="styleId"></param> /// <returns></returns> public static ISampleBaseInfo PutInStorage(string styleId) { using (SunginDataContext sc = new SunginDataContext()) { ISampleBaseInfo s = sc.SampleBaseInfos.FirstOrDefault(p => p.StyleId == styleId); if (s != null) { s.State = SampleState.在库; sc.SaveChanges(); return(s); } else { return(null); } } }
public static ISampleBaseInfo DeleteSample(string styleId, string user) { using (SunginDataContext sc = new SunginDataContext()) { ISampleBaseInfo s = sc.SampleBaseInfos.FirstOrDefault(p => p.StyleId == styleId); if (s != null) { s.Delete(user); sc.SaveChanges(); return(s); } else { return(null); } } }
public static object GetSampleListOrderByDesc(Func <ISampleBaseInfo, bool> whereLambda = null, Func <ISampleBaseInfo, object> orderbyLamba = null, int PageId = 1, int PageSize = 20) { if (orderbyLamba == null) { orderbyLamba = p => p.State; } if (whereLambda == null) { whereLambda = (p => true); } using (SunginDataContext sc = new SunginDataContext()) { int count = sc.SampleBaseInfos.Count(whereLambda); List <ISampleBaseInfo> sampleinfo = sc.SampleBaseInfos.Where(whereLambda).OrderByDescending(orderbyLamba).ThenByDescending(p => p.Id).Skip(PageSize * (PageId - 1)).Take(PageSize).ToList(); List <object> obj = new List <object>(); sampleinfo.ForEach(p => { obj.Add(SampleHelper.GetReturnObj(p)); }); return(new { items = obj, total = count, current = PageId, pageSize = PageSize }); } }