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