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, "실패");
}
}
