DAL/DalInitialize.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace DAL
{
    public class DalInitialize
    {
        /// <summary>
        /// 删除
        /// </summary>
        /// <returns></returns>
        public static Boolean UsersInitialize()
        {
            SqlDataReader reader = Dal.SqlHelpers.ExecuteGetReader(CommandType.Text, "select * from mis_users");
            if (reader.Read())
            {

                int i = Dal.SqlHelpers.ExecuteNonQuery(CommandType.Text, "delete from mis_users where user_id<>1 and user_name<>'admin'");
                if (i >= 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            else
            {
                return true;
            }
        }
        /// <summary>
        /// 删除
        /// </summary>
        /// <returns></returns>
        public static Boolean BpInitialize()
        {
            SqlDataReader reader = Dal.SqlHelpers.ExecuteGetReader(CommandType.Text, "select * from mis_bp");
            if (reader.Read())
            {

                int i = Dal.SqlHelpers.ExecuteNonQuery(CommandType.Text, "delete from mis_bp");
                if (i >= 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            else
            {
                return true;
            }
        }