private void findButton_Click(object sender, EventArgs e) { ProfJobDataSet set = profJobSet; bookmark.Get(); AppHelper.ResetGridDataSource(reportGrid); if (dateCheck.Checked == true) { set.From = fromDateEdit.Value.ToString(AppRes.csDateFormat); set.To = toDateEdit.Value.ToString(AppRes.csDateFormat); } else { set.From = ""; set.To = ""; } set.JobNo = ""; set.AreaNo = (EReportArea)areaCombo.SelectedValue; set.ItemNo = itemNoEdit.Text.Trim(); set.JobNo = string.Empty; set.ExtendASTM = false; set.Select(); AppHelper.SetGridDataSource(reportGrid, set); bookmark.Goto(); reportGrid.Focus(); }
private void Insert(EReportArea areaNo, string itemNo) { string jobNo = ""; string extendJobNo = ""; profJobSet.Type = EReportType.Chemical; profJobSet.JobNo = ""; profJobSet.AreaNo = areaNo; profJobSet.ItemNo = itemNo; profJobSet.ExtendASTM = true; profJobSet.Select(); int rowCount = profJobSet.RowCount; if (rowCount > 0) { profJobSet.Fetch(0); jobNo = profJobSet.JobNo; if (string.IsNullOrWhiteSpace(jobNo) == false) { cheCheckSet.Select(jobNo); if (cheCheckSet.Empty == false) { MessageBox.Show("Can't import chemical report because this report already exist in DB!", "SGS", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { if (rowCount > 1) { // Find jobno for additional test results for (int i = 1; i < profJobSet.RowCount; i++) { profJobSet.Fetch(i); if (profJobSet.Image == null) { extendJobNo = profJobSet.JobNo; break; } } profJobSet.Fetch(0); } cheQuery.Insert(extendJobNo); } } } findButton.PerformClick(); }
public void Import() { DialogProfJobListView dialog = new DialogProfJobListView(); try { dialog.Type = EReportType.Physical; dialog.ShowDialog(); } finally { if (dialog.DialogResult == DialogResult.OK) { profJobSet.Type = EReportType.Physical; profJobSet.JobNo = dialog.JobNo; profJobSet.ExtendASTM = false; profJobSet.Select(); profJobSet.Fetch(); Insert(); } } }