我的工单

yusijie

2024-01-30 7c212209203b9939e17edc34b48e344142d3a84d

我的工单

 WebTM/WebTM.csproj

@@ -306,6 +306,7 @@
    <Content Include="views\基础资料\公用基础资料\Gy_MaterTypeEdit.html" />
    <Content Include="views\基础资料\公用基础资料\Gy_TemporaryArea.html" />
    <Content Include="views\基础资料\公用基础资料\HBarPlanPrint_GXPG.html" />
    <Content Include="views\基础资料\公用基础资料\xmlLBM_Sc_MyTicke.aspx" />
    <Content Include="views\基础资料\公用基础资料\xmlPM_ProjectBillMainMy.aspx" />
    <Content Include="views\基础资料\公用基础资料\xmlLBM_Kf_SellOutBillList.aspx" />
    <Content Include="views\基础资料\公用基础资料\xmlLBM_Kf_SellOutBillList_BarCodeNote.aspx" />
@@ -670,6 +671,7 @@
    <Content Include="views\grf\生产订单领料状态报表.grf" />
    <Content Include="views\grf\退料通知单.grf" />
    <Content Include="views\grf\我的项目.grf" />
    <Content Include="views\grf\我的工单.grf" />
    <None Include="Web.Debug.config">
      <DependentUpon>Web.config</DependentUpon>
    </None>
@@ -1747,6 +1749,13 @@
    <Compile Include="views\基础资料\公用基础资料\xmlLBM_EquipTypeBill.aspx.designer.cs">
      <DependentUpon>xmlLBM_EquipTypeBill.aspx</DependentUpon>
    </Compile>
    <Compile Include="views\基础资料\公用基础资料\xmlLBM_Sc_MyTicke.aspx.cs">
      <DependentUpon>xmlLBM_Sc_MyTicke.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="views\基础资料\公用基础资料\xmlLBM_Sc_MyTicke.aspx.designer.cs">
      <DependentUpon>xmlLBM_Sc_MyTicke.aspx</DependentUpon>
    </Compile>
    <Compile Include="views\基础资料\公用基础资料\xmlPM_ProjectBillMainMy.aspx.cs">
      <DependentUpon>xmlPM_ProjectBillMainMy.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>

 WebTM/views/grf/ÎҵŤµ¥.grf

