private void button1_Click(object sender, EventArgs e) { MaterialCore.EmbarquesZodiac.EscanearTN scanTN = new EscanearTN(); DialogResult dr = new DialogResult(); dr = scanTN.ShowDialog(this); if (dr == DialogResult.OK) { RecargarDatos(); } }
private void btnSave_Click(object sender, EventArgs e) { this.Cursor = Cursors.WaitCursor; btnCancel.Enabled = true; for (int x = 0; x < dgvEmbarques.SelectedRows.Count; x++) { string picker = txtPicker.Text.Trim(); string tracknum = txtTracking.Text.Trim(); int id = int.Parse(dgvEmbarques.SelectedRows[x].Cells["idDataGridViewTextBoxColumn"].Value.ToString()); //ARRIVAL if (dateArrival.Checked == true) { this.embarquesZodiacTableAdapter.UpdateArrivalDate(dateArrival.Value, id); } //PICKUP if (datePickup.Checked == true) { this.embarquesZodiacTableAdapter.UpdatePickupDate(datePickup.Value, id);; } //PICKUP WAS REQUESTED if (datePickupWas.Checked == true) { this.embarquesZodiacTableAdapter.UpdatePickupDateRequested(datePickupWas.Value, id); } //UNLOADED if (dateUnloaded.Checked == true) { this.embarquesZodiacTableAdapter.UpdateUnloadedDate(dateUnloaded.Value, id); } this.embarquesZodiacTableAdapter.UpdatePicker(picker, id); //PREGUNTA SI EXISTE EL TRACKING NUMBER this.embarquesZodiacTableAdapter.UpdateTrackingNumber(tracknum, id); this.embarquesZodiacTableAdapter.UpdateReceived(chkReceived.Checked, id); this.embarquesZodiacTableAdapter.UpdateDone(chkDone.Checked, id); } if (txtTracking.Text.Trim() != "") { da = _con.getDataAdapter("SELECT nid_sku FROM dbo.sku_escanear WHERE nid_cliente = 52 AND nid_sku='" + txtTracking.Text.Trim() + "'"); dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count == 0) { this.sku_escanearTableAdapter.InsertskuEscanear(txtTracking.Text.Trim(), DateTime.Now, false, 52); } } if (chkScan.Checked == true) { MaterialCore.EmbarquesZodiac.EscanearTN scanTN = new EscanearTN(txtTracking.Text); scanTN.ShowDialog(this); } foreach (DataGridViewRow fila in dgvEmbarques.SelectedRows) { DataTable datatable = this.embarquesZodiacTableAdapter.GetDataByRegistro(int.Parse(fila.Cells["idDataGridViewTextBoxColumn"].Value.ToString())); object value = datatable.Rows[0]["registroRBI"]; if (value == DBNull.Value) { this.embarquesZodiacTableAdapter.UpdateQueryRegistro(DateTime.Now, MaterialCore.Clases.Logueado.Login.ToString(), int.Parse(fila.Cells["idDataGridViewTextBoxColumn"].Value.ToString())); } } RecargarDatos(); this.Cursor = Cursors.Default; }