コード例 #1
0
ファイル: MakingDAO.cs プロジェクト: YeJuneJi/FinalGoodeeWay
        internal MakingFormVO SelectMakingBySaleNo(int salesNo)
        {
            string sp = "SelectMakingBySaleNo";

            SqlParameter[] sqlParameters = new SqlParameter[]
            {
                new SqlParameter("salesNo", salesNo)
            };

            try
            {
                MakingFormVO makingFormVO = new MakingFormVO();

                SqlDataReader sdr = new DBConnection().Select(sp, sqlParameters);
                while (sdr.Read())
                {
                    makingFormVO.Num      = int.Parse(sdr["num"].ToString());
                    makingFormVO.SalesNo  = int.Parse(sdr["salesNo"].ToString());
                    makingFormVO.ToMaking = sdr["tomaking"].ToString();
                    makingFormVO.Division = sdr["division"].ToString();
                }

                return(makingFormVO);
            }
            catch (SqlException ee)
            {
                System.Windows.Forms.MessageBox.Show(ee.StackTrace);
                throw;
            }
        }
コード例 #2
0
ファイル: MakingDAO.cs プロジェクト: YeJuneJi/FinalGoodeeWay
        internal List <MakingFormVO> SelectMaking()
        {
            List <MakingFormVO> lst = new List <MakingFormVO>();
            string sp = "SelectMaking";

            SqlParameter[] sqlParameters = null;

            try
            {
                SqlDataReader sdr = new DBConnection().Select(sp, sqlParameters);
                while (sdr.Read())
                {
                    MakingFormVO makingFormVO = new MakingFormVO();
                    makingFormVO.Num      = int.Parse(sdr["num"].ToString());
                    makingFormVO.SalesNo  = int.Parse(sdr["salesNo"].ToString());
                    makingFormVO.ToMaking = sdr["tomaking"].ToString();
                    makingFormVO.Division = sdr["division"].ToString();

                    lst.Add(makingFormVO);
                }

                return(lst);
            }
            catch (SqlException ee)
            {
                System.Windows.Forms.MessageBox.Show(ee.StackTrace);
                throw;
            }
        }
コード例 #3
0
        private void FrmDetailSaleRecord_Load(object sender, EventArgs e)
        {
            pbxImages.BringToFront();
            pbxImages.Image = Image.FromFile(Application.StartupPath + "\\images\\" + "NewGooDeeWay.png");
            myToolTip.SetToolTip(btnRefund, "환불");
            lblSalesNo.Text    = "주문번호 : " + salesNo.ToString();
            lblSalesDate.Text  = "판매날짜 : " + salesDate.ToString();
            lblTotalPrice.Text = "금액 : " + totalPrice.ToString();

            tbxMenus.Text += "================주문 내역========================\r\n";

            //매개변수로 전달받은 Json 형식의 판매물품명을 분석해
            foreach (var rmv in realMenuVO.RealMenu)
            {
                //구분별 판매물품명을 출력한다.
                if (rmv.Menu.Division.Equals(Convert.ToString((int)Division.샌드위치)))
                {
                    tbxMenus.Text += "\r\n\r\n<<" + Enum.GetName(typeof(Division), int.Parse(rmv.Menu.Division)) + ">>\r\n" + rmv.Menu.MenuName;
                }
                else
                {
                    tbxMenus.Text += "\r\n\r\n<<" + Enum.GetName(typeof(Division), int.Parse(rmv.Menu.Division)) + ">>\r\n" + rmv.Menu.MenuName;
                }
            }

            MakingFormVO makingFormVO = new MakingFormVO();

            // 제조 대기 상태이면 환불이 가능하며 그외의 상태는 환불이 불가능하다.
            try
            {
                makingFormVO = new MakingDAO().SelectMakingBySaleNo(salesNo);
                CheckMaikingDivision(makingFormVO.Division);
            }
            catch (SqlException)
            {
                MessageBox.Show("제조 현황을 가져올 수 없습니다.");
            }
            catch (Exception except)
            {
                MessageBox.Show(except.Message);
            }
        }