ERP客户关系渠管理（二十）

首页 > 代码库 > ERP客户关系渠管理（二十）

ERP客户关系渠管理（二十）

2024-08-21 14:51:43 226人阅读

渠道的需求：

技术分享

用力图：

技术分享

渠道对应客户关系的意义？

渠道是指产品从生产出来到终端消费的流通环节。

技术分享

添加的存储过程：

ALTER PROCEDURE [dbo].[BioErpCrmManageChannel_ADD]
@ChannelID int output,
@UserID int,
@SuperiorChannel int,
@ChannelName nvarchar(50),
@Tel1 nvarchar(20),
@Tel2 nvarchar(20),
@Fax nvarchar(20),
@Address nvarchar(50),
@Email nvarchar(50),
@ChannelLevel nvarchar(20),
@NetAddress nvarchar(50),
@CreditStanding nvarchar(20),
@EnrollTime datetime,
@NextContactTime datetime,
@ChannelSize nvarchar(50),
@Vocation nvarchar(50),
@ChannelType nvarchar(30),
@Status nvarchar(30),
@Areal nvarchar(20),
@Province nvarchar(20),
@City nvarchar(20),
@TaxNumber nvarchar(50),
@AccountName nvarchar(50),
@Accounts nvarchar(50),
@CoSummary nvarchar(1000),
@CoreOperttion nvarchar(500)


 AS 
	INSERT INTO [BioErpCrmManageChannel](
	[UserID],[SuperiorChannel],[ChannelName],[Tel1],[Tel2],[Fax],[Address],[Email],[ChannelLevel],[NetAddress],[CreditStanding],[EnrollTime],[NextContactTime],[ChannelSize],[Vocation],[ChannelType],[Status],[Areal],[Province],[City],[TaxNumber],[AccountName],[Accounts],[CoSummary],[CoreOperttion]
	)VALUES(
	@UserID,@SuperiorChannel,@ChannelName,@Tel1,@Tel2,@Fax,@Address,@Email,@ChannelLevel,@NetAddress,@CreditStanding,@EnrollTime,@NextContactTime,@ChannelSize,@Vocation,@ChannelType,@Status,@Areal,@Province,@City,@TaxNumber,@AccountName,@Accounts,@CoSummary,@CoreOperttion
	)
	SET @ChannelID = @@IDENTITY

渠道修改的存储过程：

ALTER PROCEDURE [dbo].[BioErpCrmManageChannel_Update]
@ChannelID int,
@UserID int,
@SuperiorChannel int,
@ChannelName nvarchar(50),
@Tel1 nvarchar(20),
@Tel2 nvarchar(20),
@Fax nvarchar(20),
@Address nvarchar(50),
@Email nvarchar(50),
@ChannelLevel nvarchar(20),
@NetAddress nvarchar(50),
@CreditStanding nvarchar(20),
@EnrollTime datetime,
@NextContactTime datetime,

@ChannelSize nvarchar(50),
@Vocation nvarchar(50),
@ChannelType nvarchar(30),
@Status nvarchar(30),
@Areal nvarchar(20),
@Province nvarchar(20),
@City nvarchar(20),
@TaxNumber nvarchar(50),
@AccountName nvarchar(50),
@Accounts nvarchar(50),
@CoSummary nvarchar(1000),
@CoreOperttion nvarchar(500),
@DeleteState bit
 AS 
	UPDATE [BioErpCrmManageChannel] SET 
	[UserID] = @UserID,[SuperiorChannel] = @SuperiorChannel,[ChannelName] = @ChannelName,[Tel1] = @Tel1,[Tel2] = @Tel2,[Fax] = @Fax,[Address] = @Address,[Email] = @Email,[ChannelLevel] = @ChannelLevel,[NetAddress] = @NetAddress,[CreditStanding] = @CreditStanding,[EnrollTime] = @EnrollTime,[NextContactTime] = @NextContactTime,[ChannelSize] = @ChannelSize,[Vocation] = @Vocation,[ChannelType] = @ChannelType,[Status] = @Status,[Areal] = @Areal,[Province] = @Province,[City] = @City,[TaxNumber] = @TaxNumber,[AccountName] = @AccountName,[Accounts] = @Accounts,[CoSummary] = @CoSummary,[CoreOperttion] = @CoreOperttion,[DeleteState] = @DeleteState
	WHERE ChannelID=@ChannelID

渠道的联系人添加的存储过程：

