//=========================== 商品類別新增 =========================== // 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); }