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