/// <summary>
/// 根据用户编号获取用户信息
/// </summary>
/// <param name="inModel"></param>
/// <returns></returns>
public void UserList(UserInquireModel inModel)
{
if (inModel != null && inModel.UserID > 0)
{
_userDal.UserList(inModel);
}
}
public ActionResult Index(UserInquireModel inModel)
{
inModel.UserID = 1;
_Userbll.UserList(inModel);
ViewBag.Title = "Home Page";
return(View());
}
/// <summary>
/// 根据用户编号获取用户信息
/// </summary>
/// <param name="inModel"></param>
/// <returns></returns>
public void UserList(UserInquireModel inModel)
{
const string SqlStr = @"select ID=ID_int,
UserAccount = UserAccount_nvarchar,
UserPassword = UserPassword_nvarchar,
[Status]=Status_bit,
LastLoginTime=LastLoginTime_datetime,
Remark=Remark_nvarchar,
CreateTime=CreateTime_datetime
from[dbo].[User]
where ID_int = @id";
using (Conn)
{
inModel.userList = Conn.Query <UserModel>(SqlStr, new { id = inModel.UserID }).FirstOrDefault();
}
}
