25 lines
642 B
C#
25 lines
642 B
C#
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Linq;
|
|||
|
|
using System.Text;
|
|||
|
|
using System.Threading.Tasks;
|
|||
|
|
using dccdc.Models;
|
|||
|
|
using System.Data;
|
|||
|
|
using Dapper;
|
|||
|
|
|
|||
|
|
namespace dccdc.DAL
|
|||
|
|
{
|
|||
|
|
public class sqwzbxmxDal
|
|||
|
|
{
|
|||
|
|
public List<sqwzbxmxModel> GetListByParent(string id)
|
|||
|
|
{
|
|||
|
|
//throw new NotImplementedException();
|
|||
|
|
using (IDbConnection conn = CommHelper.GetSqlConnection())
|
|||
|
|
{
|
|||
|
|
string sql = "select * from sqwzbxmx where 1=1 and sqdid=@parentid";
|
|||
|
|
return conn.Query<sqwzbxmxModel>(sql, new { parentid = id }).ToList();
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|