工价阶梯优化

wtt

2025-12-19 8c3fad6d162b780679432739b09abe893e7069e2

工价阶梯优化

 WebTM/Vlog/webapi20251219.txt

New file
@@ -0,0 +1,17 @@
2025/12/19 16:35:55 æ‰“印sql:select * from h_v_IF_BarCodeBillList where hmainid in(126499) order by hmainid desc

2025/12/19 16:35:56 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;

2025/12/19 16:35:56 ReportDataSet:1

2025/12/19 16:36:27 æ‰“印sql:select * from h_v_IF_BarCodeBillList where hmainid in(126499) order by hmainid desc

2025/12/19 16:36:27 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;

2025/12/19 16:36:27 ReportDataSet:1

2025/12/19 16:51:08 æ‰“印sql:select * from h_v_IF_BarCodeBillList where hmainid in(126499) order by hmainid desc

2025/12/19 16:51:08 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;

2025/12/19 16:51:08 ReportDataSet:1

 WebTM/WebTM.csproj.user

@@ -1,6 +1,31 @@
<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="Current" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <PropertyGroup>
    <LastActiveSolutionConfig>Release|Any CPU</LastActiveSolutionConfig>
    <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig>
  </PropertyGroup>
  <ProjectExtensions>
    <VisualStudio>
      <FlavorProperties GUID="{349c5851-65df-11da-9384-00065b846f21}">
        <WebProjectProperties>
          <StartPageUrl>
          </StartPageUrl>
          <StartAction>CurrentPage</StartAction>
          <AspNetDebugging>True</AspNetDebugging>
          <SilverlightDebugging>False</SilverlightDebugging>
          <NativeDebugging>False</NativeDebugging>
          <SQLDebugging>False</SQLDebugging>
          <ExternalProgram>
          </ExternalProgram>
          <StartExternalURL>
          </StartExternalURL>
          <StartCmdLineArguments>
          </StartCmdLineArguments>
          <StartWorkingDirectory>
          </StartWorkingDirectory>
          <EnableENC>True</EnableENC>
          <AlwaysStartWebServerOnDebug>False</AlwaysStartWebServerOnDebug>
        </WebProjectProperties>
      </FlavorProperties>
    </VisualStudio>
  </ProjectExtensions>
</Project>

 WebTM/layuiadmin/Scripts/webConfig.js

@@ -7,19 +7,9 @@
    //var WEBURL = "http://localhost:8082/LuBaoAPI/";    //杨乐本地配置
   /*  var WEBURL = "http://localhost:8082/API/";    //杜贺本地配置*/
    //var WEBURL = "http://localhost:8082/API/";    //张瑞广本地配置
<<<<<<< HEAD

    var WEBURL = "http://localhost:8080/API/";    //王仪本地配置
    //var WEBURL = "http://localhost:81/API/"    //翁涛涛本地配置

/*    var WEBURL = "http://localhost:81/API/"    //翁涛涛本地配置*/

=======
    var WEBURL = "http://localhost:8080/API/";    //王仪本地配置
    //var WEBURL = "http://localhost:81/API/"    //翁涛涛本地配置
    var WEBURL = "http://localhost:81/API/"    //翁涛涛本地配置
>>>>>>> a12e0abce941275b1d4295790546c673e556cd89
    //var WEBURL = "http://localhost:8082/LuBaoAPI/";    //杨乐本地配置
   /* var WEBURL = "http://localhost:8080/API/";    //王仪本地配置*/
  //var WEBURL = "http://localhost:8082/LuBaoAPI/";    //杨乐本地配置
    //var WEBURL = "http://47.96.97.237/API/";          //智云服务器
    /*var WEBURL = "http://localhost:8082/LuBaoAPI/";*/  //余思杰本地配置
    //var WEBURL = "http://localhost:81/API/";            // é™ˆé•å“²æœ¬åœ°é…ç½®*/

 WebTM/views/¹¤×ʹÜÀí/½×Ìݹ¤¼ÛϵÊý/Gy_SteppedPriceCoefficientBillEdit.html

