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