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;
}
}
