include_OldCusData.asp

/beta/CRM/include_OldCusData.asp

http://github.com/khaneh/Orders
ASP | 92 lines | 89 code | 1 blank | 2 comment | 3 complexity | 440d63558ea72053da179d780c67fff4 MD5 | raw file
 1<%
 2' This include file needs OLD_ACID 
 3
 4%>
 5<TABLE border="1" width="100%" cellspacing="1" cellpadding="5">
 6<%
 7	mySQL="SELECT * FROM [U82ACC] WHERE [Field2] = N'" & OLD_ACID & "' "
 8	Set RS1 = conn.Execute(mySQL)
 9	'response.write mySQL
10	col1Color="#FFFFFF"
11	col2Color="#CCCCCC"
12	if (RS1.eof) then%>
13		<tr><td dir='rtl' align='center'><h1>���� ���...</h1></td></tr>
14<%	else
15		mySQL="SELECT Users.RealName as RealName FROM tblCSR_ACC_Relation INNER JOIN Users ON tblCSR_ACC_Relation.CSR = Users.ID WHERE (tblCSR_ACC_Relation.Account = '"& Request("acID")& "')"
16		Set RS2 = conn.Execute(mySQL)
17		if RS2.eof then
18			CSRName="<B><FONT Color='red'>" & "������" & "</FONT></B>"
19		else
20			CSRName="<B><FONT Color='blue'>" & RS2("RealName") & "</FONT></B>"
21		end if
22		RS2.close
23%>
24		<tr dir='rtl'>
25			<td bgcolor="<%=col1Color%>"><%= CSRName %>&nbsp;
26			</td>
27			<td bgcolor="<%=col2Color%>" width="100">����� ������ :</td>
28		</tr>
29		<tr dir='rtl'>
30			<td bgcolor="<%=col1Color%>"><%= RS1("Field3") %>&nbsp;</td><td bgcolor="<%=col2Color%>">��� ���� :</td>
31		</tr>
32		<tr dir='rtl'>
33			<td bgcolor="<%=col1Color%>"><%= RS1("Field4") %>&nbsp;</td><td bgcolor="<%=col2Color%>">���� ����� :</td>
34		</tr>
35		<tr dir='rtl'>
36			<td bgcolor="<%=col1Color%>"><%= RS1("Field5") %>&nbsp;</td><td bgcolor="<%=col2Color%>">��� :</td>
37		</tr>
38		<tr dir='rtl'>
39			<td bgcolor="<%=col1Color%>"><%= RS1("Field7") %>&nbsp;</td><td bgcolor="<%=col2Color%>">�� ������� :</td>
40		</tr>
41		<tr dir='rtl'>
42			<td bgcolor="<%=col1Color%>"><%= RS1("Field8") %>&nbsp;</td><td bgcolor="<%=col2Color%>">�� ���� :</td>
43		</tr>
44		<tr dir='rtl'>
45			<td bgcolor="<%=col1Color%>"><%= RS1("Field9") %>&nbsp;</td><td bgcolor="<%=col2Color%>">�� ��� :</td>
46		</tr>
47		<tr dir='rtl'>
48			<td bgcolor="<%=col1Color%>"><%=replace(RS1("Field10"),"�","-") %>&nbsp;</td><td bgcolor="<%=col2Color%>">���� :</td>
49		</tr>
50		<tr dir='rtl'>
51			<td bgcolor="<%=col1Color%>"><%=replace(RS1("Field11"),"�","-") %>&nbsp;</td><td bgcolor="<%=col2Color%>">Fax :</td>
52		</tr>
53		<tr dir='rtl'>
54			<td bgcolor="<%=col1Color%>"><%= RS1("Field12") %>&nbsp;</td><td bgcolor="<%=col2Color%>">���� :</td>
55		</tr>
56		<tr dir='rtl'>
57			<td bgcolor="<%=col1Color%>"><%= RS1("Field13") %>&nbsp;</td><td bgcolor="<%=col2Color%>">��� :</td>
58		</tr>
59		<tr dir='rtl'>
60			<td bgcolor="<%=col1Color%>"><%= RS1("Field14") %>&nbsp;</td><td bgcolor="<%=col2Color%>">������ :</td>
61		</tr>
62		<tr dir='rtl'>
63			<td bgcolor="<%=col1Color%>"><%= RS1("Field15") %>&nbsp;</td><td bgcolor="<%=col2Color%>">���� :</td>
64		</tr>
65		<tr dir='rtl'>
66			<td bgcolor="<%=col1Color%>"><%= RS1("Field16") %>&nbsp;</td><td bgcolor="<%=col2Color%>">����� :</td>
67		</tr>
68		<tr dir='rtl'>
69			<td colspan="2">&nbsp;</td>
70		</tr>
71		<tr dir='rtl'>
72			<td bgcolor="<%=col1Color%>"><%= RS1("Field17") %>&nbsp;</td><td rowspan="6" bgcolor="<%=col2Color%>">����� :</td>
73		</tr>
74		<tr dir='rtl'>
75			<td bgcolor="<%=col1Color%>"><%= RS1("Field18") %>&nbsp;</td>
76		</tr>
77		<tr dir='rtl'>
78			<td bgcolor="<%=col1Color%>"><%= RS1("Field19") %>&nbsp;</td>
79		</tr>
80		<tr dir='rtl'>
81			<td bgcolor="<%=col1Color%>"><%= RS1("Field20") %>&nbsp;</td>
82		</tr>
83		<tr dir='rtl'>
84			<td bgcolor="<%=col1Color%>"><%= RS1("Field21") %>&nbsp;</td>
85		</tr>
86		<tr dir='rtl'>
87			<td bgcolor="<%=col1Color%>"><%= RS1("Field22") %>&nbsp;</td>
88		</tr>
89<%
90	end if    
91%>
92</TABLE>