New file
@@ -0,0 +1,242 @@
{
    "Version":"6.8.2.5",
    "Title":"1a.简单表格",
    "Author":"锐浪报表软件",
    "Description":"演示一个最基本的列表报表。",
    "Font":{
        "Name":"宋体",
        "Size":90000,
        "Weight":400,
        "Charset":134
    },
    "Printer":{
        "LeftMargin":1,
        "TopMargin":1,
        "RightMargin":1,
        "BottomMargin":1
    },
    "DetailGrid":{
        "FixCols":20,
        "AppendBlankRow":true,
        "AppendBlankRowAtLast":true,
        "AppendBlankCol":true,
        "AppendBlankColWidth":40,
        "GrowToBottom":true,
        "Recordset":{
            "Field":[
                {
                    "Name":"排产日期"
                },
                {
                    "Name":"生产订单号"
                },
                {
                    "Name":"生产状态"
                },
                {
                    "Name":"生产订单数量"
                },
                {
                    "Name":"当日计划数量"
                },
                {
                    "Name":"已汇报数量"
                },
                {
                    "Name":"生产资源"
                },
                {
                    "Name":"物料代码"
                },
                {
                    "Name":"物料名称"
                },
                {
                    "Name":"规格型号"
                }
            ]
        },
        "Column":[
            {
                "Name":"Column1",
                "Width":2.77813
            },
            {
                "Name":"Column2",
                "Width":2.80458
            },
            {
                "Name":"Column3",
                "Width":2.77813
            },
            {
                "Name":"Column4",
                "Width":2.80458
            },
            {
                "Name":"Column5",
                "Width":2.80458
            },
            {
                "Name":"Column6",
                "Width":2.80458
            },
            {
                "Name":"Column7",
                "Width":3.38667
            },
            {
                "Name":"Column8",
                "Width":2.59292
            },
            {
                "Name":"Column9",
                "Width":3.20146
            },
            {
                "Name":"Column10",
                "Width":4.20688
            }
        ],
        "ColumnContent":{
            "Height":0.608542,
            "ColumnContentCell":[
                {
                    "Column":"Column1",
                    "DataField":"排产日期"
                },
                {
                    "Column":"Column2",
                    "DataField":"生产订单号"
                },
                {
                    "Column":"Column3",
                    "DataField":"生产状态"
                },
                {
                    "Column":"Column4",
                    "DataField":"生产订单数量"
                },
                {
                    "Column":"Column5",
                    "DataField":"当日计划数量"
                },
                {
                    "Column":"Column6",
                    "DataField":"已汇报数量"
                },
                {
                    "Column":"Column7",
                    "DataField":"生产资源"
                },
                {
                    "Column":"Column8",
                    "DataField":"物料代码"
                },
                {
                    "Column":"Column9",
                    "DataField":"物料名称"
                },
                {
                    "Column":"Column10",
                    "DataField":"规格型号"
                }
            ]
        },
        "ColumnTitle":{
            "Height":0.608542,
            "ColumnTitleCell":[
                {
                    "GroupTitle":false,
                    "Column":"Column1",
                    "TextAlign":"TopCenter",
                    "Text":"排产日期"
                },
                {
                    "GroupTitle":false,
                    "Column":"Column2",
                    "TextAlign":"TopCenter",
                    "Text":"生产订单号"
                },
                {
                    "GroupTitle":false,
                    "Column":"Column3",
                    "TextAlign":"TopCenter",
                    "Text":"生产状态"
                },
                {
                    "GroupTitle":false,
                    "Column":"Column4",
                    "TextAlign":"TopCenter",
                    "Text":"生产订单数量"
                },
                {
                    "GroupTitle":false,
                    "Column":"Column5",
                    "TextAlign":"TopCenter",
                    "Text":"当日计划数量"
                },
                {
                    "GroupTitle":false,
                    "Column":"Column6",
                    "TextAlign":"TopCenter",
                    "Text":"已汇报数量"
                },
                {
                    "GroupTitle":false,
                    "Column":"Column7",
                    "TextAlign":"TopCenter",
                    "Text":"生产资源"
                },
                {
                    "GroupTitle":false,
                    "Column":"Column8",
                    "TextAlign":"TopCenter",
                    "Text":"物料代码"
                },
                {
                    "GroupTitle":false,
                    "Column":"Column9",
                    "TextAlign":"TopCenter",
                    "Text":"物料名称"
                },
                {
                    "GroupTitle":false,
                    "Column":"Column10",
                    "TextAlign":"TopCenter",
                    "Text":"规格型号"
                }
            ]
        }
    },
    "ReportHeader":[
        {
            "Name":"ReportHeader2",
            "Height":2.01083,
            "Control":[
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox1",
                    "Left":12.8058,
                    "Top":0.608542,
                    "Width":2.80458,
                    "Height":0.582083,
                    "Font":{
                        "Name":"宋体",
                        "Size":157500,
                        "Weight":400,
                        "Charset":134
                    },
                    "TextAlign":"MiddleCenter",
                    "Text":"我的工单"
                }
            ]
        }
    ],
    "ReportFooter":[
        {
            "Name":"ReportFooter1",
            "Height":1.79917
        }
    ]
}

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/HBarPlanPrint.html

@@ -242,6 +242,9 @@
                var ListTrue = value.split('|');
                CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlPM_ProjectBillMainMy.aspx?linterid=" + ListTrue[0] + "&Num=" + ListTrue[1], true, "");
                break;
            case "Sc_MyTicketList": //我的工单
                CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_Sc_MyTicke.aspx?linterid=" + value, true, "");
                break;
        }
    </script>
</body>

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/xmlLBM_Sc_MyTicke.aspx

New file
@@ -0,0 +1,28 @@
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="xmlLBM_Sc_MyTicke.aspx.cs" Inherits="WebTM.views.基础资料.公用基础资料.xmlLBM_Sc_MyTicke" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
     <script runat="server"> 
    protected void Page_Load(object sender, EventArgs e)
    {
        //★特别提示★：
        //不同的数据库应该选用不同的报表XML数据生成类，SQL Server数据库用SqlXMLReportData，Oracle数据库用OracleXMLReportData
        //OledbXMLReportData适合于Access等本地数据库，为了演示方便，这里从Grid++Report的Access例子数据库中获取报表数据

        //OledbXMLReportData.GenOneRecordset(this, "select * from Customers order by CustomerID");
        //SqlXMLReportData.GenOneRecordset(this, "select * from h_v_Kf_POStockInBillList_K3 where hmainid=1781");
      SqlXMLReportData.GenOneRecordset(this,  "select * from h_v_Sc_ICMOBillStatus_TmpList where HInterID in (" + Request.Params["linterid"] + ")" );
    }
