public int Update(object obj) { KifuOpen kifuOpen = (KifuOpen)obj; string sql = "UPDATE KifuOpen SET OpenID=@openID WHERE KifuID=@kifuID AND Player=@player"; SqlParameter[] parameters = new SqlParameter[3]; parameters[0] = new SqlParameter("@kifuID", kifuOpen.KifuID); parameters[1] = new SqlParameter("@openID", kifuOpen.OpenID); parameters[2] = new SqlParameter("@player", kifuOpen.Player); return(SqlHelper.ExecuteNonQuery(sql, parameters)); }
public int Insert(object obj) { KifuOpen kifuOpen = (KifuOpen)obj; string sql = "INSERT INTO KifuOpen VALUES(@kifuID,@openID,@player)"; SqlParameter[] parameters = new SqlParameter[3]; parameters[0] = new SqlParameter("@kifuID", kifuOpen.KifuID); parameters[1] = new SqlParameter("@openID", kifuOpen.OpenID); parameters[2] = new SqlParameter("@player", kifuOpen.Player); return(SqlHelper.ExecuteNonQuery(sql, parameters)); }