class1.cs~rf4b2166.tmp

数据配置信息 登录数据库为sa 密码123 登录界面的用户信息:shichang 密码:sc

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace DAL
{
    public class Class1
    {
        //判断用户是否存在 
         public bool GetInfo(string strusername,string struserpwd)
         {
             SqlConnection a1 = connectionDB.getcn();
             a1.Open();        
             string str = "select Count(*) from ClassUserID where UserName='" + strusername + "' and UserPassword='" + struserpwd + "'";
             SqlCommand cm = new SqlCommand(str, a1);
             return ((int)cm.ExecuteScalar()!=0);
             a1.Close();
             
             
         }

        //显示个性签明
        public string getuserlaber(string strusername, string userpwd)
        {

            SqlConnection a2 = connectionDB.getcn();
            a2.Open(); 
            string str = "select UserLable from ClassUserID where UserName='" + strusername + "' and UserPassword='" + userpwd + "'"; 
            SqlCommand cm = new SqlCommand(str, a2);
            return cm.ExecuteScalar().ToString();
            a2.Close();

        }

        //修改用户信息

        public bool updateuser(string username, string userpwd, string userlaber, string userimage)
        {
            SqlConnection a3 = connectionDB.getcn();
            a3.Open();
            string str = "update ClassUserID set UserPassword='" + userpwd + "',UserLable='" + userlaber + "',UserImage='" + userimage + "' where UserName='" + username + "' ";
            SqlCommand cm = new SqlCommand(str, a3);
            if ((int)cm.ExecuteNonQuery()!=0)
            {
                return true;
            }
            else
            {
                return false;
            }
            a3.Close();

          
        }

        //显示密码
        public string showpwd(string username)
        {
            SqlConnection a4 = connectionDB.getcn();
            a4.Open();
            string str = "select UserPassword from ClassUserID where UserName='" + username + "' ";
            SqlCommand cm = new SqlCommand(str, a4);
            return cm.ExecuteScalar().ToString();
            a4.Close();
        }

       //插入留言 
        public bool inserly(string usertitle,string usercontents,int Userid,DateTime tiem)
        {
            SqlConnection a5= connectionDB.getcn();
            a5.Open();
            string str = "insert into ClassText (UserID,UserTtitle,UserText,UserData)   values('"+Userid+"','"+usertitle+"','"+usercontents+"','"+tiem+"')";
            SqlCommand cm = new SqlCommand(str, a5);
            cm.ExecuteNonQuery();
            return true;
            a5.Close();
            
        }

        //显示用户ID号
         public int showUserID(string strusername)
        {
            SqlConnection a6= connectionDB.getcn();
            a6.Open();
            string str = "select UserID from ClassUserID where UserName='"+strusername+"'";
            SqlCommand cm = new SqlCommand(str, a6);
            return (int)cm.ExecuteScalar();
           a6.Close();
            
            
        }

        //显示用户的用户名
        public string getname(string strusername)
        {
            SqlConnection a7 = connectionDB.getcn();
            a7.Open();
            string str = "select UserName from ClassUserID where UserName='" + strusername + "'";
            SqlCommand cm = new SqlCommand(str, a7);
            return Convert.ToString(cm.ExecuteScalar());
            a7.Close();
        }

        //向表中添加新注册用户信息
        public bool insert(string txtName, string UserPassword, int age, string UserYeah, string UserAddress, string QQ, string UserMsn, string UserEmail, string YserTel, string UserImage, string UserLaber)
        {
            SqlConnection a8 = connectionDB.getcn();
            a8.Open();
            string str = "insert into ClassUserID (UserName,UserPassword,UserQQ,UserMsn,UserAddress,UserEmail,UserTel,UserYeah,UserAge,UserLable,UserImage)   values('" + txtName + "','" + UserPassword + "','" + QQ + "','" + UserMsn + "','" + UserAddress + "','" + UserEmail + "','" + YserTel + "','" + UserYeah + "','" + age + "','" + UserLaber + "','" + UserImage + "')";
            SqlCommand cm = new SqlCommand(str, a8);
            cm.ExecuteNonQuery();
            return true;
            a8.Close();
               

        }

        //返回留言人的留言信息
        public  DataSet Sele()
        {
            SqlConnection a8 = connectionDB.getcn();
            a8.Open();
            SqlDataAdapter sda = new SqlDataAdapter();
            sda.SelectCommand = new SqlCommand("select a.TextID,b.UserName,a.UserTtitle,a.UserData,a.TextBack from ClassText as a,ClassUserID as b where a.UserID=b.UserID", a8);
            DataSet ds = new DataSet();
            sda.Fill(ds,"class");
            return ds;
        }

        //返回总共有多少条留言
        public int CountText()
        {
            SqlConnection a9= connectionDB.getcn();
            a9.Open();
            string  str = "select Count(*) from ClassUserID";
            SqlCommand sqcm = new SqlCommand(str, a9);
           
            return (Convert.ToInt32(sqcm.ExecuteScalar()));
            a9.Close() ;

        }

        //累计访问了多少次

        public void UpdateSum(int aa)
        {

            SqlConnection a8 = connectionDB.getcn();
            a8.Open();
            string str="update SumTable set CountUser='"+aa+"'";
            SqlCommand sqcm1 = new SqlCommand(str, a8);
            sqcm1.ExecuteNonQuery();
            a8.Close();

            
        }

        //插入回复
        public bool InsertBack(int textid,string username,string backbody,DateTime backtime)
        {
            SqlConnection a8 = connectionDB.getcn();
            a8.Open();
            string str = "insert into ClassUserID (TextID,UserName,BackBody,BackTime)  values('"+textid+"','" + username + "','" + backbody + "','" + backtime + "')";
            SqlCommand cm = new SqlCommand(str, a8);
            cm.ExecuteNonQuery();
            a8.Close();
            return true;
        }

        //返回回复表中的回复ID号
        public int gettextID(string strname)
        {
            SqlConnection a8 = connectionDB.getcn();
            a8.Open();
            string str = "select TextID from back where UserName='" + strname+ "'";
            SqlCommand sqcm1 = new SqlCommand(str, a8);
            return (Convert.ToInt32(sqcm1.ExecuteScalar()));
            a8.Close();
        }

        

             
    }
}