</script>
</head>
<body>
    <form id="form1" runat="server">
        <div>
        </div>
    </form>
</body>
</html>

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/xmlLBM_Sc_MyTicke.aspx.cs

New file
@@ -0,0 +1,17 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace WebTM.views.基础资料.公用基础资料
{
    public partial class xmlLBM_Sc_MyTicke : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }
    }
}

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/xmlLBM_Sc_MyTicke.aspx.designer.cs

New file
@@ -0,0 +1,26 @@
//------------------------------------------------------------------------------
// <自动生成>
//     æ­¤ä»£ç ç”±å·¥å…·ç”Ÿæˆã€‚
//
//     å¯¹æ­¤æ–‡ä»¶çš„更改可能导致不正确的行为，如果
//     é‡æ–°ç”Ÿæˆä»£ç ï¼Œåˆ™æ‰€åšæ›´æ”¹å°†ä¸¢å¤±ã€‚
// </自动生成>
//------------------------------------------------------------------------------

namespace WebTM.views.基础资料.公用基础资料
{


    public partial class xmlLBM_Sc_MyTicke
    {

        /// <summary>
        /// form1 æŽ§ä»¶ã€‚
        /// </summary>
        /// <remarks>
        /// è‡ªåŠ¨ç”Ÿæˆçš„字段。
        /// è‹¥è¦è¿›è¡Œä¿®æ”¹ï¼Œè¯·å°†å­—段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlForm form1;
    }
}

 WebTM/views/Éú²ú¹ÜÀí/¹¤µ¥/Sc_MyTicketList.html

@@ -28,15 +28,15 @@
                        <div style="padding: 10px; ">
                            <button type="button" class="layui-btn layui-btn-normal" lay-submit="" style="display:none;" id="btn_view" lay-filter="btn_view">预览</button>
                            <button type="button" class="layui-btn layui-btn-normal" lay-submit="" style="display:none;" id="btn_refresh" lay-filter="btn_refresh">刷新</button>
                            <button type="button" class="layui-btn layui-btn-normal" lay-submit="" style="display:none;" id="btn_view" lay-filter="btn_start">开工</button>
                            <button type="button" class="layui-btn layui-btn-normal" lay-submit="" style="display:none;" id="btn_view" lay-filter="btn_report">汇报</button>
                            <button type="button" class="layui-btn layui-btn-normal" lay-submit="" style="display:none;" id="btn_start" lay-filter="btn_start">开工</button>
                            <button type="button" class="layui-btn layui-btn-normal" lay-submit="" style="display:none;" id="btn_report" lay-filter="btn_report">汇报</button>
                            <button type="button" class="layui-btn layui-btn-normal" lay-submit="" style="display:none;" id="get_Exit" lay-filter="get_Exit">退出</button>
                        </div>
                        <div class="layui-tab layui-tab-card" style="margin-top:20px;">
                        <div class="layui-tab layui-tab-card" style="margin-top:20px;" lay-filter="tab-TabTest">
                            <ul class="layui-tab-title">
                                <li class="layui-this">未开工</li>
                                <li>已完工</li>
                                <li>正在生产</li>
                                <li lay-id="1" class="layui-this">未开工</li>
                                <li lay-id="2">已完工</li>
                                <li lay-id="3">正在生产</li>
                            </ul>
                            <div class="layui-tab-content">
                                <div class="layui-tab-item layui-show">
@@ -83,8 +83,8 @@
            var option_finish = ""; //已完工
            var option_proc = ""; //正在生产
            var ins;


            var TableTab = "mainTable_notStart";  //初始化页面时默认为 â€œæœªå¼€å·¥â€ é¡µç­¾
            var cur_title = "未开工"; //当前选中页签
            //#endregion

            //#region è¿›å…¥é¡µé¢å³åŠ è½½
@@ -92,7 +92,7 @@
            //
            var HModName = "Sc_MyTicketList";
            //不需要显示的字段 å¯æ‰©å±• ï¼ˆæˆ‘主导的）
            var titleData = ["HInterID","HEntryID"];
            var titleData = ["HInterID","HEntryID","HSourceID","HMaterID","HDeptID","源单子内码","源单类型","单据类型"];
            //初始化界面
            set_ClearBill();
            //#endregion
