//———————————————以下不操作缓存——————————————————— /// <summary> /// 根据id直接从数据库获取数据,防注入了 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="tableName"></param> /// <param name="listName">比如userInfo 下划线自带</param> /// <param name="id">就是id</param> /// <returns></returns> public static T GetById <T>(string tableName, int id) where T : class, new() { using (SqlConnection conn = new SqlConnection(connStr)) { string selectAll = "select * from " + tableName + " where id =@id "; var dict = new Dictionary <string, string>(); dict.Add("@id", id.ToString()); var table = SqlHelperHere.ExecuteGetDt(selectAll, dict); return(table.ConvertToList <T>().FirstOrDefault()); } }
/// <summary> /// 判断某个字段的某个值在表中是否存在,传0就不跟自己比较了(IsDeleted=0) /// </summary> /// <param name="tableName"></param> /// <param name="fieldName"></param> /// <param name="value"></param> /// <param name="id"></param> /// <returns></returns> public bool IsExists(string tableName, string fieldName, string value, string id) { string str = "select * from " + tableName + " where isDeleted='False' and id!=" + id + " and " + fieldName + " = @value"; SqlCommand com = new SqlCommand(str); com.Parameters.AddWithValue("@value", value); var r = SqlHelperHere.ExecuteScalar(com); if (r == null) { return(false); } return(true); }