@@ -948,7 +948,7 @@
                                                OperationType = 3;
                                            }
                                        } else {
                                            layer.msg("工序未选择");
                                            layer.msg(result.Message);
                                        }
                                    },
                                    error: function (xhr, status, error) {

 WebTM/views/¹¤×ʹÜÀí/½×Ìݹ¤¼ÛϵÊý/Gy_SteppedPriceCoefficientBillList.html

@@ -173,7 +173,7 @@
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                        <div id="page" style="position: relative; bottom: 0;"></div>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                            <div class="layui-btn-container" id="toolbarDemo_ButtonSet">
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Export" id="btn_Export"><i class="layui-icon layui-icon-export"></i>导出</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Add" id="btn_Add"><i class="layui-icon layui-icon-file-b"></i>新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Edit" id="btn_Edit"><i class="layui-icon layui-icon-form"></i>编辑</button>
@@ -221,15 +221,13 @@
            console.log("GetWEBURL:", typeof GetWEBURL);

            var HModName = "Gy_SteppedPriceCoefficientBillList";
            var HBillType = "GYSTPRICECOEFF";
            var HBillType = "3341";
            var HMaker = sessionStorage["HUserName"];
            var Organization = sessionStorage["Organization"];

            // æŸ¥è¯¢æ¡ä»¶
            var sWhere = "";
            var option = {};
            var page = 1;
            var size = 50;
            var set_HideButton_ID = "toolbarDemo_ButtonSet"; // æŒ‰é’®å®¹å™¨ID

            //#region ã€è¿‡æ»¤æ–¹æ¡ˆã€‘
@@ -344,8 +342,6 @@
            //刷新
            function btn_Refresh() {
                $("#btnSearch").click();
                // åˆ·æ–°åŽé‡æ–°è®¾ç½®åˆ—标题
                setTimeout(refreshTableWithChineseTitles, 500);
             
            }

@@ -387,7 +383,7 @@
                option = {
                    elem: '#mainTable'
                    , toolbar: '#toolbarDemo'
                    , page: false
                    , page: true
                    , cellMinWidth: 120
                    , totalRow: true
                    , limit: 50
@@ -413,128 +409,6 @@
                console.log("表格初始化完成");
            }

            // å­—段名到中文标题的映射
            function getColumnChineseTitle(fieldName) {
                var titleMap = {
                    // ä¸»è¡¨å­—段
                    "HInterID": "单据内码",
                    "HItemMainID": "主表内码",
                    "HBillNo": "单据号",
                    "HDate": "单据日期",
                    "HYear": "年份",
                    "HPeriod": "月份",
                    "HBillType": "单据类型",
                    "HBillSubType": "单据子类型",
                    "HBillStatus": "单据状态",
                    "HRemark": "主表备注",
                    "HChecker": "审核人",
                    "HCheckDate": "审核日期",
                    "HMaker": "制单人",
                    "HMakeDate": "制单日期",
                    "HUpDater": "修改人",
                    "HUpDateDate": "修改日期",
                    "HCloseMan": "关闭人",
                    "HCloseDate": "关闭日期",
                    "HCloseType": "关闭类型",
                    "HDropMan": "作废人",
                    "HDropDate": "作废日期",
                    "HReturnMan": "退回人",
                    "HReturnDate": "退回日期",
                    "HReturnReason": "退回原因",
                    "HProcID": "工序ID",
                    "HEmpID": "负责人ID",
                    "HDeptID": "部门ID",
                    "HStockOrgID": "组织ID",

                    // å­è¡¨å­—段
                    "HItemID": "子表内码",
                    "RowNum": "序号",
                    "HMinQty": "最小数量",
                    "HMaxQty": "最大数量",
                    "HCoefficient": "工价系数",
                    "HMaxPrice": "最大工价",
                    "HRowCloseMan": "行关闭人",
                    "HRowCloseDate": "行关闭日期",
                    "HRowCloseType": "行关闭类型",
                    "HRowRemark": "子表备注",
                    "HRelativeQty": "关联数量",
                    "HRelativeMoney": "关联金额",
                    "HSubStockOrgID": "子表组织ID",
                    "HSourceHInterID": "源单ID",
                    "HSourceItemID": "源单子ID",
                    "HSourceBillNo": "源单单号",
                    "HSourceBillType": "源单类型",
                    // æ–°å¢žçš„汇总字段
                    "TotalMinQty": "总最小数量",
                    "TotalMaxQty": "总最大数量",
                    "TotalCoefficient": "总系数",
                    "SubCount": "子表行数",
                    "TotalMaxPrice": "总价格"


                };

                return titleMap[fieldName] || fieldName;
            }

            // ========== æ ¸å¿ƒä¿®å¤ï¼šç›´æŽ¥ä½¿ç”¨é¢„处理数据 ==========
            // åŸºäºŽæŽ§åˆ¶å°æ˜¾ç¤ºçš„数据格式进行简单处理
            // è¶…级简单的日期显示函数 - ä¸“门处理您的数据格式
            // é€šç”¨æ—¥æœŸæ ¼å¼åŒ–函数 - é€‚配所有后端返回格式
            function formatDateForDisplay(fieldName, dateValue) {
                if (!dateValue) return '';

                // è½¬ä¸ºå­—符串并清理首尾空格
                var str = String(dateValue).trim();

                // è¿‡æ»¤ç»å¯¹æ— æ•ˆçš„默认日期
                var invalidDates = ['2001-10-01', '1900-01-01', '2000-01-01', '1970-01-01'];
                if (invalidDates.some(invalid => str.startsWith(invalid))) {
                    return '';
                }

                // åœºæ™¯1：处理特殊格式 2025-12-11(15):48:28
                if (str.includes('(') && str.includes(')')) {
                    try {
                        // æå–日期部分 2025-12-11 å’Œæ—¶é—´éƒ¨åˆ† 15:48:28
                        var datePart = str.split('(')[0].trim();
                        var timePart = str.split('(')[1].replace(')', '').split(':').slice(0, 3).join(':');
                        // å•æ®æ—¥æœŸåªæ˜¾ç¤ºæ—¥æœŸï¼Œå…¶ä»–时间显示完整格式
                        return fieldName === 'HDate' ? datePart : `${datePart} ${timePart}`;
                    } catch (e) {
                        console.warn(`解析特殊格式日期失败: ${str}`, e);
                    }
                }

                // åœºæ™¯2：处理 ISO æ ¼å¼ 2025-12-16T14:33:50 æˆ– 2025-12-16T14:33:50.35
                if (str.includes('T')) {
                    try {
                        var [datePart, timePart] = str.split('T');
                        // ç§»é™¤æ—¶é—´éƒ¨åˆ†çš„毫秒
                        var cleanTime = timePart.includes('.') ? timePart.split('.')[0] : timePart;
                        // åªä¿ç•™æ—¶åˆ†ç§’
                        cleanTime = cleanTime.split(':').slice(0, 3).join(':');
                        return fieldName === 'HDate' ? datePart : `${datePart} ${cleanTime}`;
                    } catch (e) {
                        console.warn(`解析ISO格式日期失败: ${str}`, e);
                    }
                }

                // åœºæ™¯3：处理纯日期 2025-12-16 æˆ– å®Œæ•´æ—¶é—´ 2025-12-16 14:33:50
                if (str.match(/^\d{4}-\d{2}-\d{2}/)) {
                    // åŒ¹é… å¹´-月-日 å¼€å¤´çš„合法格式
                    if (fieldName === 'HDate' || str.length === 10) {
                        return str.substring(0, 10); // åªæ˜¾ç¤ºæ—¥æœŸ
                    } else {
                        // è¡¥å…¨æ—¶é—´éƒ¨åˆ†ï¼ˆå¦‚果只有日期）
                        return str.length > 10 ? str : `${str} 00:00:00`;
                    }
                }

                // æ‰€æœ‰è§£æžå¤±è´¥çš„情况，返回原始值（避免空显示）
                return str;
            }



            //加载网格（动态列加载方法）
@@ -551,320 +425,70 @@
                        "user": sessionStorage["HUserName"] || "guest"
                    },
                    success: function (data1) {
                        console.log("=== API è¿”回数据 ===");

                        if (data1 && data1.list && data1.list.length > 0) {
                            console.log("列定义数量:", data1.list.length);

                            // æ­¥éª¤1：列去重
                            var uniqueColumns = [];
                            var seenColumns = new Set();
                            var columnData = [];

                            for (var key in data1.list) {
                                var colDef = data1.list[key];
                                var colName = colDef.ColmCols;

                                if (!seenColumns.has(colName)) {
                                    seenColumns.add(colName);
                                    uniqueColumns.push(colDef);
                                    columnData.push({
                                        "id": colName,
                                        "name": colName,
                                        "Type": colDef.ColmType,
                                        "chineseTitle": getColumnChineseTitle(colName)
                                    });
                                }
                            }

                            console.log("去重后列数:", columnData.length);

                            // æ­¥éª¤2：构建表格列配置 - ä½¿ç”¨å·¥åŽ‚函数避免闭包问题
                        if (data1.code == 1) {
                            var data = [];
                            var col = [];

                            // æ·»åŠ å‹¾é€‰æ¡†
                            col.push({ type: 'checkbox', fixed: 'left', totalRowText: '合计' });

                            // åˆ›å»ºæ¨¡æ¿å‡½æ•°ç”Ÿæˆå™¨
                            function createTempletFunction(fieldName, fieldType) {
                                switch (fieldType) {
                                    case 'DateTime':
                                        return function (d) {
                                            var value = d[fieldName];
                                            if (!value) return '';

                                            var str = String(value).trim();

                                            // è¿‡æ»¤æ— æ•ˆæ—¥æœŸ
                                            var invalidDates = ['2001-10-01', '1900-01-01', '2000-01-01', '1970-01-01', '0001-01-01'];
                                            if (invalidDates.some(invalid => str.startsWith(invalid))) {
                                                return '';
                                            }

                                            // æå–日期部分
                                            if (str.includes('(')) {
                                                return str.split('(')[0].trim();
                                            } else if (str.includes('T')) {
                                                return str.split('T')[0];
                                            } else if (str.match(/^\d{4}-\d{2}-\d{2}/)) {
                                                return str.substring(0, 10);
                                            }

                                            return str;
                                        };

                                    case 'Decimal':
                                    case 'Double':
                                    case 'Float':
                                        return function (d) {
                                            var value = d[fieldName];
                                            if (value === null || value === undefined || value === '') {
                                                return '';
                                            }
                                            var num = parseFloat(value);
                                            return isNaN(num) ? '' : num.toFixed(2);
                                        };

                                    case 'Int32':
                                    case 'Int64':
                                    case 'Integer':
                                        

                                        // æ•´æ•°ç±»åž‹çš„特殊处理
                                        if (fieldName === 'HBillStatus') {
                                            return function (d) {
                                                var status = d[fieldName] || '0';
                                                // è½¬æ¢ä¸ºæ•°å­—再判断
                                                var statusNum = parseInt(status);
                                                switch (statusNum) {
                                                    case 1: return '未审';
                                                    case 2: return '审核通过';
                                                    case 3: return '关闭';
                                                    case 4: return '作废';
                                                    case 5: return '审核退回';
                                                    case 6: return '审核中';
                                                    case 7: return '已阅';
                                                    case 8: return '已回复';
                                                    case 9: return '结案';
                                                    case 10: return '验证';
                                                    case 11: return '下达';
                                                    case 12: return '开工';
                                                    case 13: return '申请审批';
                                                    case 15: return '申请检验';
                                                    case 16: return '判定合格';
                                                    case 17: return '判定不合格';
                                                    case 0:
                                                    default: return '未审'; // é»˜è®¤æ˜¾ç¤ºä¸ºæœªå®¡
                                                }
                                            };
                                        }
                                        return null; // å…¶ä»–整数类型不需要特殊模板

                                    default:
                                        // æ–‡æœ¬å­—段的特殊处理
                                        if (fieldName === 'HBillNo') {
                                            return function (d) {
                                                var billNo = d[fieldName] || '';
                                                return '<span style="color: blue; cursor: pointer;">' + billNo + '</span>';
                                            };
                                        }
                                        return null;
                                }
                            var totalArray = [];
                            var titleData = [];
                            //给空的数组赋值
                            for (var key in data1.list) {
                                data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                            }

                            // åˆ›å»ºäº‹ä»¶å¤„理映射
                            function getEventForField(fieldName) {
                                if (fieldName === 'HBillNo') {
                                    return '单据号';
                                }
                                return null;
                            }

                            // èŽ·å–宽度设置
                            function getWidthForField(fieldName, fieldType) {
                                if (fieldName === 'HBillNo') return 500;
                                if (fieldName === 'HBillStatus') return 100;
                                if (fieldType === 'DateTime') return 160;
                                if (fieldType === 'Decimal' || fieldType === 'Double' || fieldType === 'Float') return 120;
                                if (fieldType === 'Int32' || fieldType === 'Int64' || fieldType === 'Integer') return 100;
                                return 150;
                            }

                            // èŽ·å–对齐方式
                            function getAlignForField(fieldType) {
                                if (fieldType === 'Decimal' || fieldType === 'Double' || fieldType === 'Float' ||
                                    fieldType === 'Int32' || fieldType === 'Int64' || fieldType === 'Integer') {
                                    return 'right';
                                }
                                return 'center';
                            }

                            // æž„建列配置
                            // æž„建列配置
                            for (var i = 0; i < columnData.length; i++) {
                                var colItem = columnData[i];
                                var columnTitle = colItem.chineseTitle;
                                var fieldName = colItem.id;
                                var fieldType = colItem.Type;
                                var columnTitle = getColumnChineseTitle(fieldName); // è¿™é‡Œé‡å¤äº†ï¼Œåˆ é™¤è¿™ä¸€è¡Œ

                                var columnConfig = {
                                    field: fieldName,
                                    title: columnTitle,  // ç¡®ä¿ä½¿ç”¨ä¸­æ–‡æ ‡é¢˜
                                    align: getAlignForField(fieldType),
                                    sort: true,
                                    width: getWidthForField(fieldName, fieldType)
                                };


                                // è®¾ç½®æ¨¡æ¿å‡½æ•°
                                var templetFunc = createTempletFunction(fieldName, fieldType);
                                if (templetFunc) {
                                    columnConfig.templet = templetFunc;
                                }

                                // è®¾ç½®äº‹ä»¶
                                var event = getEventForField(fieldName);
                                if (event) {
                                    columnConfig.event = event;
                                }

                                col.push(columnConfig);
                            }

                            console.log("构建的列配置数量:", col.length);
                            // è°ƒè¯•ï¼šæ˜¾ç¤ºå‰å‡ ä¸ªåˆ—的配置
                            for (var j = 0; j < Math.min(5, col.length); j++) {
                                console.log(`列${j}: field=${col[j].field}, title=${col[j].title}, templet=${typeof col[j].templet}`);
                            }

                            // æ­¥éª¤3：处理表格数据
                            var tableData = data1.data || [];
                            console.log("原始数据条数:", tableData.length);

                            // è°ƒè¯•ï¼šæ˜¾ç¤ºå‰å‡ è¡Œæ•°æ®çš„所有字段
                            if (tableData.length > 0) {
                                console.log("=== ç¬¬ä¸€è¡Œæ•°æ®å®Œæ•´ç»“æž„ ===");
                                var firstRow = tableData[0];
                                for (var key in firstRow) {
                                    console.log(`${key}: ${firstRow[key]} (类型: ${typeof firstRow[key]})`);
                                }
                            }

                            // å¦‚果是主表列表，按单据号去重
                            if (tableData.length > 0 && tableData[0].HBillNo) {
                                var uniqueMap = {};
                                var uniqueList = [];

                                for (var k = 0; k < tableData.length; k++) {
                                    var row = tableData[k];
                                    var billNo = row.HBillNo;

                                    if (!uniqueMap[billNo]) {
                                        uniqueMap[billNo] = true;
                                        uniqueList.push(row);
                                    }
                                }

                                tableData = uniqueList;
                                console.log("去重后数据条数:", tableData.length);
                            }

                            // æ­¥éª¤4：配置并渲染表格
                            option.cols = [col];
                            option.data = tableData;

                            console.log("option é…ç½®:", {
                                colsLength: option.cols[0].length,
                                dataLength: option.data.length
                            });

                            // åˆ—设置
                            // ä¿®æ”¹ get_Display å‡½æ•°ä¸­çš„列设置部分
                            // åˆ—设置
                            // åˆ—设置
                            if (typeof DisPlay_HideColumn === 'function') {
                                // å…ˆä¿å­˜åŽŸå§‹åˆ—配置（中文标题）
                                var originalCols = [];
                                for (var i = 0; i < col.length; i++) {
                                    originalCols.push({
                                        field: col[i].field,
                                        title: col[i].title,
                                        align: col[i].align,
                                        sort: col[i].sort,
                                        width: col[i].width,
                                        templet: col[i].templet,
                                        event: col[i].event
                            //在列表左边添加勾选框
                            col.push({ type: 'checkbox', fixed: 'left' });
                            for (var i = 0; i < data.length; i++) {
                                // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                                if ($.inArray(data[i].name, titleData) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                } else if ($.inArray(data[i].name, totalArray) > -1) { //计算列  
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, totalRow: true, width: 120 });
                                } else if (data[i].name == '单据号') {//添加超链接
                                    col.push({
                                        field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: '单据号', templet: function (d) {
                                            return '<span style="color: blue;">' + d.单据号 + '</span>'
                                        }, style: 'cursor: pointer;'
                                    });
                                } else {
                                    switch (data[i].Type) {
                                        //int
                                        case 'DateTime':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 120 });
                                            break;
                                        case 'long':
                                        case 'Int32':
                                        case 'Int64':
                                        case 'double':
                                        case 'Decimal':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 120, totalRow: true });
                                            break;
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 120 });
                                    }
                                }

                                // æ‰§è¡Œåˆ—设置
                                DisPlay_HideColumn(HModName, sessionStorage["HUserName"], option);

                                // å¼ºåˆ¶æ‰§è¡Œä¸­æ–‡æ ‡é¢˜æ¢å¤
                                setTimeout(function () {
                                    if (option.cols && option.cols[0]) {
                                        var currentCols = option.cols[0];
                                        for (var i = 0; i < currentCols.length; i++) {
                                            var currentCol = currentCols[i];
                                            if (currentCol.field && currentCol.field !== 'LAY_CHECKED' && currentCol.field !== 'checkbox') {
                                                // æŸ¥æ‰¾åŽŸå§‹é…ç½®ä¸­çš„中文标题
                                                for (var j = 0; j < originalCols.length; j++) {
                                                    if (originalCols[j].field === currentCol.field) {
                                                        currentCol.title = originalCols[j].title;
                                                        break;
                                                    }
                                                }
                                            }
                                        }
                                    }

                                    // é‡æ–°æ¸²æŸ“表格
                                    try {
                                        table.render(option);
                                        console.log("表格已重新渲染，列标题强制为中文");
                                    } catch (e) {
                                        console.error("表格渲染错误:", e);
                                    }
                                }, 200);
                            }

                            // é‡æ–°åˆå§‹åŒ–下拉框
                            ColFilter();
                            option.cols = [col];
                            option.data = data1.data;
                            //刷新表格数据
                            DisPlay_HideColumn(HModName, sessionStorage["HUserName"], option, titleData)
                            ins = table.render(option);

                            // æ¸²æŸ“表格
                            // æ¸²æŸ“表格
                            try {
                                // å…ˆé”€æ¯æ—§çš„表格
                                var mainTable = table.render(option);
                                console.log("表格渲染成功");

                                // æµ‹è¯•ï¼šæ£€æŸ¥è¡¨æ ¼æ•°æ®
                                var tableCache = table.cache.mainTable;
                                if (tableCache && tableCache.length > 0) {
                                    console.log("表格缓存第一行数据:");
                                    var cacheRow = tableCache[0];
                                    console.log("HBillNo:", cacheRow.HBillNo);
                                    console.log("HDate:", cacheRow.HDate);
                                    console.log("TotalCoefficient:", cacheRow.TotalCoefficient);
                                }
                            } catch (e) {
                                console.error("表格渲染错误:", e);
                                layer.msg("表格渲染失败: " + e.message, { icon: 5 });
                            }
                            //刷新按钮显示
                            Display_HideButton(set_HideButton_ID, HBillType, HModName, sessionStorage["HUserName"]);

                            layer.close(wait);

                            if (tableData.length > 0) {
                                layer.msg(`共 ${tableData.length} æ¡æ•°æ®`, { icon: 1, time: 2000 });
                            } else {
                                layer.msg("暂无数据", { icon: 3, time: 2000 });

                            if ($("#ColName option").length < 1) {
                                ColFilter();
                            }

                        } else {
                            console.warn("数据格式不正确或 list ä¸ºç©º");
                            layer.close(wait);
                            layer.msg("数据加载失败", { icon: 2 });
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                        }

                        
                    },
                    error: function (xhr, status, error) {
                        console.error("AJAX è¯·æ±‚错误:", error);
@@ -959,13 +583,13 @@

                // æ·»åŠ æ—¥æœŸæ¡ä»¶
                if (HMakeDate_Begin) {
                    sWhere += " and CONVERT(date, HMakeDate) >= '" + HMakeDate_Begin + "'";
                    sWhere += " and CONVERT(date, å•æ®æ—¥æœŸ) >= '" + HMakeDate_Begin + "'";
                }
                if (HMakeDate_End) {
                    sWhere += " and CONVERT(date, HMakeDate) <= '" + HMakeDate_End + "'";
                    sWhere += " and CONVERT(date, å•æ®æ—¥æœŸ) <= '" + HMakeDate_End + "'";
                }
                if (HBillNo) {
                    sWhere += " and HBillNo like '%" + HBillNo + "%'";
                    sWhere += " and å•æ®å· like '%" + HBillNo + "%'";
                }

                // ç§»é™¤å¼€å¤´çš„ "and "
@@ -1061,7 +685,6 @@
                            btn: ['确定'],
                            end: function () {
                                $("#btnSearch").trigger('click');
                                setTimeout(refreshTableWithChineseTitles, 200);
                            }
                        });
                    }
