public ShopCommentInfo GetShopComment(int shopId, int commentFlag = 1)
{
// if (commentFlag == 0) commentFlag = 1;
// const string sql = @"Select Top 1 U.UserName, U.UserId, U.Avatar, S.CommentFlag, S.CommentContent From ShopComment S Inner Join [User] U On S.UserId = U.UserID
// Where S.ShopID = @ShopID And S.CommentFlag = @CommentFlag
// Order By S.EntryDate Desc";
// var result = DefaultContext.Sql(sql)
// .Parameter("ShopID", shopId)
// .Parameter("CommentFlag", commentFlag)
// .QuerySingle<ShopCommentInfo>();
// if (result.IsNull())
// {
// result = DefaultContext.Sql(sql)
// .Parameter("ShopID", shopId)
// .Parameter("CommentFlag", 1)
// .QuerySingle<ShopCommentInfo>();
// }
var u = FakeUser.GetList().FirstOrDefault(r => r.UserId == commentFlag);
const string sql =
@"Select N'' As UserName, 18 As UserId, Null As Avatar, 5 As CommentFlag, ShortDesc As CommentContent From Shops Where ID = @ShopID";
var result = DefaultContext.Sql(sql)
.Parameter("ShopID", shopId)
.QuerySingle <ShopCommentInfo>();
result.UserName = u.UserName;
result.UserId = u.UserId;
return(result);
}
