ClientInfo.aspx
上传用户:xgw_05
上传日期:2009-12-11
资源大小:20208k
文件大小:7k
源码类别:

OA系统

开发平台:

C#

  1. <%@ Page language="c#" Codebehind="ClientInfo.aspx.cs" AutoEventWireup="false" Inherits="UDS.SubModule.CM.Stat.ClientInfo" %>
  2. <%@ Import namespace="System"%>
  3. <%@ Import namespace="System.Data"  %>
  4. <%@ Import namespace="System.Data.SqlClient"  %>
  5. <%@ Import namespace="UDS.Components"  %>
  6. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
  7. <HTML>
  8. <HEAD>
  9. <title>查询</title>
  10. <meta content="Microsoft Visual Studio 7.0" name="GENERATOR">
  11. <meta content="C#" name="CODE_LANGUAGE">
  12. <meta content="JavaScript" name="vs_defaultClientScript">
  13. <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
  14. <LINK href="../../../Css/BasicLayout.css" type="text/css" rel="stylesheet">
  15. <script language="JavaScript" src="../../../Css/meizzDate.js"></script>
  16. <script runat="server">
  17. private string GetUpdateTime(DataRow[] row)
  18. {
  19. if(row.Length!=0)
  20. {
  21. return(row[0]["UpdateTime"].ToString());
  22. }
  23. else
  24. return ("");
  25. }
  26. private string GetCurStatus(string curstatus)
  27. {
  28. switch(curstatus.Split(',')[0].ToString())
  29. {
  30. case "trace":
  31. return ("跟踪");
  32. break;
  33. case "boot":
  34. return ("启动");
  35. break;
  36. case "commend":
  37. return ("产品推荐");
  38. break;
  39. case "requirement":
  40. return ("需求定义");
  41. break;
  42. case "submit":
  43. return ("方案提交");
  44. break;
  45. case "negotiate":
  46. return ("商务谈判");
  47. break;
  48. case "actualize":
  49. return ("项目实施");
  50. break;
  51. case "traceservice":
  52. return ("跟踪服务");
  53. break;
  54. case "last":
  55. return ("收尾款");
  56. break;
  57. }
  58. return("");
  59. }
  60. private string GetAddMan(DataRow[] row)
  61. {
  62. if(row.Length!=0)
  63. {
  64. return(row[0]["realname"].ToString());
  65. }
  66. else
  67. return ("");
  68. }
  69. </script>
  70. </HEAD>
  71. <body leftmargin="0" topmargin="0">
  72. <form id="ClientInfo" method="post" runat="server">
  73. <FONT face="宋体">
  74. <TABLE borderColor="#111111" cellSpacing="0" cellPadding="0" width="100%" border="0">
  75. <TR height="30">
  76. <TD class="GbText" width="20" background="../../../Images/treetopbg.jpg" bgColor="#c0d9e6"
  77. align="right"><FONT color="#003366" size="3"><IMG height="16" src="../../../DataImages/myLinkman.gif" width="16"></FONT></TD>
  78. <TD class="GbText" background="../../../Images/treetopbg.jpg" bgColor="#e8f4ff" width="75"
  79. align="right" style="WIDTH: 75px">客户管理</TD>
  80. <TD class="GbText" background="../../../Images/treetopbg.jpg" bgColor="#e8f4ff" align="left">-查询&nbsp;</TD>
  81. </TR>
  82. </TABLE>
  83. <TABLE id="Table1" borderColor="#93bee2" cellSpacing="0" cellPadding="0" width="100%" border="1"
  84. style="BORDER-COLLAPSE: collapse" class="GbText">
  85. <TR>
  86. <TD style="WIDTH: 683px">查询条件:&nbsp;&nbsp;
  87. <asp:dropdownlist id="ddl_search" runat="server" AutoPostBack="True" Width="130px">
  88. <asp:ListItem Value="客户名称">客户名称</asp:ListItem>
  89. <asp:ListItem Value="客户分类">客户分类</asp:ListItem>
  90. <asp:ListItem Value="客户编号">客户编号</asp:ListItem>
  91. <asp:ListItem Value="联系人">联系人</asp:ListItem>
  92. <asp:ListItem Value="电话">电话</asp:ListItem>
  93. <asp:ListItem Value="所处行业">所处行业</asp:ListItem>
  94. <asp:ListItem Value="企业性质">企业性质</asp:ListItem>
  95. <asp:ListItem Value="客户来源">客户来源</asp:ListItem>
  96. <asp:ListItem Value="销售人员">销售人员</asp:ListItem>
  97. <asp:ListItem Value="添加日期">添加日期</asp:ListItem>
  98. <asp:ListItem Value="本周新增客户">本周新增客户</asp:ListItem>
  99. <asp:ListItem Value="本月新增客户">本月新增客户</asp:ListItem>
  100. </asp:dropdownlist><asp:textbox id="tbx_searchvalue" runat="server" CssClass="inputcss"></asp:textbox>&nbsp;</TD>
  101. <TD>查询范围
  102. <asp:dropdownlist id="ddl_SearchBound" runat="server">
  103. <asp:ListItem Value="1">本人与下属</asp:ListItem>
  104. <asp:ListItem Value="2">仅本人</asp:ListItem>
  105. <asp:ListItem Value="3">仅下属</asp:ListItem>
  106. </asp:dropdownlist></TD>
  107. </TR>
  108. <TR>
  109. <TD colSpan="2"><asp:radiobuttonlist id="rbl_searchvalue" runat="server" Visible="False"></asp:radiobuttonlist></TD>
  110. </TR>
  111. <TR>
  112. <TD colSpan="2"><asp:button id="btn_addsearch" runat="server" Text="添加条件" CssClass="redbuttoncss"></asp:button>&nbsp;
  113. <asp:button id="btn_Del" runat="server" Text="删除条件" CssClass="redbuttoncss"></asp:button></TD>
  114. </TR>
  115. <TR>
  116. <TD colSpan="2"><asp:listbox id="lbx_search" runat="server" Height="95px" Width="496px"></asp:listbox><BR>
  117. <asp:button id="btn_OK" runat="server" Text="查询" CssClass="redbuttoncss"></asp:button></TD>
  118. </TR>
  119. <TR>
  120. <TD colSpan="2" height="30">查询结果:共查到
  121. <asp:Literal id="ltl_Client" runat="server"></asp:Literal>位符合条件的客户</TD>
  122. </TR>
  123. <TR>
  124. <TD colSpan="2"></TD>
  125. </TR>
  126. </TABLE>
  127. <asp:DataGrid id="dgrd_clientlist" runat="server" Width="100%" AllowSorting="True" AllowPaging="True"
  128. AutoGenerateColumns="False">
  129. <HeaderStyle ForeColor="White" BackColor="#337FB2"></HeaderStyle>
  130. <Columns>
  131. <asp:TemplateColumn></asp:TemplateColumn>
  132. <asp:BoundColumn DataField="ID" SortExpression="ID" HeaderText="编号"></asp:BoundColumn>
  133. <asp:TemplateColumn SortExpression="Name" HeaderText="客户名称">
  134. <ItemTemplate>
  135. <asp:HyperLink id=Hyperlink1 runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Name") %>' NAME="Hyperlink1" Target="_blank" NavigateUrl='<%# "../Client.aspx?ClientID="+DataBinder.Eval(Container,"DataItem.ID")%>'>
  136. </asp:HyperLink>
  137. </ItemTemplate>
  138. </asp:TemplateColumn>
  139. <asp:BoundColumn DataField="Linkman" SortExpression="Linkman" HeaderText="联系人"></asp:BoundColumn>
  140. <asp:BoundColumn DataField="Linkman_Telephone" SortExpression="Linkman_Telephone" HeaderText="电话"></asp:BoundColumn>
  141. <asp:TemplateColumn SortExpression="UpdateTime" HeaderText="更新时间">
  142. <ItemTemplate>
  143. <asp:Label ID="lbl_UpdateTime" Runat="server">
  144. <%# DataBinder.Eval(Container,"DataItem.UpdateTime")%>
  145. </asp:Label>
  146. </ItemTemplate>
  147. </asp:TemplateColumn>
  148. <asp:TemplateColumn HeaderText="目前状态">
  149. <HeaderStyle Font-Size="X-Small"></HeaderStyle>
  150. <ItemTemplate>
  151. <asp:HyperLink id=Hyperlink2 runat="server" Text='<%# GetCurStatus(DataBinder.Eval(Container,"DataItem.Curstatus").ToString()) %>' NavigateUrl='<%# "../../../SubModule/CM/ClientContact_thisWeek.aspx?ClientID="+DataBinder.Eval(Container,"DataItem.ID")%>' NAME="Hyperlink2" Target="_blank">
  152. </asp:HyperLink>
  153. </ItemTemplate>
  154. </asp:TemplateColumn>
  155. <asp:TemplateColumn SortExpression="AddMan" HeaderText="添加人">
  156. <ItemTemplate>
  157. <asp:Label runat="server" Text='<%# GetAddMan(((DataRowView)Container.DataItem).Row.GetChildRows("ClientAddMan_Staff")) %>' ID="Label1">
  158. </asp:Label>
  159. </ItemTemplate>
  160. </asp:TemplateColumn>
  161. </Columns>
  162. <PagerStyle NextPageText="上一页" PrevPageText="下一页" HorizontalAlign="Right" Mode="NumericPages"></PagerStyle>
  163. </asp:DataGrid>
  164. </FONT>
  165. </form>
  166. </body>
  167. </HTML>