/// <summary> /// delete CFP /// Insert CFP /// Calculate /// </summary> public void GTSCalculate(string barcode, decimal PrsId, string fromdate, string todate) { try { string pTableName1 = GetPtableFromDate(fromdate); string pTableName2 = GetPtableFromDate(todate); barcode = barcode.PadLeft(8, '0'); DeletePTable(barcode, pTableName1); DeletePTable(barcode, pTableName2); DataSet.DBDataSetTableAdapters.TA_Calculation_Flag_PersonsTableAdapter cfpTA = new DataSet.DBDataSetTableAdapters.TA_Calculation_Flag_PersonsTableAdapter(); cfpTA.Connection = GTSAppSettings.SQLConnection; //cfpTA.DeleteCFP(PrsId); cfpTA.UpdateCFP(Utility.ToMildiDate(fromdate), PrsId); string MiladifromDate = Utility.ToString(Utility.ToMildiDate(fromdate)); //cfpTA.InsertCFP(PrsId, new DateTime(int.Parse(MiladifromDate.Split('/')[0]), int.Parse(MiladifromDate.Split('/')[1]), int.Parse(MiladifromDate.Split('/')[2]))); ServiceReference1.TotalWebServiceClient total = new GTS.Clock.AppSetup.ServiceReference1.TotalWebServiceClient("BasicHttpBinding_ITotalWebService", GTSAppSettings.WebServiceAddress); if (GTSAppSettings.ClockCalculation) { //total.Clock_FillByPersonBarCodeAndToDate(barcode, todate); } else { string date = Utility.ToString(Utility.ToMildiDate(todate)); total.GTS_ExecuteByPersonIdAndToDate("InternalUtility", PrsId, new DateTime(int.Parse(date.Split('/')[0]), int.Parse(date.Split('/')[1]), int.Parse(date.Split('/')[2]))); } } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); } }
private void button3_Click(object sender, EventArgs e) { try { GTSAppSettings.FromDate = shamsiDateTB.Text; GTSAppSettings.Barcode = barcodeTB.Text; GTS.Clock.AppSetup.DataSet.GTSDBTableAdapters.TA_PersonTableAdapter PersonTA = new GTS.Clock.AppSetup.DataSet.GTSDBTableAdapters.TA_PersonTableAdapter(); GTS.Clock.AppSetup.DataSet.DBDataSetTableAdapters.DBQuries queriesTA = new GTS.Clock.AppSetup.DataSet.DBDataSetTableAdapters.DBQuries(); DataSet.DBDataSetTableAdapters.TA_Calculation_Flag_PersonsTableAdapter cfpTA = new DataSet.DBDataSetTableAdapters.TA_Calculation_Flag_PersonsTableAdapter(); PersonTA.Connection = GTSAppSettings.SQLConnection; decimal PersonId = (decimal)PersonTA.GetPrsID(barcodeTB.Text.PadLeft(8, '0')); cfpTA.Connection = GTSAppSettings.SQLConnection; string miladiDate = Utility.ToMildiDateString(shamsiDateTB.Text); cfpTA.UpdateCFP(Utility.ToMildiDateTime(miladiDate), PersonId); if (cfpTrafficCB.Checked) { cfpTA.DeleteProcceedTraffic(PersonId, Utility.ToMildiDateTime(miladiDate)); cfpTA.InvalidateBasicTraffic(PersonId, Utility.ToMildiDateTime(miladiDate)); cfpTA.InvalidateTrafficPermits(PersonId, Utility.ToMildiDateTime(miladiDate)); } MessageBox.Show("انجام شد"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button2_Click(object sender, EventArgs e) { DataSet.DBDataSetTableAdapters.TA_Calculation_Flag_PersonsTableAdapter cfpTA = new DataSet.DBDataSetTableAdapters.TA_Calculation_Flag_PersonsTableAdapter(); cfpTA.Connection = GTSAppSettings.SQLConnection; cfpTA.DeleteAll(); }
private void button3_Click(object sender, EventArgs e) { try { GTSAppSettings.FromDate = startTimeTB.Text; GTSAppSettings.PTableName = ptableTB.Text; string sql = String.Format(@"insert into TA_Calculation_Flag_Persons select Prc_PCode ,'{0}' from {1} group by Prc_PCode", startTimeTB.Text, ptableTB.Text); QueryExecuter exe = new QueryExecuter(null); exe.RunQuery(sql, GTSAppSettings.SQLConnection); DataSet.DBDataSetTableAdapters.TA_Calculation_Flag_PersonsTableAdapter cfpTA = new DataSet.DBDataSetTableAdapters.TA_Calculation_Flag_PersonsTableAdapter(); DBDataSet.TA_Calculation_Flag_PersonsDataTable cfpTable = new DBDataSet.TA_Calculation_Flag_PersonsDataTable(); cfpTA.Connection = GTSAppSettings.SQLConnection; cfpTA.Fill(cfpTable); int cfpCount = cfpTable.Rows.Count; MessageBox.Show(String.Format("تعداد {0} درج شد", cfpCount.ToString())); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button1_Click(object sender, EventArgs e) { try { GTSAppSettings.FromDate = startTimeTB.Text; GTSAppSettings.Barcode = barcodeTB.Text.PadLeft(8, '0'); GTSAppSettings.PTableName = ptableTB.Text; GTS.Clock.AppSetup.DataSet.GTSDBTableAdapters.TA_PersonTableAdapter PersonTA = new GTS.Clock.AppSetup.DataSet.GTSDBTableAdapters.TA_PersonTableAdapter(); decimal PersonId = (decimal)PersonTA.GetPrsID(barcodeTB.Text); PTableHelper helper = new PTableHelper(); this.Cursor = Cursors.WaitCursor; DataSet.DBDataSetTableAdapters.TA_Calculation_Flag_PersonsTableAdapter cfpTA = new DataSet.DBDataSetTableAdapters.TA_Calculation_Flag_PersonsTableAdapter(); cfpTA.Connection = GTSAppSettings.SQLConnection; string date = PersianDateTime.ShamsiToMiladi(startTimeTB.Text); cfpTA.InsertCFP(PersonId, new DateTime(int.Parse(date.Split('/')[0]), int.Parse(date.Split('/')[1]), int.Parse(date.Split('/')[2]))); } finally { this.Enabled = true; this.Cursor = Cursors.Default; } }