public static void fn物件更新(CProduct product)
{
string sql = $"EXEC 物件更新 ";
sql += $"@{CProdcutKey.fProductId},";
sql += $"@{CProdcutKey.fProductName},";
sql += $"@{CProdcutKey.fProductPrice},";
sql += $"@{CProdcutKey.fProductAddress},";
sql += $"@{CProdcutKey.fProductExplain},";
sql += $"@{CProdcutKey.fProductPhoto}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CProdcutKey.fProductId, product.fProductId),
new SqlParameter(CProdcutKey.fProductName, product.fProductName),
new SqlParameter(CProdcutKey.fProductPrice, product.fProductPrice),
new SqlParameter(CProdcutKey.fProductAddress, product.fProductAddress),
new SqlParameter(CProdcutKey.fProductExplain, product.fProductExplain),
new SqlParameter(CProdcutKey.fProductPhoto, (object)product.fProductPhoto ?? DBNull.Value) //可null
};
CDbManager.executeSql(sql, paras);
}
public static void fn物件刪除(CProduct product)
{
string sql = $"EXEC 物件刪除 ";
sql += $"@{CProdcutKey.fProductId}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CProdcutKey.fProductId, product.fProductId)
};
CDbManager.executeSql(sql, paras);
}
