//=========================== 商品類別新增 =========================== //
public static void fn商品類別新增(CProductCategory productCategory)
{
string sql = $"EXEC 商品類別新增 ";
sql += $"@{CProductCategoryKey.fCategoryName}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CProductCategoryKey.fCategoryId, productCategory.fCategoryId),
new SqlParameter(CProductCategoryKey.fCategoryName, productCategory.fCategoryName)
};
CDbManager.executeSql(sql, paras);
}
//=========================== 商品類別對照新增 =========================== //
public static void fn商品類別對照新增(CProduct product, CProductCategory productCategory)
{
string sql = $"EXEC 商品類別對照新增 ";
sql += $"@{CProductCompareKey.fProductId},";
sql += $"@{CProductCompareKey.fCategoryId}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CProductCompareKey.fProductId, product.fProductId),
new SqlParameter(CProductCompareKey.fCategoryId, productCategory.fCategoryId)
};
CDbManager.executeSql(sql, paras);
}