protected override void Action() { log4net.ILog log = PtaUtil.getLog4netLogger(this.GetType().FullName + ".ActionInternal(): "); base.Action(); System.String bb_code = PtaUtil.GetDBReaderStringField(bboardDR, "BBoardCode"); String sql = "UPDATE BBoard SET IsRegistered = 'N', ProxyState=NULL, SharedSecret=NULL, GUID=NULL WHERE BBoardCode = @BBoardCode"; log.Info("sql: " + sql); SqlParameter[] update_bb_params = new SqlParameter[] { new SqlParameter("@BBoardCode", bb_code) }; Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(PtaUtil.GetSqlConnection(), System.Data.CommandType.Text, sql, update_bb_params); Response.Output.Write(PtaServerConstants.SIMPLE_SUCCESS_RESPONSE); }
protected override void Action() { log4net.ILog log = PtaUtil.getLog4netLogger(this.GetType().FullName + ".ActionInternal(): "); base.Action(); System.String proxy_state = Request[PtaServerConstants.STATE_KEY]; System.String bb_code = PtaUtil.GetDBReaderStringField(bboardDR, "BBoardCode"); String sql = "UPDATE BBoard SET ProxyState = @ProxyState WHERE BBoardCode = @BBoardCode"; log.Info("sql: " + sql); SqlParameter[] update_bb_params = new SqlParameter[] { new SqlParameter("@ProxyState", proxy_state), // new SqlParameter("@IsRegistered", is_reg) , new SqlParameter("@BBoardCode", bb_code) }; log.Info("proxy_state: " + proxy_state); log.Info("bb_code: " + bb_code); Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(PtaUtil.GetSqlConnection(), System.Data.CommandType.Text, sql, update_bb_params); Response.Output.Write(PtaServerConstants.SIMPLE_SUCCESS_RESPONSE); }