private void button2_Click(object sender, EventArgs e)
{
StickerVO stickerVO = new StickerVO();
stickerVO.IudFlag = "I";
stickerVO.FormId = DateTime.Now.ToString("yyyyMMddhhmmss");
stickerVO.Title = "새메모";
stickerVO.FormWidth = 200;
stickerVO.FormHeight = 200;
stickerVO.FormOpacity = 100;
HAEForm h = new HAEForm(stickerVO);
h.Show();
h.Focus();
}
private void openNewSticker()
{
StickerVO stickerVO = new StickerVO();
stickerVO.IudFlag = "I";
stickerVO.FormId = DateTime.Now.ToString("yyyyMMddhhmmss");
stickerVO.Title = "새메모";
stickerVO.FormWidth = 200;
stickerVO.FormHeight = 200;
stickerVO.FormOpacity = 100;
HAEForm h = new HAEForm(stickerVO, this);
haeFormList.Add(h);
h.StartPosition = FormStartPosition.CenterScreen;
h.Location = new Point(stickerVO.PosX, stickerVO.PosY);
h.Show();
h.Focus();
}
private void button1_Click(object sender, EventArgs e)
{
HAESQLiteQuery haeSQLiteQuery = new HAESQLiteQuery();
////20190618141000
//HAESQLiteVO vo = new HAESQLiteVO();
//vo.set("form_id", "20190618141000");
//DataTable dt = haeSQLiteQuery.getStickerInfoByFormId(vo);
//DataTable dt = haeSQLiteQuery.getStickerInfo(null);
//dataGridView1.DataSource = dt;
//HAESQLiteHelper sqlite = new HAESQLiteHelper();
//string sql = "select * from sticker";
//DataTable dt = sqlite.selectData(sql);
//dataGridView1.DataSource = dt;
DataTable dt = haeSQLiteQuery.getStickerInfo(null);
dataGridView1.DataSource = dt;
for (int idx = 0; idx < dt.Rows.Count; idx++)
{
DataRow dr = dt.Rows[idx];
StickerVO stickerVO = new StickerVO();
stickerVO.IudFlag = "U";
stickerVO.FormId = Convert.ToString(dr["form_id"]);
stickerVO.PosX = Convert.ToInt32(dr["pos_x"]);
stickerVO.PosY = Convert.ToInt32(dr["pos_y"]);
stickerVO.FormWidth = Convert.ToInt32(dr["form_width"]);
stickerVO.FormHeight = Convert.ToInt32(dr["form_height"]);
stickerVO.FormOpacity = Convert.ToInt32(dr["form_opacity"]);
stickerVO.Title = Convert.ToString(dr["title"]);
stickerVO.Contents = Convert.ToString(dr["contents"]);
stickerVO.FoldYn = Convert.ToString(dr["fold_yn"]);
HAEForm h = new HAEForm(stickerVO);
h.StartPosition = FormStartPosition.Manual;
h.Location = new Point(stickerVO.PosX, stickerVO.PosY);
h.Show();
h.Focus();
}
}
private void openSticker()
{
DataTable dt = getStickerInfo();
for (int idx = 0; idx < dt.Rows.Count; idx++)
{
DataRow dr = dt.Rows[idx];
//이미 List<HAEForm>에 등록된 sticker는 다시 화면에 띄위지 않는다.
if (findOpenedSticker(Convert.ToString(dr["form_id"])))
{
}
else
{
StickerVO stickerVO = new StickerVO();
stickerVO.IudFlag = "U";
stickerVO.FormId = Convert.ToString(dr["form_id"]);
stickerVO.PosX = Convert.ToInt32(dr["pos_x"]);
stickerVO.PosY = Convert.ToInt32(dr["pos_y"]);
stickerVO.FormWidth = Convert.ToInt32(dr["form_width"]);
stickerVO.FormHeight = Convert.ToInt32(dr["form_height"]);
stickerVO.FormOpacity = Convert.ToInt32(dr["form_opacity"]);
stickerVO.FormPrevWidth = Convert.ToInt32(dr["prev_form_width"]);
stickerVO.FormPrevHeight = Convert.ToInt32(dr["prev_form_height"]);
stickerVO.Title = Convert.ToString(dr["title"]);
stickerVO.Contents = Convert.ToString(dr["contents"]);
stickerVO.FoldYn = Convert.ToString(dr["fold_yn"]);
HAEForm h = new HAEForm(stickerVO, this);
//중복된 sticker를 다시 발행하지 않기 위해 List<HAEForm>에 등록
haeFormList.Add(h);
h.StartPosition = FormStartPosition.Manual;
h.Location = new Point(stickerVO.PosX, stickerVO.PosY);
h.Show();
h.Focus();
}
}
}