private void load_data(string CostingNo)
{
DataSet dsHeader = new costingCRUD().getData(CostingNo);
txtCostingNo.Text = CostingNo;
cbDIV.SelectedValue = dsHeader.Tables[0].Rows[0]["GDIV"].ToString();
cbTypeID.SelectedValue = dsHeader.Tables[0].Rows[0]["TYPEID"].ToString();
txtQty.Text = dsHeader.Tables[0].Rows[0]["QTYORDER"].ToString();
txtCustomerID.Text = dsHeader.Tables[0].Rows[0]["CUSTVENDCODE"].ToString();
txtStyleID.Text = dsHeader.Tables[0].Rows[0]["ITEMSID"].ToString();
txtCategoryID.Text = dsHeader.Tables[0].Rows[0]["CATEGORYID"].ToString();
txtKurs.Text = dsHeader.Tables[0].Rows[0]["KURS"].ToString();
cbValueIn.Text = dsHeader.Tables[0].Rows[0]["VALUEIN"].ToString();
dateCreated.Value = (DateTime)dsHeader.Tables[0].Rows[0]["DATE"];
txtPPN.Text = dsHeader.Tables[0].Rows[0]["PPN"].ToString();
txtMargin.Text = dsHeader.Tables[0].Rows[0]["MARGIN"].ToString();
txtFOB.Text = dsHeader.Tables[0].Rows[0]["SELLINGPRICE"].ToString();
txtRemarks.Text = dsHeader.Tables[0].Rows[0]["REMARKS"].ToString();
DataSet dsDetail = new costingdetailCRUD().getData(CostingNo);
dtGrid.Rows.Clear();
for (int i = 0; i < dsDetail.Tables[0].Rows.Count; i++)
{
dtGrid.Rows.Add();
dtGrid.Rows[i].HeaderCell.Value = "V";
dtGrid.Rows[i].Cells["hCostingNo"].Value = dsDetail.Tables[0].Rows[i]["COSTINGNO"].ToString();
dtGrid.Rows[i].Cells["hID"].Value = dsDetail.Tables[0].Rows[i]["ID"].ToString();
dtGrid.Rows[i].Cells["hAllowance"].Value = Convert.ToSingle(dsDetail.Tables[0].Rows[i]["ALLOWANCE"]);
dtGrid.Rows[i].Cells["hAmount"].Value = Convert.ToSingle(dsDetail.Tables[0].Rows[i]["AMOUNT"]);
dtGrid.Rows[i].Cells["hConsumption"].Value = Convert.ToSingle(dsDetail.Tables[0].Rows[i]["CONSUMPTION"]);
dtGrid.Rows[i].Cells["hCostType"].Value = dsDetail.Tables[0].Rows[i]["COSTID"].ToString();
dtGrid.Rows[i].Cells["hCurrency"].Value = dsDetail.Tables[0].Rows[i]["CURRENCY"].ToString();
dtGrid.Rows[i].Cells["hDescription"].Value = dsDetail.Tables[0].Rows[i]["DESCRIPTION"].ToString();
dtGrid.Rows[i].Cells["hKurs"].Value = Convert.ToSingle(dsDetail.Tables[0].Rows[i]["KURS"]);
dtGrid.Rows[i].Cells["hPrice"].Value = Convert.ToSingle(dsDetail.Tables[0].Rows[i]["PRICE"]);
dtGrid.Rows[i].Cells["hUOM"].Value = dsDetail.Tables[0].Rows[i]["UOMID"].ToString();
dtGrid.Rows[i].Cells["hUsage"].Value = dsDetail.Tables[0].Rows[i]["USAG"].ToString();
dtGrid.Rows[i].Cells["hWidth"].Value = dsDetail.Tables[0].Rows[i]["WIDTH"].ToString();
}
}
private void dtGrid_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var senderGrid = (DataGridView)sender;
GStrCode = "";
GitemsDesc = "";
//untuk items
if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn &&
e.RowIndex >= 0 && senderGrid.Columns[e.ColumnIndex] == dtGrid.Columns["hItemsID"])
{
frmItemsSearch f = new frmItemsSearch();
f.AddItemCallback = new frmItemsSearch.AddItemDelegate(this.SetItemsCallBack);
f.ShowDialog();
if (GStrCode != "")
{
// MessageBox.Show("keren bok");
dtGrid.Rows[e.RowIndex].Cells["hItemsID"].Value = GStrCode;
dtGrid.Rows[e.RowIndex].Cells["hDescription"].Value = GitemsDesc;
/*
* DataSet dsDetail = new mitemsCRUD().getData(GStrCode);
* if (dsDetail.Tables[0].Rows.Count > 0)
* {
* DataGridViewComboBoxCell dtgCol = dtGrid.Rows[e.RowIndex].Cells["hItemsID"] as DataGridViewComboBoxCell;
* dtgCol.DataSource = dsDetail.Tables[0];
* dtgCol.DisplayMember = "DESCRIPTION";
* dtgCol.ValueMember = "ITEMSID";
*
* }
* */
}
}
//untuk costing
if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn &&
e.RowIndex >= 0 && senderGrid.Columns[e.ColumnIndex] == dtGrid.Columns["hCostingNo"])
{
GStrCode = "";
frmcostingSearch f = new frmcostingSearch();
f.AddItemCallback = new frmcostingSearch.AddCostingDelegate(this.SetCostingCallBack);
f.ShowDialog();
if (GStrCode != "")
{
dtGrid.Rows[e.RowIndex].Cells["hCostingNo"].Value = GStrCode;
DataSet dsDetail = new costingdetailCRUD().getData(GStrCode);
if (dsDetail.Tables[0].Rows.Count > 0)
{
//DataGridViewComboBoxColumn CostingID = dtGrid.Columns["hCostingID"] as DataGridViewComboBoxColumn;//new DataGridViewComboBoxColumn();
//CostingID.DataSource = dsDetail.Tables[0];
//CostingID.DisplayMember = "DESCRIPTION";
//CostingID.ValueMember = "ID";
DataGridViewComboBoxCell dtgCol = dtGrid.Rows[e.RowIndex].Cells["hCostingID"] as DataGridViewComboBoxCell;
// dtgCol.Items.Add("comboitem1");
//dtgCol.Items.Add("comboitem2");
dtgCol.DataSource = dsDetail.Tables[0];
dtgCol.DisplayMember = "DESCRIPTION";
dtgCol.ValueMember = "ID";
//dtGrid.Rows[e.RowIndex].Cells["hCostingID"].Value
}
// else { dtGrid.Rows[e.RowIndex].Cells["hCostingID"].Value = ""; }
//MessageBox.Show("wowowowwowow");
}
}
}
private void RecordTSB_Click(object sender, EventArgs e)
{
frmPurchaseSearch f = new frmPurchaseSearch();
f.AddItemCallback = new frmPurchaseSearch.AddPurchaseDelegate(this.SetPurchaseCallBack);
f.ShowDialog();
//txtCostingNo.Text
if (GStrCode != "")
{
DataSet dsHeader = new purchaseCRUD().getData(GStrCode);
txtPONO.Text = GStrCode;
cbDIV.SelectedValue = dsHeader.Tables[0].Rows[0]["GDIV"];
dateCreated.Value = (DateTime)dsHeader.Tables[0].Rows[0]["DATE"];
txtRemarks.Text = dsHeader.Tables[0].Rows[0]["REMARKS"].ToString();
cbCurrency.Text = dsHeader.Tables[0].Rows[0]["CURRENCYID"].ToString();
txtKurs.Text = dsHeader.Tables[0].Rows[0]["KURS"].ToString();
//txtPPN.Text=dsHeader.Tables[0].Rows[0]["PPN"].ToString();
txtCustomerID.Text = dsHeader.Tables[0].Rows[0]["CUSTVENDID"].ToString();
txtDeliveryTo.Text = dsHeader.Tables[0].Rows[0]["DELIVERYTO"].ToString();
// txtAddress.Text = dsHeader.Tables[0].Rows[0]["DELIVERYTOADDRESS"].ToString();
txtRefer.Text = dsHeader.Tables[0].Rows[0]["REFERTO"].ToString();
cbCourier.Text = dsHeader.Tables[0].Rows[0]["SHIPMODA"].ToString();
txtAddresTo.Text = dsHeader.Tables[0].Rows[0]["DELIVERYTOADDRESS"].ToString();
dateDue.Value = (DateTime)dsHeader.Tables[0].Rows[0]["DUEDATE"];
dateETA.Value = (DateTime)dsHeader.Tables[0].Rows[0]["ETA"];
dateETD.Value = (DateTime)dsHeader.Tables[0].Rows[0]["ETD"];
cbTerms.Text = dsHeader.Tables[0].Rows[0]["TERMOFPAYMENT"].ToString();
//txtDiscount.Text = dsHeader.Tables[0].Rows[0]["DISCOUNT"].ToString();
//MessageBox.Show("testttt");
DataSet dsDetail = new purchasedetailCRUD().getData(GStrCode);
dtGrid.Rows.Clear();
for (int i = 0; i < dsDetail.Tables[0].Rows.Count; i++)
{
dtGrid.Rows.Add();
dtGrid.Rows[i].HeaderCell.Value = "V";
dtGrid.Rows[i].Cells["hCostingNo"].Value = dsDetail.Tables[0].Rows[i]["COSTINGNO"].ToString();
// cari items costing
GStrCode = dsDetail.Tables[0].Rows[i]["COSTINGNO"].ToString();
DataSet dsDetailtemp = new costingdetailCRUD().getData(GStrCode);
if (dsDetailtemp.Tables[0].Rows.Count > 0)
{
DataGridViewComboBoxCell dtgCol = dtGrid.Rows[i].Cells["hCostingID"] as DataGridViewComboBoxCell;
dtgCol.DataSource = dsDetailtemp.Tables[0];
dtgCol.DisplayMember = "DESCRIPTION";
dtgCol.ValueMember = "ID";
}
dtGrid.Rows[i].Cells["hItemsID"].Value = dsDetail.Tables[0].Rows[i]["ITEMSID"];
dtGrid.Rows[i].Cells["hCostingID"].Value = dsDetail.Tables[0].Rows[i]["COSTINGID"];
dtGrid.Rows[i].Cells["hPONO"].Value = dsDetail.Tables[0].Rows[i]["PONO"].ToString();
dtGrid.Rows[i].Cells["hID"].Value = dsDetail.Tables[0].Rows[i]["ID"].ToString();
dtGrid.Rows[i].Cells["hQuantity"].Value = dsDetail.Tables[0].Rows[i]["QUANTITY"].ToString();
dtGrid.Rows[i].Cells["hUOM"].Value = dsDetail.Tables[0].Rows[i]["UOM"].ToString();
dtGrid.Rows[i].Cells["hPrice"].Value = dsDetail.Tables[0].Rows[i]["PRICE"].ToString();
dtGrid.Rows[i].Cells["hDescription"].Value = dsDetail.Tables[0].Rows[i]["DESCRIPTION"].ToString();
dtGrid.Rows[i].Cells["hQtyPurchase"].Value = dsDetail.Tables[0].Rows[i]["QTYPURCHASE"].ToString();
dtGrid.Rows[i].Cells["hUOMPurchase"].Value = dsDetail.Tables[0].Rows[i]["UOMPURCHASE"].ToString();
dtGrid.Rows[i].Cells["hPricePurchase"].Value = dsDetail.Tables[0].Rows[i]["PRICEPURCHASE"].ToString();
// dtGrid.Rows[i].Cells["hPPN"].Value = dsDetail.Tables[0].Rows[i]["PPN"];
//dtGrid.Rows[i].Cells["hDiscount"].Value = dsDetail.Tables[0].Rows[i]["DISCOUNT"];
dtGrid.Rows[i].Cells["hConvert"].Value = dsDetail.Tables[0].Rows[i]["CONVER"];
dtGrid.Rows[i].Cells["hCurrency"].Value = dsDetail.Tables[0].Rows[i]["CURRENCYID"].ToString();
dtGrid.Rows[i].Cells["hKurs"].Value = dsDetail.Tables[0].Rows[i]["KURS"].ToString();
}
SimpanTSB.Enabled = false;
UbahTSB.Enabled = true;
dtGrid.Enabled = true;
}
}
