public XtYhbModel GetModel(XtYhbModel model)
{
string sql = "SELECT top 1 * FROM dbo.xt_yhb WHERE dh=@dh AND yybh=@yybh AND mm=@mm AND xm=@xm";
using (IDbConnection conn = new DapperConnection().DbConnection)
{
return(conn.QueryFirstOrDefault <XtYhbModel>(sql, model));
}
}
public void Add(XtYhbModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into xt_yhb(");
strSql.Append("zh,xm,dh,mm,cjsj,yybh)");
strSql.Append(" values (");
strSql.Append("@zh,@xm,@dh,@mm,@cjsj,@yybh)");
using (IDbConnection conn = new DapperConnection().DbConnection)
{
conn.Execute(strSql.ToString(), model);
}
}
public void Login(XtYhbModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.AppendLine("");
}
