void ActionDropDownVenders(Object sender, EventArgs e)
{
drbtn_vendor.Text = ((DXMenuItem)sender).Caption;
gOODSTableAdapter.Fill(dataSet1.GOODS);
goodstypeTableAdapter1.Fill(dataSet1.GOODSTYPE);
DataSet1.GOODSDataTable table = gOODSTableAdapter.GetDataByType(goodstypeTableAdapter1.GetDataByDesc(drbtn_vendor.Text)[0]["gdstype_no"].ToString());
gOODSBindingSource.DataSource = table;
drbtn_slvs.Text = "위치";
}
void ActionDropDownShelves(Object sender, EventArgs e)
{
drbtn_slvs.Text = ((DXMenuItem)sender).Caption;
gOODSTableAdapter.Fill(dataSet1.GOODS);
shelvesTableAdapter1.Fill(dataSet1.SHELVES);
DataSet1.GOODSDataTable table = gOODSTableAdapter.GetDataBySlvs(shelvesTableAdapter1.GetDataByDesc(drbtn_slvs.Text).Rows[0]["slvs_no"].ToString());
gOODSBindingSource.DataSource = table;
drbtn_vendor.Text = "제조사";
}
void setSamsung()
{
goodsTableAdapter1.Fill(dataSet1.GOODS);
goodstypeTableAdapter1.Fill(dataSet1.GOODSTYPE);
DataSet1.GOODSDataTable table = goodsTableAdapter1.GetDataByType(goodstypeTableAdapter1.GetDataByDesc("Samsung")[0].GDSTYPE_NO);
gridControl1.DataSource = table;
nowViewItem = "Samsung";
tileView1.RefreshData();
}
void ActionDropDownVender2(Object sender, EventArgs e)
{
drbtn_vendor2.Text = ((DXMenuItem)sender).Caption;
//goodsTableAdapter1.Fill(dataSet1.GOODS);
goodstypeTableAdapter2.Fill(dataSet1.GOODSTYPE);
if (drbtn_vendor2.Text == "제조사")
{
gridView2.DataSource = gOODSTableAdapter.GetData().Copy();
if (gridView2.RowCount > 0)
{
for (int i = 0; i < gridView2.Columns.Count; i++)
{
if (gridView2.Columns[i].GetType() == typeof(DataGridViewImageColumn))
{
(gridView2.Columns[i] as DataGridViewImageColumn).ImageLayout = DataGridViewImageCellLayout.Zoom;
}
}
}
}
else
{
DataSet1.GOODSDataTable table = gOODSTableAdapter.GetDataByType(
goodstypeTableAdapter2.GetDataByDesc(drbtn_vendor2.Text)[0]["gdstype_no"].ToString());
gridView2.DataSource = table;
if (gridView2.RowCount > 0)
{
for (int i = 0; i < gridView2.Columns.Count; i++)
{
if (gridView2.Columns[i].GetType() == typeof(DataGridViewImageColumn))
{
(gridView2.Columns[i] as DataGridViewImageColumn).ImageLayout = DataGridViewImageCellLayout.Zoom;
}
}
}
}
drbtn_rentstate2.Text = "대여상태";
drbtn_slvs2.Text = "위치";
tb_item2.Text = tb_model2.Text = "";
}
private void ActionGoodsSearch(object sender, EventArgs e)
{
gOODSTableAdapter.Fill(dataSet1.GOODS);
if (tb_item.TextLength != 0)
{
string name = tb_item.Text.ToLower();
DataSet1.GOODSDataTable table = gOODSTableAdapter.GetData();
table.CaseSensitive = false;
DataRow[] data = table.Select("gds_name like '%" + name + "%'");
gOODSBindingSource.DataSource = data;
}
else if (tb_model.TextLength != 0)
{
string model = tb_model.Text.ToLower();
DataSet1.GOODSDataTable table = gOODSTableAdapter.GetData();
table.CaseSensitive = false;
DataRow[] data = table.Select("gds_model like '%" + model + "%'");
gOODSBindingSource.DataSource = data;
}
else if (tb_item.TextLength != 0 && tb_model.TextLength != 0)
{
string name = tb_item.Text.ToLower();
string model = tb_model.Text.ToLower(); DataSet1.GOODSDataTable table = gOODSTableAdapter.GetData();
table.CaseSensitive = false;
DataRow[] data = table.Select("gds_name like '%" + name + "%' AND gds_model like '%" + model + "%'");
gOODSBindingSource.DataSource = data;
}
else
{
DataSet1.GOODSDataTable table = gOODSTableAdapter.GetData();
gOODSBindingSource.DataSource = table;
}
}
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, "실패");
}
}
private void ActionButtonSearch(object sender, EventArgs e)
{
if (tb_item2.TextLength > 0)
{
string name = tb_item2.Text.ToLower();
DataSet1.GOODSDataTable table = gOODSTableAdapter.GetData().Copy() as DataSet1.GOODSDataTable;
table.CaseSensitive = false;
DataRow[] data = table.Select("gds_name like '%" + name + "%'");
if (data.Length > 0)
{
DataTable newTable = data.CopyToDataTable();
gridView2.DataSource = newTable;
gridView2.ResetBindings();
}
else
{
gridView2.DataSource = null;
}
}
else if (tb_model2.TextLength > 0)
{
string model = tb_model2.Text.ToLower();
DataSet1.GOODSDataTable table = goodsTableAdapter1.GetData().Copy() as DataSet1.GOODSDataTable;
table.CaseSensitive = false;
DataRow[] data = table.Select("gds_model like '%" + model + "%'");
DataTable newTable = data.CopyToDataTable();
gridView2.DataSource = newTable;
gridView2.ResetBindings();
}
else if (tb_item2.TextLength * tb_model2.TextLength > 0)
{
string name = tb_item2.Text.ToLower();
string model = tb_model2.Text.ToLower();
DataSet1.GOODSDataTable table = gOODSTableAdapter.GetData().Copy() as DataSet1.GOODSDataTable;
table.CaseSensitive = false;
DataRow[] data = table.Select("gds_name like '%" + name + "%' AND gds_model like '%" + model + "%'");
DataTable newTable = data.CopyToDataTable();
gridView2.DataSource = newTable;
gridView2.ResetBindings();
}
else
{
DataSet1.GOODSDataTable table = gOODSTableAdapter.GetData().Copy() as DataSet1.GOODSDataTable;
gridView2.DataSource = table;
if (gridView2.RowCount > 0)
{
for (int i = 0; i < gridView2.Columns.Count; i++)
{
if (gridView2.Columns[i].GetType() == typeof(DataGridViewImageColumn))
{
(gridView2.Columns[i] as DataGridViewImageColumn).ImageLayout = DataGridViewImageCellLayout.Zoom;
}
}
}
gridView2.ResetBindings();
}
drbtn_rentstate2.Text = "대여상태";
drbtn_vendor2.Text = "제조사";
drbtn_slvs2.Text = "위치";
}
