private void CalculateAndDisplay(object sender, Jacksonsoft.WaitWindowEventArgs e) { //string ptableName = ""; try { GTS.Clock.AppSetup.DataSet.GTSDBTableAdapters.TA_PersonTableAdapter PersonTA = new GTS.Clock.AppSetup.DataSet.GTSDBTableAdapters.TA_PersonTableAdapter(); PersonTA.Connection = GTSAppSettings.SQLConnection; decimal PersonId = (decimal)PersonTA.GetPrsID(this.Barcode); PTableHelper helper = new PTableHelper(); helper.InitTA_PTable(); DataSet.DBDataSet.TA_PTableUsableColumnsDataTable ta_ptable = new DataSet.DBDataSet.TA_PTableUsableColumnsDataTable(); DataSet.DBDataSetTableAdapters.TA_PTableUsableColumnsTableAdapter ptableTA = new DataSet.DBDataSetTableAdapters.TA_PTableUsableColumnsTableAdapter(); ptableTA.Connection = GTSAppSettings.SQLConnection; ptableTA.Fill(ta_ptable); helper.GTSCalculate(this.Barcode, PersonId, fromDataTB.Text, toDataTB.Text); DataSet.DBDataSet.TA_PTableUsableColumnsDataTable ptable = helper.GetPTableUsableColumns(Barcode, fromDataTB.Text, toDataTB.Text, "", false); //ptable.DefaultView.Sort = "prc_date"; ta_ptable = helper.AppendPTable(ta_ptable, ptable.DefaultView); ta_ptable = helper.MinutesToTime(ta_ptable); calculate = ta_ptable; if (dataGridView1.InvokeRequired) { dataGridView1.Invoke(new MethodInvoker(delegate { dataGridView1.DataSource = ta_ptable; })); } else { dataGridView1.DataSource = ta_ptable; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Display(object sender, Jacksonsoft.WaitWindowEventArgs e) { try { string ptableName = ""; //ptableName = ptableTB1.Text; PTableHelper helper = new PTableHelper(); helper.InitTA_PTable(); DataSet.DBDataSet.TA_PTableUsableColumnsDataTable ta_ptable = new DataSet.DBDataSet.TA_PTableUsableColumnsDataTable(); DataSet.DBDataSetTableAdapters.TA_PTableUsableColumnsTableAdapter ptableTA = new DataSet.DBDataSetTableAdapters.TA_PTableUsableColumnsTableAdapter(); ptableTA.Connection = GTSAppSettings.SQLConnection; ptableTA.Fill(ta_ptable); DataSet.DBDataSet.TA_PTableUsableColumnsDataTable ptable = helper.GetPTableUsableColumns(Barcode, fromDataTB.Text, toDataTB.Text, "", false); // ptable.DefaultView.Sort = "prc_date"; ta_ptable = helper.AppendPTable(ta_ptable, ptable.DefaultView); ta_ptable = helper.MinutesToTime(ta_ptable); wthoutCalc = ta_ptable; if (dataGridView1.InvokeRequired) { dataGridView1.Invoke(new MethodInvoker(delegate { dataGridView1.DataSource = ta_ptable; })); } else { dataGridView1.DataSource = ta_ptable; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Compaire(object sender, Jacksonsoft.WaitWindowEventArgs e) { try { GTSAppSettings.FromDate = fromDataTB.Text; GTSAppSettings.ToDate = toDataTB.Text; GTSAppSettings.Barcode = Barcode; GTSAppSettings.SaveToFile(); PTableHelper helper = new PTableHelper(); helper.InitTA_PTable(); DataSet.DBDataSet.TA_PTableUsableColumnsDataTable ta_ptable = new DataSet.DBDataSet.TA_PTableUsableColumnsDataTable(); DataSet.DBDataSetTableAdapters.TA_PTableUsableColumnsTableAdapter ptableTA = new DataSet.DBDataSetTableAdapters.TA_PTableUsableColumnsTableAdapter(); ptableTA.Connection = GTSAppSettings.SQLConnection; ptableTA.Fill(ta_ptable); DataSet.DBDataSet.TA_PTableUsableColumnsDataTable ptable1 = helper.GetPTableUsableColumns(Barcode, fromDataTB.Text, toDataTB.Text, "Clock6", false); GTS.Clock.AppSetup.DataSet.GTSDBTableAdapters.TA_PersonTableAdapter PersonTA = new GTS.Clock.AppSetup.DataSet.GTSDBTableAdapters.TA_PersonTableAdapter(); decimal PersonId = (decimal)PersonTA.GetPrsID(this.Barcode); helper.GTSCalculate(Barcode, PersonId, fromDataTB.Text, toDataTB.Text); DataSet.DBDataSet.TA_PTableUsableColumnsDataTable ptable2 = helper.GetPTableUsableColumns(Barcode, fromDataTB.Text, toDataTB.Text, "GTS", false); DataSet.DBDataSet.TA_PTableUsableColumnsDataTable ptable = helper.AppendPTable(ptable1, ptable2); ptable.DefaultView.Sort = "prc_date"; ta_ptable = helper.AppendPTable(ta_ptable, ptable.DefaultView); ta_ptable = helper.MinutesToTime(ta_ptable); compaireSource = ta_ptable; if (dataGridView1.InvokeRequired) { dataGridView1.Invoke(new MethodInvoker(delegate { dataGridView1.DataSource = ta_ptable; })); } else { dataGridView1.DataSource = ta_ptable; } deffMat = helper.GetDifferenceIndex(ta_ptable, Barcode); int count = HighlightDiff(deffMat, ta_ptable); if (difCountLbl.InvokeRequired) { difCountLbl.Invoke(new MethodInvoker(delegate { difCountLbl.Text = Convert.ToString(count / 2); })); difCountLbl.Invoke(new MethodInvoker(delegate { diffCount = difCountLbl.Text; })); } else { dataGridView1.DataSource = ta_ptable; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }