cm.cs

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

									    data.MakeInParam("@ClientID",  SqlDbType.Int, 4, contact.ClientID),
									    data.MakeInParam("@MarketmanID", SqlDbType.Int, 4,contact.StaffID),
									    data.MakeInParam("@UpdateTime", SqlDbType.DateTime,8, contact.UpdateTime),
									    data.MakeInParam("@ContactTime",SqlDbType.DateTime,8,contact.ContactTime),
										data.MakeInParam("@ContactAim",SqlDbType.VarChar,500,contact.ContactAim),
										data.MakeInParam("@SellMoney",SqlDbType.Int,4,contact.SellMoney),
										data.MakeInParam("@ContactTimes", SqlDbType.Int,4, contact.ContactTimes),
									    data.MakeInParam("@BargainPrognosis",SqlDbType.VarChar,50,contact.BargainPrognosis),
										data.MakeInParam("@ContactType",SqlDbType.VarChar,50,contact.ContactType),
									    data.MakeInParam("@CurStatus",SqlDbType.VarChar,100,contact.ContactStatus),
										data.MakeInParam("@Fee",SqlDbType.Int,4,contact.ThisFee),
									    data.MakeInParam("@FeeUsed",SqlDbType.VarChar,100,contact.FeeUsed),
										data.MakeInParam("@ContactContent",SqlDbType.VarChar,1000,contact.ContactContent),
										data.MakeInParam("@NextContactAim",SqlDbType.VarChar,1000,contact.NextContactAim),
										data.MakeInParam("@NextContactTime",SqlDbType.DateTime,8,contact.NextContactTime),
									   
			};
			contact.ID = data.RunProc ("sp_CM_AddContact",prams);
			

			foreach(Cooperater cooperater in contact.arrCooperater)
			{
				SqlParameter[] prams1 = new SqlParameter[]{
											data.MakeInParam("@staffid",SqlDbType.Int,4,cooperater.StaffID),
											data.MakeInParam("@contactid",SqlDbType.Int,4,contact.ID)
										};
				data.RunProc("sp_CM_AddContact_Cooperater",prams1);
			}
			foreach(Linkman linkman in contact.arrLinkman)
			{
				SqlParameter[] prams2 = new SqlParameter[]{
										  data.MakeInParam("@staffid",SqlDbType.Int,4,linkman.ID),
										  data.MakeInParam("@contactid",SqlDbType.Int,4,contact.ID)	
				};
				data.RunProc("sp_CM_AddContact_Linkman",prams2);
			}
			return(contact.ID);

		}
		#endregion

		#region 修改接触情况
		public void UpdateContact(Contact contact)
		{
			Database data = new Database();
			SqlParameter[] prams = {
									   data.MakeInParam("@ID",SqlDbType.Int,4,contact.ID),
									   data.MakeInParam("@ClientID",  SqlDbType.Int, 4, contact.ClientID),
									   data.MakeInParam("@MarketmanID", SqlDbType.Int, 4,contact.StaffID),
									   data.MakeInParam("@UpdateTime", SqlDbType.DateTime,8, contact.ContactTime),
									   data.MakeInParam("@ContactTime",SqlDbType.DateTime,8,contact.ContactTime),
									   data.MakeInParam("@ContactAim",SqlDbType.VarChar,500,contact.ContactAim),
									   data.MakeInParam("@SellMoney",SqlDbType.Int,4,contact.SellMoney),
									   data.MakeInParam("@BargainPrognosis",SqlDbType.VarChar,50,contact.BargainPrognosis),
									   data.MakeInParam("@ContactType",SqlDbType.VarChar,50,contact.ContactType),
									   data.MakeInParam("@CurStatus",SqlDbType.VarChar,100,contact.ContactStatus),
									   data.MakeInParam("@Fee",SqlDbType.Int,4,contact.ThisFee),
									   data.MakeInParam("@FeeUsed",SqlDbType.VarChar,100,contact.FeeUsed),
									   data.MakeInParam("@ContactContent",SqlDbType.VarChar,1000,contact.ContactContent),
									   data.MakeInParam("@NextContactAim",SqlDbType.VarChar,1000,contact.NextContactAim),
									   data.MakeInParam("@NextContactTime",SqlDbType.DateTime,8,contact.NextContactTime),					   
		
			};
			data.RunProc("sp_CM_UpdateContact",prams);
			SqlParameter[] prams3 = new SqlParameter[]{
														  data.MakeInParam("@contactid",SqlDbType.Int,4,contact.ID)
													  };
			data.RunProc("sp_CM_DelContact_Linkman",prams3);
			SqlParameter[] prams4 = new SqlParameter[]{
														  data.MakeInParam("@contactid",SqlDbType.Int,4,contact.ID)
													  };
			data.RunProc("sp_CM_DelContact_Cooperater",prams4);

			foreach(Cooperater cooperater in contact.arrCooperater)
			{
				SqlParameter[] prams1 = new SqlParameter[]{
															  data.MakeInParam("@staffid",SqlDbType.Int,4,cooperater.StaffID),
															  data.MakeInParam("@contactid",SqlDbType.Int,4,contact.ID)
														  };
				data.RunProc("sp_CM_AddContact_Cooperater",prams1);
			}
			foreach(Linkman linkman in contact.arrLinkman)
			{
				SqlParameter[] prams2 = new SqlParameter[]{
															  data.MakeInParam("@staffid",SqlDbType.Int,4,linkman.ID),
															  data.MakeInParam("@contactid",SqlDbType.Int,4,contact.ID)	
														  };
				data.RunProc("sp_CM_AddContact_Linkman",prams2);
			}
		}
		#endregion
	
		#region 根据客户ID得到接触信息
		public SqlDataReader GetClientContactInfo(int clientid)
		{
			Database data = new Database();
			SqlDataReader dr = null;
			SqlParameter[] prams = {
									   data.MakeInParam("@clientid",  SqlDbType.Int, 4, clientid)
								   };
			data.RunProc ("sp_CM_GetClientContactInfo",prams,out dr);
			return(dr);
		}
		#endregion

		#region 根据客户ID得到本周内接触信息
		public SqlDataReader GetClientContactInfo_thisWeek(int clientid)
		{
			Database data = new Database();
			SqlDataReader dr = null;
			SqlParameter[] prams = {
									   data.MakeInParam("@clientid",  SqlDbType.Int, 4, clientid)
								   };
			data.RunProc ("sp_CM_GetClientContactInfo_thisWeek",prams,out dr);
			return(dr);
		}
		#endregion

		#region 根据接触id得到接触信息
		public Contact GetClientContactStruct(int contactid)
		{
			Contact contact = new Contact();
			CM cm = new CM();
			Database data = new Database();
			SqlDataReader dr = null;
			SqlParameter[] prams = {
									   data.MakeInParam("@contactid",  SqlDbType.Int, 4, contactid)
								   };
			data.RunProc("sp_CM_GetContactByID",prams,out dr);
			while(dr.Read())
			{
				contact.BargainPrognosis = dr["BargainPrognosis"].ToString();
				contact.ClientID = Int32.Parse(dr["ClientID"].ToString());
				contact.ContactAim = dr["ContactAim"].ToString();
				contact.ContactContent = dr["ContactContent"].ToString();
				contact.ContactStatus = dr["CurStatus"].ToString();
				
				contact.ContactTimes = Int32.Parse(dr["ContactTimes"].ToString());
				contact.ContactType = dr["ContactType"].ToString();
				contact.FeeUsed = dr["FeeUsed"].ToString();
				contact.ID = Int32.Parse(dr["ID"].ToString());
				contact.NextContactAim = dr["NextContactAim"].ToString();
				contact.NextContactTime = DateTime.Parse(dr["NextContactTime"].ToString());
				contact.SellMoney = dr["SellMoney"].ToString();

				if(dr["contacttime"]!=DBNull.Value) 
					contact.ContactTime = DateTime.Parse(dr["contacttime"].ToString());
				else
					contact.ContactTime = DateTime.Parse("1900-1-1");

			}
			dr.Close();
			SqlParameter[] prams1 = {
									   data.MakeInParam("@contactid",  SqlDbType.Int, 4, contactid)
								   };
			data.RunProc("sp_CM_GetContactLinkman",prams1,out dr);
			while(dr.Read())
			{
				Linkman linkman = new Linkman();
				linkman.Address = dr["Address"].ToString();
				linkman.ClientID = Int32.Parse(dr["ClientID"].ToString());
				linkman.Description = dr["Description"].ToString();
				linkman.Email = dr["Email"].ToString();
				linkman.Family = dr["Family"].ToString();
				linkman.Gender = Convert.ToBoolean(dr["Gender"]);
				linkman.ID = Int32.Parse(dr["ID"].ToString());
				linkman.Mobile = dr["Mobile"].ToString();
				linkman.Name = dr["Name"].ToString();
				linkman.Position = dr["Position"].ToString();
				linkman.Telephone = dr["Telephone"].ToString();
				contact.AddLinkman(linkman);
			}
			dr.Close();
			SqlParameter[] prams2 = {
										data.MakeInParam("@contactid",  SqlDbType.Int, 4, contactid)
									};
			data.RunProc("sp_CM_GetContactCooperater",prams2,out dr);
			while(dr.Read())
			{
				Cooperater cooperater = new Cooperater();
				cooperater.StaffID = Int32.Parse(dr["CooperatingmanID"].ToString());
				contact.AddCooperater(cooperater);
			}

			return(contact);

		}
		#endregion

		#region 得到所有协同人
		public SqlDataReader GetAllCooperater()
		{
			Database data = new Database();
			SqlDataReader dr = null;
			data.RunProc ("sp_CM_GetAllCooperater",out dr);
			return(dr);
		}
		#endregion

		#region 根据客户id得到协同人
		public SqlDataReader GetCooperaterByClientID(int clientid)
		{
			Database data = new Database();
			SqlDataReader dr = null;
			SqlParameter[] prams = {
									    data.MakeInParam("@ClientID",SqlDbType.Int,4,clientid)
			};
			data.RunProc ("sp_CM_GetCooperaterByClientID",prams,out dr);
			return(dr);
		}
		#endregion

		#region 根据人员id得到客户列表
		public SqlDataReader GetMyClients(int staffid)
		{
			Database data = new Database();
			SqlDataReader dr = null;
			SqlParameter[] prams = {
									   data.MakeInParam("@staffid",  SqlDbType.Int, 4, staffid)
								   };
			data.RunProc ("sp_CM_GetClientsByStaff",prams,out dr);
			return(dr);
		}
		#endregion

		#region 根据人员id得到时间段内的接触情况
		public SqlDataReader GetContactByStaffIDandTime(int staffid,DateTime begintime,DateTime endtime)
		{
			Database data = new Database();
			SqlDataReader dr = null;
			SqlParameter[] prams = {
									   data.MakeInParam("@staffid",  SqlDbType.Int, 4, staffid),
									   data.MakeInParam("@begintime",SqlDbType.DateTime,8,begintime),
									   data.MakeInParam("@endtime",SqlDbType.DateTime,8,endtime)
								   };
			data.RunProc ("sp_CM_GetContactByStaff",prams,out dr);
			return(dr);
		}
		#endregion

		#region 在时间范围内得到销售人员列表
		public SqlDataReader GetSellman(DateTime begintime,DateTime endtime)
		{
			Database data = new Database();
			SqlDataReader dr = null;
			SqlParameter[] prams = {
									   data.MakeInParam("@begintime",SqlDbType.DateTime,8,begintime),
									   data.MakeInParam("@endtime",SqlDbType.DateTime,8,endtime)
								   };
			data.RunProc ("sp_CM_GetSellman",prams,out dr);
			return(dr);
		}
		#endregion

		#region 得到时间段接触情况
		public SqlDataReader GetContactInfo(DateTime begintime,DateTime endtime)
		{
			Database data = new Database();
			SqlDataReader dr = null;
			SqlParameter[] prams = {
									  
									   data.MakeInParam("@begintime",SqlDbType.DateTime,8,begintime),
									   data.MakeInParam("@endtime",SqlDbType.DateTime,8,endtime)
								   };
			data.RunProc ("sp_CM_GetContactInfo",prams,out dr);
			return(dr);
		}
		#endregion

		#region 得到时间段拜访客户接触情况
		public SqlDataReader GetCallinContactInfo(DateTime begintime,DateTime endtime)
		{
			Database data = new Database();
			SqlDataReader dr = null;
			SqlParameter[] prams = {
									  
									   data.MakeInParam("@begintime",SqlDbType.DateTime,8,begintime),
									   data.MakeInParam("@endtime",SqlDbType.DateTime,8,endtime)
								   };
			data.RunProc ("sp_CM_GetCallinContact",prams,out dr);
			return(dr);
		}
		#endregion

		#region 得到时间段内的新客户情况
		public SqlDataReader GetNewClient(DateTime begintime,DateTime endtime)
		{
			Database data = new Database();
			SqlDataReader dr = null;
			SqlParameter[] prams = {
									
									   data.MakeInParam("@begintime",SqlDbType.DateTime,8,begintime),
									   data.MakeInParam("@endtime",SqlDbType.DateTime,8,endtime)
								   };
			data.RunProc ("sp_CM_GetNewClient",prams,out dr);
			return(dr);
		}
		#endregion

		#region 得到时间段内的进入谈判的客户情况
		public SqlDataReader GetNegotiateClient()
		{
			Database data = new Database();
			SqlDataReader dr = null;
			data.RunProc ("sp_CM_GetNegotiateClient",out dr);
			return(dr);
		}
		#endregion

		#region 得到时间段内的进入谈判的新客户情况
		public SqlDataReader GetNewNegotiateClient(DateTime begintime,DateTime endtime)
		{
			Database data = new Database();
			SqlDataReader dr = null;
			SqlParameter[] prams = {
									
									   data.MakeInParam("@begintime",SqlDbType.DateTime,8,begintime),
									   data.MakeInParam("@endtime",SqlDbType.DateTime,8,endtime)
								   };
			data.RunProc ("sp_CM_GetNewNegotiateClient",prams,out dr);
			return(dr);
		}
		#endregion

		#region 根据sellmanid得到时间内的新客户情况
		public SqlDataReader GetNewClientBySellman(int sellmanid, DateTime begintime,DateTime endtime)
		{
			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_GetNewClientBySellmanID",prams,out dr);
			return(dr);
		}
		#endregion

		#region 得到时间段的3星客户情况
		public SqlDataReader GetNew3StarClient(DateTime begintime,DateTime endtime)
		{
			Database data = new Database();
			SqlDataReader dr = null;
			SqlParameter[] prams = {
									  
									   data.MakeInParam("@begintime",SqlDbType.DateTime,8,begintime),
									   data.MakeInParam("@endtime",SqlDbType.DateTime,8,endtime)
								   };
			data.RunProc ("sp_CM_GetNew3StarClient",prams,out dr);
			return(dr);
		}
		#endregion

		#region 得到全部3星客户情况
		public SqlDataReader Get3StarClient()
		{
			Database data = new Database();
			SqlDataReader dr = null;
			data.RunProc ("sp_CM_Get3StarClient",out dr);
			return(dr);
		}
		#endregion

		#region 根据sellmanid得到时间段的3星客户情况
		public SqlDataReader GetNew3StarClientBySellmanID(int sellmanid,DateTime begintime,DateTime endtime)
		{
			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_GetNew3StarClientBySellmanID",prams,out dr);
			return(dr);
		}
		#endregion

		#region 根据sellmanid得到时间段的接触过的客户情况
		public SqlDataReader GetContactedClientBySellmanID(int sellmanid,DateTime begintime,DateTime endtime)
		{
			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_GetContactedClientBySellman",prams,out dr);
			return(dr);
		}
		#endregion

		#region 根据sellmanid得到时间的拜访过的客户情况
		public SqlDataReader GetCallinClientBySellmanID(int sellmanid,DateTime begintime,DateTime endtime)
		{
			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_GetCallinContactBySellmanID",prams,out dr);
			return(dr);
		}
		#endregion

		#region 根据sellmanid得到时间段内的接触情况
		public SqlDataReader GetContactBySellmanID(int sellmanid,DateTime begintime,DateTime endtime)
		{
			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_GetContactBySellmanID",prams,out dr);
			return(dr);
		}
		#endregion

		#region 根据sellmanid得到时间段内的拜访接触情况
		public SqlDataReader GeCallinContactBySellmanID(int sellmanid,DateTime begintime,DateTime endtime)
		{
			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_GetCallinContactBySellmanID",prams,out dr);
			return(dr);
		}
		#endregion

		#region 得到时间段内销售人员费用情况
		public SqlDataReader GetFeeBySellmanID(int sellmanid,DateTime begintime,DateTime endtime)
		{
			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_GetContactFeeBySellmanID",prams,out dr);
			return(dr);
		}
		#endregion