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 DataTable getStickerInfo()
{
DataTable dt = haeSQLiteQuery.getStickerInfo(null);
return(dt);
}