public static void UpdateElectricPower(string constructionCode, decimal power)
{
var electricPower = ConvertElectriPower(power);
var sql = string.Empty;
sql =
@"UPDATE ShikakuTableEntries
SET Value = '" + electricPower + @"'
WHERE
ConstructionCode = '" + constructionCode + @"'
AND ItemId = 41";
var dataBase = ShikakuTableItem.GetDatabase();
dataBase.ExecuteNonQuery(sql);
}
private static string ConvertElectriPower(decimal power)
{
var sql = string.Empty;
sql = @"SELECT ComboItems
FROM ShikakuTableNewItems
WHERE Id = 41";
var dataBase = ShikakuTableItem.GetDatabase();
var combo = dataBase.ExecuteScalar(sql);
if (combo == null)
{
throw new ApplicationException("Not found ShikakuTableItems.");
}
var items = new List <string>(combo.ToString().Split(';'));
items.Sort();
foreach (var item in items)
{
if (!item.Contains("KVA"))
{
continue;
}
decimal kva = 0;
if (!decimal.TryParse(item.Replace("KVA", ""), out kva))
{
continue;
}
if (kva < power)
{
continue;
}
return(item);
}
return(string.Empty);
}
public static List <ShikakuTableItem> GetAll()
{
var db = ShikakuTableItem.GetDatabase();
return(db.ExecuteQuery <ShikakuTableItem>("SELECT * FROM ShikakuTableOldItems"));
}