@@ -103,10 +103,39 @@
                get_print();
            });

            //开工
            form.on('submit(btn_start)', function (data) {
                get_start();
            });

            //汇报
            form.on('submit(btn_report)', function (data) {
                get_report();
            });

            //退出
            form.on('submit(get_Exit)', function (data) {
                Pub_Close(2);
            });

            //刷新
            form.on('submit(btn_refresh)', function (data) {
                get_Refresh();
            });

            
            //监听当前处于哪一个页签，传 HModName å€¼
            element.on('tab(tab-TabTest)', function (data) {
                HMaterInfo = table.cache['mainTable'];
                cur_title = data.elem.context.innerText;
                if (cur_title == "未开工") {
                    TableTab = "mainTable_notStart";
                } else if (cur_title == "已完工") {
                    TableTab = "mainTable_finish";
                } else if (cur_title == "正在生产") {
                    TableTab = "mainTable_proc";
                }
            })
            //#endregion

            //#region æœ¬é¡µé¢æ‰€æœ‰è¢«è°ƒç”¨çš„方法
@@ -130,7 +159,7 @@

            //初始化未开工列表
            function set_InitGrid_notStart() {
                option = {
                option_notStart = {
                    elem: '#mainTable_notStart'
                    , toolbar: '#toolbarDemo'
                    , page: true
@@ -145,7 +174,7 @@

            //初始化已完工列表
            function set_InitGrid_finish() {
                option2 = {
                option_finish = {
                    elem: '#mainTable_finish'
                    , page: false
                    , height: 500
@@ -157,7 +186,7 @@

            //初始化正在生产列表
            function set_InitGrid_proc() {
                option2 = {
                option_proc = {
                    elem: '#mainTable_proc'
                    , page: false
                    , height: 500
@@ -173,10 +202,10 @@
                var ajaxLoad = layer.load();

                $.ajax({
                    url: GetWEBURL() + '/PM_ReportController/PM_ProjectBillMYList',
                    url: GetWEBURL() + '/Sc_MyTicket/list',
                    type: "GET",
                    async: false,
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                    data: { "HSourceID": sessionStorage["HSourceID"], "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.count == 1) {
                            var data = [];
@@ -205,38 +234,53 @@
                            }

                            //动态显示列名
                            option = {
                                elem: '#mainTable'
                            option_notStart = {
                                elem: '#mainTable_notStart'
                                , toolbar: '#toolbarDemo'
                                , cols: [col]
                                , data: data1.data.h_p_My_PM_ProjectReportBill
                                , data: data1.data.h_p_Sc_MyICMOWorkBill
                                , height: 'full-80'
                                , page: true
                                , limits: [50, 500, 5000, 50000]
                                , limit: 50
                                , cellMinWidth: 90
                            }
                            table.render(option);
                            ins = table.render(option);
                            option1 = {
                                elem: '#mainTable1'
                            table.render(option_notStart);
                            ins = table.render(option_notStart);

                            option_finish = {
                                elem: '#mainTable_finish'
                                , toolbar: '#toolbarDemo'
                                , cols: [col]
                                , data: data1.data.h_p_My_PM_ProjectReportBill1
                                , data: data1.data.h_p_Sc_MyICMOWorkBill1
                                , height: 'full-80'
                                , page: true
                                , limits: [50, 500, 5000, 50000]
                                , limit: 50
                                , cellMinWidth: 90
                            }
                            table.render(option1);
                            table.render(option_finish);

                            option_proc = {
                                elem: '#mainTable_proc'
                                , toolbar: '#toolbarDemo'
                                , cols: [col]
                                , data: data1.data.h_p_Sc_MyICMOWorkBill2
                                , height: 'full-80'
                                , page: true
                                , limits: [50, 500, 5000, 50000]
                                , limit: 50
                                , cellMinWidth: 90
                            }
                            table.render(option_proc);

                            //刷新按钮显示
                            var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                            var HBillType = "PM_ProjectBillMainMy";
                            var HBillType = "我的工单";
                            Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);

                            //刷新表格数据
                            DisPlay_HideColumn();
                            //DisPlay_HideColumn();

                            layer.close(ajaxLoad);
                            if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
@@ -257,20 +301,109 @@
            }
            //#endregion


            //#region åˆ·æ–°
            function get_Refresh() {
                get_FastQuery();
            }
            //#endregion

            //#region å¼€å·¥
            function get_start() {                
                var checkStatus = table.checkStatus("mainTable_notStart")
                    , data = checkStatus.data;

                if (data.length == 1) {
                    layer.open({
                        type: 2,
                        skin: 'layui-layer-rim', //加上边框
                        title: '新增开工单',
                        closeBtn: 1,
                        shift: 2,
                        area: ['100%', '100%'],
                        maxmin: true,
                        content: '../../生产管理/生产开工单/Sc_Add_MESBeginWorkBillList.html?OperationType=2&linterid=&HSouceBillType=',
                        end: function () {

                        },
                        success: function (dom, index) {
                            var deliverData = [];
                            deliverData.push({
                                "HBillType": data[0].单据类型,
                                "HSourceInterID": data[0].HInterID,
                                "HSourceEntryID": data[0].源单子内码,
                                "HSourceBillNo": data[0].源单单号,
                                "HSourceBillType": data[0].源单类型
                            });

                            //通过索引获取到当前iframe弹出层
                            var iframe = window['layui-layer-iframe' + index];
                            //调用iframe弹出层内的方法
                            iframe.edit(deliverData);
                        }
                    });
                } else {
                    layer.msg('请在 æœªå¼€å·¥ é¡µç­¾ä¸­é€‰æ‹©ä¸€è¡Œæ•°æ®å¼€å·¥ï¼');
                }                
            }
            //#endregion

            //#region æ±‡æŠ¥
            function get_report() {
                var checkStatus = table.checkStatus("mainTable_proc")
                    , data = checkStatus.data;

                if (data.length == 1) {
                    layer.open({
                        type: 2,
                        skin: 'layui-layer-rim', //加上边框
                        title: '新增产量汇报单',
                        closeBtn: 1,
                        shift: 2,
                        area: ['100%', '100%'],
                        maxmin: true,
                        content: '../../生产管理/产量汇报单/Sc_Add_ProductReportBillList.html?OperationType=2&linterid=&HSouceBillType=',
                        end: function () {

                        },
                        success: function (dom, index) {
                            var deliverData = [];
                            deliverData.push({
                                "HBillType": data[0].单据类型,
                                "HSourceInterID": data[0].HInterID,
                                "HSourceEntryID": data[0].源单子内码,
                                "HSourceBillNo": data[0].源单单号,
                                "HSourceBillType": data[0].源单类型
                            });

                            //通过索引获取到当前iframe弹出层
                            var iframe = window['layui-layer-iframe' + index];
                            //调用iframe弹出层内的方法
                            iframe.edit(deliverData);
                        },
                    });
                } else {
                    layer.msg('请在 æ­£åœ¨ç”Ÿäº§ é¡µç­¾ä¸­é€‰æ‹©ä¸€è¡Œæ•°æ®å¼€å·¥ï¼');
                }                  
            }
            //#endregion
            
            //#region é¢„览
            function get_print() {
                var activeTab =getActiveTab();
                if (activeTab=="我主导的") {
                    var checkStatus = table.checkStatus('mainTable')
                        , data = checkStatus.data,
                        Num = 1;
                } else if (activeTab == "我参与的") {
                    var checkStatus = table.checkStatus('mainTable1')
                        , data = checkStatus.data,
                        Num = 2;
                var activeTab = getActiveTab();

                if (activeTab=="未开工") {
                    var checkStatus = table.checkStatus('mainTable_notStart')
                        , data = checkStatus.data;
                } else if (activeTab == "已完工") {
                    var checkStatus = table.checkStatus('mainTable_finish')
                        , data = checkStatus.data;
                } else if (activeTab == "正在生产"){
                    var checkStatus = table.checkStatus('mainTable_proc')
                        , data = checkStatus.data;
                }

                if (checkStatus.data.length == 1) {
                if (checkStatus.data.length > 0) {
                    var linterid = [];

                    for (var i = 0; i < data.length; i++) {
@@ -283,12 +416,12 @@
                        , shade: 0.6 //遮罩透明度
                        , maxmin: false //允许全屏最小化
                        , anim: 0 //0-6的动画形式，-1不开启
                        , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + linterid.toString() + "|" + Num + '&MyMsg=' + linterid.toString() + '&Type=PM_ProjectBillMainMy', 'yes']
                        , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + linterid.toString() + '&MyMsg=' + linterid.toString() + '&Type=Sc_MyTicketList', 'yes']
                        , resize: false
                    })
                }
                else {
                    layer.msg('请选择一行数据打印！');
                    layer.msg('请选择数据打印！');
                }
            }

@@ -438,11 +571,6 @@
            //#endregion
            //以上是layui模块
        });




    </script>

</body>
</html>