<%@ Page Title="" Language="C#" MasterPageFile="~/pub/default.master" AutoEventWireup="true" CodeBehind="frmPrintSOCOzgun.aspx.cs" Inherits="Shipment.frmPrintSOCOzgun" %>

​

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">

    <div class="headerRow">

        Özgün Projeler  Kalite Belgesi Yazdırma Ekranı

    </div>

    Onay Durumu: 

    <asp:DropDownList ID="drpOnay" runat="server">

        <asp:ListItem Value="-1">Tümü</asp:ListItem>

        <asp:ListItem Value="0">New</asp:ListItem>

        <asp:ListItem Value="1">Waiting Approval</asp:ListItem>

        <asp:ListItem Value="2">Approved</asp:ListItem>

        <asp:ListItem Value="3">Rejected</asp:ListItem>

        <asp:ListItem Value="4">Waiting QE Approval</asp:ListItem>

        <asp:ListItem Value="5">Failure due to SPS/CAV Approval</asp:ListItem>

        <asp:ListItem Value="6">Failure due to Open QCI</asp:ListItem>

        <asp:ListItem Value="7">Failure due to Open MRB</asp:ListItem>

    </asp:DropDownList>

    Parça No: 

    <asp:TextBox ID="txtPartNo" runat="server"></asp:TextBox>

    Seri No: 

    <asp:TextBox ID="txtSerialNo" runat="server"></asp:TextBox><br />

               Yıl :

                <asp:DropDownList ID="drpYear" runat="server">

                    <asp:ListItem Text="All" Value=""></asp:ListItem>

                </asp:DropDownList>

                FW :

                <asp:DropDownList ID="drpWeek" runat="server">

                    <asp:ListItem Text="All" Value=""></asp:ListItem>

                </asp:DropDownList>

    <asp:Button ID="btnAra" runat="server" Text="Ara" OnClick="btnAra_Click" />

    <asp:Button ID="btnTumunu" runat="server" Text="Tüm Listeleri Aç" OnClick="btnTumunu_Click" />

    <asp:Button ID="btnExcel" runat="server" Text="Excel" OnClick="btnExcel_Click" />

    <br />

    <asp:ListBox ID="lstCocList" runat="server" DataValueField="FormTrackingNumber" DataTextField="form" Width="100%" OnSelectedIndexChanged="lstCocList_SelectedIndexChanged" AutoPostBack="true" Height="150px" Font-Size="Large">

        <asp:ListItem>Seçiniz</asp:ListItem>

    </asp:ListBox>

    <br />

​

    <asp:Label ID="lblUyari" runat="server" Text="" Font-Size="Large" Font-Bold="true"></asp:Label>

    <br />

    <asp:Button ID="btnSentApprove" runat="server" Text="Seçilenleri Onaya Gönder" OnClick="btnSentApprove_Click" />

    <asp:Button ID="btnPrint" runat="server" Text="Seçilenleri Yazdır" OnClick="btnPrint_Click" />

    <asp:Button ID="btnApprove" runat="server" Text="Seçilenleri Onayla" OnClick="btnApprove_Click"  />

    <asp:Button ID="btnCancel" runat="server" Text="Seçilenleri İptal Et" OnClick="btnCancel_Click" /><br />

    COC Listesi :

    <asp:CheckBoxList ID="chklCOCList" runat="server"></asp:CheckBoxList>

