private void selectLogic()
{
try
{
DataTable dt = null;
dt = wDm.SelectFloorPlan(item_cd.Text);
if (dt != null && dt.Rows.Count > 0)
{
this.dgv_picture.RowCount = dt.Rows.Count;
for (int i = 0; i < dt.Rows.Count; i++)
{
dgv_picture.Rows[i].Cells["IMG_NAME"].Value = dt.Rows[i]["IMG_NAME"].ToString();
dgv_picture.Rows[i].Cells["SEQ"].Value = dt.Rows[i]["INPUT_CD"].ToString();
dgv_picture.Rows[i].Cells["INPUT_DATE"].Value = dt.Rows[i]["INPUT_DATE"].ToString();
dgv_picture.Rows[i].Cells[2].Value = "사진추가";
byte[] ip = (byte[])dt.Rows[i]["IMG"];
Image a = ByteImg(ip);
Image cus_img = pic_resize_logic(dgv_picture, a);
dgv_picture.Rows[i].Height = 194;
dgv_picture.Columns[1].Width = 300;
//dgv_picture.Rows[i].Cells["IMG_SIZE"].Value = "0";
dgv_picture.Rows[i].Cells["PICTURE"].Value = cus_img;
dgv_picture.Rows[i].Cells["IMG_SIZE"].Value = dt.Rows[i]["IMG_PATH"].ToString();
dgv_picture.Rows[i].Cells["PIC_PATH"].Value = ip;
//dgv_picture.Rows[e.RowIndex].Cells["PIC_PATH"].Value = img;
}
}
else
{
//MessageBox.Show("데이터가 없습니다");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void dgv_floorPlan_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
lbl_gbn.Text = "0";
dtp_input_date.Enabled = false;
DataTable dt = new DataTable();
try
{
dt = wDm.SelectFloorPlan(dgv_floorPlan.Rows[e.RowIndex].Cells["INPUT_DATE"].Value.ToString(), dgv_floorPlan.Rows[e.RowIndex].Cells["INPUT_CD"].Value.ToString());
dtp_input_date.Text = dgv_floorPlan.Rows[e.RowIndex].Cells["INPUT_DATE"].Value.ToString();
txt_input_cd.Text = dgv_floorPlan.Rows[e.RowIndex].Cells["INPUT_CD"].Value.ToString();
txtFloorPlanNm.Text = dt.Rows[0]["IMG_NAME"].ToString();
txt_comment.Text = dt.Rows[0]["COMMENT"].ToString();
img_size = int.Parse(dt.Rows[0]["IMG_PATH"].ToString());
if (dt.Rows[0]["IMG"] != null && !dt.Rows[0]["IMG"].ToString().Equals(""))
{
ip = (byte[])dt.Rows[0]["IMG"];
Image img = null;
if (ip.Length < 2)
{
pictureBox1.BackgroundImage = null;
}
else
{
Image a = ByteImg(ip);
img = ComInfo.pic_resize_logic(pictureBox1, a);
pictureBox1.BackgroundImage = img;
}
}
}
catch (Exception ex)
{
throw;
}
}
