Exemple #1
0
        private void Form1_Load(object sender, EventArgs e)
        {
            BookDB db = new BookDB();

            dt = db.GetEveryData();
            dgvMember.DataSource = dt;
        }
Exemple #2
0
        private void Form3_Load(object sender, EventArgs e)
        {
            InitCart();
            BookDB    db  = new BookDB();
            DataTable dt  = db.GetEveryData();
            int       idx = 1;

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                UserControl1 ucon = new UserControl1();
                ucon.Name     = $"conn{idx}";
                ucon.Location = new Point(3, (i * 200) + 10);
                ucon.Size     = new Size(566, 33);

                ucon.Bookid   = Convert.ToInt32(dt.Rows[i]["bookid"].ToString());
                ucon.Bookname = dt.Rows[i]["bookname"].ToString();
                //  ucon.Bookprice = ;        가격은 스킵
                ucon.Bookimage = dt.Rows[i]["bookimage"].ToString();

                ucon.AddCart += Ucon_AddCart;
                panel1.Controls.Add(ucon);
                idx++;
            }

            db.Dispose();
        }
        private void button3_Click(object sender, EventArgs e)
        {
            try
            {
                string sPath        = $"bookImage/{bookid}/";
                string localfile    = pictureBox1.Tag.ToString();
                string sExt         = localfile.Substring(localfile.LastIndexOf("."));
                string newfilename  = DateTime.Now.ToString("yyyyMMddHHmmssfff") + sExt;
                string destfilename = Path.Combine(sPath, newfilename);

                DirectoryInfo dir = new DirectoryInfo(sPath);

                if (!dir.Exists)
                {
                    dir.Create();
                }

                File.Copy(localfile, destfilename, true);

                BookDB db = new BookDB();

                bool result = db.UpdateBookImage(bookid, textBox2.Text, destfilename);

                if (result)
                {
                    MessageBox.Show("이미지 추가가 완료되었습니다.");
                    this.DialogResult = DialogResult.OK;
                    this.Close();
                }
                else
                {
                    MessageBox.Show("이미지 저장에 실패하였습니다. 다시 시도하여 주십시오.");
                }
            }
            catch (Exception)
            { }
        }