报纸排版系统技术总结1

--添加稿单
--zhubj
--20070925
--exec ProcDraftAdd '1000001','1','1','123','12','1000005','12','12','2007-5-9','ui','fg','uyiy','1'
ALTER      proc ProcDraftAdd
(
 @HasContract int,--有无合同
 @HasMoney int , --是否收费
 @SerialNnumber nvarchar(50),--合同文本编号
 @PublishNo nvarchar(50) ,--刊登期数
 @CompanyCode nvarchar(50) ,--公司编号
 @CompanyName nvarchar(50) ,--公司名称
 @ADSize nvarchar(50),--规格大小
 @ADPosition nvarchar(50),--刊登位置
 @ComeDate nvarchar(50),--收稿日期
 @ComeFrom nvarchar(50),--稿件来源
 @SWName nvarchar(50),--客服姓名
 @Introduce nvarchar(500),--备注
 @IsValid int --是否有效
)
as
declare @ReceiveDraftCode int
select @ReceiveDraftCode = ReceiveDraftCode from ReceiveDraftTable where CompanyCode =@CompanyCode
if @ReceiveDraftCode is null
begin
 select @ReceiveDraftCode =(max(ReceiveDraftCode)+1) from ReceiveDraftTable
 if @ReceiveDraftCode is null
 set @ReceiveDraftCode = 1000001
 insert into ReceiveDraftTable
 (
  ReceiveDraftCode,
  HasContract ,
  HasMoney ,
  SerialNnumber,
  PublishNo,
  CompanyCode ,
  CompanyName,
  ADSize,
  ADPosition ,
  ComeDate,
  ComeFrom,
  SWName,
  Introduce,
  IsValid
 )
 values
 (
  @ReceiveDraftCode,
  @HasContract,
  @HasMoney ,
  @SerialNnumber,
  @PublishNo ,
  @CompanyCode,
  @CompanyName ,
  @ADSize ,
  @ADPosition,
  @ComeDate ,
  @ComeFrom,
  @SWName ,
  @Introduce ,
  @IsValid
 )
return 1;
end
else
return @ReceiveDraftCode

--验证用户旧密码是否正确
--zhubj
--20070921
--exec ProcCheckUserPassword '1000000','zhangsl'
ALTER      proc ProcCheckUserPassword
(
 @CID nvarchar(50),--用户ID
 @OldPassWord nvarchar(50)--原密码
)
as
select *  from AdminUserTab
where UserCode = @CID and UserPassword = @OldPassWord
return @@identity 

 

--更新用户密码
--zhubj
--20070921
--exec ProcUpdateUserPassword '1000000','zhubj'
ALTER      proc ProcUpdateUserPassword
(
 @CID nvarchar(50),--用户ID
 @NewPassWord nvarchar(50)--原密码
)
as
update AdminUserTab
set  UserPassword = @NewPassWord
where UserCode = @CID
return

 

PageBase.cs:

 #region 后台登录
  private const String KEY_ADMINUSERCODE = "AdminUserCode";  //网站后台登录编号
  private const String KEY_ADMINNICKNAME = "AdminNickName";  //用户的姓名
  private const String KEY_ADMIN_ROLE_ID = "AdminRoleID";   //用户的权限编号
  private const String KEY_ADMIN_ROLE_NAME = "AdminRoleName";  //用户的权限名称
  
  #region 后台登陆
  /// <summary>
  /// 帐号
  /// </summary>
  public string AdminUserCode
  {
   get
   {
    try
    {
     return (string)(Session[KEY_ADMINUSERCODE]);
    }
    catch
    {
     return ("");
    }
   }
   set
   {
    if ("" == value)
    {
     Session.Remove(KEY_ADMINUSERCODE);
    }
    else
    {
     Session[KEY_ADMINUSERCODE] = value;
    }
   }
  }

  /// <summary>
  /// 姓名
  /// </summary>
  public string AdminNickName
  {
   get
   {
    try
    {
     return (string)(Session[KEY_ADMINNICKNAME]);
    }
    catch
    {
     return (null);
    }
   }
   set
   {
    if (null == value)
    {
     Session.Remove(KEY_ADMINNICKNAME);
    }
    else
    {
     Session[KEY_ADMINNICKNAME] = value;
    }
   }
  }

  /// <summary>
  ///  角色编号
  /// </summary>
  public int AdminRoleID
  {
   get
   {
    try
    {
     return (int)(Session[KEY_ADMIN_ROLE_ID]);
    }
    catch
    {
     return (-1);
    }
   }
   set
   {
    if (-1 == value)
    {
     Session.Remove(KEY_ADMIN_ROLE_ID);
    }
    else
    {
     Session[KEY_ADMIN_ROLE_ID] = value;
    }
   }
  }

  /// <summary>
  ///  角色名称
  /// </summary>
  public string AdminRoleName
  {
   get
   {
    try
    {
     return (string)(Session[KEY_ADMIN_ROLE_NAME]);
    }
    catch
    {
     return (null);
    }
   }
   set
   {
    if (null == value)
    {
     Session.Remove(KEY_ADMIN_ROLE_NAME);
    }
    else
    {
     Session[KEY_ADMIN_ROLE_NAME] = value;
    }
   }
  }

  #endregion

  #endregion 后台登录