public IEnumerable <ComSort> GetListByGroupID(int id)
{
using (IDbConnection db = _dapper.GetDbConn())
{
string query = $@"select * from ComSort where ComSort.GroupID = '{id}'";
return(db.Query <ComSort>(query));
}
}
public ComUser CheckUser(ComUser user)
{
using (IDbConnection db = _dapper.GetDbConn())
{
string query = $@"select * from ComUser where ComUser.UserName = '******' and ComUser.UserPwd = '{user.UserPwd}'";
return(db.QueryFirstOrDefault <ComUser>(query));
}
}
public IEnumerable <ComGroup> GetList()
{
using (IDbConnection db = _dapper.GetDbConn())
{
string query = $@"select * from ComGroup";
return(db.Query <ComGroup>(query));
}
}