ALTER PROCEDURE [dbo].[BioErpCrmChannelLinkMan_ADD]
@ChannelID int,
@LinkmanName nvarchar(50),
@Sex bit,
@Birthday datetime,
@IsMainLinkman bit,
@OfficialPhone nvarchar(20),
@MobilePhone nvarchar(20),
@Email nvarchar(50),
@Address nvarchar(50),
@QQ nvarchar(20),
@Remark nvarchar(500)
 AS 
	INSERT INTO [BioErpCrmChannelLinkMan](
	[ChannelID],[LinkmanName],[Sex],[Birthday],[IsMainLinkman],[OfficialPhone],[MobilePhone],[Email],[Address],[QQ],[Remark]
	)VALUES(
	@ChannelID,@LinkmanName,@Sex,@Birthday,@IsMainLinkman,@OfficialPhone,@MobilePhone,@Email,@Address,@QQ,@Remark
	)

渠道联系人修改：

ALTER PROCEDURE [dbo].[BioErpCrmChannelLinkMan_Update]
@LinkmanID int,
@ChannelID int,
@LinkmanName nvarchar(50),
@Sex bit,
@Birthday datetime,
@IsMainLinkman bit,
@OfficialPhone nvarchar(20),
@MobilePhone nvarchar(20),
@Email nvarchar(50),
@Address nvarchar(50),
@QQ nvarchar(20),
@Remark nvarchar(500),
@DeleteState bit
 AS 
	UPDATE [BioErpCrmChannelLinkMan] SET 
	[ChannelID] = @ChannelID,[LinkmanName] = @LinkmanName,[Sex] = @Sex,[Birthday] = @Birthday,[IsMainLinkman] = @IsMainLinkman,[OfficialPhone] = @OfficialPhone,[MobilePhone] = @MobilePhone,[Email] = @Email,[Address] = @Address,[QQ] = @QQ,[Remark] = @Remark,[DeleteState] = @DeleteState
	WHERE LinkmanID=@LinkmanID

联系记录（添加）：（添加的时候状态给默认值）

ALTER PROCEDURE [dbo].[BioErpCrmChannelContactNote_ADD]
@ChannelID int,
@RelationRecord nvarchar(1000),
@RelationTime datetime,
@LinkmanID int,
@RelationType nvarchar(50),
@LinkMethod nvarchar(50),
@Userid int


 AS 
	INSERT INTO [BioErpCrmChannelContactNote](
	[ChannelID],[RelationRecord],[RelationTime],[LinkmanID],[RelationType],[LinkMethod],[Userid]
	)VALUES(
	@ChannelID,@RelationRecord,@RelationTime,@LinkmanID,@RelationType,@LinkMethod,@Userid
	)

修改：

ALTER PROCEDURE [dbo].[BioErpCrmChannelContactNote_Update]
@RelationID int,
@ChannelID int,
@RelationRecord nvarchar(1000),
@RelationTime datetime,
@LinkmanID int,
@RelationType nvarchar(50),
@LinkMethod nvarchar(50),
@Userid int,
@DeleteState bit
 AS 
	UPDATE [BioErpCrmChannelContactNote] SET 
	[ChannelID] = @ChannelID,[RelationRecord] = @RelationRecord,[RelationTime] = @RelationTime,[LinkmanID] = @LinkmanID,[RelationType] = @RelationType,[LinkMethod] = @LinkMethod,[Userid] = @Userid,[DeleteState] = @DeleteState
	WHERE RelationID=@RelationID

活动管理（添加）：

ALTER PROCEDURE [dbo].[BioErpCrmChannelActivity_ADD]
@ActiveName nvarchar(100),
@ChannelID int,
@ActivityTime datetime,
@ActivityAddress nvarchar(100),
@Principal nvarchar(10),
@ActivityDesc nvarchar(4000)
 AS 
	INSERT INTO [BioErpCrmChannelActivity](
	[ActiveName],[ChannelID],[ActivityTime],[ActivityAddress],[Principal],[ActivityDesc]
	)VALUES(
	@ActiveName,@ChannelID,@ActivityTime,@ActivityAddress,@Principal,@ActivityDesc
	)

修改：

