来料检增加字段

xwt

2 天以前 8ba0722979e389a8a2f5835022a7d305ab215c08

来料检增加字段

 StandardInterface/MES.Service/Dto/service/LLJDto.cs

@@ -22,6 +22,12 @@
    public string? Remarks { get; set; }
    //特殊备注
    public string? Meom { get; set; }
    //不良原因
    public string? BLYY { get; set; }
    //所属车间
    public string? SSCJ { get; set; }
    //评审状态
    public string? PSZT { get; set; }

    public int? PHSY {get; set; }


 StandardInterface/MES.Service/Modes/LtsLlj.cs

@@ -211,7 +211,22 @@
    /// </summary>
    [SugarColumn(ColumnName = "PHSY")]
    public int? PHSY { get; set; }
    /// <summary>
    ///     破坏实验数量
    /// </summary>
    [SugarColumn(ColumnName = "BLYY")]
    public string? BLYY { get; set; }
    /// <summary>
    ///     破坏实验数量
    /// </summary>
    [SugarColumn(ColumnName = "PSZT")]
    public string? PSZT { get; set; }
    /// <summary>
    ///     破坏实验数量
    /// </summary>
    [SugarColumn(ColumnName = "SSCJ")]
    public string? SSCJ { get; set; }


 

}

 StandardInterface/MES.Service/Modes/MesQaItemsDetect01.cs

@@ -471,4 +471,19 @@
    /// </summary>
    [SugarColumn(ColumnName = "PHSY")]
    public int PHSY { get; set; }
    /// <summary>
    ///    不良原因
    /// </summary>
    [SugarColumn(ColumnName = "BLYY")]
    public string? BLYY { get; set; }
    /// <summary>
    ///     申请车间
    /// </summary>
    [SugarColumn(ColumnName = "SSCJ")]
    public string? SSCJ { get; set; }
    /// <summary>
    ///     评审状态
    /// </summary>
    [SugarColumn(ColumnName = "PSZT")]
    public string? PSZT { get; set; }
}

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

@@ -313,10 +313,10 @@

    public List<QamftpDto> GetAttachments(string ItemNo)
    {
        if (string.IsNullOrEmpty(ItemNo))
        {
            throw new ArgumentException("检验单号不能为空");
        }
        //if (string.IsNullOrEmpty(ItemNo))
        //{
           // throw new ArgumentException("检验单号不能为空");
        //}
        
        var db = SqlSugarHelper.GetInstance();
        try
@@ -861,15 +861,17 @@
        return withOracle;
    }

    //主表修改备注字段
    //主表修改字段
    public int saveRemarksGid(LLJDto dto)
    {
        return SqlSugarHelper.UseTransactionWithOracle(db =>
        {
            return db.Updateable<MesQaItemsDetect01>()
                .SetColumns(it =>
                    it.FngDesc == dto.Remarks) //SetColumns是可以叠加的 写2个就2个字段赋值
                .SetColumns(it => it.PHSY == dto.PHSY)//破坏实验数
                .SetColumns(it => it.FngDesc == dto.Remarks)
                .SetColumns(it => it.PHSY == dto.PHSY)
                .SetColumns(it => it.BLYY == dto.BLYY)
                .SetColumns(it => it.SSCJ == dto.SSCJ)
                .SetColumns(it => it.PSZT == dto.PSZT)
                .Where(it => it.ReleaseNo == dto.releaseNo)
                .ExecuteCommand();
        });