userobj.cs

一个简单的新闻后台管理系统

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Generic;
using System.Data.SqlClient;

/// <summary>
/// UserObj 的摘要说明









/// </summary>
public class UserObj
{
	public UserObj()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    public static List<User> FindUserInfo()
    {
        List<User> user = new List<User>();
        DataSet ds = UserManager.FindUserInfo();
        foreach (DataRow dr in ds.Tables[0].Rows)
        {
            user.Add(new User((int)dr["UserID"], (string)dr["UserName"], (string)dr["UserPassWord"], (bool)dr["Power"]));
        }
        return user;

    }
    public static void UpdateUser(int userID, string userName)
    {
        SqlConnection con = DataAccess.CreateConnection();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "Update t_News_User set UserName=@userName Where UserID=@userID";
        cmd.Parameters.AddWithValue("@userID",userID);
        cmd.Parameters.AddWithValue("@userName",userName);
        //cmd.Parameters.AddWithValue("@userPassword", userPassword);
        //cmd.Parameters.AddWithValue("@power", power);
        try
        {
            if (cmd.Connection.State == ConnectionState.Closed)
            {
                cmd.Connection.Open();
            }
            cmd.ExecuteNonQuery();
        }
        finally
        {
            if (cmd.Connection.State == ConnectionState.Open)
            {
                cmd.Connection.Close();
            }
            cmd.Dispose();
            con.Dispose();
        }
    }
    public static void DeleteUser(int userID)
    {
        SqlConnection con = DataAccess.CreateConnection();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "delete from t_Popedom where UserID=@userID";
        cmd.Parameters.AddWithValue("@userID", userID);
        
        if (cmd.Connection.State == ConnectionState.Closed)
        {
            cmd.Connection.Open();
        }
        try
        {
            cmd.ExecuteNonQuery();
            cmd.Parameters.Clear();
            cmd.CommandText = "Delete from t_Log where UserID=@userID";
            cmd.Parameters.AddWithValue("@userID", userID);
            cmd.ExecuteNonQuery();
            cmd.Parameters.Clear();
            cmd.CommandText = "Delete from t_News where UserID=@userID";
            cmd.Parameters.AddWithValue("@userID", userID);
            cmd.ExecuteNonQuery();
            cmd.Parameters.Clear();
            cmd.CommandText = "Delete from t_News_User where UserID=@userID";
            cmd.Parameters.AddWithValue("@userID", userID);
            cmd.ExecuteNonQuery();
        }
        finally
        {
            if (cmd.Connection.State == ConnectionState.Open)
            {
                cmd.Connection.Close();
            }
            con.Dispose();
            cmd.Dispose();
        }
    }
}