//———————————————以下不操作缓存———————————————————
/// <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);
}
