开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > OA系统 > 查看源码
Fee.aspx
资源名称：精品OA.rar　[点击查看]
上传用户：xgw_05
上传日期：2009-12-11
资源大小：20208k
文件大小：13k
源码类别：

OA系统

开发平台：

C#

Fee.aspx：源码内容
  1. <%@ Import namespace="System"%>
  2. <%@ Import namespace="System.Data"  %>
  3. <%@ Import namespace="System.Data.SqlClient"  %>
  4. <%@ Import namespace="UDS.Components"  %>
  5. <%@ Page language="c#" Codebehind="Fee.aspx.cs" AutoEventWireup="false" Inherits="UDS.SubModule.CM.Stat.Fee" %>
  6. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
  7. <HTML>
  8. <HEAD>
  9. <title>Fee</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 language="javascript">
  17. function fillstring(str)
  18. {
  19. if(str.length==1)
  20. {
  21. str = "0" + str; 
  22. }
  23. return(str);
  24. }
  25. function quickseldate(type)
  26. {
  27. var begintime,endtime;
  28. var oneminute = 60*1000;
  29. var onehour   = 60*oneminute;
  30. var oneday    = 24*onehour;
  31. var oneweek   = 7*oneday;
  33. var todayDate = new Date();
  34. var date = todayDate.getDate();
  35. var month= todayDate.getMonth() +1;
  36. var year= todayDate.getYear();
  37. var day = todayDate.getDay();
  38. if(navigator.appName == "Netscape")
  39. {
  40. year = 1900 + year;
  41. }
  43. //-->
  45. if(type=="day")
  46. {
  47. begintime = year.toString() + "-" + fillstring(month.toString()) + "-" + fillstring(date.toString());
  48. endtime = begintime;
  49. }
  50. else if(type=="week")
  51. {
  52. var daytoMon = day-1;
  53. if(day==0) 
  54. daytoMon = 6;
  56. todayDate.setTime(todayDate.getTime()-daytoMon*oneday);
  57. date = todayDate.getDate();
  58. month= todayDate.getMonth() +1;
  59. year= todayDate.getYear();
  60. day = todayDate.getDay();
  62. begintime = year.toString() + "-" + fillstring(month.toString()) + "-" + fillstring(date.toString());
  64. todayDate.setTime(todayDate.getTime()+6*oneday);
  66. date = todayDate.getDate();
  67. month= todayDate.getMonth() +1;
  68. year= todayDate.getYear();
  70. endtime = year.toString() + "-" + fillstring(month.toString()) + "-" + fillstring(date.toString());
  71. }
  72. else if(type=="month")
  73. {
  74. var dateto1 = date-1;
  76. todayDate.setTime(todayDate.getTime()-dateto1*oneday);
  77. date = todayDate.getDate();
  78. month= todayDate.getMonth() +1;
  79. year= todayDate.getYear();
  80. day = todayDate.getDay();
  82. begintime = year.toString() + "-" + fillstring(month.toString()) + "-" + fillstring(date.toString());
  84. todayDate.setMonth(month);
  85. todayDate.setTime(todayDate.getTime()-oneday);
  87. date = todayDate.getDate();
  88. month= todayDate.getMonth() +1;
  89. year= todayDate.getYear();
  91. endtime = year.toString() + "-" + fillstring(month.toString()) + "-" + fillstring(date.toString());
  93. }
  95. document.getElementById("tbx_begintime").value = begintime;
  96. document.getElementById("tbx_endtime").value = endtime;
  98. }
  99. </script>
  100. <script language="C#" runat="server">
  101. private string GetLinkMan(DataRow[] row)
  102. {
  103. if(row.Length!=0)
  104. {
  105. return(row[0]["Name"].ToString());
  106. }
  107. else
  108. return ("");
  109. }
  110. private string GetCurStatus(string curstatus)
  111. {
  112. switch(curstatus.Split(',')[0].ToString())
  113. {
  114. case "trace":
  115. return ("跟踪");
  116. break;
  117. case "boot":
  118. return ("启动");
  119. break;
  120. case "commend":
  121. return ("产品推荐");
  122. break;
  123. case "requirement":
  124. return ("需求定义");
  125. break;
  126. case "submit":
  127. return ("方案提交");
  128. break;
  129. case "negotiate":
  130. return ("商务谈判");
  131. break;
  132. case "actualize":
  133. return ("项目实施");
  134. break;
  135. case "traceservice":
  136. return ("跟踪服务");
  137. break;
  138. case "last":
  139. return ("收尾款");
  140. break;
  141. }
  142. return("");
  143. }
  144. private string GetAddMan(DataRow[] row)
  145. {
  146. if(row.Length!=0)
  147. {
  148. return(row[0]["realname"].ToString());
  149. }
  150. else
  151. return ("");
  152. }
  153. private int GetFee(DataRow[] row)
  154. {
  155. int fee = 0;
  156. if(row.Length!=0)
  157. {
  158. foreach(DataRow datarow in row)
  159. {
  160. fee += Int32.Parse(datarow["fee"].ToString());
  161. }
  162. totalfee += fee;
  163. return(fee);
  164. }
  165. else
  166. return(0);
  168. }
  169. private string GetTravel(int sellmanid,DateTime begintime,DateTime endtime)
  170. {
  171. UDS.Components.CM cm = new UDS.Components.CM();
  172. return(cm.GetTravelFeeBySellmanID(sellmanid,begintime,endtime).ToString());
  173. }
  174. private string GetFood(int sellmanid,DateTime begintime,DateTime endtime)
  175. {
  176. UDS.Components.CM cm = new UDS.Components.CM();
  177. return(cm.GetFoodFeeBySellmanID(sellmanid,begintime,endtime).ToString());
  178. }
  179. private string GetGift(int sellmanid,DateTime begintime,DateTime endtime)
  180. {
  181. UDS.Components.CM cm = new UDS.Components.CM();
  182. return(cm.GetGiftFeeBySellmanID(sellmanid,begintime,endtime).ToString());
  183. }
  184. private string GetOuter(int sellmanid,DateTime begintime,DateTime endtime)
  185. {
  186. UDS.Components.CM cm = new UDS.Components.CM();
  187. return(cm.GetOuterFeeBySellmanID(sellmanid,begintime,endtime).ToString());
  188. }
  189. private string GetContactTimes(int sellmanid,DateTime begintime,DateTime endtime)
  190. {
  191. UDS.Components.CM cm = new UDS.Components.CM();
  192. SqlDataReader dr = cm.GetContactBySellmanID(sellmanid,begintime,endtime);
  193. DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
  194. return(dt.Rows.Count.ToString());
  195. }
  196. private string GetContactedClient(int sellmanid,DateTime begintime,DateTime endtime)
  197. {
  198. UDS.Components.CM cm = new UDS.Components.CM();
  199. SqlDataReader dr = cm.GetContactedClientBySellmanID(sellmanid,begintime,endtime);
  200. DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
  201. return(dt.Rows.Count.ToString());
  202. }
  203. </script>
  204. </HEAD>
  205. <body MS_POSITIONING="GridLayout">
  206. <form id="Fee" method="post" runat="server">
  207. <FONT face="宋体">
  208. <TABLE id="Table1" cellSpacing="1" cellPadding="1" width="100%" border="1">
  209. <TR>
  210. <TD align="right"><asp:dropdownlist id="ddl_order" runat="server">
  211. <asp:ListItem Value="client">按客户发生费用总量排列</asp:ListItem>
  212. <asp:ListItem Value="sellman">按销售人员费用总量排列</asp:ListItem>
  213. </asp:dropdownlist></TD>
  214. </TR>
  215. <TR>
  216. <TD>开始时间
  217. <asp:textbox id="tbx_begintime" onfocus="setday(this);" runat="server" ReadOnly="True"></asp:textbox><asp:requiredfieldvalidator id="RequiredFieldValidator1" runat="server" ErrorMessage="*" Display="Dynamic" ControlToValidate="tbx_begintime"></asp:requiredfieldvalidator>结束时间
  218. <asp:textbox id="tbx_endtime" onfocus="setday(this);" runat="server" ReadOnly="True"></asp:textbox><asp:requiredfieldvalidator id="RequiredFieldValidator2" runat="server" ErrorMessage="*" ControlToValidate="tbx_endtime"></asp:requiredfieldvalidator><asp:radiobutton id="rbtn_thisweek" onclick="quickseldate('week');" runat="server" GroupName="quickselect"
  219. Text="本周"></asp:radiobutton><asp:radiobutton id="rbtn_thismonth" onclick="quickseldate('month');" runat="server" GroupName="quickselect"
  220. Text="本月"></asp:radiobutton><asp:button id="btn_OK" runat="server" Text="确定"></asp:button></TD>
  221. </TR>
  222. <TR>
  223. <TD>共
  224. <asp:literal id="ltl_Client" runat="server"></asp:literal>位客户，共发生费用
  225. <asp:literal id="ltl_Fee" runat="server"></asp:literal>元</TD>
  226. </TR>
  227. <TR>
  228. <TD><asp:datagrid id="dgrd_clientfee" runat="server" AllowPaging="True" AutoGenerateColumns="False"
  229. Width="100%" CellPadding="3" BorderWidth="1px" BorderColor="#93BEE2">
  230. <AlternatingItemStyle BackColor="#E8F4FF"></AlternatingItemStyle>
  231. <ItemStyle Font-Size="X-Small"></ItemStyle>
  232. <HeaderStyle ForeColor="White" BackColor="#337FB2"></HeaderStyle>
  233. <Columns>
  234. <asp:BoundColumn DataField="ID" SortExpression="ID" HeaderText="编号"></asp:BoundColumn>
  235. <asp:TemplateColumn SortExpression="NAME" HeaderText="客户名称">
  236. <ItemTemplate>
  237. <asp:HyperLink id=Hyperlink1 runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Name") %>' Target="_blank" NavigateUrl='<%# "../Client.aspx?ClientID="+DataBinder.Eval(Container,"DataItem.ID")%>'>
  238. </asp:HyperLink>
  239. </ItemTemplate>
  240. </asp:TemplateColumn>
  241. <asp:TemplateColumn HeaderText="联系人">
  242. <ItemTemplate>
  243. <A>
  244. <%# GetLinkMan(((DataRowView)Container.DataItem).Row.GetChildRows("ClientLinkman_Staff")) %>
  245. </A>
  246. </ItemTemplate>
  247. </asp:TemplateColumn>
  248. <asp:TemplateColumn HeaderText="接触次数">
  249. <ItemTemplate>
  250. <asp:Label runat="server" Text='<%# ((DataRowView)Container.DataItem).Row.GetChildRows("Client_Contact").Length %>'>
  251. </asp:Label>
  252. </ItemTemplate>
  253. </asp:TemplateColumn>
  254. <asp:TemplateColumn HeaderText="发生费用">
  255. <ItemTemplate>
  256. <asp:Label runat="server" Text='<%# GetFee(((DataRowView)Container.DataItem).Row.GetChildRows("Client_Contact")).ToString() %>'>
  257. </asp:Label>
  258. </ItemTemplate>
  259. </asp:TemplateColumn>
  260. <asp:TemplateColumn HeaderText="接触状态">
  261. <ItemTemplate>
  262. <asp:HyperLink id=Hyperlink3 runat="server" Target=_blank Text='<%# GetCurStatus(DataBinder.Eval(Container,"DataItem.Curstatus").ToString()) %>' NavigateUrl='<%# "../ClientContact.aspx?ClientID="+DataBinder.Eval(Container,"DataItem.ID")%>' NAME="Hyperlink2">
  263. </asp:HyperLink>
  264. </ItemTemplate>
  265. </asp:TemplateColumn>
  266. <asp:TemplateColumn HeaderText="添加人">
  267. <ItemTemplate>
  268. <asp:Label runat="server" Text='<%# GetAddMan(((DataRowView)Container.DataItem).Row.GetChildRows("ClientAddMan_Staff")) %>' ID="Label1">
  269. </asp:Label>
  270. </ItemTemplate>
  271. </asp:TemplateColumn>
  272. </Columns>
  273. <PagerStyle NextPageText="上一页" HorizontalAlign="Right" Mode="NumericPages"></PagerStyle>
  274. </asp:datagrid><asp:datagrid id="dgrd_sellmanfee" runat="server" AllowPaging="True" AutoGenerateColumns="False"
  275. Width="100%" Visible="False" CellPadding="3" BorderWidth="1px" BorderColor="#93BEE2">
  276. <AlternatingItemStyle BackColor="#E8F4FF"></AlternatingItemStyle>
  277. <ItemStyle Font-Size="X-Small"></ItemStyle>
  278. <HeaderStyle ForeColor="White" BackColor="#337FB2"></HeaderStyle>
  279. <Columns>
  280. <asp:TemplateColumn HeaderText="销售人员">
  281. <ItemTemplate>
  282. <%# ((DataRowView)Container.DataItem).Row.GetChildRows("StaffID_RealName")[0]["realname"].ToString() %>
  283. </ItemTemplate>
  284. </asp:TemplateColumn>
  285. <asp:TemplateColumn HeaderText="发生费用">
  286. <ItemTemplate>
  287. <%# ((DataRowView)Container.DataItem)["Fee"].ToString()%>
  288. </ItemTemplate>
  289. </asp:TemplateColumn>
  290. <asp:TemplateColumn HeaderText="差旅">
  291. <ItemTemplate>
  292. <%#  GetTravel(Int32.Parse(((DataRowView)Container.DataItem)["sellmanid"].ToString()),begintime,endtime)%>
  293. </ItemTemplate>
  294. </asp:TemplateColumn>
  295. <asp:TemplateColumn HeaderText="餐饮">
  296. <ItemTemplate>
  297. <%#  GetFood(Int32.Parse(((DataRowView)Container.DataItem)["sellmanid"].ToString()),begintime,endtime)%>
  298. </ItemTemplate>
  299. </asp:TemplateColumn>
  300. <asp:TemplateColumn HeaderText="礼品">
  301. <ItemTemplate>
  302. <%#  GetGift(Int32.Parse(((DataRowView)Container.DataItem)["sellmanid"].ToString()),begintime,endtime)%>
  303. </ItemTemplate>
  304. </asp:TemplateColumn>
  305. <asp:TemplateColumn HeaderText="公关">
  306. <ItemTemplate>
  307. <%#  GetOuter(Int32.Parse(((DataRowView)Container.DataItem)["sellmanid"].ToString()),begintime,endtime)%>
  308. </ItemTemplate>
  309. </asp:TemplateColumn>
  310. <asp:TemplateColumn HeaderText="接触次数">
  311. <ItemTemplate>
  312. <%#  GetContactTimes(Int32.Parse(((DataRowView)Container.DataItem)["sellmanid"].ToString()),begintime,endtime)%>
  313. </ItemTemplate>
  314. </asp:TemplateColumn>
  315. <asp:TemplateColumn HeaderText="接触客户数量">
  316. <ItemTemplate>
  317. <%#  GetContactedClient(Int32.Parse(((DataRowView)Container.DataItem)["sellmanid"].ToString()),begintime,endtime)%>
  318. </ItemTemplate>
  319. </asp:TemplateColumn>
  320. </Columns>
  321. <PagerStyle Mode="NumericPages" HorizontalAlign="Right"></PagerStyle>
  322. </asp:datagrid></TD>
  323. </TR>
  324. <TR>
  325. <TD align="center">&nbsp;</TD>
  326. </TR>
  327. </TABLE>
  328. </FONT>
  329. </form>
  330. </body>
  331. </HTML>