优化多组织代码

sjz

14 小时以前 302054e253f1550ee64430882786ec9a3920ec92

 MES.Service/service/QC/XJService.cs

@@ -160,20 +160,19 @@
    }


    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(
                b => new QsQaItemXj01
            .Where(b => b.QsType == "2" && b.ItemNo == itemNo).Select(b =>
                new QsQaItemXj01
                {
                    ProjName = b.ProjName,
                    ItemMod = b.ItemMod,
@@ -401,8 +400,8 @@

        if (count == passCount) result = 1;

        var useTransactionWithOracle = SqlSugarHelper.UseTransactionWithOracle(
            db =>
        var useTransactionWithOracle =
            SqlSugarHelper.UseTransactionWithOracle(db =>
            {
                var commit = 0;
                commit += db.Updateable<QsQaItemXj01>()