admins.cs

一个出售宠物的网站,比较全面

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace hellopet
{
	/// <summary>
	/// Admins 的摘要说明。
	/// </summary>
	public class Admins
	{
		   //管理员登陆
	    public string adminLogin(string adminId,string adminPassword)
	    {
		SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
		SqlCommand myCommand=new SqlCommand("adminLogin",conn);
		myCommand.CommandType=CommandType.StoredProcedure;
		//传递参数
		SqlParameter pAdminId=new SqlParameter("@adminId",SqlDbType.Char,10);
		pAdminId.Value=adminId;
		myCommand.Parameters.Add(pAdminId);
		SqlParameter pAdminPassword=new SqlParameter("@adminPassword",SqlDbType.Char,10);
		pAdminPassword.Value=adminPassword;
		myCommand.Parameters.Add(pAdminPassword);

		conn.Open();

		SqlDataReader dr=myCommand.ExecuteReader(CommandBehavior.CloseConnection);
		if(dr.Read())
		    return adminId;
		else
		    return string.Empty;

	    }
	    //修改密码
	    public void UpdateAdminPassword(string adminId,string adminPassword)
	    {
		SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
		SqlCommand myCommand=new SqlCommand("updateAdminPassword",conn);
		myCommand.CommandType=CommandType.StoredProcedure;
		//传递参数
		SqlParameter pAdminId=new SqlParameter("@adminId",SqlDbType.Char,10);
		pAdminId.Value=adminId;
		myCommand.Parameters.Add(pAdminId);
		SqlParameter pAdminPassword=new SqlParameter("@adminPassword",SqlDbType.Char,10);
		pAdminPassword.Value=adminPassword;
		myCommand.Parameters.Add(pAdminPassword);
		
		conn.Open();
		myCommand.ExecuteNonQuery();
		conn.Close();
	    }
	    //添加新闻
	    public void AddNews(string topic,string leibie,string content,DateTime addtime,string imgName)
	    {
		SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
	    SqlCommand myCommand=new SqlCommand("addNews",conn);
	    myCommand.CommandType=CommandType.StoredProcedure;
	    //传递参数
	    SqlParameter pTopic=new SqlParameter("@topic",SqlDbType.Char,40);
	    pTopic.Value=topic;
	    myCommand.Parameters.Add(pTopic);
	    SqlParameter pLeibie=new SqlParameter("@leibie",SqlDbType.Char,10);
	    pLeibie.Value=leibie;
	    myCommand.Parameters.Add(pLeibie);
	    SqlParameter pContent=new SqlParameter("@content",SqlDbType.NText,16);
	    pContent.Value=content;
	    myCommand.Parameters.Add(pContent);
	    SqlParameter pTime=new SqlParameter("@addtime",SqlDbType.DateTime,8);
	    pTime.Value=addtime;
	    myCommand.Parameters.Add(pTime);
	    SqlParameter pImgName=new SqlParameter("@imgName",SqlDbType.Char,30);
		pImgName.Value=@imgName;
		myCommand.Parameters.Add(pImgName);

	    conn.Open();
		myCommand.ExecuteNonQuery();
		conn.Close();
	    }
	    //新闻数据显示
	    public DataSet queryNews()
	    {
		SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
		string queryStr="select topic,addtime from news";
		SqlDataAdapter da=new SqlDataAdapter(queryStr,conn);
		DataSet ds=new DataSet();
		da.Fill(ds,"news");
		return ds;
	    }
	    //读取新闻
		public SqlDataReader readNews()
		{
		SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
		SqlCommand myCommand=new SqlCommand("select * from news where topic='111111'",conn);
		    conn.Open();
		    SqlDataReader dr=myCommand.ExecuteReader();
		    return dr;

	    }
	    //查询单条新闻纪录
	    public SqlDataReader Query_details(string topic)
	    {
		SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
		SqlCommand myCommand=new SqlCommand("query_details",conn);
		myCommand.CommandType=CommandType.StoredProcedure;
		SqlParameter pTopic =new SqlParameter("@topic",SqlDbType.Char,40);
		pTopic.Value=topic;
		myCommand.Parameters.Add(pTopic);
		conn.Open();
		SqlDataReader dr=myCommand.ExecuteReader();
		return dr;

	    }
	    //删除新闻纪录
	    public void DelNews(string topic)
	    {
		SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
		string strDel="delete from news where topic ='"+topic+"'";
		SqlCommand myCommand=new SqlCommand(strDel,conn);
		
		conn.Open();
		myCommand.ExecuteNonQuery();
		conn.Close();
	    }
	    }
}