public static int AddFaceBook(int bizID, int pFaceBookID, string content, FaceBookType? fbType, int? rate, out string message) { int code = -1; if (fbType.HasValue && fbType.Value == FaceBookType.Eleooo) bizID = UserBLL.MainCompanyAccount.Id; if (!fbType.HasValue || bizID <= 0) { message = "业务参数错误!"; goto lbl_return; } var userID = AppContextBase.CurrentUserID; if (userID <= 0) { message = "你还没有登录,不能发表评论."; goto lbl_return; } DateTime? orderDate = null; if (fbType.Value == FaceBookType.OrderMeal) { orderDate = OrderMealBLL.GetUserLatestOrderDate(userID, bizID); if (!orderDate.HasValue) { message = "你还没在此商家订过餐,不能发表评论."; goto lbl_return; } } if (string.IsNullOrEmpty(content)) { message = "点评内容不能为空."; goto lbl_return; } new SysCompanyFaceBook { FaceBookBizID = bizID, FaceBookBizType = (int)fbType.Value, FaceBookMemberID = userID, FaceBookDate = DateTime.Now, FaceBookMemo = content, FaceBookRate = rate, LatestOrderDate = orderDate, PBizID = pFaceBookID, IsRead = true }.Save( ); message = "点评成功"; code = 0; lbl_return: return code; }
protected void Page_Load(object sender, EventArgs e) { fbType = Formatter.ToEnum<FaceBookType>(Request["fbType"], FaceBookType.OrderMeal); var bizID = Utilities.ToInt(Request["bizID"]); IsViewMyFaceBook = Request["showMe"] == "true"; isLogin = AppContext.Context.CurrentSubSys != SubSystem.ALL; UserId = AppContext.CurrentUserID; if (fbType == FaceBookType.OrderMeal) { rpFbOrderMeal.Visible = true; rpFbOrderMeal.PageIndex = Utilities.ToInt(Request["pageIndex"]); int beginRate = Utilities.ToInt(Request["beginRate"]); int endRate = Utilities.ToInt(Request["endRate"]); var query = DB.Select(Utilities.GetTableColumns(SysCompanyFaceBook.Schema), SysMember.Columns.MemberPhoneNumber, SysMember.Columns.MemberFullname) .From<SysCompanyFaceBook>( ) .InnerJoin(SysMember.IdColumn, SysCompanyFaceBook.FaceBookMemberIDColumn) .Where(SysCompanyFaceBook.FaceBookBizIDColumn).IsEqualTo(bizID) .And(SysCompanyFaceBook.FaceBookBizTypeColumn).IsEqualTo((int)fbType) .And(SysCompanyFaceBook.FaceBookRateColumn).IsBetweenAnd(beginRate, endRate) .OrderDesc(SysCompanyFaceBook.IdColumn.QualifiedName); rpFbOrderMeal.QuerySource = query; rpFbOrderMeal.DataBind( ); } else if (fbType == FaceBookType.Eleooo) { rpFbEleooo.Visible = true; var pFaceBookID = Utilities.ToInt(Request["pBiz"]); if (pFaceBookID == 0) { rpFbEleooo.PageIndex = Utilities.ToInt(Request["pageIndex"]); var query = DB.Select(Utilities.GetTableColumns(SysCompanyFaceBook.Schema), SysMember.Columns.MemberPhoneNumber, SysMember.Columns.MemberFullname) .From<SysCompanyFaceBook>( ) .InnerJoin(SysMember.IdColumn, SysCompanyFaceBook.FaceBookMemberIDColumn) .Where(SysCompanyFaceBook.FaceBookBizIDColumn).IsEqualTo(UserBLL.MainCompanyAccount.Id) .And(SysCompanyFaceBook.FaceBookBizTypeColumn).IsEqualTo((int)fbType) .And(SysCompanyFaceBook.PBizIDColumn).IsEqualTo(0) .OrderDesc(SysCompanyFaceBook.TopDateColumn.QualifiedName, SysCompanyFaceBook.IdColumn.QualifiedName); if (IsViewMyFaceBook) query.And(SysCompanyFaceBook.FaceBookMemberIDColumn).IsEqualTo(AppContext.CurrentUserID); rpFbEleooo.QuerySource = query; } else { rpFbEleooo.AllowPaging = false; rpFbEleooo.HeaderTemplate = null; rpFbEleooo.FooterTemplate = null; var query = DB.Select(Utilities.GetTableColumns(SysCompanyFaceBook.Schema), SysMember.Columns.MemberPhoneNumber, SysMember.Columns.MemberFullname) .From<SysCompanyFaceBook>( ) .InnerJoin(SysMember.IdColumn, SysCompanyFaceBook.FaceBookMemberIDColumn) .Where(SysCompanyFaceBook.IdColumn).IsEqualTo(pFaceBookID); rpFbEleooo.QuerySource = query; } rpFbEleooo.DataBind( ); } }