cm.cs

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

		#region 根据sellmanid得到时间段内的差旅费用
		public int GetTravelFeeBySellmanID(int sellmanid,DateTime begintime,DateTime endtime)
		{
			int result = 0;
			Database data = new Database();
			SqlDataReader dr = null;
			SqlParameter[] prams = {
									   data.MakeInParam("@sellmanid",SqlDbType.Int,4,sellmanid),
									   data.MakeInParam("@begintime",SqlDbType.DateTime,8,begintime),
									   data.MakeInParam("@endtime",SqlDbType.DateTime,8,endtime)
								   };
			data.RunProc ("sp_CM_GetTravelFeeBySellmanID",prams,out dr);
			while(dr.Read())
			{
				if(dr["fee"]!=DBNull.Value)
					result = Int32.Parse(dr["fee"].ToString());
			}
			return(result);
		}
		#endregion

		#region 根据sellmanid得到时间段内的餐饮费用
		public int GetFoodFeeBySellmanID(int sellmanid,DateTime begintime,DateTime endtime)
		{
			int result = 0;
			Database data = new Database();
			SqlDataReader dr = null;
			SqlParameter[] prams = {
									   data.MakeInParam("@sellmanid",SqlDbType.Int,4,sellmanid),
									   data.MakeInParam("@begintime",SqlDbType.DateTime,8,begintime),
									   data.MakeInParam("@endtime",SqlDbType.DateTime,8,endtime)
								   };
			data.RunProc ("sp_CM_GetFoodFeeBySellmanID",prams,out dr);
			while(dr.Read())
			{
				if(dr["fee"]!=DBNull.Value)
					result = Int32.Parse(dr["fee"].ToString());
			}
			return(result);
		}
		#endregion

		#region 根据sellmanid得到时间段内的礼品费用
		public int GetGiftFeeBySellmanID(int sellmanid,DateTime begintime,DateTime endtime)
		{
			int result = 0;
			Database data = new Database();
			SqlDataReader dr = null;
			SqlParameter[] prams = {
									   data.MakeInParam("@sellmanid",SqlDbType.Int,4,sellmanid),
									   data.MakeInParam("@begintime",SqlDbType.DateTime,8,begintime),
									   data.MakeInParam("@endtime",SqlDbType.DateTime,8,endtime)
								   };
			data.RunProc ("sp_CM_GetGiftFeeBySellmanID",prams,out dr);
			while(dr.Read())
			{
				if(dr["fee"]!=DBNull.Value)
					result = Int32.Parse(dr["fee"].ToString());
			}
			return(result);
		}
		#endregion

		#region 根据sellmanid得到时间段内的公关费用
		public int GetOuterFeeBySellmanID(int sellmanid,DateTime begintime,DateTime endtime)
		{
			int result = 0;
			Database data = new Database();
			SqlDataReader dr = null;
			SqlParameter[] prams = {
									   data.MakeInParam("@sellmanid",SqlDbType.Int,4,sellmanid),
									   data.MakeInParam("@begintime",SqlDbType.DateTime,8,begintime),
									   data.MakeInParam("@endtime",SqlDbType.DateTime,8,endtime)
								   };
			data.RunProc ("sp_CM_GetOuterFeeBySellmanID",prams,out dr);
			while(dr.Read())
			{
				if(dr["fee"]!=DBNull.Value)
					result = Int32.Parse(dr["fee"].ToString());
			}
			return(result);
		}
		#endregion

		#region 上传一个文件得到id号
		public int InsertFile(string path,string type,int pertainid,string extension)
		{
			Database data = new Database();
			SqlParameter[] prams = {
									   data.MakeInParam("@path",SqlDbType.VarChar,500,path),
									   data.MakeInParam("@type",SqlDbType.VarChar,50,type),
									   data.MakeInParam("@pertainID",SqlDbType.Int,4,pertainid),
									   data.MakeInParam("@extension",SqlDbType.VarChar,100,extension)
								   };
			
			return(data.RunProc ("sp_CM_AddFile",prams));
		}

		#endregion

		#region 根据contactid得到上传附件信息
		public SqlDataReader GetAttachmentByContactID(int contactid)
		{
			Database data = new Database();
			SqlDataReader dr = null;
			SqlParameter[] prams = {
									   data.MakeInParam("@contactid",SqlDbType.Int,4,contactid)
								   };
			data.RunProc ("sp_CM_GetAttachmentByContactID",prams,out dr);
			return(dr);
		}
		#endregion

		#region 根据clientid得到上传附件信息
		public SqlDataReader GetAttachmentByClientID(int clientid)
		{
			Database data = new Database();
			SqlDataReader dr = null;
			SqlParameter[] prams = {
									   data.MakeInParam("@clientid",SqlDbType.Int,4,clientid)
								   };
			data.RunProc ("sp_CM_GetAttachmentByClientID",prams,out dr);
			return(dr);
		}
		#endregion


	}

	#region 数据结构

	#region 客户结构
	/// <summary>
	/// 客户信息
	/// </summary>
	public class ClientInfo
	{
		private int id = 0;
		private DateTime birthday = DateTime.Now;
		private DateTime updatetime = DateTime.Now;
		private string clientshortname = "";
		private string clientname = "";
		private int chieflinkmanid = 0;
		private string linkman_telephone = "";
		private string clienttype = "";
		private string enterprisetype = "";
		private string clienttrade = "";
		private string clientsource = "";
		private string clientinitiative = "";
		private int addmanid = 0;
		private int contacttimes = 0;
		private string sellphase = "";
		private string bargainprognosis = "";
		private float fee = 0;
		private string curstatus = "";
		private string type = "";

		/// <summary>
		/// 客户ID
		/// </summary>
		public int ID
		{
			get{return id;}
			set{id = value;	}
		}
		/// <summary>
		/// 添加日期
		/// </summary>
		public DateTime Birthday
		{
			get{return birthday;}
			set{birthday = value;}
		}
		/// <summary>
		/// 最后更新日期
		/// </summary>
		public DateTime UpdateTime
		{
			get{return updatetime;}
			set{updatetime = value;}
		}
		/// <summary>
		/// 添加人ID
		/// </summary>
		public int AddManID
		{
			get{return addmanid;}
			set{addmanid = value;}
		}
		/// <summary>
		/// 客户简称
		/// </summary>
		public string ClientShortName
		{
			get{return clientshortname;}
			set{clientshortname = value;}
		}
		/// <summary>
		/// 主要联系人ID
		/// </summary>
		public int ChiefLinkmanID
		{
			get{return chieflinkmanid;}
			set{chieflinkmanid = value;}
		}
		/// <summary>
		/// 客户全称
		/// </summary>
		public string ClientName
		{
			get{return clientname;}
			set{clientname = value;}
		}
		/// <summary>
		/// 客户分类
		/// </summary>
		public string ClientType
		{
			get{return clienttype;}
			set{clienttype = value;}
		}
		/// <summary>
		/// 企业性质
		/// </summary>
		public string EnterpriseType
		{
			get{return enterprisetype;}
			set{enterprisetype = value;}
		}
		/// <summary>
		/// 所处行业
		/// </summary>
		public string ClientTrade
		{
			get{return clienttrade;}
			set{clienttrade = value;}
		}
		/// <summary>
		/// 客户来源
		/// </summary>
		public string ClientSource
		{
			get{return clientsource;}
			set{clientsource = value;}
		}
		/// <summary>
		/// 客户主动
		/// </summary>
		public string ClientInitiative
		{
			get{return clientinitiative;}
			set{clientinitiative = value;}
		}
		/// <summary>
		/// 接触次数
		/// </summary>
		public int ContactTimes
		{
			get{return contacttimes;}
			set{contacttimes = value;}
		}
		/// <summary>
		/// 销售阶段
		/// </summary>
		public string SellPhase
		{
			get{return sellphase;}
			set{sellphase = value;}
		}
		/// <summary>
		/// 成交评估
		/// </summary>
		public string BargainPrognosis
		{
			get{return bargainprognosis;}
			set{bargainprognosis = value;}
		}
		/// <summary>
		/// 发生费用
		/// </summary>
		public float Fee
		{
			get{return fee;}
			set{fee = value;}
		}
		/// <summary>
		/// 联系人电话
		/// </summary>
		public string Linkman_Telephone
		{
			get{return linkman_telephone;}
			set{linkman_telephone = value;}
		}
		/// <summary>
		/// 当前状态
		/// </summary>
		public string CurStatus
		{
			get{return curstatus;}
			set{curstatus = value;}
		}
		/// <summary>
		/// 客户分类
		/// </summary>
		public string Type
		{
			get{return type;}
			set{type = value;}
		}

		private string affiliatedarea = "";
		/// <summary>
		/// 隶属区域
		/// </summary>
		public string Affiliatedarea
		{
			get{return affiliatedarea;}
			set{affiliatedarea = value;}
		}

		private string url = "";
		/// <summary>
		/// 网址
		/// </summary>
		public string URL
		{
			get{return url;}
			set{url = value;}
		}

		private string zip = "";
		/// <summary>
		/// 邮编
		/// </summary>
		public string ZIP
		{
			get{return zip;}
			set{zip = value;}
		}

		private string address = "";
		/// <summary>
		/// 地址
		/// </summary>
		public string Address
		{
			get{return address;}
			set{address = value;}
		}

		private string companyproperty = "";
		/// <summary>
		/// 公司性质
		/// </summary>
		public string CompanyProperty
		{
			get{return companyproperty;}
			set{companyproperty = value;}
		}

		private string calling = "";
		/// <summary>
		/// 所处行业
		/// </summary>
		public string Calling
		{
			get{return calling;}
			set{calling = value;}
		}

		private string companysize = "";
		/// <summary>
		/// 公司规模
		/// </summary>
		public string CompanySize
		{
			get{return companysize;}
			set{companysize = value;}
		}

		private string money = "";
		/// <summary>
		/// 注册资金
		/// </summary>
		public string Money
		{
			get{return money;}
			set{money = value;}
		}

		private string operation = "";
		/// <summary>
		/// 主营业务
		/// </summary>
		public string Operation
		{
			get{return operation;}
			set{operation = value;}
		}
		
		private string introduce = "";
		/// <summary>
		/// 企业简介
		/// </summary>
		public string Introduce
		{
			get{return introduce;}
			set{introduce = value;}
		}

		private string itgrade = "";
		/// <summary>
		/// 信息化程度
		/// </summary>
		public string ITGrade
		{
			get{return itgrade;}
			set{itgrade = value;}
		}

		private int pcnumber = 0;
		/// <summary>
		/// 电脑数量
		/// </summary>
		public  int PCNumber
		{
			get{return pcnumber;}
			set{pcnumber = value;}
		}

		private string net = "";
		/// <summary>
		/// 网络状况
		/// </summary>
		public string Net
		{
			get{return net;}
			set{net = value;}
		}
		
		private int itstaffs = 0;
		/// <summary>
		/// 专业IT人员
		/// </summary>
		public int ITStaffs
		{
			get{return itstaffs;}
			set{itstaffs = value;}
		}
		
		private string itdepartment = "";
		/// <summary>
		/// IT部门
		/// </summary>