​

        <input id="Button6" class="btnAcik" onclick="SetAllCheckBoxes('cbId',true);" 

                    type="button" value="Hepsini Seç" />

                <input ID="Button7" class="btnAcik" onclick="SetAllCheckBoxes('cbId',false);" 

                        type="button" value="X Seçimi Temizle" />

    <asp:Panel ID="pnlEdit" runat="server" BorderColor="#33ccff" BorderWidth="2" Visible="false">

        <h2>Parça Detayları</h2>

        <%--OnRowUpdated="grdQuality_RowUpdated" OnRowUpdating="grdQuality_RowUpdating" ="ID"--%>

        <asp:GridView ID="grdQuality" runat="server" Width="100%" CellPadding="4" ForeColor="#333333" GridLines="None" AutoGenerateColumns="False" DataKeyNames="Id" OnRowCommand="grdQuality_RowCommand" OnRowCancelingEdit="grdQuality_RowCancelingEdit" OnRowEditing="grdQuality_RowEditing" DataSourceID="SqlDataSourceSubPart">

            <AlternatingRowStyle BackColor="White" />

            <EditRowStyle BackColor="#24F1B0" />

            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />

            <RowStyle BackColor="#EFF3FB" />

            <SelectedRowStyle BackColor="#D1DD01" Font-Bold="True" ForeColor="#333333" />

            <SortedAscendingCellStyle BackColor="#F5F7FB" />

            <SortedAscendingHeaderStyle BackColor="#6D95E1" />

            <SortedDescendingCellStyle BackColor="#E9EBEF" />

            <SortedDescendingHeaderStyle BackColor="#4870BE" />

            <Columns>

                <asp:BoundField DataField="FormTrackingNumber" HeaderText="#Form Tracking Number"

                    SortExpression="FormTrackingNumber" ReadOnly="true" />

                <asp:BoundField DataField="PartNo" HeaderText="part_no" SortExpression="PartNo" />

                <asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />

                <asp:BoundField DataField="qty" HeaderText="qty" SortExpression="qty" />

                <asp:BoundField DataField="Serial" HeaderText="Serial" SortExpression="Serial">

                    <ItemStyle Width="150px" />

                </asp:BoundField>

                <asp:TemplateField HeaderText="Consession" HeaderStyle-HorizontalAlign="Left">

                    <ItemTemplate>

                        <%# Eval("Consession") %>

                    </ItemTemplate>

                    <EditItemTemplate>

                        <div id="Consession">

                            <asp:TextBox ID="txtConsession" Text='<%#Bind("Consession")%>' TextMode="MultiLine" runat="server" Height="100" />

                        </div>

                    </EditItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField HeaderText="DrawingIssue" HeaderStyle-HorizontalAlign="Left">

                    <ItemTemplate>

                        <label id="lblDrawingIssue"><%#Eval("DrawingIssue")%></label>

                    </ItemTemplate>

                    <EditItemTemplate>

                        <select onchange="GetIssue()" id="drpIssue">

                            <option>ISSUE Seçiniz</option>

                            <option>F-ISSUE</option>

                            <option>M-ISSUE</option>

                        </select><br />

                        <div style="float: left;">Rev:</div>

                        <input id="drpRev" type="text" style="float: left; width: 40px;" onchange="GetRev()" />

                        <br />

                        <br />

                        <div style="float: left;">UBF-</div>

                        <input style="float: left; width: 40px;" type="text" onchange="GetUbf()" id="txtUbf" /><br />

                        <div style="cursor: pointer; color: red; font-weight: bold;" title="Remove DrawingIssue" onclick="removeUBF()">(X)</div>

                        <br />

                        <label id="lblDrawingIssueEdit"><%#Eval("DrawingIssue")%></label>

                    </EditItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField HeaderText="Remarks" HeaderStyle-HorizontalAlign="Left">

                    <ItemTemplate>

                        <%# Eval("Remarks") %>

                    </ItemTemplate>

                    <EditItemTemplate>

                        <asp:TextBox ID="txtRemark" Text='<%#Bind("Remarks")%>' TextMode="MultiLine" runat="server" Height="100" />

