public void GetDicShopInfo()
{
var temp = SQLCon.Query <ShopDBInformation>("select * from ShopDBInformation");
foreach (ShopDBInformation pInfo in temp)
{
if (!Data_ShopInfo.DIC_SHOP_DB_INFO_OVERALL_INFO.ContainsKey(pInfo.IdentificationNumber))
{
Data_ShopInfo.DIC_SHOP_DB_INFO_OVERALL_INFO.Add(pInfo.IdentificationNumber, pInfo);
}
}
}
public int GetDBSize(string dbKind)
{
List <DBAllSize> tempSize = SQLCon.Query <DBAllSize>("select * from DBAllSize where DBName = ?", dbKind);
try
{
dbSize = tempSize[0].DB_Num;
}
catch
{
return(0);
}
return(dbSize);
}
public void UpdateShopData(string col, int val, string id)
{
var temp = SQLCon.Query <int>("update ShopDBInformation set " + col + " = " + val + " where IdentificationNumber = ?", id);
}
public void IncreaseData(string dbKind)
{
var updateMarks = SQLCon.Query <int>("UPDATE DBAllSize Set DB_Num = (DB_Num+1) WHERE DBName = ?", dbKind);
}