public Form_Upgrade_inThread(UpgradeDB_inThread xUpgrade_inThread, UpgradeDB_inThread.Upgrade[] upgradeArray, int j, string xBackupFileName) { InitializeComponent(); m_Upgrade_inThread = xUpgrade_inThread; this.upgradeArray = upgradeArray; this.m_j = j; m_BackupFileName = xBackupFileName; thread = new ThreadProcessor.ThreadP(); }
internal bool Write2DB(Database_Upgrade_WindowsForm_Thread wfp_ui_thread,UpgradeDB_inThread.eUpgrade eUpgr,Old_tables_1_04_to_1_05 m_Old_tables_1_04_to_1_05) { string Err = null; foreach (TableDataItem xtdi in fkey_TableDataItem_List) { xtdi.Write2DB(wfp_ui_thread, eUpgr, m_Old_tables_1_04_to_1_05); } if (eUpgr == UpgradeDB_inThread.eUpgrade.from_1_04_to_105) { if (this.tbl.TableName.ToLower().Equals("pricelist")) { if (GlobalData.Office_ID<0) { string sql = "insert into Office (myOrganisation_ID,Name)values(1,'P1')"; object oret = null; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql,null,ref GlobalData.Office_ID,ref oret, ref Err,"Office")) { sql = "insert into myOrganisation_Person (UserName,Password,Job,Active,Description,Person_ID,Office_ID)values('marjetkah',null,'Direktor',1,'Direktorica in lastnica podjetja',1,1)"; long x_myOrganisation_Person_ID = -1; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, null, ref x_myOrganisation_Person_ID, ref oret, ref Err, "Office")) { } else { LogFile.Error.Show("ERROR:usrc_Upgrade:Write2DB:sql=" + sql + "\r\nErr=" + Err); return false; } } else { LogFile.Error.Show("ERROR:usrc_Upgrade:Write2DB:sql=" + sql + "\r\nErr=" + Err); return false; } } } else if (this.tbl.TableName.ToLower().Equals("atom_pricelist")) { string sql = null; object oret = null; if (GlobalData.Atom_Office_ID < 0) { sql = "insert into Atom_Office (Atom_myOrganisation_ID,Name)values(1,'P1')"; if (!DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, null, ref GlobalData.Atom_Office_ID, ref oret, ref Err, "Atom_Office")) { LogFile.Error.Show("ERROR:usrc_Upgrade:Write2DB:sql=" + sql + "\r\nErr=" + Err); return false; } } DateTime dtStart = new DateTime(2015, 4, 29); DateTime_v dtEnd_v = new DateTime_v(); dtEnd_v.v = DateTime.Now; if (!GlobalData.GetWorkPeriodOld(f_Atom_WorkPeriod.sWorkPeriod_DB_ver_1_04,null,dtStart,dtEnd_v, ref Err)) { return false; } } else if (this.tbl.TableName.ToLower().Equals("docinvoice")) { DateTime dtStart = new DateTime(2015, 4, 29); DateTime_v dtEnd_v = new DateTime_v(); dtEnd_v.v = DateTime.Now; GlobalData.GetWorkPeriodOld(f_Atom_WorkPeriod.sWorkPeriod_DB_ver_1_04, null, dtStart, dtEnd_v, ref Err); } } string tname = tbl.TableName; string sql_insert_columns = null; string sql_insert_values = null; List<SQL_Parameter> lpar = new List<SQL_Parameter>(); bool bDocInvoiceTime = false; bool bFirstPrintTime = false; bool bPaid = false; bool bStorno = false; foreach (DataRow dr in dt.Rows) { if (dr["old_id"] is System.DBNull) { wfp_ui_thread.Message(lngRPM.s_ImportData.s + ":" + tname); sql_insert_columns = null; sql_insert_values = null; lpar.Clear(); long old_id = (long)dr["id"]; DateTime_v InvoiceTime_v = null; DateTime_v PaidTime_v = null; DateTime_v StornoTime_v = null; foreach (DataColumn dcol in dt.Columns) { if (dcol.ColumnName.ToUpper().Equals("ID") || dcol.ColumnName.ToUpper().Equals("OLD_ID")) { continue; } else { if (eUpgr == UpgradeDB_inThread.eUpgrade.from_1_04_to_105) { if (dcol.ColumnName.ToLower().Equals("myorganisation_person_id")) { continue; } if (this.tbl.TableName.ToLower().Equals("atom_pricelist")) { if (dcol.ColumnName.ToLower().Equals("atom_myorganisation_person_id")) { continue; } } else { if (this.tbl.TableName.ToLower().Equals("docinvoice")) { if (dcol.ColumnName.ToLower().Equals("atom_myorganisation_person_id")) { continue; } } } } } object o = dr[dcol]; string sparname = null; SQL_Parameter par = null; if (new_SQL_Parameter(this, dr, dcol, ref sparname, o, ref par)) { if (dcol.ColumnName.ToLower().Equals("paid")) { bPaid = true; } if (dcol.ColumnName.ToLower().Equals("storno")) { bStorno = true; } if (dcol.ColumnName.ToLower().Equals("firstprinttime")) { bFirstPrintTime = true; } else if (dcol.ColumnName.ToLower().Equals("docinvoicetime")) { bDocInvoiceTime = true; } else { if (par != null) { lpar.Add(par); } if (sql_insert_columns == null) { sql_insert_columns = dcol.ColumnName; } else { sql_insert_columns += "," + dcol.ColumnName; } if (sql_insert_values == null) { sql_insert_values = sparname; } else { sql_insert_values += "," + sparname; } } } else { return false; } } if (bDocInvoiceTime) { if (dr["docinvoicetime"] is DateTime) { InvoiceTime_v = new DateTime_v(); InvoiceTime_v.v = (DateTime)dr["docinvoicetime"]; } } if (bPaid) { if (dr["Paid"] is bool) { PaidTime_v = new DateTime_v(); PaidTime_v.v = GetDocInvoiceTime(old_id,m_Old_tables_1_04_to_1_05); } } if (bStorno) { if (dr["Storno"] is bool) { if ((bool)dr["Storno"]) { StornoTime_v = new DateTime_v(); StornoTime_v.v = GetInvoiceStornoTime(old_id, m_Old_tables_1_04_to_1_05); } else { bStorno = false; } } } string sql_insert = " insert into " + tname + " (" + sql_insert_columns + ") values (" + sql_insert_values + ")"; long new_id = -1; object ores = null; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql_insert, lpar, ref new_id, ref ores, ref Err, tname)) { dr["OLD_ID"] = old_id; dr["id"] = new_id; if (tname.ToLower().Equals("docinvoice")) { long Journal_DocInvoice_ID = -1; f_Journal_DocInvoice.Write(new_id, GlobalData.Atom_WorkPeriod_ID, GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoiceDraftTime.Name, GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoiceDraftTime.Description, InvoiceTime_v, ref Journal_DocInvoice_ID); if (dr["Draft"] is bool) { if (!(bool)dr["Draft"]) { f_Journal_DocInvoice.Write(new_id, GlobalData.Atom_WorkPeriod_ID, GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoiceTime.Name, GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoiceTime.Description ,InvoiceTime_v, ref Journal_DocInvoice_ID); f_Journal_DocInvoice.Write(new_id, GlobalData.Atom_WorkPeriod_ID, GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoicePaidTime.Name, GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoicePaidTime.Description, InvoiceTime_v, ref Journal_DocInvoice_ID); } } } else if (tname.ToLower().Equals("invoice")) { long Journal_Invoice_ID = -1; f_Journal_DocInvoice.Write(new_id, GlobalData.Atom_WorkPeriod_ID, "Paid", "Plačano", PaidTime_v, ref Journal_Invoice_ID); if (bStorno) { f_Journal_DocInvoice.Write(new_id, GlobalData.Atom_WorkPeriod_ID, "Storno*", "Napaka pri vnosu", StornoTime_v, ref Journal_Invoice_ID); } } } else { LogFile.Error.Show("ERROR:usrc_Upgrade:Write2DB:Err=" + Err); return false; } } } return true; }
public usrc_Document() { InitializeComponent(); Program.usrc_TangentaPrint1 = this.usrc_TangentaPrint1; m_UpgradeDB = new UpgradeDB_inThread(this); }