DAL/SiteDAL.cs

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

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;


namespace MySite
{
    public class SiteDAL
    {
        private SqlConnection sqlcon;
        private SqlCommand sqlcom;
        private string strCon = "Data Source=.;Initial Catalog=MyDB;Integrated Security=true";
                
        public DataSet GetUser(string id, string name ,string sex)
        {
            string sqlstr = "select * from UserInfo where 1=1 ";
            if (id != "" && id != null)
            {
                sqlstr = sqlstr + " And (Id = '" + id + "')";
            }
            else
            {
                if (name != "" && name != null)
                {
                    sqlstr = sqlstr + " And (Id like '%" + name + "%' Or Name like '%" + name + "%')";
                }
            }
            if (sex != "全部")
            {
                sqlstr = sqlstr + " And Sex='" + sex + "'";
            }
            sqlcon = new SqlConnection(strCon);
            SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
            DataSet myds = new DataSet();
            sqlcon.Open();
            myda.Fill(myds, "user");            
            sqlcon.Close();
            return myds;
        }

        internal int DeleteSafe(string Id)
        {
            string sqlstr = "delete from safeInfo where Id='" + Id + "'";
            sqlcon = new SqlConnection(strCon);
            sqlcom = new SqlCommand(sqlstr, sqlcon);
            sqlcon.Open();
            int result = sqlcom.ExecuteNonQuery();
            sqlcon.Close();
            return result;
        }

        internal DataSet GetSafe(string id ,string name, DateTime? jxrq)
        {
            string sqlstr = "select * from SafeInfo where 1=1 ";
            if (!string.IsNullOrEmpty(id))
            {
                sqlstr = sqlstr + " And (Id = " + id + ")";