/// <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); }
/// <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); }