dbClass/Admins.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
namespace dbClass
{
   public  class Admins
    {
       public bool IsAdminHasBy(string condition)
       {
           bool IsOK = false;
           string sql = "select * from admins where " + condition;
           SqlConnection con = new SqlConnection(SqlHelper.connstring);
           con.Open();
           SqlCommand cmd=new SqlCommand(sql,con);
           SqlDataReader sdr=cmd.ExecuteReader();
           if (sdr.Read())
           {
               IsOK = true;

           }
           sdr.Close();
           con.Close();
           return IsOK;

       }
       public bool IsBlog_AdminHasBy(string condition)
       {
           bool IsOK = false;
           string sql = "select * from Blog_Admin where " + condition;
           SqlConnection con = new SqlConnection(SqlHelper.connstring);
           con.Open();
           SqlCommand cmd = new SqlCommand(sql, con);
           SqlDataReader sdr = cmd.ExecuteReader();
           if (sdr.Read())
           {
               IsOK = true;

           }
           sdr.Close();
           con.Close();
           return IsOK;

       } 
       /// <summary>
       /// 添加用户
       /// </summary>
       /// <returns>true-成功;false-失败</returns>
       public bool AddAdmin(string name, string pwd)
       {
           bool isOK = false;
           if (IsAdminHasBy("name='" + name + "'"))
           {
               isOK = false;
           }
          
           string sql = "insert into admins (name,pwd,pDate) values ('" + name + "','" + pwd + "','" + DateTime.Now.ToString() + "')";
           SqlConnection con = new SqlConnection(SqlHelper.connstring);
           con.Open();
           SqlCommand cmd = new SqlCommand(sql, con);