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( );
}
}
