public FrmUpdateSaleRecords(SaleRecordsVO saleRecords, string salesItemName) { this.saleRecords = saleRecords; this.salesItemName = salesItemName; InitializeComponent(); this.Icon = Resources.C_Sharp_Logo_2_1; }
internal SaleRecordsVO SelectSaleRecordNumForMaking(DateTime salesDate, string salesitemName) { string sp = "SelectSaleRecordNumForMaking"; SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("salesDate", salesDate), new SqlParameter("salesitemName", salesitemName) }; try { SaleRecordsVO saleRecordsVO = new SaleRecordsVO(); SqlDataReader sdr = new DBConnection().Select(sp, sqlParameters); while (sdr.Read()) { saleRecordsVO.SalesNo = int.Parse(sdr["salesNo"].ToString()); } return(saleRecordsVO); } catch (SqlException ee) { System.Windows.Forms.MessageBox.Show(ee.StackTrace); throw; } }
/// <summary> /// 판매기록 수정을 위한 UpdateSaleRecords /// </summary> /// <param name="saleRecordsVO"> 판매기록 데이터가 담긴 saleRecordsVO 객체</param> /// <returns>성공 여부 반환</returns> internal int UpdateSaleRecords(SaleRecordsVO saleRecordsVO) { DBConnection connection = new DBConnection(); string storedProcedure = "UpdateSaleRecords"; SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("salesNo", saleRecordsVO.SalesNo), new SqlParameter("salesDate", saleRecordsVO.SalesDate), new SqlParameter("salesitemName", saleRecordsVO.SalesitemName), new SqlParameter("salesPrice", saleRecordsVO.SalesPrice), new SqlParameter("discount", saleRecordsVO.Discount), new SqlParameter("duty", saleRecordsVO.Duty), new SqlParameter("salesTotal", saleRecordsVO.SalesTotal), new SqlParameter("paymentPlan", saleRecordsVO.PaymentPlan) }; try { return(connection.Update(storedProcedure, sqlParameters)); } catch (SqlException) { throw; } }
/// <summary> /// 모든 판매기록을 검색하기위한 메서드 /// </summary> /// <returns> 검색결과를 컬렉션으로 반환</returns> public List <SaleRecordsVO> OutPutAllSaleRecords() { List <SaleRecordsVO> lst = new List <SaleRecordsVO>(); string sp = "SelectSaleRecords"; try { SqlDataReader sdr = new DBConnection().Select(sp, null); while (sdr.Read()) { SaleRecordsVO saleRecordsVO = new SaleRecordsVO(); saleRecordsVO.SalesNo = Convert.ToInt32(sdr["salesNo"]); saleRecordsVO.SalesDate = Convert.ToDateTime(sdr["salesDate"]); saleRecordsVO.SalesitemName = sdr["salesitemName"].ToString(); saleRecordsVO.SalesPrice = float.Parse(sdr["salesPrice"].ToString()); saleRecordsVO.Discount = float.Parse(sdr["discount"].ToString()); saleRecordsVO.Duty = float.Parse(sdr["duty"].ToString()); saleRecordsVO.SalesTotal = float.Parse(sdr["salesTotal"].ToString()); saleRecordsVO.PaymentPlan = sdr["paymentPlan"].ToString(); lst.Add(saleRecordsVO); } return(lst); } catch (SqlException) { throw; } }
/// <summary> /// 기간별 판매기록을 검색하기 위한 SelectSaleRacordsByPeriod 메서드 /// </summary> /// <param name="periodStart">시작기간</param> /// <param name="periodEnd">종료기간</param> /// <returns>검색결과를 컬렉션으로 반환</returns> public List <SaleRecordsVO> SelectSaleRacordsByPeriod(DateTime periodStart, DateTime periodEnd) { List <SaleRecordsVO> lst = new List <SaleRecordsVO>(); string sp = "SelectSaleRacordsByPeriod"; SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("periodStart", periodStart), new SqlParameter("periodEnd", periodEnd) }; try { SqlDataReader sdr = new DBConnection().Select(sp, sqlParameters); while (sdr.Read()) { SaleRecordsVO saleRecordsVO = new SaleRecordsVO(); saleRecordsVO.SalesNo = Convert.ToInt32(sdr["salesNo"]); saleRecordsVO.SalesDate = Convert.ToDateTime(sdr["salesDate"]); saleRecordsVO.SalesitemName = sdr["salesitemName"].ToString(); saleRecordsVO.SalesPrice = float.Parse(sdr["salesPrice"].ToString()); saleRecordsVO.Discount = float.Parse(sdr["discount"].ToString()); saleRecordsVO.Duty = float.Parse(sdr["duty"].ToString()); saleRecordsVO.SalesTotal = float.Parse(sdr["salesTotal"].ToString()); saleRecordsVO.PaymentPlan = sdr["paymentPlan"].ToString(); lst.Add(saleRecordsVO); } return(lst); } catch (SqlException) { throw; } }
private void salesRecordsGView_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex != -1) { saleRecords = new SaleRecordsVO() { SalesNo = int.Parse(salesRecordsGView.Rows[e.RowIndex].Cells[0].Value.ToString()), SalesDate = DateTime.Parse(salesRecordsGView.Rows[e.RowIndex].Cells[1].Value.ToString()), SalesitemName = salesRecordsGView.Rows[e.RowIndex].Cells[2].Value.ToString(), SalesPrice = float.Parse(salesRecordsGView.Rows[e.RowIndex].Cells[3].Value.ToString()), Discount = float.Parse(salesRecordsGView.Rows[e.RowIndex].Cells[4].Value.ToString()), Duty = float.Parse(salesRecordsGView.Rows[e.RowIndex].Cells[5].Value.ToString()), SalesTotal = float.Parse(salesRecordsGView.Rows[e.RowIndex].Cells[6].Value.ToString()), PaymentPlan = salesRecordsGView.Rows[e.RowIndex].Cells[7].Value.ToString() }; } }
private void btnUpdate_Click(object sender, EventArgs e) { int no = saleRecords.SalesNo; string name = tbxUpdateName.Text.Trim(); string price = tbxUpdatePrice.Text.Replace(" ", "").Trim(); string discount = tbxUpdateDiscount.Text.Replace(" ", "").Trim(); string duty = tbxUpdateduty.Text.Replace(" ", "").Trim(); string total = tbxUpdateTotal.Text.Replace(" ", "").Trim(); string plan = tbxUpadatePlan.Text.Replace(" ", "").Trim(); if (ValidateNull(name, price, discount, duty, total, plan) && ValidateType(price, discount, duty, total)) { SaleRecordsVO saleRecords = new SaleRecordsVO() { SalesNo = no, SalesDate = dtpUpdateDate.Value, SalesitemName = salesItemName, SalesPrice = float.Parse(price), Discount = float.Parse(discount), Duty = float.Parse(duty), SalesTotal = float.Parse(total), PaymentPlan = plan }; try { new SaleRecordsDAO().UpdateSaleRecords(saleRecords); MessageBox.Show("기록 수정 성공"); } catch (SqlException) { MessageBox.Show("기록을 수정 할 수 없습니다."); } Close(); } }
/// <summary> /// 확인 버튼 클릭시 작동하는 이벤트 메소드 /// 받은 돈과 결제금액을 비교하여 처리 그 외의 여러가지 예외처리 메소드 작동 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnOk_Click(object sender, EventArgs e) // 결제 버튼 클릭시 작동 { if (MessageBox.Show("결제하시겠습니까?", "", MessageBoxButtons.OKCancel) == DialogResult.OK) { if (float.Parse(txtTotal.Text) > float.Parse(txtPaid.Text)) { MessageBox.Show("결제 금액이 부족합니다"); } else { if (cbReceipt.Checked) { // 영수중 체크시 출력 기능 구현 MessageBox.Show("영수증 출력"); } string toMaking = String.Empty; RealMenuVO rm = new RealMenuVO(); MenuAndDetails[] bb = new MenuAndDetails[bucketMenuAndDetailList.Count]; int i = 0; foreach (var item in bucketMenuAndDetailList) { bb[i] = item; i++; } rm.RealMenu = bb; toMaking += JsonConvert.SerializeObject(rm, Formatting.Indented); // 판매기록 테이블에 기입할 내용 넘겨줌 SaleRecordsVO saleRecord = new SaleRecordsVO(); saleRecord.SalesDate = DateTime.Now; saleRecord.SalesitemName = toMaking; saleRecord.SalesPrice = float.Parse(txtPrice.Text); saleRecord.Discount = float.Parse(txtSale.Text); saleRecord.Duty = float.Parse(txtTax.Text); saleRecord.SalesTotal = float.Parse(txtTotal.Text); saleRecord.PaymentPlan = "null"; try { new SaleRecordsDAO().InsertSaleRecords(saleRecord); } catch (Exception ee) { MessageBox.Show(ee.StackTrace); } // making 테이블에 넘겨줄때 try { SaleRecordsVO saleRecordsVO = new MakingDAO().SelectSaleRecordNumForMaking(saleRecord.SalesDate, saleRecord.SalesitemName); new MakingDAO().InsertMaking(saleRecordsVO.SalesNo, toMaking); } catch (Exception ee) { MessageBox.Show(ee.StackTrace); } result = true; this.Close(); } } }