​

                    </EditItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField>

                    <ItemTemplate>

                        <asp:LinkButton ID="ImageButton3" runat="server" BackColor="Yellow" Width="100%" CommandName="edit" CommandArgument='<%#Eval("DrawingIssue")%>' Text="Edit" OnClientClick="setHdn()" />

                        <asp:LinkButton ID="ImageButton4" runat="server" CommandName="insert" Text="Insert" BackColor="Green" ForeColor="White" Width="100%" />

                        <asp:LinkButton ID="ImageButton5" runat="server" BackColor="Red" Width="100%" ForeColor="White"

                            CommandName="delete" Text="Delete" OnClientClick="return confirm('Alt Parça Silinecektir. Onayliyor musunuz?')" />

                    </ItemTemplate>

                    <EditItemTemplate>

                        <asp:LinkButton ID="LinkButton1" runat="server" CommandName="update">Update</asp:LinkButton>

                        <asp:LinkButton ID="LinkButton2" runat="server" CommandName="cancel">Cancel</asp:LinkButton>

                    </EditItemTemplate>

                </asp:TemplateField>

            </Columns>

        </asp:GridView>

        <asp:SqlDataSource ID="SqlDataSourceSubPart" runat="server" ConnectionString="<%$ ConnectionStrings:SalesDBConnStr %>" SelectCommand="SELECT Id, FormTrackingNumber ,WorkOrderNo ,Description ,PartNo ,Qty ,Serial ,Status ,Remarks ,AuthorisationNumber ,ApprovalName ,ApprovalDate,year,fw,isSubPart, Consession, DrawingIssue FROM [COCOzgunProje] WHERE ([FormTrackingNumber] = @FormTrackingNumber)" UpdateCommand="UPDATE [COCOzgunProje] SET  [Consession] = @Consession, [DrawingIssue] = @DrawingIssue, [Remarks] = @Remarks, [PartNo] = @PartNo,[Description] = @Description,[QTY] = @QTY,[Serial] = @Serial  WHERE [ID] = @ID" InsertCommand="insert into COCOzgunProje (FormTrackingNumber,[isSubPart]) values (@FormTrackingNumber,1)" DeleteCommand="delete FROM [COCOzgunProje] WHERE [ID] = @ID">

            <SelectParameters>

                <asp:Parameter Name="FormTrackingNumber" Type="String" />

            </SelectParameters>

            <UpdateParameters>

                <asp:ControlParameter ControlID="hdnDrawIssue" PropertyName="Value" Name="DrawingIssue" Type="String" />

                <asp:Parameter Name="Consession" Type="String" />

                <asp:Parameter Name="Remarks" Type="String" />

                <asp:Parameter Name="PartNo" Type="String" />

                <asp:Parameter Name="Description" Type="String" />

                <asp:Parameter Name="QTY" Type="String" />

                <asp:Parameter Name="serial" Type="String" />

                <asp:Parameter Name="ID" Type="Int32" />

            </UpdateParameters>

            <InsertParameters>

                <asp:Parameter Name="FormTrackingNumber" Type="String" />

​

            </InsertParameters>

            <DeleteParameters>

                <asp:Parameter Name="ID" Type="Int32" />

            </DeleteParameters>

        </asp:SqlDataSource>

        <asp:HiddenField ID="hdnDrawIssue" runat="server" />

        <asp:Button ID="btnQEOnayla" runat="server" Text="Onayla" OnClick="btnQEOnayla_Click" />

        <asp:Button ID="btnQEReddet" runat="server" Text="Reddet" OnClick="btnQEReddet_Click" />

        <br />

        <br />

    </asp:Panel>

    <%--OnRowCommand="gridItems_RowCommand" OnRowEditing="gridItems_RowEditing"--%>

    <asp:GridView ID="gridItems" runat="server" AutoGenerateColumns="False" DataKeyNames="id"

        Font-Size="8pt" SkinID="Grid" OnRowCommand="gridItems_RowCommand">

        <Columns>

            <asp:TemplateField HeaderText="" InsertVisible="False" SortExpression="id">

                <ItemTemplate>

                    <input id="cbId" name="cbId" type="checkbox" value='<%# Eval("id") %>' style="height: 50px;" />

                </ItemTemplate>

            </asp:TemplateField>

            <asp:TemplateField>

                <ItemTemplate>

                    <%-- <asp:ImageButton ID="ImageButton1" runat="server"

                        CommandArgument='<%# Eval("id") %>' CommandName="Print"

                        ImageUrl="pub/img/word.png" />--%>

                </ItemTemplate>

            </asp:TemplateField>

            <asp:TemplateField>

                <ItemTemplate>

                    <%-- <asp:ImageButton ID="ImageButton2" runat="server"

                        CommandArgument='<%# Eval("id") %>' CommandName="PrintPDF"

                        ImageUrl="pub/img/pdf.jpg" />--%>

                </ItemTemplate>

            </asp:TemplateField>

            <asp:BoundField DataField="id" HeaderText="#id"

                SortExpression="id" />

            <asp:BoundField DataField="FormTrackingNumber" HeaderText="FormTrackingNumber"

                SortExpression="FormTrackingNumber" />

            <asp:BoundField DataField="PartNo" HeaderText="part_no"

                SortExpression="PartNo" />

            <asp:BoundField DataField="Serial" HeaderText="Serial"

                SortExpression="Serial" />

            <asp:BoundField DataField="Description" HeaderText="Description"

                SortExpression="Description" />

            <asp:BoundField DataField="WorkOrderNo" HeaderText="WorkOrderNo" ReadOnly="True"

                SortExpression="WorkOrderNo" />

            <asp:BoundField DataField="qty" HeaderText="qty" SortExpression="qty" />

            <asp:BoundField DataField="Remarks" HeaderText="Remarks"

                SortExpression="Remarks"></asp:BoundField>

            <asp:BoundField DataField="ApprovalName" HeaderText="ApprovalName" ReadOnly="True"

                SortExpression="ApprovalName" />

            <asp:BoundField DataField="ApprovalDate" HeaderText="ApprovalDate" ReadOnly="True"

                SortExpression="ApprovalDate" />

            <asp:BoundField DataField="Status" HeaderText="Status" ReadOnly="True"

                SortExpression="Status" />

            <asp:TemplateField>

                <ItemTemplate>

                    <asp:ImageButton ID="ImageButton3" runat="server"

                        CommandArgument='<%# Eval("id") %>' CommandName="editPart"

                        ImageUrl="pub/img/edit1.gif" />

                </ItemTemplate>

            </asp:TemplateField>

            <%-- CssClass='<%#Eval("ApproveStatusId").ToString()=="5" ||Eval("ApproveStatusId").ToString()=="6"  ? "hideDel":"itemEdit" %>'--%>

        </Columns>

    </asp:GridView>

