public int Update(StatisticAccessModels item) { int rs = 0; StringBuilder sqlBuilder = new StringBuilder(); sqlBuilder.Append(" UPDATE "); sqlBuilder.Append(" gov_statistic_access "); sqlBuilder.Append(" SET "); sqlBuilder.Append(" count = "); sqlBuilder.Append(item.Count); sqlBuilder.Append(" WHERE "); sqlBuilder.Append(" date = '" + item.Date.ToString("yyyy/MM/dd") + "'"); this.Sql = sqlBuilder.ToString(); MySqlCommand objCmd = new MySqlCommand(Sql, getConnection()); rs = objCmd.ExecuteNonQuery(); return rs; }
public int insert(StatisticAccessModels item) { int rs = 0; StringBuilder sqlBuilder = new StringBuilder(); sqlBuilder.Append("INSERT "); sqlBuilder.Append("INTO "); sqlBuilder.Append("gov_statistic_access "); sqlBuilder.Append("( "); sqlBuilder.Append("date, "); sqlBuilder.Append("count "); sqlBuilder.Append(") "); sqlBuilder.Append("values("); sqlBuilder.Append("@1, @2"); sqlBuilder.Append(")"); this.Sql = sqlBuilder.ToString(); MySqlCommand objCmd = new MySqlCommand(Sql, getConnection()); objCmd.Parameters.AddWithValue("@1", item.Date); objCmd.Parameters.AddWithValue("@2", item.Count); rs = objCmd.ExecuteNonQuery(); return rs; }