/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. 

  2. ' This include file needs OLD_ACID 

    3. 

  3. 

    4. 

  4. %>

    5. 

  5. <TABLE border="1" width="100%" cellspacing="1" cellpadding="5">

    6. 

  6. <%

    7. 

  7. 	mySQL="SELECT * FROM [U82ACC] WHERE [Field2] = N'" & OLD_ACID & "' "

    8. 

  8. 	Set RS1 = conn.Execute(mySQL)

    9. 

  9. 	'response.write mySQL

    10. 

  10. 	col1Color="#FFFFFF"

    11. 

  11. 	col2Color="#CCCCCC"

    12. 

  12. 	if (RS1.eof) then%>

    13. 

  13. 		<tr><td dir='rtl' align='center'><h1> ...</h1></td></tr>

    14. 

  14. <%	else

    15. 

  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. 

  16. 		Set RS2 = conn.Execute(mySQL)

    17. 

  17. 		if RS2.eof then

    18. 

  18. 			CSRName="<B><FONT Color='red'>" & "" & "</FONT></B>"

    19. 

  19. 		else

    20. 

  20. 			CSRName="<B><FONT Color='blue'>" & RS2("RealName") & "</FONT></B>"

    21. 

  21. 		end if

    22. 

  22. 		RS2.close

    23. 

  23. %>

    24. 

  24. 		<tr dir='rtl'>

    25. 

  25. 			<td bgcolor="<%=col1Color%>"><%= CSRName %>&nbsp;

    26. 

  26. 			</td>

    27. 

  27. 			<td bgcolor="<%=col2Color%>" width="100">  :</td>

    28. 

  28. 		</tr>

    29. 

  29. 		<tr dir='rtl'>

    30. 

  30. 			<td bgcolor="<%=col1Color%>"><%= RS1("Field3") %>&nbsp;</td><td bgcolor="<%=col2Color%>">  :</td>

    31. 

  31. 		</tr>

    32. 

  32. 		<tr dir='rtl'>

    33. 

  33. 			<td bgcolor="<%=col1Color%>"><%= RS1("Field4") %>&nbsp;</td><td bgcolor="<%=col2Color%>">  :</td>

    34. 

  34. 		</tr>

    35. 

  35. 		<tr dir='rtl'>

    36. 

  36. 			<td bgcolor="<%=col1Color%>"><%= RS1("Field5") %>&nbsp;</td><td bgcolor="<%=col2Color%>"> :</td>

    37. 

  37. 		</tr>

    38. 

  38. 		<tr dir='rtl'>

    39. 

  39. 			<td bgcolor="<%=col1Color%>"><%= RS1("Field7") %>&nbsp;</td><td bgcolor="<%=col2Color%>">  :</td>

    40. 

  40. 		</tr>

    41. 

  41. 		<tr dir='rtl'>

    42. 

  42. 			<td bgcolor="<%=col1Color%>"><%= RS1("Field8") %>&nbsp;</td><td bgcolor="<%=col2Color%>">  :</td>

    43. 

  43. 		</tr>

    44. 

  44. 		<tr dir='rtl'>

    45. 

  45. 			<td bgcolor="<%=col1Color%>"><%= RS1("Field9") %>&nbsp;</td><td bgcolor="<%=col2Color%>">  :</td>

    46. 

  46. 		</tr>

    47. 

  47. 		<tr dir='rtl'>

    48. 

  48. 			<td bgcolor="<%=col1Color%>"><%=replace(RS1("Field10"),"","-") %>&nbsp;</td><td bgcolor="<%=col2Color%>"> :</td>

    49. 

  49. 		</tr>

    50. 

  50. 		<tr dir='rtl'>

    51. 

  51. 			<td bgcolor="<%=col1Color%>"><%=replace(RS1("Field11"),"","-") %>&nbsp;</td><td bgcolor="<%=col2Color%>">Fax :</td>

    52. 

  52. 		</tr>

    53. 

  53. 		<tr dir='rtl'>

    54. 

  54. 			<td bgcolor="<%=col1Color%>"><%= RS1("Field12") %>&nbsp;</td><td bgcolor="<%=col2Color%>"> :</td>

    55. 

  55. 		</tr>

    56. 

  56. 		<tr dir='rtl'>

    57. 

  57. 			<td bgcolor="<%=col1Color%>"><%= RS1("Field13") %>&nbsp;</td><td bgcolor="<%=col2Color%>"> :</td>

    58. 

  58. 		</tr>

    59. 

  59. 		<tr dir='rtl'>

    60. 

  60. 			<td bgcolor="<%=col1Color%>"><%= RS1("Field14") %>&nbsp;</td><td bgcolor="<%=col2Color%>"> :</td>

    61. 

  61. 		</tr>

    62. 

  62. 		<tr dir='rtl'>

    63. 

  63. 			<td bgcolor="<%=col1Color%>"><%= RS1("Field15") %>&nbsp;</td><td bgcolor="<%=col2Color%>"> :</td>

    64. 

  64. 		</tr>

    65. 

  65. 		<tr dir='rtl'>

    66. 

  66. 			<td bgcolor="<%=col1Color%>"><%= RS1("Field16") %>&nbsp;</td><td bgcolor="<%=col2Color%>"> :</td>

    67. 

  67. 		</tr>

    68. 

  68. 		<tr dir='rtl'>

    69. 

  69. 			<td colspan="2">&nbsp;</td>

    70. 

  70. 		</tr>

    71. 

  71. 		<tr dir='rtl'>

    72. 

  72. 			<td bgcolor="<%=col1Color%>"><%= RS1("Field17") %>&nbsp;</td><td rowspan="6" bgcolor="<%=col2Color%>"> :</td>

    73. 

  73. 		</tr>

    74. 

  74. 		<tr dir='rtl'>

    75. 

  75. 			<td bgcolor="<%=col1Color%>"><%= RS1("Field18") %>&nbsp;</td>

    76. 

  76. 		</tr>

    77. 

  77. 		<tr dir='rtl'>

    78. 

  78. 			<td bgcolor="<%=col1Color%>"><%= RS1("Field19") %>&nbsp;</td>

    79. 

  79. 		</tr>

    80. 

  80. 		<tr dir='rtl'>

    81. 

  81. 			<td bgcolor="<%=col1Color%>"><%= RS1("Field20") %>&nbsp;</td>

    82. 

  82. 		</tr>

    83. 

  83. 		<tr dir='rtl'>

    84. 

  84. 			<td bgcolor="<%=col1Color%>"><%= RS1("Field21") %>&nbsp;</td>

    85. 

  85. 		</tr>

    86. 

  86. 		<tr dir='rtl'>

    87. 

  87. 			<td bgcolor="<%=col1Color%>"><%= RS1("Field22") %>&nbsp;</td>

    88. 

  88. 		</tr>

    89. 

  89. <%

    90. 

  90. 	end if    

    91. 

  91. %>

    92. 

  92. </TABLE>
    93.