@@ -1079,7 +702,6 @@
                    btn: ['确定'],
                    end: function () {
                        $("#btnSearch").trigger('click');
                        setTimeout(refreshTableWithChineseTitles, 200);
                    }
                });
            }
@@ -1102,7 +724,6 @@
                            btn: ['确定'],
                            end: function () {
                                $("#btnSearch").trigger('click');
                                setTimeout(refreshTableWithChineseTitles, 200);
                            }
                        });
                    }
@@ -1129,7 +750,6 @@
                                if (result.code === "1") {
                                    layer.msg("删除成功！", { time: 1000, icon: 1 }, function () {
                                        $("#btnSearch").trigger('click');
                                        setTimeout(refreshTableWithChineseTitles, 200);
                                    });
                                } else {
                                    layer.msg(result.Message || "删除失败", { icon: 2 });
@@ -1174,7 +794,6 @@
                            if (result.code === "1") {
                                layer.msg(result.Message || (num === 1 ? "审核成功" : "反审核成功"), { time: 1000, icon: 1 }, function () {
                                    $("#btnSearch").trigger('click');
                                    setTimeout(refreshTableWithChineseTitles, 200);
                                });
                            } else {
                                layer.msg(result.Message || "操作失败", { icon: 2 });
@@ -1189,34 +808,7 @@
                }
            }
            //#endregion
            function refreshTableWithChineseTitles() {
                console.log("=== å¼€å§‹è®¾ç½®ä¸­æ–‡åˆ—标题 ===");

                // ç¡®ä¿åˆ—标题为中文
                if (option.cols && option.cols[0]) {
                    var cols = option.cols[0];
                    console.log("当前列数:", cols.length);

                    for (var i = 0; i < cols.length; i++) {
                        var col = cols[i];
                        if (col.field && col.field !== 'LAY_CHECKED' && col.field !== 'checkbox') {
                            var chineseTitle = getColumnChineseTitle(col.field);
                            if (chineseTitle && chineseTitle !== col.field) { // ç¡®ä¿ä¸æ˜¯å­—段名本身
                                col.title = chineseTitle;
                                console.log(`设置列标题: ${col.field} -> ${chineseTitle}`);
                            }
                        }
                    }
                }

                // é‡æ–°æ¸²æŸ“表格
                try {
                    table.render(option);
                    console.log("表格已重新渲染，列标题为中文");
                } catch (e) {
                    console.error("表格渲染错误:", e);
                }
            }
            

            function set_CloseBill(num) {
                var checkStatus = table.checkStatus('mainTable'),

 WebTM/views/ÖÊÁ¿¹ÜÀí/Ê×¼þ¼ìÑéµ¥/QC_FirstPieceCheckBillList2.html

@@ -704,7 +704,7 @@
            //#endregion

            //#region åˆ†é¡µæŸ¥è¯¢
            function get_DisplayPage(sWhere) {           
            function get_Display(sWhere) {           
                var ajaxLoad = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/QC_FirstPieceCheckBillMain/QC_FirstPieceCheckBillMainListPage',
@@ -905,7 +905,7 @@
                    }
                }
                //RoadHBillNo(sqlWhere);
                get_DisplayPage(sqlWhere);
                get_Display(sqlWhere);
            }
            //#endregion