private void RecordTSB_Click(object sender, EventArgs e)
{
DataSet data = new grndetailCRUD().SearchDataGrn(txtStyleID.Text, txtStyleDesc.Text, GlobalVariables.GCode);
DtGrid.DataSource = data;
DtGrid.DataMember = "tblgrndetail";
}
private void cmdStyle_Click(object sender, EventArgs e)
{
GStrCode = "";
frmginGarmentSearchStyle f = new frmginGarmentSearchStyle();
f.AddItemCallback = new frmginGarmentSearchStyle.AddStyleDelegate(this.SetStyleCallBack);
GlobalVariables.GCode = "RAW";
f.ShowDialog();
if (GStrCode != "")
{
DataSet dsDetail = new grndetailCRUD().getDataStyle(GStrCode);
cbJENIS.Text = "RAW";
//dtGrid.Rows.Clear();
Int32 index = dtGrid.Rows.Count - 1;
for (int i = 0; i < dsDetail.Tables[0].Rows.Count; i++)
{
dtGrid.Rows.Add();
dtGrid.Rows[index].HeaderCell.Value = "#";
dtGrid.Rows[index].Cells["hID"].Value = index;//dsDetail.Tables[0].Rows[i]["ID"].ToString();
dtGrid.Rows[index].Cells["hItemsID"].Value = Convert.ToString(dsDetail.Tables[0].Rows[0]["ITEMSID"]);
dtGrid.Rows[index].Cells["hDescription"].Value = Convert.ToString(dsDetail.Tables[0].Rows[0]["ITEMSID"]);
dtGrid.Rows[index].Cells["hJenis"].Value = dsDetail.Tables[0].Rows[i]["JENIS"].ToString();
dtGrid.Rows[index].Cells["hColorID"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["COLORID"]);
dtGrid.Rows[index].Cells["hSizeID"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["SIZEID"]);
dtGrid.Rows[index].Cells["hGrade"].Value = DBNull.Value.Equals(dsDetail.Tables[0].Rows[i]["GRADE"]) ? null : dsDetail.Tables[0].Rows[i]["GRADE"].ToString();
dtGrid.Rows[index].Cells["hPONO"].Value = Convert.ToString(dsDetail.Tables[0].Rows[0]["PONO"]);
dtGrid.Rows[index].Cells["hStyleID"].Value = Convert.ToString(dsDetail.Tables[0].Rows[0]["STYLEID"]);
dtGrid.Rows[index].Cells["hStyleIDto"].Value = Convert.ToString(dsDetail.Tables[0].Rows[0]["STYLEID"]);
dtGrid.Rows[index].Cells["hQuantity"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["QTYOH"]);
dtGrid.Rows[index].Cells["hUOM"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["UOM"]);
dtGrid.Rows[index].Cells["hGRNNO"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["GRNNO"]);
index++;
}
}
SimpanTSB.Enabled = true;
UbahTSB.Enabled = true;
dtGrid.Enabled = true;
}
private void button1_Click(object sender, EventArgs e)
{
GStrCode = "";
if (cbTypeID.Text == "PENGELUARAN")
{
frmginSearch f = new frmginSearch();
f.AddItemCallback = new frmginSearch.AddPurchaseDelegate(this.SetPurchaseCallBack);
f.ShowDialog();
if (GStrCode != "")
{
DataSet dsDetail = new gindetailCRUD().getData(GStrCode);
dtGrid.Rows.Clear();
for (int i = 0; i < dsDetail.Tables[0].Rows.Count; i++)
{
dtGrid.Rows.Add();
dtGrid.Rows[i].HeaderCell.Value = "#";
dtGrid.Rows[i].Cells["hTransNo"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["GINNO"]);
dtGrid.Rows[i].Cells["hID"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["ID"]);
dtGrid.Rows[i].Cells["hItemsID"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["ITEMSID"]);
dtGrid.Rows[i].Cells["hDescription"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["DESCRIPTION"]);
// dtGrid.Rows[i].Cells["hJenis"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["JENIS"]);
// dtGrid.Rows[i].Cells["hColorID"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["COLORID"]);
// dtGrid.Rows[i].Cells["hSizeID"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["SIZEID"]);
// dtGrid.Rows[i].Cells["hGrade"].Value = DBNull.Value.Equals(dsDetail.Tables[0].Rows[i]["GRADE"]) ? null : dsDetail.Tables[0].Rows[i]["GRADE"].ToString();
dtGrid.Rows[i].Cells["hStyleID"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["STYLEID"]);
// dtGrid.Rows[i].Cells["hPONO"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["PONO"]);
dtGrid.Rows[i].Cells["hQuantity"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["QUANTITY"]);
dtGrid.Rows[i].Cells["hUOM"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["UOM"]);
//dtGrid.Rows[i].Cells["hPrice"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["PRICE"]);
//dtGrid.Rows[i].Cells["hKurs"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["KURS"]);
}
}
}
else if (cbTypeID.Text == "PEMASUKAN")
{
frmgrnSearch f = new frmgrnSearch();
f.AddItemCallback = new frmgrnSearch.AddPurchaseDelegate(this.SetPurchaseCallBack);
f.ShowDialog();
if (GStrCode != "")
{
DataSet dsDetail = new grndetailCRUD().getData(GStrCode);
dtGrid.Rows.Clear();
for (int i = 0; i < dsDetail.Tables[0].Rows.Count; i++)
{
dtGrid.Rows.Add();
dtGrid.Rows[i].HeaderCell.Value = "#";
//key
// dtGrid.Rows[i].Cells["hGRNNo1"].Value = dsDetail.Tables[0].Rows[i]["GRNNO"].ToString();
// dtGrid.Rows[i].Cells["hID1"].Value = dsDetail.Tables[0].Rows[i]["ID"].ToString();
//end key
dtGrid.Rows[i].Cells["hTransNo"].Value = dsDetail.Tables[0].Rows[i]["GRNNO"].ToString();
dtGrid.Rows[i].Cells["hID"].Value = dsDetail.Tables[0].Rows[i]["ID"].ToString();
dtGrid.Rows[i].Cells["hItemsID"].Value = dsDetail.Tables[0].Rows[i]["ITEMSID"].ToString();
dtGrid.Rows[i].Cells["hDescription"].Value = dsDetail.Tables[0].Rows[i]["DESCRIPTION"].ToString();
//dtGrid.Rows[i].Cells["hJenis"].Value = dsDetail.Tables[0].Rows[i]["JENIS"].ToString();
dtGrid.Rows[i].Cells["hStyleID"].Value = dsDetail.Tables[0].Rows[i]["STYLEID"].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();
}
}
}
else
{
MessageBox.Show("You must select type");
}
}
private void RecordTSB_Click(object sender, EventArgs e)
{
GStrCode = "";
frmgrnSearch f = new frmgrnSearch();
GlobalVariables.GCode = "PRODUCT";
f.AddItemCallback = new frmgrnSearch.AddPurchaseDelegate(this.SetPurchaseCallBack);
f.ShowDialog();
//txtCostingNo.Text
if (GStrCode != "")
{
//load header
//GRNNO,DATE,OFFICER,GDIV,RECEIVEFROM,REMARKS,STOREID,PONO,CUSTVENDCODE,REFFNO,APPROVE,APPROVEDATE,APPROVEBY,
//CLOSE,STYLEID,COLORID,DOCREGNO,JENIS,
DataSet dsHeader = new grnCRUD().getData(GStrCode);
txtGRNNO.Text = GStrCode;
dateCreated.Value = (DateTime)dsHeader.Tables[0].Rows[0]["DATE"];
cbDIV.SelectedValue = dsHeader.Tables[0].Rows[0]["GDIV"];
//RECEIVEFROM di hilangkan
txtRemarks.Text = dsHeader.Tables[0].Rows[0]["REMARKS"].ToString();
txtCustomerID.Text = dsHeader.Tables[0].Rows[0]["CUSTVENDCODE"].ToString();
txtRefer.Text = dsHeader.Tables[0].Rows[0]["REFFNO"].ToString();
txtJONO.Text = dsHeader.Tables[0].Rows[0]["PONO"].ToString();
cbJENIS.Text = dsHeader.Tables[0].Rows[0]["JENIS"].ToString();
cbStore.Text = dsHeader.Tables[0].Rows[0]["STOREID"].ToString();
//load detail
DataSet dsDetail = new grndetailCRUD().getData(GStrCode);
dtGrid.Rows.Clear();
for (int i = 0; i < dsDetail.Tables[0].Rows.Count; i++)
{
GlobalVariables.GID = GlobalVariables.GID + 1;
// ID,ITEMSID,DESCRIPTION,JENIS,COLORID,SIZEID,GRADE,COSTINGNO,STYLEID,PONO,QUANTITY,UOM,
//PRICE,CURRENCYID,KURS,REMARKS,QTYPURCHASE,PRICEPURCHASE,UOMPURCHASE,
dtGrid.Rows.Add();
dtGrid.Rows[i].HeaderCell.Value = "V";
//key
dtGrid.Rows[i].Cells["hGRNNo1"].Value = dsDetail.Tables[0].Rows[i]["GRNNO"].ToString();
dtGrid.Rows[i].Cells["hID1"].Value = dsDetail.Tables[0].Rows[i]["ID"].ToString();
//end key
dtGrid.Rows[i].Cells["hGRNNo"].Value = dsDetail.Tables[0].Rows[i]["GRNNO"].ToString();
dtGrid.Rows[i].Cells["hID"].Value = dsDetail.Tables[0].Rows[i]["ID"].ToString();
dtGrid.Rows[i].Cells["hItemsID"].Value = dsDetail.Tables[0].Rows[i]["ITEMSID"].ToString();
dtGrid.Rows[i].Cells["hDescription"].Value = dsDetail.Tables[0].Rows[i]["DESCRIPTION"].ToString();
dtGrid.Rows[i].Cells["hJenis"].Value = dsDetail.Tables[0].Rows[i]["JENIS"].ToString();
dtGrid.Rows[i].Cells["hColorID"].Value = dsDetail.Tables[0].Rows[i]["COLORID"].ToString();
dtGrid.Rows[i].Cells["hSizeID"].Value = dsDetail.Tables[0].Rows[i]["SIZEID"].ToString();
//if (row[col] == DBNull.Value)
dtGrid.Rows[i].Cells["hGrade"].Value = DBNull.Value.Equals(dsDetail.Tables[0].Rows[i]["GRADE"]) ? null : dsDetail.Tables[0].Rows[i]["GRADE"].ToString();
//dtGrid.Rows[i].Cells["hCostingNo"].Value = dsDetail.Tables[0].Rows[i]["COSTINGNO"].ToString();
dtGrid.Rows[i].Cells["hStyleID"].Value = dsDetail.Tables[0].Rows[i]["STYLEID"].ToString();
dtGrid.Rows[i].Cells["hPONO"].Value = dsDetail.Tables[0].Rows[i]["PONO"].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["hCurrencyID"].Value = dsDetail.Tables[0].Rows[i]["CURRENCYID"].ToString();
//dtGrid.Rows[i].Cells["hKurs"].Value = dsDetail.Tables[0].Rows[i]["KURS"].ToString();
dtGrid.Rows[i].Cells["hConvert"].Value = dsDetail.Tables[0].Rows[i]["CONVER"].ToString();
//dtGrid.Rows[i].Cells["hRemarks"].Value = dsDetail.Tables[0].Rows[i]["REMARKS"].ToString();
dtGrid.Rows[i].Cells["hQtyPurchase"].Value = dsDetail.Tables[0].Rows[i]["QTYPURCHASE"].ToString();
//dtGrid.Rows[i].Cells["hPricePurchase"].Value = dsDetail.Tables[0].Rows[i]["PRICEPURCHASE"].ToString();
dtGrid.Rows[i].Cells["hUOMPurchase"].Value = dsDetail.Tables[0].Rows[i]["UOMPURCHASE"].ToString();
}
SimpanTSB.Enabled = false;
UbahTSB.Enabled = true;
dtGrid.Enabled = true;
}
}
