/// <summary> /// 判断是否存在 /// </summary> public static bool Has(this MySqlConnection conn, ZinSQL sql) { var fields = sql.GetFields(); var count = conn.ExecuteScalar(string.Format("select COUNT({1}) from {0} where {2} = {3}", sql.TableName, fields, fields, sql.GetValues())); return(Convert.ToInt32(count) > 0); }
/// <summary> /// 计数 /// </summary> public static int Count(this MySqlConnection conn, ZinSQL sql, List <MySqlParameter> paramList) { var sqlStr = string.Empty; if (string.IsNullOrEmpty(sql.Where)) { sqlStr = string.Format("select count({1}) from {0}", sql.TableName, sql.GetFields()); } else { sqlStr = string.Format("select count({1}) from {0} where {2}", sql.TableName, sql.GetFields(), sql.Where); } return(conn.ExecuteScalar(sqlStr, paramList).ToInt()); }
/// <summary> /// 获取 /// </summary> public static List <object[]> Get(this MySqlConnection conn, ZinSQL sql, List <MySqlParameter> paramList) { var sqlStr = string.Empty; if (string.IsNullOrEmpty(sql.Where)) { sqlStr = string.Format("select {1} from {0}", sql.TableName, sql.GetFields()); } else { sqlStr = string.Format("select {1} from {0} where {2}", sql.TableName, sql.GetFields(), sql.Where); } return(conn.ExecuteQuery(sqlStr, paramList)); }
/// <summary> /// 插入信息 /// </summary> public static void Insert(this MySqlConnection conn, ZinSQL sql, List <MySqlParameter> paramList) { conn.ExecuteNonQuery(string.Format("insert into {0}({1}) values({2})", sql.TableName, sql.GetFields(), sql.GetValues()), paramList); }
public static object GetScalarResult(this MySqlConnection conn, ZinSQL sql, List <MySqlParameter> paramList) { if (string.IsNullOrEmpty(sql.Where)) { return(conn.ExecuteScalar(string.Format("select {1} from {0}", sql.TableName, sql.GetFields()), paramList)); } else { return(conn.ExecuteScalar(string.Format("select {1} from {0} where {2}", sql.TableName, sql.GetFields(), sql.Where), paramList)); } }