| | |
|---|
| | | |
|---|
| | | PlanQty = a.Daa008,//工单数量 |
|---|
| | | ItemModel = a.Daa004,//规格 |
|---|
| | | ItemName = a.Daa003//产品名称 |
|---|
| | | |
|---|
| | | ItemName = a.Daa003,//产品名称 |
|---|
| | | ItemId = a.Daa002//产品名称 |
|---|
| | | }).OrderBy(s => s.CreateDate, OrderByType.Desc) |
|---|
| | | .ToPageList(queryObj.PageIndex, queryObj.Limit); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | public List<QsQaItemXj01> setJYItem(string itemNo) |
|---|
| | | public List<QsQaItemXj01> setJYItem(decimal itemId) |
|---|
| | | { |
|---|
| | | var db = SqlSugarHelper.GetInstance(); |
|---|
| | | |
|---|
| | | var count = db.Queryable<MesQa>().Where(s => s.QsType == "2" |
|---|
| | | && s.ItemNo == itemNo && s.Fsubmit == 1).Count(); |
|---|
| | | && s.ItemId == itemId && s.Fsubmit == 1).Count(); |
|---|
| | | |
|---|
| | | if (count <= 0) return new List<QsQaItemXj01>(); |
|---|
| | | |
|---|
| | | return db |
|---|
| | | .Queryable<MesQualityStandard>() |
|---|
| | | .Where(b => b.QsType == "2" |
|---|
| | | && b.ItemNo == itemNo).Select( |
|---|
| | | && b.ItemId == itemId).Select( |
|---|
| | | b => new QsQaItemXj01 |
|---|
| | | { |
|---|
| | | ProjName = b.ProjName, |
|---|
| | |
|---|
| | | InspectionMethod = b.InspectionMethod, |
|---|
| | | UsingInstruments = b.UsingInstruments, |
|---|
| | | LevelNum = SqlFunc.IsNull( |
|---|
| | | SqlFunc.IsNull(b.LevelNum * b.InspectionLevel, 1), |
|---|
| | | b.InspectionLevel), |
|---|
| | | MaxValue = b.MaxValue, |
|---|
| | | StandardValue = b.StandardValue, |
|---|
| | | MinValue = b.MinValue, |
|---|
| | | SqlFunc.IsNull( Convert.ToDecimal(b.LevelNum) * Convert.ToDecimal(b.InspectionLevel) , 1), |
|---|
| | | Convert.ToDecimal(b.InspectionLevel)), |
|---|
| | | MaxValue = Convert.ToDecimal(b.MaxValue), |
|---|
| | | StandardValue = Convert.ToDecimal(b.StandardValue), |
|---|
| | | MinValue = Convert.ToDecimal(b.MinValue), |
|---|
| | | Notes = b.Notes, |
|---|
| | | FcheckLevel = b.FcheckLevel, |
|---|
| | | FacLevel = b.FacLevel, |
|---|
