fee.aspx.cs

除了具有传统OA的邮件、工作流、文档等功能外

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace UDS.SubModule.CM.Stat
{
	/// <summary>
	/// Fee 的摘要说明。
	/// </summary>
	public partial class Fee : System.Web.UI.Page
	{
	
		protected DateTime begintime;
		protected DateTime endtime;
		private string type = "";
		protected int totalfee = 0;

		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!Page.IsPostBack)
			{
				begintime = (Request.QueryString["begintime"]==null)?DateTime.Now:DateTime.Parse(Request.QueryString["begintime"]);
				endtime = (Request.QueryString["endtime"]==null)?DateTime.Now:DateTime.Parse(Request.QueryString["endtime"]);
				type = (Request.QueryString["type"]==null)?"":Request.QueryString["type"];
				ViewState["begintime"] = begintime;
				ViewState["endtime"]  = endtime;
				ViewState["type"]  = type;

				tbx_begintime.Text = begintime.ToShortDateString();
				tbx_endtime.Text = endtime.ToShortDateString();

				foreach(ListItem li in ddl_order.Items)
				{
					if(li.Value==type)
					{
						li.Selected = true;
					}
					else
					{
						li.Selected = false;
					}
				}
				if(type!="") BindData(type);
			}
			else
			{
				begintime = DateTime.Parse(ViewState["begintime"].ToString());
				endtime = DateTime.Parse(ViewState["endtime"].ToString());
				type    = ViewState["type"].ToString();
			}
		}

		private void BindData(string type)
		{
			begintime = DateTime.Parse(tbx_begintime.Text);
			endtime   = DateTime.Parse(tbx_endtime.Text);

			UDS.Components.CM cm = new UDS.Components.CM();
			DataSet ds = new DataSet();
			UDS.Components.Staff staff = new UDS.Components.Staff();

			SqlDataReader dr_staff = staff.GetAllStaffs();
			DataTable dt_staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_staff);
			dt_staff.TableName = "Staff";
			ds.Tables.Add(dt_staff);

			SqlDataReader dr_client = cm.GetContactedClientBySellmanID(0,begintime,endtime);
			DataTable dt_client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_client);
			dt_client.TableName = "Client";
			ds.Tables.Add(dt_client);

			ltl_Client.Text = dt_client.Rows.Count.ToString();

			if(type=="client")//按客户排列
			{
				dgrd_clientfee.Visible = true;
				dgrd_sellmanfee.Visible = false;

				SqlDataReader dr_contact = cm.GetContactInfo(begintime,endtime);
				DataTable dt_contact = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_contact);
				dt_contact.TableName = "Contact";
				ds.Tables.Add(dt_contact);

				SqlDataReader dr_linkman = cm.GetAllLinkman();
				DataTable dt_linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkman);
				dt_linkman.TableName = "Linkman";
				ds.Tables.Add(dt_linkman);

				ds.Relations.Add("ClientAddMan_Staff",ds.Tables["Client"].Columns["AddManID"],ds.Tables["Staff"].Columns["Staff_ID"],false);
				ds.Relations.Add("ClientLinkman_Staff",ds.Tables["Client"].Columns["ChiefLinkmanID"],ds.Tables["Linkman"].Columns["ID"],false);
				ds.Relations.Add("Client_Contact",ds.Tables["Client"].Columns["ID"],ds.Tables["Contact"].Columns["ClientID"],false);

				dgrd_clientfee.DataSource = dt_client.DefaultView;
				dgrd_clientfee.DataBind();

				ltl_Fee.Text = totalfee.ToString();
			}
			else if(type=="sellman")
			{
				dgrd_clientfee.Visible = false;
				dgrd_sellmanfee.Visible = true;

				SqlDataReader dr_sellman = cm.GetSellman(begintime,endtime);
				DataTable dt_sellman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_sellman);
				dt_sellman.TableName = "Sellman";
				ds.Tables.Add(dt_sellman);

				foreach(DataRow row in dt_sellman.Rows)
				{
					totalfee += Int32.Parse(row["fee"].ToString());
				}

				ds.Relations.Add("StaffID_RealName",ds.Tables["Sellman"].Columns["Staff_Name"],ds.Tables["Staff"].Columns["Staff_Name"],false); 

				dgrd_sellmanfee.DataSource = dt_sellman.DefaultView;
				dgrd_sellmanfee.DataBind();

				ltl_Fee.Text = totalfee.ToString();
			}
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    

		}
		#endregion

		protected void btn_OK_Click(object sender, System.EventArgs e)
		{
			BindData(ddl_order.SelectedItem.Value);
		}

		protected void ddl_order_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			if(((DropDownList)sender).SelectedItem.Value=="client")
			{
				dgrd_clientfee.Visible = true;
				dgrd_sellmanfee.Visible = false;
			}
			else if(((DropDownList)sender).SelectedItem.Value=="sellman")
			{
				dgrd_clientfee.Visible = false;
				dgrd_sellmanfee.Visible = true;
			}
			BindData(((DropDownList)sender).SelectedItem.Value);
		}
	}
}