Dal/DAdmin.cs

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

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

using System;
using System.Text;

using System.Data;
using System.Data.SqlClient;
using System.Runtime.InteropServices;
using Model;


namespace Dal
{
    public partial class DAdmin
    {

        public bool SetStatus(int Id, int Status)
        {
           int rows = OLEDBHelper.ExeNonQuery("update [Admin] set locked="+Status.ToString()+" where Id="+Id.ToString(),null,CommandType.Text);
           if (rows > 0)
           {
               return true;
           }
           else
           {
               return false;
           }
        }
        /// <summary>
        /// 更新一条登录信息
        /// </summary>
        public bool UpdateLogin(MAdmin model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update Admin set ");
            strSql.Append("Id=@Id,");
            strSql.Append("LastLoginIp=@LastLoginIp,");
            strSql.Append("LastLoginTime=@LastLoginTime");
            strSql.Append(" where Id=@Id ");
            SqlParameter[] parameters = {
					new SqlParameter("@Id", SqlDbType.Int,4),
					new SqlParameter("@LastLoginIp", SqlDbType.VarChar,255),
					new SqlParameter("@LastLoginTime", SqlDbType.DateTime)};
            parameters[0].Value = model.Id;
            parameters[1].Value = model.LastLoginIp;
            parameters[2].Value = model.LastLoginTime;

            int rows = OLEDBHelper.ExeNonQuery(strSql.ToString(),parameters,CommandType.Text);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Mod(MAdmin model)
        {