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