​

​

    <script type="text/javascript">

​

        function GetIssue() {

            var x = document.getElementById("lblDrawingIssueEdit").innerHTML;

            var xx = x.split(" ");

​

            var x = document.getElementById("drpIssue").value;

            if (String(xx[2]).indexOf("UBF-") == -1 && String(xx[2]) != "undefined" && String(xx[2]) != "")

                xx[2] = "UBF-" + xx[2];

            var deger = x + " " + xx[1] + " " + xx[2];

            deger = deger.replace("undefined", "").replace("undefined", "");

​

​

            document.getElementById("ctl00_ContentPlaceHolder1_hdnDrawIssue").value = deger;

            document.getElementById("lblDrawingIssueEdit").innerHTML = deger;

        }

        function GetRev() {

            var x = document.getElementById("lblDrawingIssueEdit").innerHTML;

            var xx = x.split(" ");

            var x = document.getElementById("drpRev").value;

​

​

            console.log(x);

            if (String(xx[2]).indexOf("UBF-") == -1 && String(xx[2]) != "undefined" && String(xx[2]) != "")

                xx[2] = "UBF-" + xx[2];

            var deger = xx[0] + " REV" + x + " " + xx[2];

​

​

​

            deger = deger.replace("undefined", "").replace("undefined", "");

            document.getElementById("ctl00_ContentPlaceHolder1_hdnDrawIssue").value = deger;

            document.getElementById("lblDrawingIssueEdit").innerHTML = deger;

        }

        function GetUbf() {

            var x = document.getElementById("lblDrawingIssueEdit").innerHTML;

            var xx = x.split(" ");

​

​

​

            var x = document.getElementById("txtUbf").value;

            if (String(x).indexOf("UBF-") == -1 && String(x) != "")

                x = "UBF-" + x;

            var deger = xx[0] + " " + xx[1] + " " + x;

​

​

            deger = deger.replace("undefined", "").replace("undefined", "");

            document.getElementById("ctl00_ContentPlaceHolder1_hdnDrawIssue").value = deger;

            document.getElementById("lblDrawingIssueEdit").innerHTML = deger;

        }

​

        function removeUBF() {

            document.getElementById("ctl00_ContentPlaceHolder1_hdnDrawIssue").value = "";

            document.getElementById("lblDrawingIssueEdit").innerHTML = "";

        }

​

    </script>

</asp:Content>

​