private void deleteStickerInfo()
{
HAESQLiteVO vo = new HAESQLiteVO();
vo.set("form_id", stickerVO.FormId);
vo.set("del_yn", "Y");
vo.set("del_dt", DateTime.Today.ToLongDateString());
vo.set("updt_dt", DateTime.Today.ToLongDateString());
if (haeSQLiteQuery.deleteStickerInfo(vo) > 0)
{
this.Close();
}
}
private void updateStickerInfo()
{
HAESQLiteVO vo = new HAESQLiteVO();
vo.set("form_id", stickerVO.FormId);
vo.set("pos_x", this.Location.X);
vo.set("pos_y", this.Location.Y);
vo.set("form_width", this.Width);
vo.set("form_height", this.Height);
vo.set("prev_form_width", this.Width);
vo.set("prev_form_height", previousFoldingSize.Height);
vo.set("form_opacity", tbarOpacity.Value);
vo.set("title", lblFormTitle.Text);
vo.set("contents", rtbContents.Text);
vo.set("contents_rtf", rtbContents.Text);
vo.set("fold_yn", (folding)? "Y":"N");
vo.set("hidden_yn", "N");
vo.set("updt_dt", DateTime.Today.ToLongDateString());
haeSQLiteQuery.updateStickerInfo(vo);
}
private void insertStickerInfo()
{
HAESQLiteVO vo = new HAESQLiteVO();
vo.set("form_id", stickerVO.FormId);
vo.set("pos_x", this.Location.X);
vo.set("pos_y", this.Location.Y);
vo.set("form_width", this.Width);
vo.set("form_height", this.Height);
vo.set("prev_form_width", this.Width);
vo.set("prev_form_height", this.Height);
vo.set("form_opacity", tbarOpacity.Value);
vo.set("title", lblFormTitle.Text);
vo.set("contents", rtbContents.Text);
vo.set("contents_rtf", rtbContents.Text);
vo.set("fold_yn", "N");
vo.set("hidden_yn", "N");
vo.set("rgst_dt", DateTime.Today.ToLongDateString());
vo.set("updt_dt", DateTime.Today.ToLongDateString());
if (haeSQLiteQuery.insertStickerInfo(vo) > 0)
{
stickerVO.IudFlag = "U";
}
}