天师鬼禄,彭浩翔骂大鹏,老爸老妈浪漫史第七季
/// <summary> /// dapper数据访问抽象基础类 /// </summary> public class dapperhelper { public static string connectionstring = desencrypt.decrypt(configurationmanager.connectionstrings["soacon"].connectionstring); /// <summary> /// 连接数据库 /// </summary> /// <returns></returns> public static idbconnection dbconnection() { var connection = new sqlconnection(connectionstring);//连接sql server数据库 connection.open(); return connection; } /// <summary> /// 执行是否存在数据 /// </summary> /// <typeparam name="t"></typeparam> /// <param name="sqlstr">查询(例:select count(1) from xxx )</param> /// <param name="param">匿名类型</param> /// <returns></returns> public static bool exists(string sqlstr, object param) { using (idbconnection conn = dapperhelper.dbconnection()) { int count = conn.query<int>(sqlstr, param).firstordefault(); return count > 0 ? true : false; } } }
调用:
#region 判断是否存在库存(不论热前还是热后) /// <summary> /// 判断是否存在库存(不论热前还是热后) /// </summary> /// <param name="processcardnumber">流转卡号</param> /// <returns></returns> public bool existinventory(string processcardnumber) { string sqlstr = " select count(1) from udtwip_inventory where processcardnumber=@processcardnumber "; return dapperhelper.exists(sqlstr, new { processcardnumber = processcardnumber }); } #endregion
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
Net Core Web Api项目与在NginX下发布的方法
asp.net core3.1 引用的元包dll版本兼容性问题解决方案
IdentityServer4实现.Net Core API接口权限认证(快速入门)
ASP.NET Core MVC通过IViewLocationExpander扩展视图搜索路径的实现
网友评论