protected override void Render(HtmlTextWriter writer)
{
if (this.Activity != null)
{
PrizeQuery page = new PrizeQuery {
ActivityId = this.Activity.ActivityId,
SortOrder = SortAction.Desc,
SortBy = "PrizeTime"
};
IOrderedEnumerable <PrizeRecordInfo> source = from a in VshopBrowser.GetPrizeList(page)
orderby a.PrizeTime descending
select a;
StringBuilder builder = new StringBuilder();
if ((source != null) && (source.Count <PrizeRecordInfo>() > 0))
{
foreach (PrizeRecordInfo info in source)
{
if (!string.IsNullOrEmpty(info.CellPhone) && !string.IsNullOrEmpty(info.RealName))
{
builder.AppendFormat("<p>{0} {1} {2}</p>", info.Prizelevel, this.ShowCellPhone(info.CellPhone), info.RealName);
}
}
writer.Write(builder.ToString());
}
else
{
builder.AppendFormat("<p>暂无获奖名单！</p>", new object[0]);
}
}
}
public PageModel <ViewUserAwardRecordsInfo> GetAllAwardRecordsByActityId(PrizeQuery page)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendFormat("1=1");
if (page.Status > 0)
{
stringBuilder.AppendFormat(" and Status ={0}", page.Status);
}
if (page.ActivityId > 0)
{
stringBuilder.AppendFormat(" and ActivityId ={0}", page.ActivityId);
}
if (page.ActivityType != 0)
{
stringBuilder.AppendFormat(" and ActivityType={0}", (int)page.ActivityType);
}
if (!string.IsNullOrEmpty(page.UserName))
{
stringBuilder.AppendFormat(" and UserName='******'", page.UserName);
}
if (page.AwardGrade > 0)
{
stringBuilder.AppendFormat(" and AwardGrade ={0}", page.AwardGrade);
}
if (page.IsDel)
{
stringBuilder.AppendFormat(" and IsDel=0");
}
return(DataHelper.PagingByRownumber <ViewUserAwardRecordsInfo>(page.PageIndex, page.PageSize, page.SortBy, page.SortOrder, page.IsCount, "vw_Hishop_UserAwardRecords", "ID", stringBuilder.ToString(), "*"));
}
public void GetList(HttpContext context)
{
int num = 1;
int num2 = 10;
num = base.GetIntParam(context, "page", false).Value;
if (num < 1)
{
num = 1;
}
num2 = base.GetIntParam(context, "rows", false).Value;
if (num2 < 1)
{
num2 = 10;
}
PrizeQuery prizeQuery = new PrizeQuery();
prizeQuery.UserName = context.Request["UserName"];
prizeQuery.ActivityId = base.GetIntParam(context, "ActivityId", false).Value;
prizeQuery.Status = base.GetIntParam(context, "Status", false).Value;
prizeQuery.AwardGrade = base.GetIntParam(context, "AwardGrade", false).Value;
prizeQuery.PageIndex = num;
prizeQuery.PageSize = num2;
prizeQuery.SortBy = "CreateDate";
prizeQuery.SortOrder = SortAction.Desc;
DataGridViewModel <Dictionary <string, object> > dataList = this.GetDataList(prizeQuery);
string s = base.SerializeObjectToJson(dataList);
context.Response.Write(s);
context.Response.End();
}
protected override void Render(HtmlTextWriter writer)
{
StringBuilder stringBuilder = new StringBuilder();
if (this.Activity != null)
{
PrizeQuery prizeQuery = new PrizeQuery();
prizeQuery.ActivityId = this.Activity.ActivityId;
prizeQuery.SortOrder = SortAction.Desc;
prizeQuery.SortBy = "PrizeTime";
IOrderedEnumerable <PrizeRecordInfo> orderedEnumerable = from a in VshopBrowser.GetPrizeList(prizeQuery)
orderby a.PrizeTime descending
select a;
if (orderedEnumerable != null && orderedEnumerable.Count() > 0)
{
foreach (PrizeRecordInfo item in orderedEnumerable)
{
if (!string.IsNullOrEmpty(item.CellPhone) && !string.IsNullOrEmpty(item.RealName))
{
stringBuilder.AppendFormat("<p>{0} {1} {2}</p>", item.Prizelevel, this.ShowCellPhone(item.CellPhone), item.RealName);
}
}
}
else
{
stringBuilder.AppendFormat("<p>暂无获奖名单！</p>");
}
}
else if (this.ActivityId > 0)
{
PrizeQuery prizeQuery2 = new PrizeQuery();
prizeQuery2.ActivityId = this.ActivityId;
prizeQuery2.PageIndex = 1;
prizeQuery2.PageSize = 20;
prizeQuery2.SortBy = "CreateDate";
prizeQuery2.SortOrder = SortAction.Desc;
prizeQuery2.IsDel = true;
IEnumerable <ViewUserAwardRecordsInfo> models = ActivityHelper.GetAllAwardRecordsByActityId(prizeQuery2).Models;
if (models != null && models.Count() > 0)
{
foreach (ViewUserAwardRecordsInfo item2 in models)
{
if (!string.IsNullOrEmpty(item2.UserName))
{
stringBuilder.AppendFormat("<p>{0} {1}</p>", this.ShowUserName(item2.UserName), this.CapitalLetters(item2.AwardGrade) + "等奖");
}
}
}
else
{
stringBuilder.AppendFormat("<p>暂无获奖名单！</p>");
}
}
writer.Write(stringBuilder.ToString());
}
protected void BindPrizeList()
{
PrizeQuery page = new PrizeQuery {
ActivityId = this.activeid
};
List <PrizeRecordInfo> prizeList = VShopHelper.GetPrizeList(page);
if ((prizeList != null) && (prizeList.Count > 0))
{
this.LitTitle.Text = prizeList[0].ActivityName;
}
this.rpMaterial.DataSource = prizeList;
this.rpMaterial.DataBind();
}
protected void BindPrizeList()
{
PrizeQuery prizeQuery = new PrizeQuery();
prizeQuery.ActivityId = this.activeid;
List <PrizeRecordInfo> prizeList = VShopHelper.GetPrizeList(prizeQuery);
if (prizeList != null && prizeList.Count > 0)
{
this.LitTitle.Text = prizeList[0].ActivityName;
}
this.nodata = (prizeList.Count == 0);
this.rpMaterial.DataSource = prizeList;
this.rpMaterial.DataBind();
}
public List <PrizeRecordInfo> GetPrizeListEx(PrizeQuery page)
{
StringBuilder builder = new StringBuilder();
builder.Append("select * from Vshop_PrizeRecord ");
if (page.ActivityId != 0)
{
builder.AppendFormat(" where ActivityId={0}", page.ActivityId);
}
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
return(ReaderConvert.ReaderToList <PrizeRecordInfo>(reader) as List <PrizeRecordInfo>);
}
}
public List <PrizeRecordInfo> GetPrizeList(PrizeQuery page)
{
StringBuilder builder = new StringBuilder();
builder.Append("select ActivityName=(select ActivityName from Vshop_LotteryActivity a where a.ActivityId=b.ActivityId),");
builder.Append("UserName=(select UserName from aspnet_Members c where c.UserId=b.UserId),");
builder.Append(" b.* from Vshop_PrizeRecord b");
if (page.ActivityId != 0)
{
builder.AppendFormat(" where b.ActivityId={0}", page.ActivityId);
}
builder.AppendFormat(" and b.IsPrize=1 order by b.PrizeTime desc", new object[0]);
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
return(ReaderConvert.ReaderToList <PrizeRecordInfo>(reader) as List <PrizeRecordInfo>);
}
}
protected override void Render(HtmlTextWriter writer)
{
if (this.Activity != null)
{
PrizeQuery page = new PrizeQuery {
ActivityId = this.Activity.ActivityId,
SortOrder = SortAction.Desc,
SortBy = "PrizeTime"
};
IOrderedEnumerable <PrizeRecordInfo> source = from a in VshopBrowser.GetPrizeList(page)
orderby a.PrizeTime descending
select a;
StringBuilder builder = new StringBuilder();
if ((source != null) && (source.Count <PrizeRecordInfo>() > 0))
{
builder.Append("<table class=\"tabstyle\" width=\"100%\" border=\"0\" cellspacing=\"\" cellpadding=\"\">");
//<td style=\"text-align:center; width:30%\">获取人</td>
builder.Append("<tbody><tr><th>电话</th><th>奖项</th></tr>");
int i = 1;
foreach (PrizeRecordInfo info in source)
{
if (i <= 5)
{
i++;
if (!string.IsNullOrEmpty(info.CellPhone) && !string.IsNullOrEmpty(info.RealName))
{
builder.Append("<tr>");
//builder.AppendFormat("<td style=\"text-align:center; width:30%\">{0}<td>", info.RealName);
builder.AppendFormat("<td style=\"text-align:center; width:50%\">{0}</td>", this.ShowCellPhone(info.CellPhone));
builder.AppendFormat("<td style=\"text-align:center; width:50%\">{0}</td>", info.Prizelevel);
builder.Append("</tr>");
}
}
}
builder.Append("</tbody></table>");
writer.Write(builder.ToString());
}
else
{
builder.AppendFormat("<p>暂无获奖名单！</p>", new object[0]);
}
}
}
private DataGridViewModel <Dictionary <string, object> > GetDataList(PrizeQuery query)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
if (query != null)
{
PageModel <ViewUserAwardRecordsInfo> allAwardRecordsByActityId = ActivityHelper.GetAllAwardRecordsByActityId(query);
dataGridViewModel.rows = new List <Dictionary <string, object> >();
dataGridViewModel.total = allAwardRecordsByActityId.Total;
foreach (ViewUserAwardRecordsInfo model in allAwardRecordsByActityId.Models)
{
Dictionary <string, object> dictionary = model.ToDictionary();
dictionary.Add("AwardGradeText", this.GetWeekCN(model.AwardGrade));
dictionary.Add("StatusText", (model.Status == 2) ? "已领奖" : "未领奖");
dataGridViewModel.rows.Add(dictionary);
}
}
return(dataGridViewModel);
}
public List <PrizeRecordInfo> GetPrizeList(PrizeQuery page)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select ActivityName=(select ActivityName from Vshop_LotteryActivity a where a.ActivityId=b.ActivityId),");
stringBuilder.Append("UserName=(select UserName from aspnet_Members c where c.UserId=b.UserId),");
stringBuilder.Append(" b.* from Vshop_PrizeRecord b");
if (page.ActivityId != 0)
{
stringBuilder.AppendFormat(" where b.ActivityId={0}", page.ActivityId);
}
stringBuilder.AppendFormat(" and b.IsPrize=1 order by b.PrizeTime desc");
DbCommand sqlStringCommand = base.database.GetSqlStringCommand(stringBuilder.ToString());
List <PrizeRecordInfo> result = null;
using (IDataReader objReader = base.database.ExecuteReader(sqlStringCommand))
{
result = (DataHelper.ReaderToList <PrizeRecordInfo>(objReader) as List <PrizeRecordInfo>);
}
return(result);
}
public static List <PrizeRecordInfo> GetPrizeList(PrizeQuery page)
{
return(new LotteryActivityDao().GetPrizeList(page));
}
public static List <PrizeRecordInfo> GetPrizeList(PrizeQuery page)
{
return(new PrizeRecordDao().GetPrizeList(page));
}
protected override void AttachChildControls()
{
if (!int.TryParse(this.Page.Request.QueryString["activityid"], out this.activityid))
{
base.GotoResourceNotFound("");
}
//this.bgimg = (HtmlImage) this.FindControl("bgimg");
this.litActivityDesc = (Literal)this.FindControl("litActivityDesc");
//this.litStartDate = (Literal) this.FindControl("litStartDate");
//this.litEndDate = (Literal) this.FindControl("litEndDate");
this.litPrizeNames = (Common_PrizeNames)this.FindControl("litPrizeNames");
this.litPrizeUsers = (Common_PrizeUsers)this.FindControl("litPrizeUsers");
this.litSurplusNum = (Literal)this.FindControl("litSurplusNum");
this.litNum = (Literal)this.FindControl("litNum");
this.litimage = (Literal)this.FindControl("litimage");
LotteryActivityInfo lotteryActivity = VshopBrowser.GetLotteryActivity(this.activityid);
if (lotteryActivity == null)
{
base.GotoResourceNotFound("");
}
if (MemberProcessor.GetCurrentMember() == null)
{
MemberInfo member = new MemberInfo();
string generateId = Globals.GetGenerateId();
member.GradeId = MemberProcessor.GetDefaultMemberGrade();
member.UserName = "";
member.OpenId = "";
member.CreateDate = DateTime.Now;
member.SessionId = generateId;
member.SessionEndTime = DateTime.Now;
MemberProcessor.CreateMember(member);
member = MemberProcessor.GetMember(generateId);
HttpCookie cookie = new HttpCookie("Vshop-Member")
{
Value = member.UserId.ToString(),
Expires = DateTime.Now.AddYears(10)
};
HttpContext.Current.Response.Cookies.Add(cookie);
}
PageTitle.AddSiteNameTitle(lotteryActivity.ActivityName);
litimage.Text = Globals.HostPath(HttpContext.Current.Request.Url) + lotteryActivity.ActivityPic;
//this.litStartDate.Text = lotteryActivity.StartTime.ToString("yyyy年MM月dd日 HH:mm:ss");
//this.litEndDate.Text = lotteryActivity.EndTime.ToString("yyyy年MM月dd日 HH:mm:ss");
//if (lotteryActivity.PrizeSettingList.Count > 3)
//{
// this.bgimg.Src = Globals.GetVshopSkinPath(null) + "/images/process/panpic2.png";
//}
if ((lotteryActivity.StartTime < DateTime.Now) && (DateTime.Now < lotteryActivity.EndTime))
{
this.litActivityDesc.Text = lotteryActivity.ActivityDesc;
this.litPrizeNames.Activity = lotteryActivity;
this.litPrizeUsers.Activity = lotteryActivity;
int userPrizeCount = VshopBrowser.GetUserPrizeCount(this.activityid);
this.litActivityDesc.Text = this.litActivityDesc.Text;
//剩余次数提示
this.litSurplusNum.Text = string.Format("您一共有{0}次参与机会，目前还剩<b class=\"sign\">{1}</b>次。", lotteryActivity.MaxNum, lotteryActivity.MaxNum - userPrizeCount);
PrizeQuery page = new PrizeQuery
{
ActivityId = this.activityid
};
System.Collections.Generic.List <PrizeRecordInfo> prizeList = VShopHelper.GetPrizeListEx(page);
if (prizeList != null && prizeList.Count > 0)
{
this.litNum.Text = prizeList.Count.ToString();
}
else
{
this.litNum.Text = "0";
}
//前台JS刷的营销数据
if (!string.IsNullOrEmpty(lotteryActivity.GradeIds))
{
this.litNum.Text = lotteryActivity.GradeIds;
}
}
else
{
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "myscript", "<script>$(function(){alert_h(\"活动还未开始或者已经结束！\");});</script>");
}
}
public static PageModel <ViewUserAwardRecordsInfo> GetAllAwardRecordsByActityId(PrizeQuery query)
{
return(new ActivityDao().GetAllAwardRecordsByActityId(query));
}
