Mozi.DataAccess

[{
	"name": "mz.createtableuser",
	"command": "query",
	"parameter": [ ],
	"statement": "
		IF NOT EXISTS(SELECT 1 FROM sysobjects WHERE id=object_id(\'$schema$.tbUsers\') AND TYPE =\'U\'))
		CREATE TABLE tbUsers
		(
				UserId   varchar(10) default \'\' not null ,
				NickName varchar(100) default \'\' not null,
				UserPwd  varchar(32) default \'\' not null,
				RegDate  date not null,
				Mobile   varchar(20) default \'\' not null,
				IsForbidden int default 0 not null
				CONSTRAINT PK_TBUSERS PRIMARY KEY (UserId)
		)
	",
	"results": [ ],
	"comment": "创建用户信息表"
},{
	"name": "mz.getuserinfo",
	"command": "query",
	"parameter": [ "UserId" ],
	"statement": "select * from $schema$.tbUsers where UserId=#param.UserId# ",
	"results": [ "UserId", "Nickname" ],
	"comment": "获取用户信息"
}]   

using System;

namespace Mozi.DataAccess.Test.Model
{
	public class User
    {
        public string UserId    { get; set; }
        public string NickName  { get; set; }
        public string Password  { get; set; }
        public string Mobile    { get; set; }
        public DateTime RegDate { get; set; }
        public int IsForbidden  { get; set; }
    }
}

    public class DaUser
    {
        /// <summary>
        /// 数据库访问对象
        /// </summary>
        SQLServer.Access _server = new SQLServer.Access(new ServerConfig()
        {
            Host="127.0.0.1",
            Instance="",
            User="sa",
            Password="123456",
            ConnectionName="测试库",
            Database="example"
        });
        /// <summary>
        /// 查询指定的用户
        /// </summary>
        /// <param name="userid"></param>
        /// <returns></returns>
        public User GetUsers(string userid)
        {
            SqlStatement sql = SqlMapContainer.Find("mz.getuserinfo");
            return _server.ExecuteQueryForTop<User>(sql, new { UserId = userid });
        }
    }