-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathCheckprod.aspx
More file actions
165 lines (160 loc) · 8.37 KB
/
Copy pathCheckprod.aspx
File metadata and controls
165 lines (160 loc) · 8.37 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="Checkprod.aspx.cs" Inherits="Checkprod" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
<style type="text/css">
.style17
{
width: 100%;
height: 28px;
}
.style18
{
width: 810px;
}
.style19
{
width: 792px;
height: 108px;
}
</style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
<p>
<asp:Label ID="Label7" runat="server" Font-Bold="True" Font-Size="Large"
Text="Search here"></asp:Label>
<asp:TextBox ID="TextBox7" runat="server" Width="202px"></asp:TextBox>
<asp:Button ID="Button4" runat="server" Font-Bold="True" style="margin-left: 0px"
Text="Go" Width="40px" BackColor="#3366CC" ForeColor="White"
onclick="Button4_Click" />
</p>
<p>
<br />
</p>
<table class="style17">
<tr>
<td class="style18" valign="top">
<img alt="" class="style19" src="Photos/image-2.jpg" /></td>
<td>
<asp:Menu ID="Menu1" runat="server" BackColor="#003366"
DynamicHorizontalOffset="2" Font-Bold="True" Font-Names="Verdana"
Font-Size="Small" ForeColor="White" StaticSubMenuIndent="10px">
<DynamicHoverStyle BackColor="#284E98" ForeColor="White" />
<DynamicMenuItemStyle HorizontalPadding="5px" VerticalPadding="2px" />
<DynamicMenuStyle BackColor="#B5C7DE" />
<DynamicSelectedStyle BackColor="#507CD1" />
<Items>
<asp:MenuItem Text="Productivity" Value="Poductivity ">
<asp:MenuItem NavigateUrl="~/Productivity.aspx" Text="Add to productivity"
Value="Add to productivity">
</asp:MenuItem>
<asp:MenuItem NavigateUrl="~/Checkprod.aspx" Text="Check list "
Value="Check list">
</asp:MenuItem>
</asp:MenuItem>
<asp:MenuItem Text="Minls tagged" Value="Minls tagged">
<asp:MenuItem NavigateUrl="Tagged.aspx" Text="Add minls tagged"
Value="Add minls tagged"></asp:MenuItem>
<asp:MenuItem NavigateUrl="Taggedcheck.aspx" Text="Check tagged minls"
Value="Check tagged minls"></asp:MenuItem>
</asp:MenuItem>
<asp:MenuItem Text="Team" Value="Team">
<asp:MenuItem NavigateUrl="Team.aspx" Text="Add Team" Value="Add Team">
</asp:MenuItem>
<asp:MenuItem NavigateUrl="Teamcheck.aspx" Text="Check Team list"
Value="Check Team list"></asp:MenuItem>
</asp:MenuItem>
<asp:MenuItem NavigateUrl="Mineralslist.aspx" Text="Minerals" Value="Minerals">
</asp:MenuItem>
<asp:MenuItem Text="Report" Value="Report">
<asp:MenuItem Text="All minerals mined " Value="All minerals mined "
NavigateUrl="Repproductivity.aspx">
</asp:MenuItem>
<asp:MenuItem NavigateUrl="Repuntaggedcoltan.aspx" Text="Untagged coltan"
Value="Untagged coltan"></asp:MenuItem>
<asp:MenuItem Text="Untagged cassterite" Value="Minerals tagged"
NavigateUrl="Repuntaggedcass.aspx"></asp:MenuItem>
</asp:MenuItem>
</Items>
<StaticHoverStyle BackColor="#284E98" ForeColor="White" />
<StaticMenuItemStyle HorizontalPadding="5px" VerticalPadding="2px" />
<StaticSelectedStyle BackColor="#003300" />
</asp:Menu>
</td>
</tr>
</table>
<br />
<asp:Label ID="Label18" runat="server" Font-Bold="True" Font-Size="Medium"
Font-Underline="True" Text="LIST OF MINERALS MINED IN OUR PERIMETER" ForeColor="Black"
style="font-family: Algerian"></asp:Label>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px"
CellPadding="3" DataKeyNames="Op_code" DataSourceID="SqlDataSource2">
<Columns>
<asp:BoundField DataField="Op_code" HeaderText="Op_code" ReadOnly="True"
SortExpression="Op_code" />
<asp:BoundField DataField="Minls_code" HeaderText="Minls_code"
SortExpression="Minls_code" />
<asp:BoundField DataField="Staff_id" HeaderText="Staff_id"
SortExpression="Staff_id" />
<asp:BoundField DataField="Quantity_mined" HeaderText="Quantity_mined"
SortExpression="Quantity_mined" />
<asp:BoundField DataField="Issue_date" HeaderText="Issue_date"
SortExpression="Issue_date" />
<asp:BoundField DataField="status" HeaderText="status"
SortExpression="status" />
</Columns>
<FooterStyle BackColor="White" ForeColor="#000066" />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
<RowStyle ForeColor="#000066" />
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#F1F1F1" />
<SortedAscendingHeaderStyle BackColor="#007DBB" />
<SortedDescendingCellStyle BackColor="#CAC9C9" />
<SortedDescendingHeaderStyle BackColor="#00547E" />
</asp:GridView>
<br />
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:SkymineralsConnectionString2 %>"
DeleteCommand="DELETE FROM [Productivity] WHERE [Op_code] = @Op_code"
InsertCommand="INSERT INTO [Productivity] ([Op_code], [Minls_code], [Staff_id], [Quantity_mined], [Issue_date], [status]) VALUES (@Op_code, @Minls_code, @Staff_id, @Quantity_mined, @Issue_date, @status)"
SelectCommand="SELECT * FROM [Productivity]"
UpdateCommand="UPDATE [Productivity] SET [Minls_code] = @Minls_code, [Staff_id] = @Staff_id, [Quantity_mined] = @Quantity_mined, [Issue_date] = @Issue_date, [status] = @status WHERE [Op_code] = @Op_code">
<DeleteParameters>
<asp:Parameter Name="Op_code" Type="String" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="Op_code" Type="String" />
<asp:Parameter Name="Minls_code" Type="Int32" />
<asp:Parameter Name="Staff_id" Type="String" />
<asp:Parameter Name="Quantity_mined" Type="Double" />
<asp:Parameter Name="Issue_date" Type="DateTime" />
<asp:Parameter Name="status" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="Minls_code" Type="Int32" />
<asp:Parameter Name="Staff_id" Type="String" />
<asp:Parameter Name="Quantity_mined" Type="Double" />
<asp:Parameter Name="Issue_date" Type="DateTime" />
<asp:Parameter Name="status" Type="String" />
<asp:Parameter Name="Op_code" Type="String" />
</UpdateParameters>
</asp:SqlDataSource>
<br />
<asp:GridView ID="GridView2" runat="server" BackColor="White"
BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" CellPadding="3"
CellSpacing="1" GridLines="None">
<FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#E7E7FF" />
<PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" />
<RowStyle BackColor="#DEDFDE" ForeColor="Black" />
<SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#F1F1F1" />
<SortedAscendingHeaderStyle BackColor="#594B9C" />
<SortedDescendingCellStyle BackColor="#CAC9C9" />
<SortedDescendingHeaderStyle BackColor="#33276A" />
</asp:GridView>
<br />
<br />
<br />
<br />
</asp:Content>