/// <summary>
/// 更新
/// </summary>
/// <param name="id">更新対象ID</param>
/// <param name="text">テキスト</param>
private bool Update(string id, string text)
{
using (var accessor = new SqlAccessor())
using (var statement = new SqlStatement("Sample", "Update"))
{
var ht = new Hashtable
{
{ "id", id },
{ "text", text }
};
var result = statement.ExecStatementWithOC(accessor, ht);
return(result > 0);
}
}
/// <summary>
/// ログインユーザを登録する
/// </summary>
/// <returns></returns>
private bool UpsertUser()
{
// 対象のテーブルはLOGINIDにユニークIndexを設定し重複を弾く
using (var accessor = new SqlAccessor())
using (var statement = new SqlStatement("BBSUser", "Upsert"))
{
var ht = new Hashtable
{
{ BBSConst.SQL_PRAM_USER_ID, Session[BBSConst.SESSION_NAME_TEMP_USERID].ToString() },
{ BBSConst.SQL_PRAM_LOGIN_ID, Session[BBSConst.SESSION_NAME_TEMP_LOGINID].ToString() },
{ BBSConst.SQL_PRAM_PASSWORD, Session[BBSConst.SESSION_NAME_TEMP_PASSWORD].ToString() },
{ BBSConst.SQL_PRAM_USER_NAME, Session[BBSConst.SESSION_NAME_TEMP_USER_NAME].ToString() }
};
var result = statement.ExecStatementWithOC(accessor, ht);
return(result > 0);
}
}
/// <summary>
/// 掲示板の登録更新処理を行う
/// </summary>
/// <returns></returns>
private bool UpsertThread()
{
// 対象のテーブルはLOGINIDにユニークIndexを設定し重複を弾く
using (var accessor = new SqlAccessor())
using (var statement = new SqlStatement("Thread", "Upsert"))
{
var ht = new Hashtable
{
{ BBSConst.SQL_PRAM_USER_ID, Session[BBSConst.SESSION_NAME_USERID].ToString() },
{ BBSConst.SQL_PRAM_TITLE, tbTitle.Text },
{ BBSConst.SQL_PRAM_POST_TEXT, tbPostText.Text },
{ BBSConst.SQL_PRAM_THREAD_ID, hdnTreadId.Value == "0" ? 0 : int.Parse(hdnTreadId.Value) },
{ BBSConst.SQL_PRAM_IS_DELETED, hdnIsDeleteFlg.Value == "0" ? 0 : 1 },
{ BBSConst.SQL_PRAM_ORIGIN_THREAD_ID, hdnOrigenTreadId.Value == "0" ? 0 : int.Parse(hdnOrigenTreadId.Value) }
};
var result = statement.ExecStatementWithOC(accessor, ht);
return(result > 0);
}
}
