Example #1
0
        //=========================== 商品圖片刪除 =========================== //
        public static void fn商品圖片刪除(CProductPicture productPicture)
        {
            string sql = $"EXEC 商品圖片刪除 ";

            sql += $"@{CProductPictureKey.fProductPictureId}";

            List <SqlParameter> paras = new List <SqlParameter>()
            {
                new SqlParameter(CProductPictureKey.fProductPictureId, productPicture.fProductPictureId),
            };

            CDbManager.executeSql(sql, paras);
        }
Example #2
0
        //=========================== 商品圖片新增 =========================== //
        public static void fn商品圖片新增(CProduct product, CProductPicture productPicture)
        {
            string sql = $"EXEC 商品圖片新增 ";

            sql += $"@{CProductPictureKey.fPicture},";
            sql += $"@{CProductPictureKey.fProductId}";

            List <SqlParameter> paras = new List <SqlParameter>()
            {
                new SqlParameter(CProductPictureKey.fPicture, productPicture.fPicture),
                new SqlParameter(CProductPictureKey.fProductId, product.fProductId)
            };

            CDbManager.executeSql(sql, paras);
        }