?? daluserrole.cs
字號:
?using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
/// <summary>
///DALUserRole 的摘要說明
/// </summary>
namespace corInfMan.DAL
{
public class DALUserRole
{
public DALUserRole()
{
//
//TODO: 在此處添加構造函數邏輯
//
}
public void userInRole(string username,string rolename)
{
string sqlStr = "insert into aspnet_UserRole values(@UserName,@RoleName)";
SqlParameter[] parm = { new SqlParameter("@UserName", SqlDbType.NVarChar), new SqlParameter("@RoleName", SqlDbType.NVarChar) };
parm[0].Value = username;
parm[1].Value = rolename;
corInfMan.Utility.SQLHelper.ExecuteSql(sqlStr, parm);
}
public string usersRole(string name)
{
string sqlStr = "select RoleName from aspnet_UserRole where UserName=@name";
SqlParameter[] parm = { new SqlParameter("@name",SqlDbType.NVarChar)};
parm[0].Value = name;
return corInfMan.Utility.SQLHelper.GetSingle(sqlStr, parm).ToString();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -