private void CompleteDO(int rowIndex) { DataTable dt_Item = (DataTable)dgvItemList.DataSource; DataGridView dgv = dgvDOList; string doCode = dgv.Rows[rowIndex].Cells[header_DONo].Value.ToString(); string customerShortName = dgv.Rows[rowIndex].Cells[header_Customer].Value.ToString(); string customerCode = dgv.Rows[rowIndex].Cells[header_CustomerCode].Value.ToString(); DataTable dt = NewCompleteTable(); DataRow dt_Row; foreach (DataRow row in dt_Item.Rows) { string doTableCode = row[header_DOTblCode].ToString(); string itemCode = row[header_ItemCode].ToString(); string PcsQty = row[header_DeliveryPCS].ToString(); string BagQty = row[header_DeliveryBAG].ToString(); if (!string.IsNullOrEmpty(itemCode)) { dt_Row = dt.NewRow(); dt_Row[header_DOTblCode] = doTableCode; dt_Row[header_DONo] = doCode; dt_Row[header_Customer] = customerShortName; dt_Row[header_CustomerCode] = customerCode; dt_Row[header_ItemCode] = itemCode; dt_Row[header_DeliveryPCS] = PcsQty; dt_Row[header_DeliveryBAG] = BagQty; dt.Rows.Add(dt_Row); } } frmDeliveryDate frm = new frmDeliveryDate(dt) { StartPosition = FormStartPosition.CenterScreen }; frm.ShowDialog();//Item Edit if (frmInOutEdit.TrfSuccess) { MessageBox.Show("transfer success"); LoadDOList(); } }
private void EditDeliveryDate() { frmDeliveryDate frm = new frmDeliveryDate(text_SelectDeliveryDate) { StartPosition = FormStartPosition.CenterScreen }; frm.ShowDialog();//Item Edit if (frmDeliveryDate.selectedDate != DateTime.MaxValue) { //DateTime selectedDate = DateTime.Now; DateTime selectedDate = frmDeliveryDate.selectedDate; DataGridView dgv = dgvMainList; DataTable dt = (DataTable)dgv.DataSource; uSpp.Updated_Date = DateTime.Now; uSpp.Updated_By = MainDashboard.USER_ID; for (int i = 0; i < dt.Rows.Count; i++) { bool rowSelected = dgv.Rows[i].Selected; if (rowSelected) { if (selectedDate == DateTimePicker.MinimumDateTime || selectedDate == null) { dgv.Rows[i].Cells[header_DeliveryDate].Value = ""; uSpp.Delivery_date = null; } else { dgv.Rows[i].Cells[header_DeliveryDate].Value = selectedDate.Date; uSpp.Delivery_date = selectedDate.Date; } //update int planningNo = int.TryParse(dt.Rows[i][header_PlanningNo].ToString(), out planningNo) ? planningNo : -1; int poCode = int.TryParse(dt.Rows[i][header_POCode].ToString(), out poCode) ? poCode : -1; uSpp.Planning_no = planningNo; uSpp.PO_code = poCode; if (!dalSPP.DeliveryTripDateUpdate(uSpp)) { MessageBox.Show("Failed to update delivery data!"); break; } } } } }
private void btnDelivered_Click(object sender, EventArgs e) { if (btnDelivered.Text == "CONFIRM") { //get data DataTable dt = GetSelectedData(); //check if data exist if (dt.Rows.Count > 0) { frmDeliveryDate frm = new frmDeliveryDate(); frm.StartPosition = FormStartPosition.CenterScreen; frm.ShowDialog(); if (frmDeliveryDate.selectedDate != DateTimePicker.MinimumDateTime && frmDeliveryDate.selectedDate != DateTime.MaxValue) { foreach (DataRow row in dt.Rows) { row[header_DeliveredDate] = frmDeliveryDate.selectedDate.Date; } //process to In/Out frmInOutEdit frm2 = new frmInOutEdit(dt, 0); frm2.StartPosition = FormStartPosition.CenterScreen; frm2.ShowDialog(); } else { MessageBox.Show("Date invalid!"); } } } else { btnDelivered.BackColor = Color.FromArgb(0, 184, 148); btnDelivered.Text = "CONFIRM"; cbSelectAll.Visible = true; cbSelectAll.Checked = true; btnCancel.Visible = true; btnAdd.Visible = false; Loaded = false; dgvItemList.ClearSelection(); dgvDeliveryList.DataSource = null; ColumnSelectAction(); Loaded = true; } }