public void InsertDB() { 수주 orderList = new 수주(); List <수주> 수주 = DB.수주.GetAll(); 발주등록.BehindSujuListCnt = DB.수주.GetAll().Count; if (수주.Where(x => x.수주번호 == dgv엑셀.CurrentRow.Cells[0].Value.ToString()).ToList().Count == 0 || 수주. Where(x => x.수주번호2 == dgv엑셀.CurrentRow.Cells[1].Value.ToString()).Count() == 0) { orderList.수주번호 = dgv엑셀.CurrentRow.Cells[0].Value.ToString(); orderList.수주번호2 = dgv엑셀.CurrentRow.Cells[1].Value.ToString(); orderList.제품번호 = dgv엑셀.CurrentRow.Cells[2].Value.ToString(); orderList.주문수량 = int.Parse(dgv엑셀.CurrentRow.Cells[3].Value.ToString()); orderList.납품업체번호 = dgv엑셀.CurrentRow.Cells[4].Value.ToString(); orderList.단가 = int.Parse(dgv엑셀.CurrentRow.Cells[5].Value.ToString()); orderList.금액 = int.Parse(dgv엑셀.CurrentRow.Cells[6].Value.ToString()); orderList.주문일 = DateTime.Parse(dgv엑셀.CurrentRow.Cells[7].Value.ToString()); orderList.납기일 = DateTime.Parse(dgv엑셀.CurrentRow.Cells[8].Value.ToString()); orderList.잔량 = orderList.주문수량; orderList.출고량 = 0; orderList.출고여부 = false; DB.수주.Insert(orderList); MessageBox.Show($"수주번호 {orderList.수주번호} / {orderList.수주번호2} 가 등록되엇습니다."); bds수주.DataSource = DB.수주.조회(txb품목명.Text, txb납품업체이름.Text, firstDate, lastDate); dgv엑셀.CurrentRow.Cells[9].Value = null; Register발주(); } else { MessageBox.Show("이미 등록된 수주 데이터 입니다"); } }
public void UpdataData() { int maxRow = dgv엑셀.Rows.Count; 수주 orderList = new 수주(); List <수주> 수주 = DB.수주.GetAll(); if (수주.Count != 0) { for (int j = 0; j < maxRow; j++) { if (수주.Where(x => x.수주번호 == dgv엑셀.Rows[j].Cells[0].Value.ToString() && x.수주번호2 == dgv엑셀.Rows[j].Cells[1].Value.ToString()).Count() >= 1) { if (int.Parse(dgv엑셀.Rows[j].Cells[3].Value.ToString()) < int.Parse(수주.Where(x => x.수주번호 == dgv엑셀.Rows[j].Cells[0].Value.ToString() && x.수주번호2 == dgv엑셀.Rows[j].Cells[1].Value.ToString()).Select(x => x.주문수량).First().ToString())) { dgv엑셀.Rows[j].Cells[9].Value = "수량 감소 ".ToString(); } if (int.Parse(dgv엑셀.Rows[j].Cells[3].Value.ToString()) > int.Parse(수주.Where(x => x.수주번호 == dgv엑셀.Rows[j].Cells[0].Value.ToString() && x.수주번호2 == dgv엑셀.Rows[j].Cells[1].Value.ToString()).Select(x => x.주문수량).First().ToString())) { dgv엑셀.Rows[j].Cells[9].Value = "수량 증가 ".ToString(); } if (DateTime.Parse(dgv엑셀.Rows[j].Cells[8].Value.ToString()).Date < 수주.Where(x => x.수주번호 == dgv엑셀.Rows[j].Cells[0].Value.ToString() && x.수주번호2 == dgv엑셀.Rows[j].Cells[1].Value.ToString()).Select(x => x.납기일).First().Date) { dgv엑셀.Rows[j].Cells[9].Value += "납기일 당겨짐".ToString(); } if (DateTime.Parse(dgv엑셀.Rows[j].Cells[8].Value.ToString()).Date > 수주.Where(x => x.수주번호 == dgv엑셀.Rows[j].Cells[0].Value.ToString() && x.수주번호2 == dgv엑셀.Rows[j].Cells[1].Value.ToString()).Select(x => x.납기일).First().Date) { dgv엑셀.Rows[j].Cells[9].Value += "납기일 늦어짐".ToString(); } } else { dgv엑셀.Rows[j].Cells[9].Value = "New Data".ToString(); } } } else { for (int j = 0; j < maxRow; j++) { dgv엑셀.Rows[j].Cells[9].Value = "New Data".ToString(); } return; } }
private void btn삭제_Click(object sender, EventArgs e) { 수주 orderList = dgv수주.CurrentRow.DataBoundItem as 수주; if (orderList == null) { return; } DialogResult result = MessageBox.Show("삭제 하시겠습니까?", "알림", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (result == DialogResult.OK) { DB.수주.Delete(orderList); MessageBox.Show("삭제하였습니다", "알림", MessageBoxButtons.OK, MessageBoxIcon.Information); bds수주.DataSource = DB.수주.GetAll(); } }
private void btn변경_Click(object sender, EventArgs e) { 수주 orderList = new 수주(); DialogResult result = MessageBox.Show("변경 하기겠습니까?", "알림", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (result == DialogResult.OK) { orderList.수주번호 = dgv엑셀.CurrentRow.Cells[0].Value.ToString(); orderList.수주번호2 = dgv엑셀.CurrentRow.Cells[1].Value.ToString(); orderList.제품번호 = int.Parse(dgv엑셀.CurrentRow.Cells[2].Value.ToString()); orderList.주문수량 = int.Parse(dgv엑셀.CurrentRow.Cells[3].Value.ToString()); orderList.납품업체번호 = int.Parse(dgv엑셀.CurrentRow.Cells[4].Value.ToString()); orderList.주문일 = int.Parse(dgv엑셀.CurrentRow.Cells[5].Value.ToString()); orderList.납기일 = int.Parse(dgv엑셀.CurrentRow.Cells[6].Value.ToString()); DB.수주.Update(orderList); MessageBox.Show("변경하였습니다", "알림", MessageBoxButtons.OK, MessageBoxIcon.Information); bds수주.DataSource = DB.수주.GetAll(); } }
public void InsertDB() { int maxRow = dgv엑셀.Rows.Count; List <수주> 수주 = DB.수주.GetAll(); 수주 orderList = new 수주(); for (int j = 0; j < maxRow; j++) { string Superkey = dgv엑셀.Rows[j].Cells[0].Value.ToString() + dgv엑셀.Rows[j].Cells[1].Value.ToString(); int cnt = 0; for (int i = 0; i < 수주.Count; i++) { string DBSuperKey = dgv엑셀.Rows[i].Cells[0].Value.ToString() + dgv엑셀.Rows[i].Cells[1].Value.ToString(); if (Superkey != DBSuperKey) { cnt++; if (cnt == 수주.Count) { orderList.수주번호 = dgv엑셀[0, j].Value.ToString(); orderList.수주번호2 = dgv엑셀[1, j].Value.ToString(); orderList.제품번호 = int.Parse(dgv엑셀[2, j].Value.ToString()); orderList.주문수량 = int.Parse(dgv엑셀[3, j].Value.ToString()); orderList.납품업체번호 = int.Parse(dgv엑셀[4, j].Value.ToString()); orderList.주문일 = int.Parse(dgv엑셀[5, j].Value.ToString()); orderList.납기일 = int.Parse(dgv엑셀[6, j].Value.ToString()); DB.수주.Insert(orderList); cnt = 0; } } else { break; } } foreach (var item in 수주) { string DBSuperKey = item.수주번호 + item.수주번호2; if (Superkey == DBSuperKey) { if (int.Parse(dgv엑셀.Rows[j].Cells[3].Value.ToString()) < item.주문수량) { dgv엑셀.Rows[j].Cells[7].Value = "다운"; } else if (int.Parse(dgv엑셀.Rows[j].Cells[3].Value.ToString()) > item.주문수량) { dgv엑셀.Rows[j].Cells[7].Value = "업"; } if (int.Parse(dgv엑셀.Rows[j].Cells[6].Value.ToString()) < item.납기일) { dgv엑셀.Rows[j].Cells[8].Value = "빨라짐"; } else if (int.Parse(dgv엑셀.Rows[j].Cells[6].Value.ToString()) > item.납기일) { dgv엑셀.Rows[j].Cells[8].Value = "늦어짐"; } break; } } } }