/// <summary> /// 是否存在记录 /// </summary> /// <param name="sqlwhere">条件</param> /// <param name="files">查询字段</param> /// <param name="orderby">排序</param> /// <returns>bool</returns> public virtual T GetModel(string sqlwhere, string files, string orderby) { if (string.IsNullOrEmpty(sqlwhere)) { sqlwhere = "1=1"; } if (string.IsNullOrEmpty(files)) { files = "*"; } if (string.IsNullOrEmpty(orderby)) { orderby = "id desc"; } try { T t = WriteDataBase.SingleOrDefault <T>(Sql.Builder.Select(files).From(TableName).Where(sqlwhere).OrderBy(orderby)); return(t); } catch (Exception ex) { LogHelper.Error(ex); WriteDataBase.CloseSharedConnection(); return(null); } finally { WriteDataBase.CloseSharedConnection(); } }
/// <summary> /// 是否存在记录 /// </summary> /// <param name="id">主键ID</param> /// <returns>bool</returns> public virtual T GetModel(int id) { string sqlwhere = string.Empty; if (id > 0) { sqlwhere = "id=" + id; } try { T t = WriteDataBase.SingleOrDefault <T>(Sql.Builder.From(TableName).Where(sqlwhere)); return(t); } catch (Exception ex) { LogHelper.Error(ex); WriteDataBase.CloseSharedConnection(); return(null); } finally { WriteDataBase.CloseSharedConnection(); } }