public void Init(xUnitList xxUnitList) { m_xUnitList = xxUnitList; Set_DataSource(); this.cmb_Unit.SelectedValueChanged += new System.EventHandler(this.cmb_Unit_SelectedValueChanged); }
private static bool Init_Unit_Table(ref string Err) { string s_Unit_table_name = DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(TangentaTableClass.Unit)).TableName; string s_col_Name = DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(TangentaTableClass.Unit)).FindColumn(DBSync.DBSync.DB_for_Tangenta.mt.m_Unit.Name.GetType()).Name; string s_col_Symbol = DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(TangentaTableClass.Unit)).FindColumn(DBSync.DBSync.DB_for_Tangenta.mt.m_Unit.Symbol.GetType()).Name; string s_col_DecimalPlaces = DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(TangentaTableClass.Unit)).FindColumn(DBSync.DBSync.DB_for_Tangenta.mt.m_Unit.DecimalPlaces.GetType()).Name; string s_col_StorageOption = DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(TangentaTableClass.Unit)).FindColumn(DBSync.DBSync.DB_for_Tangenta.mt.m_Unit.StorageOption.GetType()).Name; string s_col_Description = DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(TangentaTableClass.Unit)).FindColumn(DBSync.DBSync.DB_for_Tangenta.mt.m_Unit.Description.GetType()).Name; xUnitList xUnitList = new xUnitList(); long Unit_table_Rows_Count = fs.GetTableRowsCount(s_Unit_table_name); if (Unit_table_Rows_Count >= 0) { long l_unit_table_rows_count = Convert.ToInt64(xUnitList.m_DefaltUnitList.Count); if (Unit_table_Rows_Count == l_unit_table_rows_count) { //Unit table allready written return true; } else if (Unit_table_Rows_Count == 0) { DBSync.DBSync.DB_for_Tangenta.m_DBTables.m_con.BatchOpen = true; string sql_Unit = "insert into " + s_Unit_table_name + " ( " + s_col_Name + "," + s_col_Symbol + "," + s_col_DecimalPlaces + "," + s_col_StorageOption + "," + s_col_Description + " ) values ("; foreach (xUnit unit in xUnitList.m_DefaltUnitList) { string sStorageOptionValue = null; if (unit.StorageOption) { sStorageOptionValue = "1"; } else { sStorageOptionValue = "0"; } string sValues = "'" + unit.Name + "','" + unit.Symbol + "'," + unit.DecimalPlaces.ToString() + "," + sStorageOptionValue + ",'" + unit.Description + "'"; string sql = sql_Unit + sValues + ")"; object Result = null; if (!DBSync.DBSync.ExecuteNonQuerySQL(sql, null, ref Result, ref Err)) { Err = "ERROR::TangentaDB:fs:Init_Unit_Table:Err=" + Err; DBSync.DBSync.DB_for_Tangenta.m_DBTables.m_con.Disconnect(); DBSync.DBSync.DB_for_Tangenta.m_DBTables.m_con.BatchOpen = false; return false; } } DBSync.DBSync.DB_for_Tangenta.m_DBTables.m_con.Disconnect(); DBSync.DBSync.DB_for_Tangenta.m_DBTables.m_con.BatchOpen = false; return true; } else { LogFile.Error.Show("WARNING:TangentaDB.cs:fs.Init_Unit_Table:Unit_table_Rows_Count != xUnitList.m_DefaltUnitList.Count!\r\nUnit_table_Rows_Count = " + Unit_table_Rows_Count.ToString() + " xCurrencyList.m_CurrencyList.Count = " + xUnitList.m_DefaltUnitList.Count.ToString()); return true; } } else { return false; } }