using?System;
using?System.Data;
using?System.Collections;
using?System.Data.SqlClient;


namespace?ST_GROUP.FlowerPrearrange
{
????///?

????///?ST_Flower?description?for?Flower。
????///?

????public?class?ST_Flower?:?ST_base
????{
????????//public?DataSet?FlowerName（string?TypeName）
????????//{
????????//????//查找鮮花類型
????????//????string?FlowerName?=?“SELECT?ST_Name?FROM?ST_FlowerType“;
????????//????DataSet?ds?=?new?DataSet（）;
????????//????ds?=?ST_ExecuteSql4Ds（FlowerName）;
????????//????return?ds;
????????//}
????????///?

????????///?鮮花的點擊率
????????///?

????????///?
????????public?void?FlowerHits（int?FlowerId）
????????{
????????????string?SQLHits?=?“Update?ST_Flower?set?ST_hits=ST_hits+1?Where?ST_id=?“?+?FlowerId;
????????????try
????????????{
????????????????ST_ExecuteSql4Ds（SQLHits）;
????????????}
????????????catch
????????????{
????????????????throw?new?Exception（“點擊率更新失敗！“）;
????????????}
????????}
????????///?

????????///?添加用戶信息
????????///?

????????///?
????????///?
????????public?int?InsertComment（MODEL.MDLST_CommentInfo?CommentInfo）
????????{
????????????string?SQLInsert?=?“INSERT?INTO?ST_Comment（ST_FlowerIdST_UserNameST_EmailST_CaptionST_ContentST_PublishDate）VALUES（@ST_FlowerId@ST_UserName@ST_Email@ST_Caption@ST_Content@ST_PublishDate）“;
????????????SqlParameter[]?parm?=?new?SqlParameter[]?{?new?SqlParameter（“@ST_FlowerId“?CommentInfo.ST_FLOWERID）?new?SqlParameter（“@ST_UserName“?CommentInfo.ST_USERNAME）?new?SqlParameter（“@ST_Email“?CommentInfo.ST_EMAIL）?new?SqlParameter（“@ST_Caption“?CommentInfo.ST_CAPTION）?new?SqlParameter（“@ST_Content“?CommentInfo.ST_CONTENT）?new?SqlParameter（“@ST_PublishDate“CommentInfo.ST_PUBLISHDATE）?};
????????????return?RunProcGetData（SQLInsertparm）;
????????}
????????///?

????????///?得到鮮花的評論信息
????????///?

????????///?
????????///?
????????public?DataSet?CommentByFlowerId（int?FlowerId）
????????{
????????????DataSet?ds;//錯誤，sql語句！
????????????string?SQLComment?=?“select?*?from?ST_Comment?where?ST_Flowerid=“?+?FlowerId;
????????????ds?=?ST_ExecuteSql4Ds（SQLComment）;
????????????return?ds;
????????}
????????///?

????????///?得到鮮花的詳細信息
????????///?

????????///?
????????///?
????????public?DataSet?FlowerDetail（int?FlowerId）
????????{
????????????try
????????????{
????????????????string?SQLDetail?=?“SELECT?ST_FlowerType.ST_Name?AS?ST_FlowerTypeNameST_Flower.ST_idST_Flower.ST_nameST_priceST_typeST_DescriptionST_discountST_hitsST_statusST_salesST_image=case?when（not?ST_Cover?is?null）?then?‘?‘?else?‘?