ModuleMaster/inv/itassetcheck.aspx - main - ivan/ModMas

ModuleMaster/inv/itassetcheck.aspx
253 строки13 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:4900d9fb6
<%@ Page Language="VB"
    AutoEventWireup="false"
    EnableEventValidation="false"
    CodeFile="itassetcheck.aspx.vb" Inherits="Inv_itassetcheck" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>IT Asset Check</title>
    <script src="../Scripts/jquery-1.9.1.min.js"></script>
    <style type="text/css">
        html {
            padding: 0px;
            margin: 0px;
            width: 100%;
            height: 100%;
        }

        body {
            padding: 0px;
            margin: 0px;
            width: 100%;
            height: 100%;
            background-color: black;
            font-family: Gulim, "Helvetica Neue", Helvetica, Arial, sans-serif, "BankGothic Md BT";
            font-size: 12pt !important;
        }

        form {
            padding: 0px;
            margin: 0px;
            width: 100%;
            height: 100%;
        }

        .fill {
            width: 100%;
            height: 100%;
        }
        .vfill90{
            height: 90%
        }
        .hfill100{
            width:100%;
        }

        .middle {
            margin: 0 auto;
        }

        .gray {
            background-color: gray;
        }

        .white {
            background-color: white;
        }

        .yellow {
            background-color: lightyellow;
        }

        .vhalf {
            height: 50%;
        }

        .half {
            width: 50%;
        }

        .hide {
            /*visibility: hidden;*/
            display: none;
        }

        .action {
            cursor: pointer;
        }

        .center {
            text-align: center;
            vertical-align: middle;
        }

        .auto-style1 {
            font-family: Gulim;
            font-size: xx-large;
            font-weight: bold;
        }
        .auto-style2 {
            color: #FFFFFF;
            font-size: xx-large;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
        <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
        <asp:AsyncFileUpload ID="FileUpload1" runat="server" class="hide" ClientIDMode="Static" OnClientUploadComplete="uploadComplete" />
        <div class="fill">
            <table class="fill">
                <tr>
                    <td class="half vhalf">
                        <div class="">
                            <div id="fuwrapper" class=""
                                onclick="document.getElementById('<%=FileUpload1.ClientID %>_ctl02').click()">
                                <asp:Image ID="Image1" ImageUrl="plus.png" runat="server" CssClass="" ClientIDMode="static" Height="485px" Width="911px" />
                            </div>

                        </div>
                    </td>
                    <td class="half vhalf">
                        <div class="yellow fill center">
                            <br />
                            <span class="auto-style1">
                                PIC: <asp:TextBox ID="inspector" runat="server"  Font-Size="24pt"></asp:TextBox><br />
                                <asp:Label runat="server" ID="assetid"></asp:Label><br />
                                <asp:Label runat="server" ID="assetdescr"></asp:Label><br />
                                <asp:Label runat="server" ID="assetsn"></asp:Label><br />
                                <asp:Label runat="server" ID="assetinvn"></asp:Label>
                                <asp:HiddenField ID="rowid" runat="server" Value="" ></asp:HiddenField>
                            </span>
                            <br />
                            <asp:RadioButtonList ID="checkresult" runat="server" RepeatDirection="Horizontal" CssClass="middle" Font-Size="XX-Large" Font-Bold="true">
                                <asp:ListItem Selected="True">OK</asp:ListItem>
                                <asp:ListItem>NG</asp:ListItem>
                            </asp:RadioButtonList>
                            <br />
                            <asp:TextBox runat="server" ID="remark" TextMode="MultiLine" Font-Size="24pt" Height="149px" Width="696px"></asp:TextBox><br />
                            <asp:Button runat="server" ID="save" Text="SAVE" Font-Size="X-Large" Height="115px" Width="233px" />
                        </div>
                    </td>
                </tr>
                <tr>
                    <td colspan="2" class="vhalf center"><span class="auto-style2">DEPARTMENT:</span> 
                        <asp:DropDownList runat="server" ID="department"
                            CssClass="middle auto-style1" AutoPostBack="True"
                            DataSourceID="departmentlist"
                            DataTextField="DEPARTMENT"
                            DataValueField="DEPARTMENT">
                        </asp:DropDownList><span class="auto-style2">ASSET TYPE: </span>
                        <asp:DropDownList ID="ASSET_TYPE" runat="server"
                              CssClass="middle auto-style1" AutoPostBack="True" DataSourceID="assettypelist" DataTextField="text" DataValueField="value">
                        </asp:DropDownList>
                        <asp:SqlDataSource ID="assettypelist" runat="server" ConnectionString="<%$ ConnectionStrings:SERKIntranetConnectionString %>" SelectCommand="
                            select 'ALL' as text, '%' as value  union all 
                            select distinct [TYPE], [TYPE]
                             from UserModules.[User].[IT_ASSET_LIST]
where department = @department 
and id in (select asset_id from UserModules.[User].IT_ASSET_INVENTORY)">
                            <SelectParameters>
                                <asp:ControlParameter ControlID="department" Name="department" PropertyName="SelectedValue" />
                            </SelectParameters>
                        </asp:SqlDataSource>
                        <span class="auto-style2">PIC: </span>
                        <asp:DropDownList ID="PIC" runat="server"
                              CssClass="middle auto-style1" AutoPostBack="True" DataSourceID="piclist" DataTextField="text" DataValueField="value">
                        </asp:DropDownList>
                        <asp:SqlDataSource ID="piclist" runat="server" ConnectionString="<%$ ConnectionStrings:SERKIntranetConnectionString %>" SelectCommand="
                                 select 'ALL' as text, '%' as value  union all 
                            select distinct [OWNER], [OWNER] from UserModules.[User].[IT_ASSET_LIST]
where department = @department 
and [type] like '%' + @type + '%'
and id in (select asset_id from UserModules.[User].IT_ASSET_INVENTORY)">
                            <SelectParameters>
                                <asp:ControlParameter ControlID="department" Name="department" PropertyName="SelectedValue" />
                                <asp:ControlParameter ControlID="ASSET_TYPE" Name="type" PropertyName="SelectedValue" />
                            </SelectParameters>
                        </asp:SqlDataSource>
                        <div class="vfill90 hfill100 center" style="overflow-y: scroll;">

                            <asp:SqlDataSource ID="departmentlist" runat="server"
                                ConnectionString="<%$ ConnectionStrings:ModMas%>" SelectCommand="select distinct DEPARTMENT from UserModules.[User].[IT_ASSET_LIST]
order by department "></asp:SqlDataSource>
                            <asp:GridView runat="server" ID="ASSETLIST" CssClass="fill"
                                CellPadding="4" Font-Size="14pt" ForeColor="#333333" GridLines="None" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="assetlistds" DataKeyNames="id1">
                                <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                                <Columns>
                                    <asp:BoundField DataField="id" HeaderText="id" SortExpression="id" />
                                    <asp:BoundField DataField="Type" HeaderText="Type" SortExpression="Type" />
                                    <asp:BoundField DataField="Model" HeaderText="Model" SortExpression="Model" />
                                    <asp:BoundField DataField="SN" HeaderText="SN" SortExpression="SN" />
                                    <asp:BoundField DataField="Inv. number" HeaderText="Inv. number" SortExpression="Inv. number" />
                                    <asp:BoundField DataField="Check date" HeaderText="Check date" SortExpression="Check date" />
                                    <asp:BoundField DataField="Check result" HeaderText="Check result" SortExpression="Check result" />
                                    <asp:BoundField DataField="Remark" HeaderText="Remark" SortExpression="Remark" />
                                    <asp:BoundField DataField="PIC" HeaderText="PIC" ReadOnly="True" SortExpression="PIC" />
                                    <asp:BoundField DataField="Check period" HeaderText="Check period" SortExpression="Check period" />
                                    <asp:BoundField DataField="Photo" HeaderText="Photo" SortExpression="Photo" />
                                    <asp:BoundField DataField="id1" HeaderText="id1" InsertVisible="False" ReadOnly="True" SortExpression="id1" Visible="true" />
                                </Columns>
                                <EditRowStyle BackColor="#999999" />
                                <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                                <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                                <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                                <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                                <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                                <SortedAscendingCellStyle BackColor="#E9E7E2" />
                                <SortedAscendingHeaderStyle BackColor="#506C8C" />
                                <SortedDescendingCellStyle BackColor="#FFFDF8" />
                                <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
                            </asp:GridView>
                            <asp:SqlDataSource ID="assetlistds" runat="server" ConnectionString="<%$ ConnectionStrings:SERKIntranetConnectionString %>" SelectCommand="        select t1.asset_id as id
        , t2.TYPE as  [Type] 
        , t2.MODEL  as [Model]
        , t2.SERIAL_NUMBER  as [SN]
        , t2.INVENTORY_NUMBER as [Inv. number] 
        , t1.inventory_date as [Check date]
        , t1.result as [Check result]
        , t1.remark as [Remark]
        , t1.pic_singleid as PIC
        , t1.inventory_period as [Check period] 
        ,  (SELECT MAX(ID) FROM UserModulesAttachments.[user].it_asset_inventory WHERE parentid = t1.id and [type]='PHOTO' AND DELETED='N' ) as Photo 
         , t1.id
        from UserModules.[User].[IT_ASSET_INVENTORY] t1 
        left join UserModules.[User].[IT_ASSET_LIST] t2 
        on t1.asset_id = t2.id 
        WHERE T2.DEPARTMENT = @DEPARTMENT
                                AND T2.[TYPE] like '%' +  @TYPE + '%'
                                and T2.[OWNER] LIKE '%' +  @OWNER +  '%' "
                                >
                                <SelectParameters>
                                    <asp:ControlParameter ControlID="department" Name="DEPARTMENT" PropertyName="SelectedValue" />
                                    <asp:ControlParameter ControlID="ASSET_TYPE" Name="TYPE" PropertyName="SelectedValue" />
                                    <asp:ControlParameter ControlID="PIC" Name="OWNER" PropertyName="SelectedValue" />
                                </SelectParameters>
                            </asp:SqlDataSource>
                        </div>
                    </td>
                </tr>
            </table>
        </div>
        <script type="text/javascript">
            $(document).ready(function () {
            })
            function uploadComplete(sender, e) {
                var filename = e._fileName.replace('C:\\fakepath\\', '');
                $("#Image1").attr("src", filename);

                var h = document.documentElement.clientHeight
                var w = document.documentElement.clientWidth;
                $("#Image1").attr("width", (w - w % 2) / 2 - 10);
                $("#Image1").attr("height", (h - h % 2) / 2 - 10);
            }
            //$("#fuwrapper").click(function () {
            //    console.log("click!!");
            //    $("#FileUpload1").trigger("click");            }
        </script>
    </form>
</body>
</html>