QMS.DAL/Base/Admin.cs

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

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

//=======================本页代码由代码生成工具所生成,请勿手动调整=======================
using System;
using System.Collections;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Web.Mvc;
using System.Web.Caching;
using QMS.Model;
using QMS.Common;

namespace QMS.DAL.Base
{
/// <summary>
/// 管理员-数据访问类
/// 创建人:
/// 日期:2017/4/23 0:06:36
/// </summary>
public class  Admin:_base
{
#region 获取缓存DataSet
/// <summary>
/// 获取缓存DataSet
/// </summary>
/// <param name="trans"></param>
/// <returns></returns>
public DataSet GetCacheDataSet(SqlTransaction trans)
{
string key = "Cache_Admin_DataSet";
DataSet ds;
object value = CacheHelper.GetCache(key);
if (value != null)
ds = (DataSet)value;
else
{
ds = GetDataSet(trans, CommandType.Text, "select * from t_Admin", null);
CacheHelper.AddCache(key, ds, null, Cache.NoAbsoluteExpiration, TimeSpan.FromMinutes(20), CacheItemPriority.Normal, null);
}
return ds;
}
#endregion
#region 实体转换
/// <summary>
/// 实体转换
/// </summary>
protected AdminModel Model(DataRow dr)
{
AdminModel admModel=new AdminModel();
admModel.AdminID=Convert.IsDBNull(dr["AdminID"]) ? 0 : (int)dr["AdminID"];
admModel.AdminName=Convert.IsDBNull(dr["AdminName"]) ? "" : (string)dr["AdminName"];
admModel.AdminPass=Convert.IsDBNull(dr["AdminPass"]) ? "" : (string)dr["AdminPass"];
admModel.RealName=Convert.IsDBNull(dr["RealName"]) ? "" : (string)dr["RealName"];
admModel.Sex=Convert.IsDBNull(dr["Sex"]) ? 0 : (int)dr["Sex"];
admModel.Email=Convert.IsDBNull(dr["Email"]) ? "" : (string)dr["Email"];
admModel.Mobile=Convert.IsDBNull(dr["Mobile"]) ? "" : (string)dr["Mobile"];
admModel.Comment=Convert.IsDBNull(dr["Comment"]) ? "" : (string)dr["Comment"];
admModel.LoginNum=Convert.IsDBNull(dr["LoginNum"]) ? 0 : (int)dr["LoginNum"];
admModel.LastLoginTime=Convert.IsDBNull(dr["LastLoginTime"]) ? Convert.ToDateTime("1900-1-1") : (DateTime)dr["LastLoginTime"];