private void load_data(string JONO) { DataSet dsHeader = new joborderCRUD().getData(JONO); txtCostingNo.Text = JONO; 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]["QUANTITY"].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(); dateCreated.Value = (DateTime)dsHeader.Tables[0].Rows[0]["DATE"]; txtPOCustomer.Text = dsHeader.Tables[0].Rows[0]["POCUSTOMER"].ToString(); txtRemarks.Text = dsHeader.Tables[0].Rows[0]["REMARKS"].ToString(); txtWash.Text = dsHeader.Tables[0].Rows[0]["WASH"].ToString(); DataSet dsDetail = new joborderdetailCRUD().getData(JONO); 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["hOrderNo"].Value = dsDetail.Tables[0].Rows[i]["ORDERNO"].ToString(); dtGrid.Rows[i].Cells["hPOCustomer"].Value = dsDetail.Tables[0].Rows[i]["POCUSTOMER"].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(); dtGrid.Rows[i].Cells["hNoUrut"].Value = dsDetail.Tables[0].Rows[i]["NOURUT"].ToString(); dtGrid.Rows[i].Cells["hAllowance"].Value = dsDetail.Tables[0].Rows[i]["ALLOWANCE"].ToString(); dtGrid.Rows[i].Cells["hQuantity"].Value = dsDetail.Tables[0].Rows[i]["QUANTITY"].ToString(); dtGrid.Rows[i].Cells["hCuttingQty"].Value = dsDetail.Tables[0].Rows[i]["CUTTINGQTY"].ToString(); dtGrid.Rows[i].Cells["hDestination"].Value = dsDetail.Tables[0].Rows[i]["DESTINATION"].ToString(); //dt = dsDetail.Tables[0].Rows[i]["DELIVERY"].; dtGrid.Rows[i].Cells["hDelivery"].Value = Convert.ToDateTime(dsDetail.Tables[0].Rows[i]["DELIVERY"]).ToString("dd/MM/yyyy"); } }
private void load_color(string JONO) { DataSet dsColor = new joborderCRUD().getColor(JONO); dtColor.Rows.Clear(); for (int i = 0; i < dsColor.Tables[0].Rows.Count; i++) { dtColor.Rows.Add(); dtColor.Rows[i].Cells["hJONO"].Value = Convert.ToString(dsColor.Tables[0].Rows[i]["JONO"]); dtColor.Rows[i].Cells["hStyleID"].Value = Convert.ToString(dsColor.Tables[0].Rows[i]["STYLEID"]); txtJONO.Text = Convert.ToString(dsColor.Tables[0].Rows[i]["ORDERNO"]); txtStyleID.Text = Convert.ToString(dsColor.Tables[0].Rows[i]["ITEMSID"]); dtColor.Rows[i].Cells["hColorID"].Value = Convert.ToString(dsColor.Tables[0].Rows[i]["COLORID"]); if (!DBNull.Value.Equals(dsColor.Tables[0].Rows[i]["STARTDATE"])) { dtColor.Rows[i].Cells["hStart"].Value = Convert.ToDateTime(dsColor.Tables[0].Rows[i]["STARTDATE"]).ToString(GlobalVariables.GFormat); } if (!DBNull.Value.Equals(dsColor.Tables[0].Rows[i]["CLOSEDATE"])) { dtColor.Rows[i].Cells["hClose"].Value = Convert.ToDateTime(dsColor.Tables[0].Rows[i]["CLOSEDATE"]).ToString(GlobalVariables.GFormat); } if (!DBNull.Value.Equals(dsColor.Tables[0].Rows[i]["DELIVERYDATE"])) { dtColor.Rows[i].Cells["hDelivery"].Value = Convert.ToDateTime(dsColor.Tables[0].Rows[i]["DELIVERYDATE"]).ToString(GlobalVariables.GFormat); } } }
private void Print_Click(object sender, EventArgs e) { DataSet data = new joborderCRUD().prJobOrder(txtCostingNo.Text); Application.DoEvents(); data.WriteXml("C:\\MyGarmentReport\\joborder.xml", XmlWriteMode.WriteSchema); Form f = new PrintJO(); f.Show(); }
private void RecordTSB_Click(object sender, EventArgs e) { //k.ORDERNO=txtCostingNo.Text; // k.TYPEID=txtTypeID.Text; //k.APPROVE= txtStatus.Text; //k.OFFICER=txtOfficer.Text; //k.CUSTVENDCODE=txtCustomer.Text; //k.APPROVE= Convert.ToInt32(cbApprove.Text); DataSet data = new joborderCRUD().getData(txtCostingNo.Text, txtStyleID.Text, txtPOCustomer.Text, txtOfficer.Text, txtCustomer.Text); DtGrid.DataSource = data; DtGrid.DataMember = "tbljoborder"; }
private void load_size(string JONO) { DataSet dsSize = new joborderCRUD().getSize(JONO); dtSize.Rows.Clear(); for (int i = 0; i < dsSize.Tables[0].Rows.Count; i++) { dtSize.Rows.Add(); dtSize.Rows[i].Cells["dStyleID"].Value = Convert.ToString(dsSize.Tables[0].Rows[i]["STYLEID"]); dtSize.Rows[i].Cells["dSizeID"].Value = Convert.ToString(dsSize.Tables[0].Rows[i]["SIZEID"]); //dtSize.Rows[i].Cells["dNoUrut"].Value = Convert.ToString(dsSize.Tables[0].Rows[i]["NOURUT"]); dtSize.Rows[i].Cells["dNoUrut"].Value = i; dtSize.Rows[i].Cells["dQtyPlan"].Value = Convert.ToString(dsSize.Tables[0].Rows[i]["CUTTINGQTY"]); dtSize.Rows[i].Cells["dRatio"].Value = Convert.ToString(dsSize.Tables[0].Rows[i]["RATIO"]); } }
private void button1_Click(object sender, EventArgs e) { frmjoborderSearch f = new frmjoborderSearch(); f.AddItemCallback = new frmjoborderSearch.AddCostingDelegate(this.SetCostingCallBack); f.ShowDialog(); if (GStrCode != "") { DataSet dsHeader = new joborderCRUD().getGarment(GStrCode); cbDIV.SelectedValue = dsHeader.Tables[0].Rows[0]["GDIV"].ToString(); txtCustomerID.Text = dsHeader.Tables[0].Rows[0]["CUSTVENDCODE"].ToString(); DataSet dsSupplier = new mcustvendCRUD().getData(txtCustomerID.Text, "", ""); if (dsSupplier.Tables[0].Rows.Count > 0) { txtCustomerDesc.Text = dsSupplier.Tables[0].Rows[0]["NAME"].ToString(); txtAddress.Text = dsSupplier.Tables[0].Rows[0]["ADDRESS"].ToString(); } //isi detail DataSet dsDetail = new joborderdetailCRUD().getData(GStrCode); // var index = dtGrid.Rows.Add(); 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["hID"].Value = i;//dsDetail.Tables[0].Rows[i]["ID"].ToString(); dtGrid.Rows[i].Cells["hItemsID"].Value = Convert.ToString(dsHeader.Tables[0].Rows[0]["ITEMSID"]); dtGrid.Rows[i].Cells["hDescription"].Value = Convert.ToString(dsHeader.Tables[0].Rows[0]["ITEMSID"]); // dtGrid.Rows[i].Cells["hJenis"].Value = dsDetail.Tables[0].Rows[i]["JENIS"].ToString(); 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 = "A"; dtGrid.Rows[i].Cells["hStyleID"].Value = Convert.ToString(dsHeader.Tables[0].Rows[0]["ITEMSID"]); dtGrid.Rows[i].Cells["hQuantity"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["QUANTITY"]); dtGrid.Rows[i].Cells["hUOM"].Value = "PCS"; dtGrid.Rows[i].Cells["hConvert"].Value = 1; dtGrid.Rows[i].Cells["hQtyPurchase"].Value = Convert.ToString(dsDetail.Tables[0].Rows[i]["QUANTITY"]); dtGrid.Rows[i].Cells["hUOMPurchase"].Value = "PCS"; } SimpanTSB.Enabled = true; UbahTSB.Enabled = false; dtGrid.Enabled = true; } }