ALTER PROCEDURE [dbo].[BioErpCrmChannelActivity_Update]
@ActivityID int,
@ActiveName nvarchar(100),
@ChannelID int,
@ActivityTime datetime,
@ActivityAddress nvarchar(100),
@Principal nvarchar(10),
@ActivityDesc nvarchar(4000),
@DeleteState bit
 AS 
	UPDATE [BioErpCrmChannelActivity] SET 
	[ActiveName] = @ActiveName,[ChannelID] = @ChannelID,[ActivityTime] = @ActivityTime,[ActivityAddress] = @ActivityAddress,[Principal] = @Principal,[ActivityDesc] = @ActivityDesc,[DeleteState] = @DeleteState
	WHERE ActivityID=@ActivityID

文档的添加：

ALTER PROCEDURE [dbo].[BioErpCrmChannelDocument_ADD]
@DocumentID int,
@ChannelID int
 AS 
	INSERT INTO [BioErpCrmChannelDocument](
	[DocumentID],[ChannelID]
	)VALUES(
	@DocumentID,@ChannelID
	)

文档的修改：

ALTER PROCEDURE [dbo].[BioErpCrmChannelDocument_Update]
@ChannelDocumentID int,
@DocumentID int,
@ChannelID int,
@DeleteState bit
 AS 
	UPDATE [BioErpCrmChannelDocument] SET 
	[DocumentID] = @DocumentID,[ChannelID] = @ChannelID,[DeleteState] = @DeleteState
	WHERE ChannelDocumentID=@ChannelDocumentID

添加的BLL层代码：

 /// <summary>
      /// 添加一条渠道基本信息，返回当前添加的渠道的编号
      /// </summary>
      /// <param name="channel"></param>
        /// <returns>int</returns>
      public int BioErpCrmManageChannelAdd(BioErpCrmManageChannel model)
      {
          SqlParameter[] parameters = {
					new SqlParameter("@ChannelID", SqlDbType.Int,4),
					new SqlParameter("@UserID", SqlDbType.Int,4),
					new SqlParameter("@SuperiorChannel", SqlDbType.Int,4),
					new SqlParameter("@ChannelName", SqlDbType.NVarChar,50),
					new SqlParameter("@Tel1", SqlDbType.NVarChar,20),
					new SqlParameter("@Tel2", SqlDbType.NVarChar,20),
					new SqlParameter("@Fax", SqlDbType.NVarChar,20),
					new SqlParameter("@Address", SqlDbType.NVarChar,50),
					new SqlParameter("@Email", SqlDbType.NVarChar,50),
					new SqlParameter("@ChannelLevel", SqlDbType.NVarChar,20),
					new SqlParameter("@NetAddress", SqlDbType.NVarChar,50),
					new SqlParameter("@CreditStanding", SqlDbType.NVarChar,20),
					new SqlParameter("@EnrollTime", SqlDbType.DateTime),
					new SqlParameter("@NextContactTime", SqlDbType.DateTime),
					new SqlParameter("@AlternateTime", SqlDbType.DateTime),
					new SqlParameter("@StratTime", SqlDbType.DateTime),
					new SqlParameter("@ChannelSize", SqlDbType.NVarChar,50),
					new SqlParameter("@Vocation", SqlDbType.NVarChar,50),
					new SqlParameter("@ChannelType", SqlDbType.NVarChar,30),
					new SqlParameter("@Status", SqlDbType.NVarChar,30),
					new SqlParameter("@Areal", SqlDbType.NVarChar,20),
					new SqlParameter("@Province", SqlDbType.NVarChar,20),
					new SqlParameter("@City", SqlDbType.NVarChar,20),
					new SqlParameter("@TaxNumber", SqlDbType.NVarChar,50),
					new SqlParameter("@AccountName", SqlDbType.NVarChar,50),
					new SqlParameter("@Accounts", SqlDbType.NVarChar,50),
					new SqlParameter("@CoSummary", SqlDbType.NVarChar,1000),
					new SqlParameter("@CoreOperttion", SqlDbType.NVarChar,500),
					new SqlParameter("@DeleteState", SqlDbType.Bit,1)};
          parameters[0].Direction = ParameterDirection.Output;          
          parameters[1].Value = http://www.mamicode.com/model.UserID;"BioErpCrmManageChannel_ADD", CommandType.StoredProcedure, parameters);
        if (count != 0)
        {
            return int.Parse(parameters[0].Value.ToString());
        }
        else
        {
            return 0;
        }
      
      }

ERP客户关系渠管理（二十）

声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉：投诉/举报工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。

联系
我们

首页 > 代码库 > ERP客户关系渠管理（二十）

ERP客户关系渠管理（二十）

看完仍有疑问？有类似问题直接问程序猿