public static MySqlParameter AddQueryParam(this ZinSQL sql, string field, object value, bool addParam = false, string op = "=") { sql.SetParamQuery(field, op); if (addParam) { sql.AddParam(field); } return(new MySqlParameter(string.Format("@{0}", field), value)); }
/// <summary> /// 保存数据 /// </summary> public void SaveData <T>(string type, T data, DatabaseConfig config = null) where T : new() { #if NoneWriteSQL return; #endif try { var sql = new ZinSQL("game_data"); var paramList = new List <MySqlParameter>(); paramList.Add(sql.AddParam("DataValue", SerializationHelper.Serialize <T>(data))); paramList.Add(sql.AddParam("DataType", type)); sql.SetQuery("DataType", type); sql.Config = config; InsertOrUpdate(sql, paramList); } catch (Exception ex) { // LogHelper.WriteErrorLog(ex); // LogHelper.WriteErrorLog(string.Format("Save Data {0} Error", type)); } }
public static MySqlParameter AddParam(this ZinSQL sql, string field, object value) { sql.AddParam(field); return(new MySqlParameter(string.Format("@{0}", field), value)); }