浏览1个人可以建军存储过程,红月私服,红月私服发布网,红月一条龙,红月sf-http://www.zhaohy.net

	网站首页

	私服发布

	查询已开游戏

	技术文章

	家族发布

	红月家族

	相关下载

	开区一条龙

	技术论坛

1个人可以建军存储过程

文章作者:admin

文章来源:找红月服就在zhaohy.net-国内最齐全红月私服游戏开服网|zhaohy.net

更新时间：2015/4/21 13:47:11

ALTER  PROCEDURE RMS_ARMY_CREATERESERVEARMY
      @Camp             tinyint,
      @Name             varchar(10),
      @Commander       varchar(14),
      @Notice       varchar(166)

AS
set nocount on

begin transaction RMS_ARMY_CREATERESERVEARMY

      declare @ActivityDate datetime
      declare @CreateTime datetime
      declare @RowCount int
      set @CreateTime=getdate()

      set @ActivityDate=DateAdd(day,7,@CreateTime)

      select @RowCount=count(*) from tblArmyList1 where Name=@Name or Commander=@Commander
      if @RowCount=0
      begin

            insert tblArmyList1 values (0,-1, @Camp, @Name,@Commander,'',getdate(), @ActivityDate,@Notice,0)

            declare @ID int
            select @ID=ID from tblArmyList1 where Commander=@Commander
            if @@ROWCOUNT!=0
            begin
                     EXEC RMS_ARMY_WRITEARMYLOG @ArmyID=@ID,@LogKind='预备自由军创建'
                     INSERT tblArmyMemberList1 (RegularSoldier,ArmyID,SubArmyID,JoinTime) VALUES('魔影建军1号',@ID,0,getdate())
                     INSERT tblArmyMemberList1 (RegularSoldier,ArmyID,SubArmyID,JoinTime) VALUES('魔影建军2号',@ID,0,getdate())
                     INSERT tblArmyMemberList1 (RegularSoldier,ArmyID,SubArmyID,JoinTime) VALUES('魔影建军3号',@ID,0,getdate())
                     INSERT tblArmyMemberList1 (RegularSoldier,ArmyID,SubArmyID,JoinTime) VALUES('魔影建军4号',@ID,0,getdate())
                     INSERT tblArmyMemberList1 (RegularSoldier,ArmyID,SubArmyID,JoinTime) VALUES('魔影建军5号',@ID,0,getdate())
                     INSERT tblArmyMemberList1 (RegularSoldier,ArmyID,SubArmyID,JoinTime) VALUES('魔影建军6号',@ID,0,getdate())
                     INSERT tblArmyMemberList1 (RegularSoldier,ArmyID,SubArmyID,JoinTime) VALUES('魔影建军7号',@ID,0,getdate())
                     INSERT tblArmyMemberList1 (RegularSoldier,ArmyID,SubArmyID,JoinTime) VALUES('魔影建军8号',@ID,0,getdate())
                     INSERT tblArmyMemberList1 (RegularSoldier,ArmyID,SubArmyID,JoinTime) VALUES('魔影建军9号',@ID,0,getdate())
                     INSERT tblArmyMemberList1 (RegularSoldier,ArmyID,SubArmyID,JoinTime) VALUES('魔影建军10号',@ID,0,getdate())
            end
      end
commit transaction RMS_ARMY_CREATERESERVEARMY
GO
如果想4个人建军则去掉4条插入就可以了
注意因为3.8不能一个人加入多个军需要把tblArmyMemberList1 表的RegularSoldier主键去掉
原创作者：紫夜残风
转载请留下版权  首发：红月基地 www.hygm.net

浏览次数：775