| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | public List<QsQaItemXj01> setJYItem(decimal itemId) |
|---|
| | | public List<QsQaItemXj01> setJYItem(string itemNo) |
|---|
| | | { |
|---|
| | | var db = SqlSugarHelper.GetInstance(); |
|---|
| | | |
|---|
| | | var count = db.Queryable<MesQa>().Where(s => s.QsType == "2" |
|---|
| | | && s.ItemId == itemId && s.Fsubmit == 1).Count(); |
|---|
| | | var count = db.Queryable<MesQa>().Where(s => s.QsType == "2" && s.ItemNo == itemNo && s.Fsubmit == 1).Count(); |
|---|
| | | |
|---|
| | | if (count <= 0) return new List<QsQaItemXj01>(); |
|---|
| | | |
|---|
| | | return db |
|---|
| | | .Queryable<MesQualityStandard>() |
|---|
| | | .Where(b => b.QsType == "2" |
|---|
| | | && b.ItemId == itemId).Select( |
|---|
| | | .Where(b => b.QsType == "2" && b.ItemNo == itemNo).Select( |
|---|
| | | b => new QsQaItemXj01 |
|---|
| | | { |
|---|
| | | ProjName = b.ProjName, |
|---|
