增加斯莫尔质量报表增加过滤条件查询,质量月度目标单增加 字段 HProcTarGetVal money --各工序目标值,

zrg

2024-10-09 e1cbefad8e411d8305c6730c2e1e0221a7525c9d

 WebAPI/Controllers/品质管理/车间自检单/QC_WorkSelfCheckBillController.cs

@@ -33,6 +33,16 @@
            {
                List<object> columnNameList = new List<object>();

                //鍒ゆ柇鏉冮檺
                if (!DBUtility.ClsPub.Security_Log("QC_WorkSelfCheckBill_Query", 3, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "鎮ㄦ病鏈夎妯″潡鏉冮檺,璇蜂笌绠＄悊鍛樿仈绯伙紒";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                string sql1 = "select * from h_v_QC_WorkSelfCheckBill where 1 = 1  ";
                string sql = sql1 + sWhere + " order by hmainid desc";
                ds = oCN.RunProcReturn(sql, "h_v_QC_WorkSelfCheckBill");