?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();
        }
    }
}