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

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

渠道的需求：

用力图：

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

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

添加的存储过程：

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层代码：

///

/// 添加一条渠道基本信息，返回当前添加的渠道的编号 ///

/// /// int 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 = model.UserID; parameters[2].Value = model.SuperiorChannel; parameters[3].Value = model.ChannelName; parameters[4].Value = model.Tel1; parameters[5].Value = model.Tel2; parameters[6].Value = model.Fax; parameters[7].Value = model.Address; parameters[8].Value = model.Email; parameters[9].Value = model.ChannelLevel; parameters[10].Value = model.NetAddress; parameters[11].Value = model.CreditStanding; parameters[12].Value = model.EnrollTime; parameters[13].Value = model.NextContactTime; parameters[14].Value = model.AlternateTime; parameters[15].Value = model.StratTime; parameters[16].Value = model.ChannelSize; parameters[17].Value = model.Vocation; parameters[18].Value = model.ChannelType; parameters[19].Value = model.Status; parameters[20].Value = model.Areal; parameters[21].Value = model.Province; parameters[22].Value = model.City; parameters[23].Value = model.TaxNumber; parameters[24].Value = model.AccountName; parameters[25].Value = model.Accounts; parameters[26].Value = model.CoSummary; parameters[27].Value = model.CoreOperttion; parameters[28].Value = model.DeleteState; int count= DataBaseHelper.ExcuteSqlReturnInt("BioErpCrmManageChannel_ADD", CommandType.StoredProcedure, parameters); if (count != 0) { return int.Parse(parameters[0].Value.ToString()); } else { return 0; } }

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。