void setForm(DataSet1.GOODSRow goodsData, DataSet1.CUSTOMERSRow customerData) { goodsTableAdapter1.Fill(dataSet11.GOODS); goodstypeTableAdapter1.Fill(dataSet11.GOODSTYPE); goodsunitTableAdapter1.Fill(dataSet11.GOODSUNIT); goodsgradeTableAdapter1.Fill(dataSet11.GOODSGRADE); tb_required.Text = "1"; tb_name.Text = customerData.C_NAME; tb_item.Text = goodsData.GDS_NAME; tb_vender.Text = goodstypeTableAdapter1.GetDataByNo(goodsData.GDSTYPE_NO)[0].GDSTYPE_DESC; tb_model.Text = goodsData.GDS_MODEL; tb_qty.Text = goodsData.GDS_QTY.ToString(); tb_unit.Text = goodsunitTableAdapter1.GetDataByNo(goodsData.GDSUNIT_ID)[0].GDSUNIT_DESC; tb_grade.Text = goodsgradeTableAdapter1.GetDataByNo(goodsData.GDSGRADE_NO)[0].GDSGRADE_DESC; tb_serial.Text = goodsData.GDS_ID.ToString(); dt_start.Value = getDateServerTime(); dt_end.Value = dt_start.Value; dt_end.MinDate = dt_start.Value.AddDays(1); dt_end.MaxDate = dt_start.Value.AddDays( double.Parse(goodsgradeTableAdapter1.GetDataByNo(goodsData.GDSGRADE_NO)[0].GDSGRADE_PERIOD)); TimeSpan period = dt_end.Value - dt_start.Value; tb_period.Text = period.Days.ToString(); decimal price = goodsData.GDS_PRICE; decimal priceRate = goodsgradeTableAdapter1.GetDataByNo(goodsData.GDSGRADE_NO)[0].GDSGRADE_PRICERATE; string days = tb_period.Text; string required = tb_required.Text; string fee = (Convert.ToInt64(price * priceRate) * int.Parse(days) * int.Parse(required)).ToString(); tb_fee.Text = fee; }
private void DoRowDoubleClick(GridView view, Point pt) { GridHitInfo info = view.CalcHitInfo(pt); if (info.InRow || info.InRowCell) { string colCaption = info.Column == null ? "N/A" : info.Column.GetCaption(); if (!colCaption.Equals("N/A")) { DataRowView rowView = view.GetRow(info.RowHandle) as DataRowView; DataSet1.GOODSRow goodsRow = rowView.Row as DataSet1.GOODSRow; new GoodsDetailView().Show(); /* * if (goodsRow.GDS_QTY < 1) * { * if (MessageBox.Show("현재 재고가 없습니다.\n예약하시겠습니까?", "재고부족", MessageBoxButtons.YesNo) == * DialogResult.Yes) * { * new MakeReservationsForm(goodsRow, customersEmail).ShowDialog(); * } * }*/ } } }
public RentForm(DataSet1.GOODSRow goodsRow, DataSet1.CUSTOMERSRow customersRow) { InitializeComponent(); oracleConnection1.Open(); this.goodsRow = goodsRow; this.customersRow = customersRow; setForm(goodsRow, customersRow); }
public MakeReservationsForm(DataSet1.GOODSRow goodsRow, string customersEmail) { InitializeComponent(); oracleConnection1.Open(); this.goodsRow = goodsRow; this.customersEmail = customersEmail; setUI(); }
public BuyingForm(DataSet1.GOODSRow data) { InitializeComponent(); this.currentGoodsRow = data; oracleConnection1.Open(); setDropDownUnit(); setDropDownShelves(); setDropDownVendors(); setDropDownGrade(); setDropDownStore(); lb_add.Text = "수 정"; setModify(data); }
private void ActionReturn(object sender, EventArgs e) { if (tb_returnqty.TextLength < 1) { return; } try { string grade = dtbtn_grade.Text; string returnQty = tb_returnqty.Text; DateTime reutnrTime = dt_end.Value; if (rentRow != null && customersRow != null) { goodsTableAdapter1.Fill(dataSet11.GOODS); DataSet1.GOODSRow goodsRow = goodsTableAdapter1.GetDataById(rentRow.GDS_ID)[0]; goodsRow.GDSGRADE_NO = goodsgradeTableAdapter1.GetDataByDesc(grade)[0].GDSGRADE_NO; goodsRow.GDS_QTY += int.Parse(returnQty); int ret = goodsTableAdapter1.Update(goodsRow); if (ret < 1) { throw new Exception(); } rentRow.RNT_RETURNDATE = reutnrTime; rentRow.RNTSTATE_NO = "1"; ret = rentTableAdapter1.Update(rentRow); if (ret > 0) { MessageBox.Show("반납완료"); this.Close(); } else { throw new Exception(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "실패"); } }
void setModify(DataSet1.GOODSRow data) { b = data.GDS_IMG; if (b != null) { pb_img.Image = new Bitmap(new MemoryStream(b)); } string gds_id = data.GDS_ID.ToString(); string gds_name = data.GDS_NAME; string gds_qty = data.GDS_QTY.ToString(); string slvs_no = data.SLVS_NO; string gdstype_no = data.GDSTYPE_NO; string gdsgrade_no = data.GDSGRADE_NO; string gdsunit_id = data.GDSUNIT_ID; string gds_price = data.GDS_PRICE.ToString(); string gds_model = data.GDS_MODEL.ToString(); buyinggoodsTableAdapter1.Fill(dataSet1.BUYINGGOODS); goodsunitTableAdapter1.Fill(dataSet1.GOODSUNIT); goodsgradeTableAdapter1.Fill(dataSet1.GOODSGRADE); shelvesTableAdapter1.Fill(dataSet1.SHELVES); goodsstoreTableAdapter1.Fill(dataSet1.GOODSSTORE); goodstypeTableAdapter1.Fill(dataSet1.GOODSTYPE); DataSet1.BUYINGGOODSDataTable table = buyinggoodsTableAdapter1.GetData(); DataRow[] rows = table.Select("gds_id = " + gds_id); DataRow row = rows[0]; tb_name.Text = gds_name; tb_price.Text = gds_price; tb_qty.Text = gds_qty; tb_model.Text = gds_model; drbtn_unit.Text = goodsunitTableAdapter1.GetData().Select("gdsunit_id = " + gdsunit_id)[0]["gdsunit_desc"] as string; drbtn_grade.Text = goodsgradeTableAdapter1.GetData().Select("gdsgrade_no = " + gdsgrade_no)[0]["gdsgrade_desc"] as string; drbtn_slvs.Text = shelvesTableAdapter1.GetData().Select("slvs_no = " + slvs_no)[0]["slvs_desc"] as string; drbtn_store.Text = goodsstoreTableAdapter1.GetData().Select("str_id = " + row["str_id"])[0]["str_name"] as string; drbtn_vendor.Text = goodstypeTableAdapter1.GetData().Select("gdstype_no = " + gdsgrade_no)[0]["gdstype_desc"] as string; }
void windowsUIButtonPanel_ButtonClick(object sender, DevExpress.XtraBars.Docking2010.ButtonEventArgs e) { String button = e.Button.Properties.Caption; switch (button) { case "구매": new BuyingForm().ShowDialog(); break; case "수정": DataRowView view = gOODSBindingSource.Current as DataRowView; DataSet1.GOODSRow data = view.Row as DataSet1.GOODSRow; new BuyingForm(data).ShowDialog(); break; case "폐기": if (MessageBox.Show("폐기하시겠습니까?", "Warning", MessageBoxButtons.OKCancel) == DialogResult.OK) { try { gOODSBindingSource.EndEdit(); gOODSBindingSource.RemoveCurrent(); goodsTableAdapter1.Update(dataSet1.GOODS); goodsTableAdapter1.Fill(dataSet1.GOODS); } catch (Exception ex) { MessageBox.Show(ex.Message, "Failed"); } } break; case "새로고침": break; case "프린트": gridControl.ShowRibbonPrintPreview(); break; } goodsTableAdapter1.Fill(dataSet1.GOODS); gridControl.ResetBindings(); }
private void ActionGoodsRent(object sender, DataGridViewCellMouseEventArgs e) { DataSet1.GOODSRow goodsRow = gOODSBindingSource.Current as DataSet1.GOODSRow; if (goodsRow == null) { DataRowView goodsView = gOODSBindingSource.Current as DataRowView; goodsRow = goodsView.Row as DataSet1.GOODSRow; } DataSet1.CUSTOMERSRow customersRow = cUSTOMERSBindingSource.Current as DataSet1.CUSTOMERSRow; if (customersRow == null) { DataRowView customersView = cUSTOMERSBindingSource.Current as DataRowView; customersRow = customersView.Row as DataSet1.CUSTOMERSRow; } if (MessageBox.Show("대여를 진행합니다.", "알림", MessageBoxButtons.YesNo) == DialogResult.Yes) { new RentForm(goodsRow, customersRow).ShowDialog(); rENTBindingSource.DataSource = rENTTableAdapter.GetDataByCid(customersRow.C_ID); rENTBindingSource.ResetBindings(true); resetState(rENTBindingSource.DataSource as DataSet1.RENTDataTable); } }
void Modify() { try { if (b.Length * tb_name.TextLength * tb_model.TextLength * tb_qty.TextLength * tb_price.TextLength * drbtn_unit.Text.Length * drbtn_grade.Text.Length * drbtn_slvs.Text.Length * drbtn_store.Text.Length * drbtn_vendor.Text.Length == 0) { return; } if (drbtn_unit.Text.Equals("단위")) { return; } goodsTableAdapter1.Fill(dataSet1.GOODS); goodsgradeTableAdapter1.Fill(dataSet1.GOODSGRADE); goodstypeTableAdapter1.Fill(dataSet1.GOODSTYPE); goodsunitTableAdapter1.Fill(dataSet1.GOODSUNIT); DataSet1.GOODSGRADEDataTable goodsgradeDataTable = goodsgradeTableAdapter1.GetData(); DataSet1.GOODSTYPEDataTable goodstypeDataTable = goodstypeTableAdapter1.GetData(); DataSet1.GOODSUNITDataTable goodsunitDataTable = goodsunitTableAdapter1.GetData(); string gdsgrade_no; // DataRow[] gradeData = goodsgradeDataTable.Select("gdsgrade_desc = " + drbtn_grade.Text); // gdsgrade_no = gradeData[0]["gdsgrade_no"] as string; gdsgrade_no = goodsgradeTableAdapter1.GetDataByDesc(drbtn_grade.Text)[0].GDSGRADE_NO; string gdstype_no; // DataRow[] typeData = goodstypeDataTable.Select("gdstype_desc = " + drbtn_vendor.Text); // gdstype_no = typeData[0]["gdstype_no"] as string; gdstype_no = goodstypeTableAdapter1.GetDataByDesc(drbtn_vendor.Text)[0].GDSTYPE_NO; string gdsunit_id; // DataRow[] unitData = goodsunitDataTable.Select("gdsunit_desc = " + drbtn_unit.Text); // gdsunit_id = unitData[0]["gdsunit_id"] as string; gdsunit_id = goodsunitTableAdapter1.GetDataByDesc(drbtn_unit.Text)[0].GDSUNIT_ID; string slvs_no; slvs_no = shelvesTableAdapter1.GetDataByDesc(drbtn_slvs.Text)[0].SLVS_NO; DataSet1.GOODSDataTable goodsDataTable = goodsTableAdapter1.GetData(); DataSet1.GOODSRow presentRow = goodsDataTable.FindByGDS_ID(currentGoodsRow.GDS_ID); presentRow.GDS_IMG = b; presentRow.GDS_NAME = tb_name.Text; presentRow.GDSGRADE_NO = gdsgrade_no; presentRow.GDSTYPE_NO = gdstype_no; presentRow.GDSUNIT_ID = gdsunit_id; presentRow.SLVS_NO = slvs_no; presentRow.GDS_PRICE = int.Parse(tb_price.Text); presentRow.GDS_QTY = int.Parse(tb_qty.Text); presentRow.GDS_MODEL = tb_model.Text; int ret = goodsTableAdapter1.Update(presentRow); if (ret < 1) { MessageBox.Show("실패"); } buyinggoodsTableAdapter1.Fill(dataSet1.BUYINGGOODS); goodsstoreTableAdapter1.Fill(dataSet1.GOODSSTORE); DataSet1.BUYINGGOODSRow buyingRows = buyinggoodsTableAdapter1.GetData().Select("gds_id = " + currentGoodsRow.GDS_ID)[0] as DataSet1.BUYINGGOODSRow; buyingRows.STR_ID = goodsstoreTableAdapter1.GetDataByName(drbtn_store.Text)[0].STR_ID; ret = buyinggoodsTableAdapter1.Update(buyingRows); if (ret > 0) { MessageBox.Show("성공"); this.Close(); } else { MessageBox.Show("실패"); } } catch (Exception e) { MessageBox.Show(e.Message, "실패!"); } }
private void Buy() { int ret; try { if (b.Length * tb_name.TextLength * tb_model.TextLength * tb_qty.TextLength * tb_price.TextLength * drbtn_unit.Text.Length * drbtn_grade.Text.Length * drbtn_slvs.Text.Length * drbtn_store.Text.Length * drbtn_vendor.Text.Length == 0) { return; } if (drbtn_unit.Text.Equals("단위")) { return; } goodsTableAdapter1.Fill(dataSet1.GOODS); goodsgradeTableAdapter1.Fill(dataSet1.GOODSGRADE); goodstypeTableAdapter1.Fill(dataSet1.GOODSTYPE); goodsunitTableAdapter1.Fill(dataSet1.GOODSUNIT); DataSet1.GOODSGRADEDataTable goodsgradeDataTable = goodsgradeTableAdapter1.GetData(); DataSet1.GOODSTYPEDataTable goodstypeDataTable = goodstypeTableAdapter1.GetData(); DataSet1.GOODSUNITDataTable goodsunitDataTable = goodsunitTableAdapter1.GetData(); string gdsgrade_no; // DataRow[] gradeData = goodsgradeDataTable.Select("gdsgrade_desc = " + drbtn_grade.Text); // gdsgrade_no = gradeData[0]["gdsgrade_no"] as string; gdsgrade_no = goodsgradeTableAdapter1.GetDataByDesc(drbtn_grade.Text)[0].GDSGRADE_NO; string gdstype_no; // DataRow[] typeData = goodstypeDataTable.Select("gdstype_desc = " + drbtn_vendor.Text); // gdstype_no = typeData[0]["gdstype_no"] as string; gdstype_no = goodstypeTableAdapter1.GetDataByDesc(drbtn_vendor.Text)[0].GDSTYPE_NO; string gdsunit_id; // DataRow[] unitData = goodsunitDataTable.Select("gdsunit_desc = " + drbtn_unit.Text); // gdsunit_id = unitData[0]["gdsunit_id"] as string; gdsunit_id = goodsunitTableAdapter1.GetDataByDesc(drbtn_unit.Text)[0].GDSUNIT_ID; string slvs_no; slvs_no = shelvesTableAdapter1.GetDataByDesc(drbtn_slvs.Text)[0].SLVS_NO; DataSet1.GOODSDataTable goodsDataTable = goodsTableAdapter1.GetData(); DataSet1.GOODSRow goodsRow = goodsDataTable.NewGOODSRow(); goodsRow.GDS_IMG = b; goodsRow.GDS_NAME = tb_name.Text; goodsRow.GDSGRADE_NO = gdsgrade_no; goodsRow.GDSTYPE_NO = gdstype_no; goodsRow.GDSUNIT_ID = gdsunit_id; goodsRow.SLVS_NO = slvs_no; goodsRow.GDS_PRICE = int.Parse(tb_price.Text); goodsRow.GDS_QTY = int.Parse(tb_qty.Text); goodsRow.GDS_MODEL = tb_model.Text; goodsDataTable.Rows.Add(goodsRow); ret = goodsTableAdapter1.Update(goodsDataTable); if (ret < 1) { throw new Exception("상품등록 실패"); } goodsstoreTableAdapter1.Fill(dataSet1.GOODSSTORE); buyinggoodsTableAdapter1.Fill(dataSet1.BUYINGGOODS); DataSet1.GOODSSTOREDataTable goodsstoreDataTable = goodsstoreTableAdapter1.GetData(); DataSet1.BUYINGGOODSDataTable buyinggoodsDataTable = buyinggoodsTableAdapter1.GetData(); goodsDataTable = goodsTableAdapter1.GetData(); int gds_id = int.Parse(goodsRow.GDS_ID.ToString()); int str_id; //DataRow[] storeData = goodsstoreDataTable.Select("str_name = " + drbtn_store.Text); // str_id = int.Parse(storeData[0]["str_id"] as string); str_id = int.Parse(goodsstoreTableAdapter1.GetDataByName(drbtn_store.Text)[0].STR_ID.ToString()); DataSet1.BUYINGGOODSRow buyinggoodsRow = buyinggoodsDataTable.NewBUYINGGOODSRow(); buyinggoodsRow.BUYING_DATE = getDateServerTime(); buyinggoodsRow.GDS_ID = gds_id; buyinggoodsRow.STR_ID = str_id; buyinggoodsRow.MNG_ID = Form1.account; buyinggoodsDataTable.Rows.Add(buyinggoodsRow); ret = buyinggoodsTableAdapter1.Update(buyinggoodsDataTable); if (ret < 1) { throw new Exception("구매정보 등록 실패"); } MessageBox.Show("업데이트 성공"); this.Close(); } catch (Exception e) { MessageBox.Show(e.Message, "실패"); } }