/// <summary>
/// 得到一行企业信息
/// </summary>
/// <param name="yybh"></param>
/// <returns></returns>
public QyJbxxModel GetqyjbxxOne(string yybh, string dwbh)
{
using (IDbConnection conn = new DapperConnection().DbConnection)
{
string sql = "select * from qy_jbxx a where yybh='" + yybh + "' and isdept=0 and bh='" + dwbh + "'";
QyJbxxModel model = conn.Query <QyJbxxModel>(sql, null).FirstOrDefault();
return(model);
}
}
/// <summary>
/// 企业登陆
/// </summary>
/// <param name="yybh"></param>
/// <param name="dwbh"></param>
/// <param name="zh"></param>
/// <returns></returns>
public QyJbxxModel GetqyjbxxDl(string yybh, string dwbh, string zh, string mm)
{
using (IDbConnection conn = new DapperConnection().DbConnection)
{
string sql = "select * from qy_jbxx a where yybh=@yybh and isdept=0 and bh=@dwbh and zh=@zh and mm=@mm";
QyJbxxModel model = conn.Query <QyJbxxModel>(sql, new { yybh = yybh, dwbh = dwbh, zh = zh, mm = mm }).FirstOrDefault();
return(model);
}
}
