新加判断提交标识审核标识

fcx

7 天以前 35f29f98993a2cede58e105ff810c83d7b8858f4

新加判断提交标识审核标识

 StandardPda/MES.Service/service/QC/SJService.cs

@@ -733,7 +733,6 @@
            SqlSugarHelper.UseTransactionWithOracle(db =>
            {
                return db.Updateable<QsItemIpiReq>()
                    .SetColumns(s => s.Fsubmit == 1)
                    .SetColumns(s => s.FsubmitBy == rkjDto.userNo)
                    .SetColumns(s => s.FsubmitDate == DateTime.Now)
                    .Where(s => s.Id == rkjDto.gid)

 StandardPda/MESApplication/Controllers/QC/SJController.cs

@@ -451,6 +451,12 @@
            var tbBillList = new SJService().SJQaSubmit(rkjDto);
            resultInfos.tbBillList = tbBillList;
            //=================  判断检验合格生成巡检单 =========
            var sqlpass6 = $@"update QS_ITEM_IPI_REQ set FSUBMIT1 = 1 where A.ID = '{rkjDto.gid}' ";
            var dtPass7 = SQLHelper.ExecuteQuery(sqlpass6);




            var sqlPass1 = $@"
    SELECT 
        IS_PASS
@@ -474,6 +480,11 @@

            bool isPass = false;






            if (dtPass1 != null && dtPass1.Rows.Count > 0)
            {
                var value = dtPass1.Rows[0]["IS_PASS"]?.ToString();
@@ -481,8 +492,16 @@
                // 判断为合格（IS_PASS = 1）
                if (value == "1")
                {
                   

                    isPass = true;
                }
                else
                {
                    var sqlpass4 = $@"update QS_ITEM_IPI_REQ set FSUBMIT = 0 where A.ID = '{rkjDto.gid}' ";

                    var dtPass5 = SQLHelper.ExecuteQuery(sqlpass4);
                }
            }

            // 如果合格，执行存储过程