1.工艺路线：复制、编辑 进入页面没有带出数据 原因：Gy_RoutingBillMain表缺少字段HBeginDate、HEndDate 处理方...

duhe

2024-09-02 42020c854d6087a5af50d97de658b57e55996939

 WebTM/views/³µ¼ä¹ÜÀí/±¨±í·ÖÎö/Kf_ProdProcessSumReport_DyeColor_third.html

@@ -370,49 +370,53 @@
                    }
                    com = " and (" + ColName + " " + com + ")";
                }

                var com1 = "";
                if (ColName1 != 0 && Comparator1 != 0) {
                    var com1 = "";
                    
                    switch (Comparator1) {
                        case "7":
                            com1 = "like'%" + ColContent1 + "%'";
                            com1 = "like ''%" + ColContent1 + "%''";
                            break;
                        case "8":
                            com1 = "like'%" + ColContent1 + "'";
                            com1 = "like ''%" + ColContent1 + "''";
                            break;
                        case "9":
                            com1 = "like'" + ColContent1 + "%'";
                            com1 = "like ''" + ColContent1 + "%''";
                            break;
                        case "10":
                            com1 = "not like'%" + ColContent1 + "%'";
                            com1 = "not like ''%" + ColContent1 + "%''";
                            break;
                        default:
                            com1 = "" + Comparator1 + "'" + ColContent1 + "'";
                            com1 = "" + Comparator1 + "''" + ColContent1 + "''";
                            break;
                    }
                    sWhere += " and " + ColName1 + " " + com1;
                    com1 = " and (" + ColName1 + " " + com1 + ")";
                }

                var com2 = "";
                if (ColName2 != 0 && Comparator2 != 0) {
                    var com2 = "";
                    
                    switch (Comparator2) {
                        case "7":
                            com2 = "like'%" + ColContent2 + "%'";
                            com2 = "like ''%" + ColContent2 + "%''";
                            break;
                        case "8":
                            com2 = "like'%" + ColContent2 + "'";
                            com2 = "like ''%" + ColContent2 + "''";
                            break;
                        case "9":
                            com2 = "like'" + ColContent2 + "%'";
                            com2 = "like ''" + ColContent2 + "%''";
                            break;
                        case "10":
                            com2 = "not like'%" + ColContent2 + "%'";
                            com2 = "not like ''%" + ColContent2 + "%''";
                            break;
                        default:
                            com2 = "" + Comparator + "'" + ColContent + "'";
                            com2 = "" + Comparator2 + "''" + ColContent2 + "''";
                            break;
                    }
                    sWhere += " and " + ColName2 + " " + com2;
                    com2 = " and (" + ColName2 + " " + com2 + ")";
                }
                com += com + com1 + com2;
                com = com + com1 + com2;

                //根据用户过滤用户关联客户的记录
                var OtherSearch = getSWhereByHUser();
@@ -540,6 +544,7 @@
                var wait = layer.load();//遮罩
                $.ajax({
                    url: GetWEBURL() + '/ProdProcessSumReport/ProdProcessSumReport_DyeColor_third',
                    async:false,
                    type: "GET",
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"]  },
                    success: function (data1) {
@@ -680,48 +685,50 @@

                var com1 = "";
                if (ColName1 != 0 && Comparator1 != 0) {

                    switch (Comparator1) {
                        case "7":
                            com1 = "like'%" + ColContent1 + "%'";
                            com1 = "like ''%" + ColContent1 + "%''";
                            break;
                        case "8":
                            com1 = "like'%" + ColContent1 + "'";
                            com1 = "like ''%" + ColContent1 + "''";
                            break;
                        case "9":
                            com1 = "like'" + ColContent1 + "%'";
                            com1 = "like ''" + ColContent1 + "%''";
                            break;
                        case "10":
                            com1 = "not like'%" + ColContent1 + "%'";
                            com1 = "not like ''%" + ColContent1 + "%''";
                            break;
                        default:
                            com1 = "" + Comparator1 + "'" + ColContent1 + "'";
                            com1 = "" + Comparator1 + "''" + ColContent1 + "''";
                            break;
                    }
                    sWhere += " and " + ColName1 + " " + com1;
                    com1 = " and (" + ColName1 + " " + com1 + ")";
                }

                var com2 = "";
                if (ColName2 != 0 && Comparator2 != 0) {

                    switch (Comparator2) {
                        case "7":
                            com2 = "like'%" + ColContent2 + "%'";
                            com2 = "like ''%" + ColContent2 + "%''";
                            break;
                        case "8":
                            com2 = "like'%" + ColContent2 + "'";
                            com2 = "like ''%" + ColContent2 + "''";
                            break;
                        case "9":
                            com2 = "like'" + ColContent2 + "%'";
                            com2 = "like ''" + ColContent2 + "%''";
                            break;
                        case "10":
                            com2 = "not like'%" + ColContent2 + "%'";
                            com2 = "not like ''%" + ColContent2 + "%''";
                            break;
                        default:
                            com2 = "" + Comparator + "'" + ColContent + "'";
                            com2 = "" + Comparator2 + "''" + ColContent2 + "''";
                            break;
                    }
                    sWhere += " and " + ColName2 + " " + com2;
                    com2 = " and (" + ColName2 + " " + com2 + ")";
                }
                com += com + com1 + com2;
                com = com + com1 + com2;

                //根据用户过滤用户关联客户的记录
                var OtherSearch = getSWhereByHUser();
@@ -838,6 +845,7 @@
                ColFilter();
                $.ajax({
                    url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
                    async:false,
                    type: "GET",
                    data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
                    success: function (data1) {