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; } }
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; } }
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); } }