role.cs

来自「天织在线购物网站完整源码及文档 本网站是一套基于Web2.0思想设计、采用」· CS 代码 · 共 73 行

/********************************************************************************
** 作者：高亮
** 创始时间： 2007-12-22
** 描述：
**    主要用于后台管理员进行用户的角色分配，…
** 表：
*********************************************************************************/
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Configuration;
namespace background
{
    public class Role
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["TZroomConnectionString"].ConnectionString);
        /// <summary>
        /// 
        /// </summary>
        /// <param name="name">普通用户的名字</param>
        /// <returns></returns>
        public bool popedom(String name) {
            String T_name = name;
            String sql = "insert into administrator(administrator,password) select UserName,Password from U_Info where UserName='" + T_name + "'";
            SqlCommand cmd = new SqlCommand(sql, conn);
            int Result = -1;
            try
            {
                conn.Open();
                Result = cmd.ExecuteNonQuery();
                int delyes = -1;
                delyes = del(T_name);
                if (Result != -1 && delyes != -1)
                {
                    return true;
                }
                else {
                    return false;
                }
            }
            catch (Exception ex)
            {
                throw (ex);
            }
            finally {
                conn.Close();
            }
        }
        public int del(String name) {
            String T_name = name;
            String sql = "delete from U_Info where UserName='" + T_name + "'";
            SqlCommand cmd = new SqlCommand(sql, conn);
            int Result = -1;
            try
            {
                Result = cmd.ExecuteNonQuery();
                if (Result != -1)
                {
                    return 1;
                }
                else {
                    return -1;
                }
            }
            catch (Exception ex)
            {
                throw (ex);
            }
        }
    }
}