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 });
}
}