llj备注

xwt

6 天以前 db5e488203b05d785baf1614b727afaf20a03fe6

llj备注

 StandardInterface/MES.Service/service/QC/LljService.cs

@@ -1531,4 +1531,24 @@
        return match.Success ? int.Parse(match.Groups[1].Value) : 0;
    }


    /// <summary>
    /// 保存备注到主表
    /// </summary>
    /// <param name="gid">主表ID</param>
    /// <param name="releaseNo">检验单号</param>
    /// <param name="lotNo1">备注内容</param>
    /// <returns>影响行数</returns>
    public int SaveLotNo1(decimal gid, string? releaseNo, string? lotNo1)
    {
        var db = SqlSugarHelper.GetInstance();
        return db.Updateable<MesQaItemsDetect01>()
            .SetColumns(it => new MesQaItemsDetect01
            {
                LotNo1 = lotNo1
            })
            .Where(it => it.Id == gid && it.ReleaseNo == releaseNo)
            .ExecuteCommand();
    }

}

 StandardInterface/MESApplication/Controllers/QC/LljController.cs

@@ -1,4 +1,4 @@
using System.Dynamic;
using System.Dynamic;
using MES.Service.Dto.service;
using MES.Service.Modes;
using MES.Service.service.QC;
@@ -294,9 +294,7 @@
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    //IqcQaSubmit
    }    //IqcQaSubmit
    [HttpPost("IqcQaSubmit")]
    public ResponseResult IqcQaSubmit(LLJDto rkjDto)
    {
@@ -318,6 +316,33 @@
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    /// 保存备注到主表
    /// </summary>
    [HttpPost("saveLotNo1")]
    public ResponseResult saveLotNo1([FromBody] JObject data)
    {
        var gid = Convert.ToDecimal(data["gid"].ToString());
        var releaseNo = data["releaseNo"]?.ToString();
        var lotNo1 = data["lotNo1"]?.ToString();
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var tbBillList = new LljService().SaveLotNo1(gid, releaseNo, lotNo1);
            resultInfos.tbBillList = tbBillList;
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }
    [HttpPost("EmergencyRelease")]
    public ResponseResult EmergencyRelease([FromBody] JObject data)
    {

 StandardInterface/MESApplication/appsettings.json

@@ -10,6 +10,6 @@
  "AppSettings": {
    "TestErpUrl": "http://192.168.11.120:8098/WebService1.asmx/mesToErpinfo",
    "ProductionErpUrl": "http://192.168.11.120:8098/WebService1.asmx/mesToErpinfoFormal",
    "DataBaseConn": "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.22)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = test_dev; Password=hmprd"
    "DataBaseConn": "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.22)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = hm_prd; Password=hmprd"
  }
}