class1.cs~rf268cc6.tmp

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

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

namespace DAL
{
    public class Class1
    {
        public  SqlConnection getcn()
        {
            SqlConnection cn = new SqlConnection("server=.;database=ClassSay;uid=sa;pwd=123");
           
        }
         public bool GetInfo(string strusername,string struserpwd)
         {
             SqlConnection a1 = Class1.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 cn1 = new SqlConnection("server=.;database=ClassSay;uid=sa;pwd=123");
            cn1.Open();
            string str = "select UserLable from ClassUserID where UserName='" + strusername + "' and UserPassword='" + userpwd + "'"; 
            SqlCommand cm = new SqlCommand(str, cn1);
            return cm.ExecuteScalar().ToString();
            cn1.Close();

        }

        public bool updateuser(string username, string userpwd, string userlaber, string userimage)
        {
            SqlConnection cn2 = new SqlConnection("server=.;database=ClassSay;uid=sa;pwd=123");
            cn2.Open();
            string str = "select UserLable from ClassUserID where UserName='" + username + "' and UserPassword='" + userpwd + "'";
            SqlCommand cm = new SqlCommand(str, cn2);
            return Ac2.getuserlaber(username, userpwd);
        }
       
    }
}