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
| using System;
using System.Collections.Generic;
using System.Data;
using System.Data.OracleClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace WebApplication11
{
public partial class gridView : System.Web.UI.Page
{
public string conn = @"Data Source = " + "cheburek" + "; User ID = " + "kek" + "; password = " + "lol" + "; ";
protected void Page_Load(object sender, EventArgs e)
{
OracleConnection orac = new OracleConnection(conn);
orac.Open();
OracleDataAdapter dt = new OracleDataAdapter("Select tpam.tpam_09.manufacture, tpam.tpam_09.standart, tpam.tpam_09.pipe_od, tpam.tpam_09.pipe_wall, tpam.tpam_09.grade, tpam.tpam_09.heat_n, tpam.tpam_09.pipe_tenar, tpam.tpam_09.mill_ord, tpam.tpam_09.LENGTH, tpam.tpam_09.po_n, TPAM.TPAM_09.ITEM_CODE, tpam.tpam_09.COATERS, tpam.tpam_09.pipe_n as pipe_n1, tpam.tpam_09.type, tpam.tpam_09.od, tpam.tpam_09.date1, tpam.tpam_09.mpa, tpam.tpam_09.user1, tpam.tpam_09.pr1, tpam.tpam_09.pr2, tpam.tpam_09.CRN, tpam.tpam_09.DD, tpam.tpam_09.tenaris, tpam.tpam_09.MTC, R1.data_n1,R1.data_n1, tpam.tpam_09.pipe_n, R1.remark, tpam.tpam_09_wp05.data_n1 as data_n1wp05, tpam.tpam_09_wp05.data_n1 as data_n1wp05, tpam.tpam_09_wp05.shift, tpam.tpam_09_wp05.sec, tpam.tpam_09.pipe_n, tpam.tpam_09_wp05.pipe_size, tpam.tpam_09_wp05.batch_red, tpam.tpam_09_wp05.batch_gold, tpam.tpam_09_wp05.inspekt, tpam.tpam_09_wp05.tracking, tpam.tpam_09_wp05.lot, tpam.tpam_09_wp05.remark1,tpam.tpam_09_wp06.data_n1 as data_n1wp6, tpam.tpam_09_wp06.data_n1 as data_n1wp6, tpam.tpam_09_wp06.shift1, tpam.tpam_09_wp06.sec2, tpam.tpam_09.pipe_n, tpam.tpam_09_wp06.result, tpam.tpam_09_wp06.Q_ty ,R2.data_n1 as data_n11,R2.data_n1 as data_n11, TPAM.tpam_09.pipe_n, R2.remark as remark2222,tpam.tpam_09_wp10.data_n5,tpam.tpam_09_wp10.data_n5,tpam.tpam_09_wp10.shift5,tpam.tpam_09.pipe_n,tpam.tpam_09_wp10.LENGTH51,tpam.tpam_09_wp10.status51,tpam.tpam_09_wp10.remark51,tpam.tpam_09_wp10.status51,tpam.tpam_09_wp10.remark51,tpam.tpam_09_wp10.STRIP5,tpam.tpam_09_wp10.LENGTH52,tpam.tpam_09_wp10.test5,tpam.tpam_09.mtc,tpam.tpam_09.remark5,tpam.tpam_09_wp12.data6, tpam.tpam_09.Pipe_n,tpam.tpam_status.description, tpam.tpam_09_wp12.bt, tpam.tpam_09_wp12.st6, tpam.tpam_09.DATE7, tpam.tpam_09.pipe_n as pipe_n6, tpam.tpam_09.DJW, tpam.tpam_09.DATE8, tpam.tpam_09.WEEK, tpam.tpam_09.pipe_n as pipe_n7, tpam.tpam_09.WELD, tpam.tpam_09.LENGTH8, tpam.tpam_09.DATE11, tpam.tpam_09.STATUS2, tpam.tpam_09.RET_DATE, tpam.tpam_09.pipe_n as pipe_n8, tpam.tpam_09.RET_INSPST, tpam.tpam_09.RET_RRDATE, tpam.tpam_09.RET_FIND, tpam.tpam_09.RET_CRN, tpam.tpam_09.RET_SRN, tpam.tpam_09.RET_DD, tpam.tpam_09.DATE10, tpam.tpam_09.pipe_n as pipe_n9, tpam.tpam_09.Weld, tpam.tpam_09.Length8, tpam.tpam_09.NOM from tpam.tpam_09 LEFT JOIN tpam.tpam_09_remark R1 ON (tpam.tpam_09.pipe_n = R1.pipe_n) AND (R1.wp = 03) left JOIN tpam.tpam_09_wp05 ON tpam.tpam_09.pipe_n = tpam.tpam_09_wp05.pipe_n left JOIN tpam.tpam_09_wp06 ON tpam.tpam_09.pipe_n = tpam.tpam_09_wp06.pipe_n LEFT JOIN tpam.tpam_09_remark R2 ON (tpam.tpam_09.pipe_n = R2.pipe_n) AND (R2.wp = 09) left JOIN tpam.tpam_09_wp10 ON tpam.tpam_09.pipe_n = tpam.tpam_09_wp10.pipe_n left JOIN tpam.tpam_09_wp12 ON tpam.tpam_09.pipe_n = tpam.tpam_09_wp12.pipe_n left join tpam.TPAM_STATUS On tpam_09.status = tpam.tpam_status.kod order by rownum desc", conn);
DataTable dit = new DataTable();
dt.Fill(dit);
GridView1.DataSource = dit;
GridView1.DataBind();
GridView1.HeaderRow.Cells[0].Text = "Manufacturer’s name:";
GridView1.HeaderRow.Cells[1].Text = "Standard:";
GridView1.HeaderRow.Cells[2].Text = "Pipe OD (mm):";
GridView1.HeaderRow.Cells[3].Text = "Pipe wall thickness (mm):";
GridView1.HeaderRow.Cells[4].Text = "Grade:";
GridView1.HeaderRow.Cells[5].Text = "Heat number:";
GridView1.HeaderRow.Cells[6].Text = "Manufacturer’s pipe number:";
GridView1.HeaderRow.Cells[7].Text = "Mill order number:";
GridView1.HeaderRow.Cells[8].Text = "Pipe length (mm):";
GridView1.HeaderRow.Cells[9].Text = "P.O. number:";
GridView1.HeaderRow.Cells[10].Text = "Item code:";
GridView1.HeaderRow.Cells[11].Text = "Coater's name:";
GridView1.HeaderRow.Cells[12].Text = "Unique coating number:";
GridView1.HeaderRow.Cells[13].Text = "Type of coating:";
GridView1.HeaderRow.Cells[14].Text = "OD in:";
GridView1.HeaderRow.Cells[15].Text = "Date:";
GridView1.HeaderRow.Cells[16].Text = "Mpa:";
GridView1.HeaderRow.Cells[17].Text = "QC inspector:";
GridView1.HeaderRow.Cells[18].Text = "End Cap Status One End";
GridView1.HeaderRow.Cells[19].Text = "End Cap Status 2nd End";
GridView1.HeaderRow.Cells[20].Text = "CRN No." ;
GridView1.HeaderRow.Cells[21].Text = "DD No.";
GridView1.HeaderRow.Cells[22].Text = "Tenaris MTC No.";
GridView1.HeaderRow.Cells[23].Text = "ACM MTC NO.";
GridView1.HeaderRow.Cells[24].Text = "First date";
GridView1.HeaderRow.Cells[25].Text = "Second date";
GridView1.HeaderRow.Cells[26].Text = "Pipe No.";
GridView1.HeaderRow.Cells[27].Text = "remark";
GridView1.HeaderRow.Cells[28].Text = "First coated date";
GridView1.HeaderRow.Cells[29].Text = "Second coated date";
GridView1.HeaderRow.Cells[30].Text = "Shift";
GridView1.HeaderRow.Cells[31].Text = "Sequence Number";
GridView1.HeaderRow.Cells[32].Text = "Pipe No.";
GridView1.HeaderRow.Cells[33].Text = "Pipe size";
GridView1.HeaderRow.Cells[34].Text = "Batch No. Red";
GridView1.HeaderRow.Cells[35].Text = "Batch No. Gold";
GridView1.HeaderRow.Cells[36].Text = "Visual inspection";
GridView1.HeaderRow.Cells[37].Text = "Tracking number for sample cutting";
GridView1.HeaderRow.Cells[38].Text = "Lot number";
GridView1.HeaderRow.Cells[39].Text = "Remark";
GridView1.HeaderRow.Cells[40].Text = "First date";
GridView1.HeaderRow.Cells[41].Text = "Second date";
GridView1.HeaderRow.Cells[42].Text = "Shift";
GridView1.HeaderRow.Cells[43].Text = "Sequence Number";
GridView1.HeaderRow.Cells[44].Text = "Pipe No.";
GridView1.HeaderRow.Cells[45].Text = "Result";
GridView1.HeaderRow.Cells[46].Text = "Q-ty of holidays";
GridView1.HeaderRow.Cells[47].Text = "First date";
GridView1.HeaderRow.Cells[48].Text = "Second date";
GridView1.HeaderRow.Cells[49].Text = "Pipe No.";
GridView1.HeaderRow.Cells[50].Text = "Result";
GridView1.HeaderRow.Cells[51].Text = "First date";
GridView1.HeaderRow.Cells[52].Text = "Final date";
GridView1.HeaderRow.Cells[53].Text = "Shift";
GridView1.HeaderRow.Cells[54].Text = "Pipe No.";
GridView1.HeaderRow.Cells[55].Text = "Pipe length";
GridView1.HeaderRow.Cells[56].Text = "First status";
GridView1.HeaderRow.Cells[57].Text = "Remark (To first status)";
GridView1.HeaderRow.Cells[58].Text = "Final status";
GridView1.HeaderRow.Cells[59].Text = "Remark (To final status)";
GridView1.HeaderRow.Cells[60].Text = "Stripped date";
GridView1.HeaderRow.Cells[61].Text = "Sample cuting (length)";
GridView1.HeaderRow.Cells[62].Text = "Pipe cutted to Lab testing";
GridView1.HeaderRow.Cells[63].Text = "# MTC";
GridView1.HeaderRow.Cells[64].Text = "remark";
GridView1.HeaderRow.Cells[65].Text = "Date";
GridView1.HeaderRow.Cells[66].Text = "Pipe no.";
GridView1.HeaderRow.Cells[67].Text = "Yard";
GridView1.HeaderRow.Cells[68].Text = "End caps status";
GridView1.HeaderRow.Cells[69].Text = "End caps status 2";
GridView1.HeaderRow.Cells[70].Text = "Date";
GridView1.HeaderRow.Cells[71].Text = "Pipe no.";
GridView1.HeaderRow.Cells[72].Text = "DJW";
GridView1.HeaderRow.Cells[73].Text = "Date DJC";
GridView1.HeaderRow.Cells[74].Text = "Week";
GridView1.HeaderRow.Cells[75].Text = "Pipe no. ";
GridView1.HeaderRow.Cells[76].Text = "Weld No.";
GridView1.HeaderRow.Cells[77].Text = "DJ Length";
GridView1.HeaderRow.Cells[78].Text = "Date";
GridView1.HeaderRow.Cells[79].Text = "Status";
GridView1.HeaderRow.Cells[80].Text = "Return Date";
GridView1.HeaderRow.Cells[81].Text = "Pipe no.";
GridView1.HeaderRow.Cells[82].Text = "Inspection Status(Repair / Recoating";
GridView1.HeaderRow.Cells[83].Text = "Repair /RecoatingDate";
GridView1.HeaderRow.Cells[84].Text = "Re-Final Date";
GridView1.HeaderRow.Cells[85].Text = "Re-CRN";
GridView1.HeaderRow.Cells[86].Text = "Re-SRN";
GridView1.HeaderRow.Cells[87].Text = "Re-DD";
GridView1.HeaderRow.Cells[88].Text = "Date";
GridView1.HeaderRow.Cells[89].Text = "Pipe No.";
GridView1.HeaderRow.Cells[90].Text = "SL/DJ";
GridView1.HeaderRow.Cells[91].Text = "DJ Length";
GridView1.HeaderRow.Cells[92].Text = "No. car";
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void GridView2_SelectedIndexChanged(object sender, EventArgs e)
{
}
}
} |
(
