protected void ConfirmSend_Click(object sender, EventArgs e)
{
if (this.txtLogID.Value == "")
{
this.ShowMsg("LogID为空，请检查！", false);
}
else
{
int result = 0;
if (!int.TryParse(this.txtDeliverID.Value.Trim(), out result) || (this.txtDeliverStaus.Value != "2"))
{
this.ShowMsg("当前状态下不允许操作！", false);
}
else
{
PrizesDeliveQuery query = new PrizesDeliveQuery {
Status = 3,
ReceiveTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
LogId = this.txtLogID.Value,
Id = result
};
if (GameHelper.UpdatePrizesDelivery(query))
{
this.ShowMsg("收货在确认成功！", true);
this.BindData();
}
else
{
this.ShowMsg("收货在确认成功失败", false);
}
}
}
}
protected void AddrBtn_Click(object sender, EventArgs e)
{
if (this.txtLogID.Value == "")
{
this.ShowMsg("LogID为空，请检查！", false);
}
else
{
string str = this.txtPrizeReceiver.Text.Trim();
string str2 = this.txtPrizeTel.Text.Trim();
string str3 = this.txtPrizeAddress.Text.Trim();
string s = this.HideRegion.Value.Trim();
if (str.Length < 2)
{
this.ShowMsg("收货人不能为空", false);
}
else if (str2.Length < 8)
{
this.ShowMsg("联系电话不正确", false);
}
else if (str3.Length < 6)
{
this.ShowMsg("地址不够详细", false);
}
else
{
int result = 0;
if (!int.TryParse(s, out result))
{
this.ShowMsg("省市区未选择", false);
}
else
{
s = RegionHelper.GetFullPath(result);
PrizesDeliveQuery query = new PrizesDeliveQuery {
Status = 1,
ReggionPath = s,
Address = str3,
Tel = str2,
Receiver = str,
LogId = this.txtLogID.Value
};
int num2 = 0;
int.TryParse(this.txtDeliverID.Value.Trim(), out num2);
query.Id = num2;
if (GameHelper.UpdatePrizesDelivery(query))
{
this.ShowMsg("保存收货人信息成功！", true);
this.BindData();
}
else
{
this.ShowMsg("保存信息失败", false);
}
}
}
}
}
protected override void AttachChildControls()
{
int num;
int num2;
PageTitle.AddSiteNameTitle("我的优惠券");
this.txtTotal = (HtmlInputHidden)this.FindControl("txtTotal");
this.txtShowTabNum = (HtmlInputHidden)this.FindControl("txtShowTabNum");
this.rptActivity = (VshopTemplatedRepeater)this.FindControl("rptActivity");
this.txtShowTabNum.Value = "0";
PrizesDeliveQuery query = new PrizesDeliveQuery();
if (!int.TryParse(this.Page.Request.QueryString["page"], out num))
{
num = 1;
}
if (!int.TryParse(this.Page.Request.QueryString["size"], out num2))
{
num2 = 20;
}
MemberCouponsSearch search = new MemberCouponsSearch {
CouponName = "",
Status = "0",
MemberId = Globals.GetCurrentMemberUserId(),
IsCount = true,
PageIndex = num,
PageSize = num2,
SortBy = "CouponId",
SortOrder = SortAction.Desc
};
int total = 0;
DataTable memberCoupons = CouponHelper.GetMemberCoupons(search, ref total);
if ((memberCoupons != null) && (memberCoupons.Rows.Count > 0))
{
memberCoupons.Columns.Add("useConditon");
memberCoupons.Columns.Add("sStatus");
for (int i = 0; i < memberCoupons.Rows.Count; i++)
{
decimal num5 = decimal.Parse(memberCoupons.Rows[i]["ConditionValue"].ToString());
if (num5 == 0M)
{
memberCoupons.Rows[i]["useConditon"] = "无消费限制";
}
else
{
memberCoupons.Rows[i]["useConditon"] = "满" + num5.ToString("F2") + "可使用";
}
memberCoupons.Rows[i]["sStatus"] = (int.Parse(memberCoupons.Rows[i]["Status"].ToString()) == 0) ? "已领用" : "已使用";
}
}
MemberInfo currentMember = MemberProcessor.GetCurrentMember();
this.rptActivity.DataSource = memberCoupons;
this.rptActivity.DataBind();
this.txtTotal.SetWhenIsNotNull(total.ToString());
}
protected void SendBtn_Click(object sender, EventArgs e)
{
if (this.txtLogID.Value == "")
{
this.ShowMsg("LogID为空，请检查！", false);
}
else
{
int result = 0;
if ((!int.TryParse(this.txtDeliverID.Value.Trim(), out result) || (this.txtDeliverStaus.Value == "")) || ((this.txtDeliverStaus.Value == "3") || (this.txtDeliverStaus.Value == "0")))
{
this.ShowMsg("当前状态下不允许操作！", false);
}
else
{
string str = this.txtDeliveryTime.Value.Trim();
string str2 = this.txtPrizeExpressName.Text.Trim();
string str3 = this.txtPrizeCourierNumber.Text.Trim();
if (str2.Length < 2)
{
this.ShowMsg("快递公司名称有误！", false);
}
else if (str3.Length < 6)
{
this.ShowMsg("快递单号不正确！", false);
}
else
{
PrizesDeliveQuery query = new PrizesDeliveQuery
{
Status = 2,
ExpressName = str2,
CourierNumber = str3
};
if (str == "")
{
query.DeliveryTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
query.LogId = this.txtLogID.Value;
query.Id = result;
if (GameHelper.UpdatePrizesDelivery(query))
{
this.ShowMsg("奖品发货信息保存成功！", true);
this.BindData();
}
else
{
this.ShowMsg("奖品发货信息保存失败", false);
}
}
}
}
}
public DbQueryResult GetAllPrizesDeliveryList(PrizesDeliveQuery query, string ExtendLimits = "", string selectFields = "*")
{
StringBuilder builder = new StringBuilder();
builder.Append(" 1=1 ");
if (query.Status >= 0)
{
builder.Append(" AND ");
builder.AppendFormat("status = {0}", query.Status);
}
if (!string.IsNullOrEmpty(query.ProductName))
{
builder.Append(" AND ");
builder.AppendFormat(" ProductName like '%{0}%'", DataHelper.CleanSearchString(query.ProductName));
}
if (!string.IsNullOrEmpty(query.Pid))
{
builder.Append(" AND ");
builder.AppendFormat(" Pid = '{0}'", query.Pid);
}
if (!string.IsNullOrEmpty(query.ActivityTitle))
{
builder.Append(" AND ");
builder.AppendFormat(" Title like '%{0}%'", DataHelper.CleanSearchString(query.ActivityTitle));
}
if (!string.IsNullOrEmpty(query.Receiver))
{
builder.Append(" AND ");
builder.AppendFormat(" Receiver = '{0}'", DataHelper.CleanSearchString(query.Receiver));
}
if (!string.IsNullOrEmpty(query.ReggionId))
{
builder.Append(" AND ");
builder.AppendFormat(" ',' + ReggionPath + ',' like '%,{0},%'", DataHelper.CleanSearchString(query.ReggionId));
}
DateTime now = DateTime.Now;
if (DateTime.TryParse(query.StartDate, out now))
{
builder.Append(" AND ");
builder.AppendFormat(" WinTime>='{0}'", now.ToString("yyyy-MM-dd 00:00:00"));
}
if (DateTime.TryParse(query.EndDate, out now))
{
builder.Append(" AND ");
builder.AppendFormat(" WinTime<='{0}'", now.ToString("yyyy-MM-dd 23:59:59"));
}
if (ExtendLimits != "")
{
builder.Append(ExtendLimits);
}
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Vshop_ProductPrizeLIst_WithDelievelyInfo", "WinTime", (builder.Length > 0) ? builder.ToString() : null, selectFields));
}
protected void Page_Load(object sender, EventArgs e)
{
this.Did = base.Request.QueryString["LogId"];
if (!string.IsNullOrEmpty(this.Did))
{
PrizesDeliveQuery query = new PrizesDeliveQuery {
Status = -1,
SortBy = "LogId",
LogId = this.Did,
PageIndex = 1,
PageSize = 2,
PrizeType = -1
};
DataTable data = (DataTable)GameHelper.GetPrizesDeliveryList(query, "", "*").Data;
if ((data != null) && (data.Rows.Count > 0))
{
DataRow row = data.Rows[0];
this.txtStatus.Text = GameHelper.GetPrizesDeliveStatus(this.Dbnull2str(row["status"]));
this.txtCourierNumber.Text = this.Dbnull2str(row["CourierNumber"]);
this.txtExpressName.Text = this.Dbnull2str(row["ExpressName"]);
this.txtTel.Text = this.Dbnull2str(row["Tel"]);
this.txtDTel.Text = this.Dbnull2str(row["Tel"]);
this.txtReceiver.Text = this.Dbnull2str(row["Receiver"]);
this.txtDeliever.Text = this.Dbnull2str(row["Receiver"]);
if (this.txtTel.Text == "")
{
this.txtTel.Text = this.Dbnull2str(row["CellPhone"]);
this.txtDTel.Text = this.Dbnull2str(row["CellPhone"]);
}
if (this.txtDeliever.Text == "")
{
this.txtReceiver.Text = this.Dbnull2str(row["RealName"]);
this.txtDeliever.Text = this.Dbnull2str(row["RealName"]);
}
this.txtAddress.Text = this.Dbnull2str(row["Address"]);
this.txtRegionName.Text = this.Dbnull2str(row["ReggionPath"]);
if (this.txtRegionName.Text.Trim() != "")
{
string[] strArray = this.txtRegionName.Text.Trim().Split(new char[] { ',' });
this.txtRegionName.Text = RegionHelper.GetFullRegion(int.Parse(strArray[strArray.Length - 1]), ",");
}
this.txtPlayTime.Text = ((DateTime)row["PlayTime"]).ToString("yyyy-MM-dd HH:mm:ss");
this.txtPrizeGrade.Text = GameHelper.GetPrizeGradeName(this.Dbnull2str(row["PrizeGrade"]));
this.txtGameTitle.Text = row["GameTitle"].ToString();
this.txtGameType.Text = GameHelper.GetGameTypeName(row["GameType"].ToString());
this.txtProductName.Text = row["ProductName"].ToString();
this.txtImage.ImageUrl = (row["ThumbnailUrl100"] == DBNull.Value) ? "/utility/pics/none.gif" : row["ThumbnailUrl100"].ToString();
}
}
}
public bool GetPrizesDeliveInfo(PrizesDeliveQuery query, out string GameTitle, out int UserId)
{
GameTitle = "";
UserId = 0;
DbCommand sqlStringCommand = this._database.GetSqlStringCommand("select top 1 GameTitle, UserId from [vw_Hishop_PrizesDeliveryRecord] where LogId=" + query.LogId.ToString() + " and ID=" + query.Id.ToString());
DataTable table = this._database.ExecuteDataSet(sqlStringCommand).Tables[0];
if ((table != null) && (table.Rows.Count > 0))
{
GameTitle = Convert.ToString(table.Rows[0]["GameTitle"]);
UserId = Convert.ToInt32(table.Rows[0]["UserId"]);
return(true);
}
return(false);
}
protected void SendBtn_Click(object sender, System.EventArgs e)
{
if (this.txtLogID.Value == "")
{
this.ShowMsg("LogID为空，请检查！", false);
return;
}
int id = 0;
if (!int.TryParse(this.txtDeliverID.Value.Trim(), out id) || this.txtDeliverStaus.Value == "" || this.txtDeliverStaus.Value == "3" || this.txtDeliverStaus.Value == "0")
{
this.ShowMsg("当前状态下不允许操作！", false);
return;
}
string a = this.txtDeliveryTime.Value.Trim();
string text = this.txtPrizeExpressName.Text.Trim();
string text2 = this.txtPrizeCourierNumber.Text.Trim();
if (text.Length < 2)
{
this.ShowMsg("快递公司名称有误！", false);
return;
}
if (text2.Length < 6)
{
this.ShowMsg("快递单号不正确！", false);
return;
}
PrizesDeliveQuery prizesDeliveQuery = new PrizesDeliveQuery();
prizesDeliveQuery.Status = 2;
prizesDeliveQuery.ExpressName = text;
prizesDeliveQuery.CourierNumber = text2;
if (a == "")
{
prizesDeliveQuery.DeliveryTime = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
prizesDeliveQuery.LogId = this.txtLogID.Value;
prizesDeliveQuery.Id = id;
if (GameHelper.UpdatePrizesDelivery(prizesDeliveQuery))
{
this.ShowMsg("奖品发货信息保存成功！", true);
this.BindData();
return;
}
this.ShowMsg("奖品发货信息保存失败", false);
}
private void BindData()
{
PrizesDeliveQuery entity = new PrizesDeliveQuery
{
Status = int.Parse(this.ShowTabNum) - 1,
StartDate = this.StartDate,
EndDate = this.EndDate,
SortBy = "WinTime",
PrizeType = 2,
SortOrder = SortAction.Desc,
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
ProductName = this.ProductName,
Receiver = this.Receiver,
ReggionId = this.AddrReggion,
ActivityTitle = this.ActitivyTitle
};
Globals.EntityCoding(entity, true);
DbQueryResult result = GameHelper.GetAllPrizesDeliveryList(entity, "", "*");
this.reDistributor.DataSource = result.Data;
this.reDistributor.DataBind();
this.pager.TotalRecords = result.TotalRecords;
this.bidExpress();
DataTable prizesDeliveryNum = GameHelper.GetPrizesDeliveryNum();
int num = 0;
int num2 = 0;
int num3 = 0;
int num4 = 0;
int num5 = 0;
if ((prizesDeliveryNum != null) && (prizesDeliveryNum.Rows.Count > 0))
{
num = int.Parse(prizesDeliveryNum.Rows[0]["st0"].ToString());
num2 = int.Parse(prizesDeliveryNum.Rows[0]["st1"].ToString());
num3 = int.Parse(prizesDeliveryNum.Rows[0]["st2"].ToString());
num4 = int.Parse(prizesDeliveryNum.Rows[0]["st3"].ToString());
num5 = ((num + num2) + num3) + num4;
}
this.ListAll.Text = "所有奖品(" + num5 + ")";
this.ListWaitAddr.Text = "待填写收货地址(" + num + ")";
this.ListWaitSend.Text = "待发货(" + num2 + ")";
this.ListHasSend.Text = "已发货(" + num3 + ")";
this.ListHasReceive.Text = "已收货(" + num4 + ")";
}
private void BindData()
{
PrizesDeliveQuery prizesDeliveQuery = new PrizesDeliveQuery();
prizesDeliveQuery.Status = int.Parse(this.ShowTabNum) - 1;
prizesDeliveQuery.StartDate = this.StartDate;
prizesDeliveQuery.EndDate = this.EndDate;
prizesDeliveQuery.SortBy = "WinTime";
prizesDeliveQuery.PrizeType = 2;
prizesDeliveQuery.SortOrder = SortAction.Desc;
prizesDeliveQuery.PageIndex = this.pager.PageIndex;
prizesDeliveQuery.PageSize = this.pager.PageSize;
prizesDeliveQuery.ProductName = this.ProductName;
prizesDeliveQuery.Receiver = this.Receiver;
prizesDeliveQuery.ReggionId = this.AddrReggion;
prizesDeliveQuery.ActivityTitle = this.ActitivyTitle;
Globals.EntityCoding(prizesDeliveQuery, true);
DbQueryResult allPrizesDeliveryList = GameHelper.GetAllPrizesDeliveryList(prizesDeliveQuery, "", "*");
this.reDistributor.DataSource = allPrizesDeliveryList.Data;
this.reDistributor.DataBind();
this.pager.TotalRecords = allPrizesDeliveryList.TotalRecords;
this.bidExpress();
System.Data.DataTable prizesDeliveryNum = GameHelper.GetPrizesDeliveryNum();
int num = 0;
int num2 = 0;
int num3 = 0;
int num4 = 0;
int num5 = 0;
if (prizesDeliveryNum != null && prizesDeliveryNum.Rows.Count > 0)
{
num = int.Parse(prizesDeliveryNum.Rows[0]["st0"].ToString());
num2 = int.Parse(prizesDeliveryNum.Rows[0]["st1"].ToString());
num3 = int.Parse(prizesDeliveryNum.Rows[0]["st2"].ToString());
num4 = int.Parse(prizesDeliveryNum.Rows[0]["st3"].ToString());
num5 = num + num2 + num3 + num4;
}
this.ListAll.Text = "所有奖品(" + num5 + ")";
this.ListWaitAddr.Text = "待填写收货地址(" + num + ")";
this.ListWaitSend.Text = "待发货(" + num2 + ")";
this.ListHasSend.Text = "已发货(" + num3 + ")";
this.ListHasReceive.Text = "已收货(" + num4 + ")";
}
public bool GetPrizesDeliveInfo(PrizesDeliveQuery query, out string GameTitle, out int UserId)
{
GameTitle = "";
UserId = 0;
System.Data.Common.DbCommand sqlStringCommand = this._database.GetSqlStringCommand("select top 1 GameTitle, UserId from [vw_Hishop_PrizesDeliveryRecord] where LogId=" + query.LogId.ToString() + " and ID=" + query.Id.ToString());
System.Data.DataTable dataTable = this._database.ExecuteDataSet(sqlStringCommand).Tables[0];
bool result;
if (dataTable != null && dataTable.Rows.Count > 0)
{
GameTitle = Convert.ToString(dataTable.Rows[0]["GameTitle"]);
UserId = Convert.ToInt32(dataTable.Rows[0]["UserId"]);
result = true;
}
else
{
result = false;
}
return(result);
}
private void BindData()
{
PrizesDeliveQuery query = new PrizesDeliveQuery {
SortBy = "LogId",
GameId = new int?(this.gameId),
PageIndex = this.pageIndex,
PageSize = this.pageSize
};
string isFinished = this.isFinished;
if (!string.IsNullOrEmpty(isFinished))
{
query.IsUsed = new int?(int.Parse(isFinished));
}
DbQueryResult prizeLogLists = GameHelper.GetPrizeLogLists(query);
DataTable data = (DataTable)prizeLogLists.Data;
this.grdPrizeLists.DataSource = data;
this.grdPrizeLists.DataBind();
this.pager1.TotalRecords = prizeLogLists.TotalRecords;
}
public static bool UpdatePrizesDelivery(PrizesDeliveQuery query)
{
bool flag = new GameDao().UpdatePrizesDelivery(query);
if (flag)
{
string gameTitle = "";
int userId = 0;
new GameDao().GetPrizesDeliveInfo(query, out gameTitle, out userId);
try
{
MemberInfo member = MemberHelper.GetMember(userId);
if (member != null)
{
Messenger.SendWeiXinMsg_PrizeRelease(member, gameTitle);
}
}
catch (Exception var_4_4F)
{
}
}
return(flag);
}
public DbQueryResult GetPrizeLogLists(PrizesDeliveQuery query)
{
string selectFields = "LogId, PlayTime, UserId, UserName, PrizeGrade, PrizeType, GivePoint, GiveCouponId, GiveShopBookId,Prize ";
StringBuilder stringBuilder = new StringBuilder(" 1=1 ");
if (query.GameId.HasValue)
{
stringBuilder.AppendFormat(" and GameId={0}", query.GameId);
}
if (query.IsUsed.HasValue)
{
stringBuilder.AppendFormat(" and IsUsed={0}", query.IsUsed);
}
if (!string.IsNullOrEmpty(query.StartDate))
{
stringBuilder.AppendFormat(" and PlayTime>='{0}'", query.StartDate);
}
if (!string.IsNullOrEmpty(query.EndDate))
{
stringBuilder.AppendFormat(" and PlayTime<'{0}'", query.EndDate);
}
return(DataHelper.PagingByTopnotin(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_PrizesRecord", "LogId", stringBuilder.ToString(), selectFields));
}
public static bool UpdatePrizesDelivery(PrizesDeliveQuery query)
{
bool flag = (new GameDao()).UpdatePrizesDelivery(query);
if (flag)
{
string str = "";
int num = 0;
string str1 = "";
(new GameDao()).GetPrizesDeliveInfo(query, out str, out num, out str1);
try
{
MemberInfo member = MemberHelper.GetMember(num);
if (member != null)
{
Messenger.SendWeiXinMsg_PrizeRelease(member, str, str1);
}
}
catch (Exception exception)
{
}
}
return(flag);
}
public static DbQueryResult GetAllPrizesDeliveryList(PrizesDeliveQuery query, string ExtendLimits = "", string selectFields = "*")
{
return(new GameDao().GetAllPrizesDeliveryList(query, ExtendLimits, selectFields));
}
public static DbQueryResult GetPrizeLogLists(PrizesDeliveQuery query)
{
return(new PrizeResultDao().GetPrizeLogLists(query));
}
public static DbQueryResult GetPrizesDeliveryList(PrizesDeliveQuery query, [Optional, DefaultParameterValue("")] string ExtendLimits, [Optional, DefaultParameterValue("*")] string selectFields)
{
return(new GameDao().GetPrizesDeliveryList(query, ExtendLimits, selectFields));
}
protected void btnExportButton_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ActitivyTitle"]))
{
this.ActitivyTitle = this.Page.Request.QueryString["ActitivyTitle"];
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["AddrReggion"]))
{
this.AddrReggion = base.Server.UrlDecode(this.Page.Request.QueryString["AddrReggion"]);
this.SelReggion.SetSelectedRegionId(new int?(int.Parse(this.AddrReggion)));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ShowTabNum"]))
{
this.ShowTabNum = base.Server.UrlDecode(this.Page.Request.QueryString["ShowTabNum"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["Receiver"]))
{
this.Receiver = base.Server.UrlDecode(this.Page.Request.QueryString["Receiver"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ProductName"]))
{
this.ProductName = base.Server.UrlDecode(this.Page.Request.QueryString["ProductName"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["StartDate"]))
{
this.StartDate = base.Server.UrlDecode(this.Page.Request.QueryString["StartDate"]);
this.calendarStartDate.SelectedDate = new DateTime?(DateTime.Parse(this.StartDate));
}
else
{
this.StartDate = "";
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["EndDate"]))
{
this.EndDate = base.Server.UrlDecode(this.Page.Request.QueryString["EndDate"]);
this.calendarEndDate.SelectedDate = new DateTime?(DateTime.Parse(this.EndDate));
}
else
{
this.EndDate = "";
}
PrizesDeliveQuery entity = new PrizesDeliveQuery {
Status = int.Parse(this.ShowTabNum) - 1,
StartDate = this.StartDate,
EndDate = this.EndDate,
SortBy = "WinTime",
PrizeType = 2,
SortOrder = SortAction.Desc,
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
ProductName = this.ProductName,
Receiver = this.Receiver,
ReggionId = this.AddrReggion,
ActivityTitle = this.ActitivyTitle
};
Globals.EntityCoding(entity, true);
DbQueryResult result = GameHelper.GetAllPrizesDeliveryList(entity, "", "*");
StringBuilder builder = new StringBuilder();
builder.AppendLine("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">");
builder.AppendLine("<tr style=\"font-weight: bold; white-space: nowrap;\">");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >活动名称</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >商品名称</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >奖品等级</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >中奖时间</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >收货人</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >联系电话</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >详细地址</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >快递公司</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >快递编号</td>");
builder.AppendLine("</tr>");
DataTable data = (DataTable)result.Data;
string str = string.Empty;
string str2 = string.Empty;
new List <int>();
if (!string.IsNullOrEmpty(this.hidLogId.Value) || !string.IsNullOrEmpty(this.hidPid.Value))
{
str = this.hidLogId.Value;
str2 = this.hidPid.Value;
string[] collection = str.Split(new char[] { ',' });
string[] strArray2 = str2.Split(new char[] { ',' });
List <string> list = new List <string>(collection);
List <string> list2 = new List <string>(strArray2);
for (int i = 0; i < data.Rows.Count; i++)
{
string item = data.Rows[i]["LogId"].ToString();
string str4 = data.Rows[i]["Pid"].ToString();
if (list.Contains(item) || list2.Contains(str4))
{
builder.AppendLine("<tr>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[i]["Title"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[i]["ProductName"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + GameHelper.GetPrizeGradeName(data.Rows[i]["PrizeGrade"].ToString()) + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[i]["WinTime"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[i]["Receiver"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[i]["Tel"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[i]["Address"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[i]["ExpressName"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[i]["CourierNumber"] + "</td>");
builder.AppendLine("</tr>");
}
}
}
else
{
for (int j = 0; j < data.Rows.Count; j++)
{
data.Rows[j]["LogId"].ToString();
builder.AppendLine("<tr>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[j]["Title"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[j]["ProductName"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + GameHelper.GetPrizeGradeName(data.Rows[j]["PrizeGrade"].ToString()) + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[j]["WinTime"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[j]["Receiver"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[j]["Tel"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[j]["Address"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[j]["ExpressName"] + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + data.Rows[j]["CourierNumber"] + "</td>");
builder.AppendLine("</tr>");
}
}
if (data.Rows.Count == 0)
{
builder.AppendLine("<tr><td></td></tr>");
}
builder.AppendLine("</table>");
this.Page.Response.Clear();
this.Page.Response.Buffer = false;
this.Page.Response.Charset = "UTF-8";
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=PrizeLists_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");
this.Page.Response.ContentEncoding = Encoding.GetEncoding("UTF-8");
this.Page.Response.ContentType = "application/ms-excel";
this.Page.EnableViewState = false;
this.Page.Response.Write(builder.ToString());
this.Page.Response.End();
}
protected void btnExportButton_Click(object sender, System.EventArgs e)
{
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ActitivyTitle"]))
{
this.ActitivyTitle = this.Page.Request.QueryString["ActitivyTitle"];
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["AddrReggion"]))
{
this.AddrReggion = base.Server.UrlDecode(this.Page.Request.QueryString["AddrReggion"]);
this.SelReggion.SetSelectedRegionId(new int?(int.Parse(this.AddrReggion)));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ShowTabNum"]))
{
this.ShowTabNum = base.Server.UrlDecode(this.Page.Request.QueryString["ShowTabNum"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["Receiver"]))
{
this.Receiver = base.Server.UrlDecode(this.Page.Request.QueryString["Receiver"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ProductName"]))
{
this.ProductName = base.Server.UrlDecode(this.Page.Request.QueryString["ProductName"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["StartDate"]))
{
this.StartDate = base.Server.UrlDecode(this.Page.Request.QueryString["StartDate"]);
this.calendarStartDate.SelectedDate = new System.DateTime?(System.DateTime.Parse(this.StartDate));
}
else
{
this.StartDate = "";
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["EndDate"]))
{
this.EndDate = base.Server.UrlDecode(this.Page.Request.QueryString["EndDate"]);
this.calendarEndDate.SelectedDate = new System.DateTime?(System.DateTime.Parse(this.EndDate));
}
else
{
this.EndDate = "";
}
PrizesDeliveQuery prizesDeliveQuery = new PrizesDeliveQuery();
prizesDeliveQuery.Status = int.Parse(this.ShowTabNum) - 1;
prizesDeliveQuery.StartDate = this.StartDate;
prizesDeliveQuery.EndDate = this.EndDate;
prizesDeliveQuery.SortBy = "WinTime";
prizesDeliveQuery.PrizeType = 2;
prizesDeliveQuery.SortOrder = SortAction.Desc;
prizesDeliveQuery.PageIndex = this.pager.PageIndex;
prizesDeliveQuery.PageSize = this.pager.PageSize;
prizesDeliveQuery.ProductName = this.ProductName;
prizesDeliveQuery.Receiver = this.Receiver;
prizesDeliveQuery.ReggionId = this.AddrReggion;
prizesDeliveQuery.ActivityTitle = this.ActitivyTitle;
Globals.EntityCoding(prizesDeliveQuery, true);
DbQueryResult allPrizesDeliveryList = GameHelper.GetAllPrizesDeliveryList(prizesDeliveQuery, "", "*");
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
stringBuilder.AppendLine("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">");
stringBuilder.AppendLine("<tr style=\"font-weight: bold; white-space: nowrap;\">");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >活动名称</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >商品名称</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >奖品等级</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >中奖时间</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >收货人</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >联系电话</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >详细地址</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >快递公司</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >快递编号</td>");
stringBuilder.AppendLine("</tr>");
System.Data.DataTable dataTable = (System.Data.DataTable)allPrizesDeliveryList.Data;
string text = string.Empty;
new System.Collections.Generic.List <int>();
if (!string.IsNullOrEmpty(base.Request["CheckBoxGroup"]))
{
text = base.Request["CheckBoxGroup"];
string[] collection = text.Split(new char[]
{
','
});
System.Collections.Generic.List <string> list = new System.Collections.Generic.List <string>(collection);
for (int i = 0; i < dataTable.Rows.Count; i++)
{
string item = dataTable.Rows[i]["LogId"].ToString();
if (list.Contains(item))
{
stringBuilder.AppendLine("<tr>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["Title"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["ProductName"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + GameHelper.GetPrizeGradeName(dataTable.Rows[i]["PrizeGrade"].ToString()) + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["WinTime"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["Receiver"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["Tel"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["Address"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["ExpressName"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[i]["CourierNumber"] + "</td>");
stringBuilder.AppendLine("</tr>");
}
}
}
else
{
for (int j = 0; j < dataTable.Rows.Count; j++)
{
dataTable.Rows[j]["LogId"].ToString();
stringBuilder.AppendLine("<tr>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["Title"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["ProductName"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + GameHelper.GetPrizeGradeName(dataTable.Rows[j]["PrizeGrade"].ToString()) + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["WinTime"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["Receiver"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["Tel"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["Address"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["ExpressName"] + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat: @;\" >" + dataTable.Rows[j]["CourierNumber"] + "</td>");
stringBuilder.AppendLine("</tr>");
}
}
if (dataTable.Rows.Count == 0)
{
stringBuilder.AppendLine("<tr><td></td></tr>");
}
stringBuilder.AppendLine("</table>");
this.Page.Response.Clear();
this.Page.Response.Buffer = false;
this.Page.Response.Charset = "UTF-8";
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=PrizeLists_" + System.DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");
this.Page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
this.Page.Response.ContentType = "application/ms-excel";
this.Page.EnableViewState = false;
this.Page.Response.Write(stringBuilder.ToString());
this.Page.Response.End();
}
public bool UpdatePrizesDelivery(PrizesDeliveQuery query)
{
DbCommand sqlStringCommand;
StringBuilder builder = new StringBuilder();
if (query.Id == 0)
{
builder.Append("insert into Hishop_PrizesDeliveryRecord");
builder.Append("(Receiver,Tel,LogId,ReggionPath,Address,status,RecordType,Pid)VALUES");
builder.Append("(@Receiver,@Tel,@LogId,@ReggionPath,@Address,@Status,@RecordType,@Pid)");
builder.Append(";update Hishop_PromotionGameResultMembersLog set IsUsed=1 where LogId=" + query.LogId);
sqlStringCommand = this._database.GetSqlStringCommand(builder.ToString());
this._database.AddInParameter(sqlStringCommand, "@Receiver", DbType.String, query.Receiver);
this._database.AddInParameter(sqlStringCommand, "@Tel", DbType.String, query.Tel);
this._database.AddInParameter(sqlStringCommand, "@LogId", DbType.Int32, query.LogId);
this._database.AddInParameter(sqlStringCommand, "@ReggionPath", DbType.String, query.ReggionPath);
this._database.AddInParameter(sqlStringCommand, "@Address", DbType.String, query.Address);
this._database.AddInParameter(sqlStringCommand, "@RecordType", DbType.String, query.RecordType);
if (string.IsNullOrEmpty(query.Pid))
{
query.Pid = "0";
}
this._database.AddInParameter(sqlStringCommand, "@Pid", DbType.String, query.Pid);
if (((query.Address.Length > 5) && (query.ReggionPath.Length > 0)) && ((query.Receiver.Length > 1) && (query.Tel.Length > 7)))
{
this._database.AddInParameter(sqlStringCommand, "@Status", DbType.Int16, 1);
}
else
{
this._database.AddInParameter(sqlStringCommand, "@Status", DbType.Int16, 0);
}
}
else
{
builder.Append("Update Hishop_PrizesDeliveryRecord ");
if (query.Status == 0)
{
builder.Append("set status=status");
}
else
{
builder.Append("set Status=@Status");
}
if (!string.IsNullOrEmpty(query.Receiver))
{
builder.Append(",Receiver=@Receiver");
}
if (!string.IsNullOrEmpty(query.Tel))
{
builder.Append(",Tel=@Tel");
}
if (!string.IsNullOrEmpty(query.ReggionPath))
{
builder.Append(",ReggionPath=@ReggionPath");
}
if (!string.IsNullOrEmpty(query.ExpressName))
{
builder.Append(",ExpressName=@ExpressName");
}
if (!string.IsNullOrEmpty(query.CourierNumber))
{
builder.Append(",CourierNumber=@CourierNumber");
}
if (!string.IsNullOrEmpty(query.Address))
{
builder.Append(",Address=@Address");
}
DateTime now = DateTime.Now;
if (DateTime.TryParse(query.DeliveryTime, out now))
{
builder.AppendFormat(",DeliveryTime='{0}'", now.ToString("yyyy-MM-dd 00:00:00"));
}
if (DateTime.TryParse(query.ReceiveTime, out now))
{
builder.AppendFormat(",ReceiveTime='{0}'", now.ToString("yyyy-MM-dd 00:00:00"));
}
builder.Append(" where Id=@Id");
if ((query.Status == 3) && (query.LogId != "0"))
{
builder.Append(";update Hishop_PromotionGameResultMembersLog set IsUsed=1 where LogId=" + query.LogId);
}
sqlStringCommand = this._database.GetSqlStringCommand(builder.ToString());
this._database.AddInParameter(sqlStringCommand, "@Status", DbType.Int16, query.Status);
this._database.AddInParameter(sqlStringCommand, "@Address", DbType.String, query.Address);
this._database.AddInParameter(sqlStringCommand, "@ExpressName", DbType.String, query.ExpressName);
this._database.AddInParameter(sqlStringCommand, "@CourierNumber", DbType.String, query.CourierNumber);
this._database.AddInParameter(sqlStringCommand, "@ReggionPath", DbType.String, query.ReggionPath);
this._database.AddInParameter(sqlStringCommand, "@Receiver", DbType.String, query.Receiver);
this._database.AddInParameter(sqlStringCommand, "@Tel", DbType.String, query.Tel);
this._database.AddInParameter(sqlStringCommand, "@Id", DbType.Int32, query.Id);
}
return(this._database.ExecuteNonQuery(sqlStringCommand) > 0);
}
public static bool UpdateOneyuanDelivery(PrizesDeliveQuery query)
{
return(new GameDao().UpdatePrizesDelivery(query));
}
protected override void AttachChildControls()
{
int num;
int num2;
PageTitle.AddSiteNameTitle("我的奖品");
this.rptList = (VshopTemplatedRepeater)this.FindControl("rptList");
this.txtTotal = (HtmlInputHidden)this.FindControl("txtTotal");
this.txtShowTabNum = (HtmlInputHidden)this.FindControl("txtShowTabNum");
HtmlSelect select = (HtmlSelect)this.FindControl("txtRevAddress");
IList <ShippingAddressInfo> shippingAddresses = MemberProcessor.GetShippingAddresses();
select.Items.Clear();
foreach (ShippingAddressInfo info in shippingAddresses)
{
string str = "";
string text = "";
str = string.Concat(new object[] { info.ShipTo, "|", info.CellPhone, "|", info.RegionId, "|", info.Address });
text = info.ShipTo + " " + info.CellPhone + " " + RegionHelper.GetFullRegion(info.RegionId, ",") + " " + info.Address;
select.Items.Add(new ListItem(text, str));
}
select.Items.Add(new ListItem("--新增收货地址--", "addNew"));
string str3 = Globals.RequestQueryStr("ShowTab");
if (string.IsNullOrEmpty(str3))
{
str3 = "0";
}
PrizesDeliveQuery entity = new PrizesDeliveQuery();
if (!int.TryParse(this.Page.Request.QueryString["page"], out num))
{
num = 1;
}
if (!int.TryParse(this.Page.Request.QueryString["size"], out num2))
{
num2 = 20;
}
string extendLimits = "";
if (str3 == "0")
{
extendLimits = " and status in(0,1,2) ";
}
else
{
extendLimits = " and status=3 ";
}
this.txtShowTabNum.Value = str3;
entity.Status = -1;
entity.SortBy = "LogId";
entity.SortOrder = SortAction.Desc;
entity.PageIndex = num;
entity.PrizeType = -1;
entity.PageSize = num2;
entity.UserId = Globals.GetCurrentMemberUserId();
Globals.EntityCoding(entity, true);
DbQueryResult result = GameHelper.GetPrizesDeliveryList(entity, extendLimits, "*");
this.rptList.DataSource = result.Data;
this.rptList.DataBind();
this.txtTotal.SetWhenIsNotNull(result.TotalRecords.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
this.Did = base.Request.QueryString["LogId"];
string str = Globals.RequestQueryStr("pid");
if (!string.IsNullOrEmpty(this.Did))
{
PrizesDeliveQuery query = new PrizesDeliveQuery
{
Status = -1,
PageIndex = 1,
PageSize = 2,
PrizeType = -1
};
DbQueryResult result = null;
if (!string.IsNullOrEmpty(str) && (str != "0"))
{
query.Pid = str;
result = GameHelper.GetAllPrizesDeliveryList(query, "", "*");
}
else
{
query.LogId = this.Did;
query.SortBy = "LogId";
result = GameHelper.GetPrizesDeliveryList(query, "", "*");
}
DataTable data = (DataTable)result.Data;
if ((data != null) && (data.Rows.Count > 0))
{
DataRow row = data.Rows[0];
this.txtStatus.Text = GameHelper.GetPrizesDeliveStatus(this.Dbnull2str(row["status"]), this.Dbnull2str(row["IsLogistics"]), this.Dbnull2str(row["PrizeType"]), row["gametype"].ToString());
this.txtCourierNumber.Text = this.Dbnull2str(row["CourierNumber"]);
this.txtExpressName.Text = this.Dbnull2str(row["ExpressName"]);
this.txtTel.Text = this.Dbnull2str(row["Tel"]);
this.txtDTel.Text = this.Dbnull2str(row["Tel"]);
this.txtReceiver.Text = this.Dbnull2str(row["Receiver"]);
this.txtDeliever.Text = this.Dbnull2str(row["Receiver"]);
this.txtAddress.Text = this.Dbnull2str(row["Address"]);
this.txtRegionName.Text = this.Dbnull2str(row["ReggionPath"]);
this.txtImage.ImageUrl = (row["ThumbnailUrl100"] == DBNull.Value) ? "/utility/pics/none.gif" : row["ThumbnailUrl100"].ToString();
if (this.txtRegionName.Text.Trim() != "")
{
string[] strArray = this.txtRegionName.Text.Trim().Split(new char[] { ',' });
this.txtRegionName.Text = RegionHelper.GetFullRegion(int.Parse(strArray[strArray.Length - 1]), ",");
}
if (!string.IsNullOrEmpty(str) && (str != "0"))
{
if (this.txtTel.Text == "")
{
this.txtTel.Text = this.Dbnull2str(row["Tel"]);
this.txtDTel.Text = this.Dbnull2str(row["Tel"]);
}
this.txtPlayTime.Text = ((DateTime)row["WinTime"]).ToString("yyyy-MM-dd HH:mm:ss");
this.txtGameTitle.Text = row["Title"].ToString();
}
else
{
if (((this.txtImage.ImageUrl == "/utility/pics/none.gif") && (row["PrizeId"] != DBNull.Value)) && (Globals.ToNum(row["PrizeId"]) > 0))
{
int prizeId = Globals.ToNum(row["PrizeId"]);
if (prizeId > 0)
{
GamePrizeInfo gamePrizeInfoById = GameHelper.GetGamePrizeInfoById(prizeId);
if (gamePrizeInfoById != null)
{
this.txtImage.ImageUrl = gamePrizeInfoById.PrizeImage;
}
}
}
if (this.txtDeliever.Text == "")
{
this.txtReceiver.Text = this.Dbnull2str(row["RealName"]);
this.txtDeliever.Text = this.Dbnull2str(row["RealName"]);
}
if (this.txtTel.Text == "")
{
this.txtTel.Text = this.Dbnull2str(row["CellPhone"]);
this.txtDTel.Text = this.Dbnull2str(row["CellPhone"]);
}
this.txtGameTitle.Text = row["GameTitle"].ToString();
this.txtPlayTime.Text = ((DateTime)row["PlayTime"]).ToString("yyyy-MM-dd HH:mm:ss");
}
this.txtPrizeGrade.Text = GameHelper.GetPrizeGradeName(this.Dbnull2str(row["PrizeGrade"]));
this.txtGameType.Text = GameHelper.GetGameTypeName(row["GameType"].ToString());
this.txtProductName.Text = row["ProductName"].ToString();
}
}
}
protected override void AttachChildControls()
{
PageTitle.AddSiteNameTitle("我的优惠券");
this.txtTotal = (System.Web.UI.HtmlControls.HtmlInputHidden) this.FindControl("txtTotal");
this.txtShowTabNum = (System.Web.UI.HtmlControls.HtmlInputHidden) this.FindControl("txtShowTabNum");
this.rptActivity = (VshopTemplatedRepeater)this.FindControl("rptActivity");
string value = "0";
this.txtShowTabNum.Value = value;
PrizesDeliveQuery prizesDeliveQuery = new PrizesDeliveQuery();
int pageIndex;
if (!int.TryParse(this.Page.Request.QueryString["page"], out pageIndex))
{
pageIndex = 1;
}
int pageSize;
if (!int.TryParse(this.Page.Request.QueryString["size"], out pageSize))
{
pageSize = 20;
}
MemberCouponsSearch memberCouponsSearch = new MemberCouponsSearch();
memberCouponsSearch.CouponName = "";
memberCouponsSearch.Status = "0";
memberCouponsSearch.MemberId = Globals.GetCurrentMemberUserId(false);
memberCouponsSearch.IsCount = true;
memberCouponsSearch.PageIndex = pageIndex;
memberCouponsSearch.PageSize = pageSize;
memberCouponsSearch.SortBy = "CouponId";
memberCouponsSearch.SortOrder = SortAction.Desc;
int num = 0;
DataTable memberCoupons = CouponHelper.GetMemberCoupons(memberCouponsSearch, ref num);
if (memberCoupons != null)
{
if (memberCoupons.Rows.Count > 0)
{
memberCoupons.Columns.Add("useConditon");
memberCoupons.Columns.Add("sStatus");
for (int i = 0; i < memberCoupons.Rows.Count; i++)
{
decimal d = decimal.Parse(memberCoupons.Rows[i]["ConditionValue"].ToString());
if (d == 0m)
{
memberCoupons.Rows[i]["useConditon"] = "无消费额限制";
}
else
{
memberCoupons.Rows[i]["useConditon"] = "满" + d.ToString("F2") + "可使用";
}
memberCoupons.Rows[i]["sStatus"] = ((int.Parse(memberCoupons.Rows[i]["Status"].ToString()) == 0) ? "已领用" : "已使用");
}
}
}
MemberInfo currentMember = MemberProcessor.GetCurrentMember();
this.rptActivity.DataSource = memberCoupons;
this.rptActivity.DataBind();
this.txtTotal.SetWhenIsNotNull(num.ToString());
}
protected override void AttachChildControls()
{
PageTitle.AddSiteNameTitle("我的奖品");
this.rptList = (VshopTemplatedRepeater)this.FindControl("rptList");
this.txtTotal = (System.Web.UI.HtmlControls.HtmlInputHidden) this.FindControl("txtTotal");
this.txtShowTabNum = (System.Web.UI.HtmlControls.HtmlInputHidden) this.FindControl("txtShowTabNum");
this.litShipTo = (System.Web.UI.WebControls.Literal) this.FindControl("litShipTo");
this.litCellPhone = (System.Web.UI.WebControls.Literal) this.FindControl("litCellPhone");
this.litAddress = (System.Web.UI.WebControls.Literal) this.FindControl("litAddress");
this.rptAddress = (VshopTemplatedRepeater)this.FindControl("rptAddress");
System.Collections.Generic.IList <ShippingAddressInfo> shippingAddresses = MemberProcessor.GetShippingAddresses();
this.rptAddress.DataSource = from item in shippingAddresses
orderby item.IsDefault
select item;
this.rptAddress.DataBind();
this.litAddAddress = (System.Web.UI.WebControls.Literal) this.FindControl("litAddAddress");
this.selectShipTo = (System.Web.UI.HtmlControls.HtmlInputHidden) this.FindControl("selectShipTo");
ShippingAddressInfo shippingAddressInfo = shippingAddresses.FirstOrDefault((ShippingAddressInfo item) => item.IsDefault);
if (shippingAddressInfo == null)
{
shippingAddressInfo = ((shippingAddresses.Count > 0) ? shippingAddresses[0] : null);
}
if (shippingAddressInfo != null)
{
this.litShipTo.Text = shippingAddressInfo.ShipTo;
this.litCellPhone.Text = shippingAddressInfo.CellPhone;
this.litAddress.Text = shippingAddressInfo.Address;
this.selectShipTo.SetWhenIsNotNull(shippingAddressInfo.ShippingId.ToString());
}
this.litAddAddress.Text = " href='/Vshop/AddShippingAddress.aspx?returnUrl=" + Globals.UrlEncode(System.Web.HttpContext.Current.Request.Url.ToString()) + "'";
string text = Globals.RequestQueryStr("ShowTab");
if (string.IsNullOrEmpty(text))
{
text = "0";
}
PrizesDeliveQuery prizesDeliveQuery = new PrizesDeliveQuery();
int pageIndex;
if (!int.TryParse(this.Page.Request.QueryString["page"], out pageIndex))
{
pageIndex = 1;
}
int pageSize;
if (!int.TryParse(this.Page.Request.QueryString["size"], out pageSize))
{
pageSize = 20;
}
string extendLimits;
if (text == "0")
{
string str = System.DateTime.Now.ToString("yyyy-MM-dd");
extendLimits = " and (status in(0,1,2) or playtime>'" + str + "') ";
}
else
{
extendLimits = " and (status=3 or status=4)";
}
this.txtShowTabNum.Value = text;
prizesDeliveQuery.Status = -1;
prizesDeliveQuery.SortBy = "LogId";
prizesDeliveQuery.SortOrder = SortAction.Desc;
prizesDeliveQuery.PageIndex = pageIndex;
prizesDeliveQuery.PrizeType = -1;
prizesDeliveQuery.PageSize = pageSize;
prizesDeliveQuery.UserId = Globals.GetCurrentMemberUserId();
Globals.EntityCoding(prizesDeliveQuery, true);
DbQueryResult prizesDeliveryList = GameHelper.GetPrizesDeliveryList(prizesDeliveQuery, extendLimits, "*");
this.rptList.ItemDataBound += new System.Web.UI.WebControls.RepeaterItemEventHandler(this.refriendscircle_ItemDataBound);
this.CouponList.Clear();
string text2 = "";
DataTable dataTable = (DataTable)prizesDeliveryList.Data;
if (dataTable != null && dataTable.Rows.Count > 1)
{
for (int i = 0; i < dataTable.Rows.Count; i++)
{
if (dataTable.Rows[i]["GiveCouponId"] != System.DBNull.Value && dataTable.Rows[i]["GiveCouponId"].ToString() != "")
{
text2 = text2 + "," + dataTable.Rows[i]["GiveCouponId"].ToString();
}
}
}
if (text2.Length > 1)
{
text2 = text2.Remove(0, 1);
int[] couponId = System.Array.ConvertAll <string, int>(text2.Split(new char[]
{
','
}), (string s) => int.Parse(s));
DataTable couponsListByIds = CouponHelper.GetCouponsListByIds(couponId);
if (couponsListByIds != null && couponsListByIds.Rows.Count > 0)
{
for (int i = 0; i < couponsListByIds.Rows.Count; i++)
{
int key = (int)couponsListByIds.Rows[i]["CouponId"];
if (!this.CouponList.ContainsKey(key))
{
this.CouponList.Add(key, couponsListByIds.Rows[i]["CouponName"].ToString() + "[面值" + couponsListByIds.Rows[i]["CouponValue"].ToString() + "元]");
}
}
}
}
this.rptList.DataSource = prizesDeliveryList.Data;
this.rptList.DataBind();
this.txtTotal.SetWhenIsNotNull(prizesDeliveryList.TotalRecords.ToString());
}
public DbQueryResult GetPrizesDeliveryList(PrizesDeliveQuery query, string ExtendLimits = "", string selectFields = "*")
{
StringBuilder builder = new StringBuilder();
builder.Append(" 1=1 ");
if (query.PrizeType > -1)
{
builder.Append(" AND ");
builder.AppendFormat(" PrizeType = {0}", query.PrizeType);
}
if (query.Id > 0)
{
builder.Append(" AND ");
builder.AppendFormat(" Id = {0}", query.Id);
}
if (query.UserId > 0)
{
builder.Append(" AND ");
builder.AppendFormat(" UserId = {0}", query.UserId);
}
if (!string.IsNullOrEmpty(query.LogId))
{
builder.Append(" AND ");
builder.AppendFormat(" LogId = {0}", query.LogId);
}
if (query.Status >= 0)
{
builder.Append(" AND ");
builder.AppendFormat("status = {0}", query.Status);
}
if (!string.IsNullOrEmpty(query.ProductName))
{
builder.Append(" AND ");
builder.AppendFormat(" ProductName like '%{0}%'", DataHelper.CleanSearchString(query.ProductName));
}
if (!string.IsNullOrEmpty(query.Receiver))
{
builder.Append(" AND ");
builder.AppendFormat("( Receiver = '{0}'", DataHelper.CleanSearchString(query.Receiver));
builder.AppendFormat(" OR RealName = '{0}' )", DataHelper.CleanSearchString(query.Receiver));
}
if (!string.IsNullOrEmpty(query.ReggionId))
{
builder.Append(" AND ");
builder.AppendFormat(" ',' + ReggionPath + ',' like '%,{0},%'", DataHelper.CleanSearchString(query.ReggionId));
}
DateTime now = DateTime.Now;
if (DateTime.TryParse(query.StartDate, out now))
{
builder.Append(" AND ");
builder.AppendFormat(" PlayTime>='{0}'", now.ToString("yyyy-MM-dd 00:00:00"));
}
if (DateTime.TryParse(query.EndDate, out now))
{
builder.Append(" AND ");
builder.AppendFormat(" PlayTime<='{0}'", now.ToString("yyyy-MM-dd 23:59:59"));
}
if (ExtendLimits != "")
{
builder.Append(ExtendLimits);
}
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_PrizesDeliveryRecord", "LogId", (builder.Length > 0) ? builder.ToString() : null, selectFields));
}
protected void AddrBtn_Click(object sender, System.EventArgs e)
{
if (this.txtLogID.Value == "")
{
this.ShowMsg("LogID为空，请检查！", false);
return;
}
string text = this.txtPrizeReceiver.Text.Trim();
string text2 = this.txtPrizeTel.Text.Trim();
string text3 = this.txtPrizeAddress.Text.Trim();
string text4 = this.HideRegion.Value.Trim();
if (text.Length < 2)
{
this.ShowMsg("收货人不能为空", false);
return;
}
if (text2.Length < 8)
{
this.ShowMsg("联系电话不正确", false);
return;
}
if (text3.Length < 6)
{
this.ShowMsg("地址不够详细", false);
return;
}
int currentRegionId = 0;
if (!int.TryParse(text4, out currentRegionId))
{
this.ShowMsg("省市区未选择", false);
return;
}
text4 = RegionHelper.GetFullPath(currentRegionId);
PrizesDeliveQuery prizesDeliveQuery = new PrizesDeliveQuery();
prizesDeliveQuery.Status = 1;
prizesDeliveQuery.ReggionPath = text4;
prizesDeliveQuery.Address = text3;
prizesDeliveQuery.Tel = text2;
prizesDeliveQuery.Receiver = text;
prizesDeliveQuery.LogId = this.txtLogID.Value;
prizesDeliveQuery.Pid = this.txtLogPid.Value;
int id = 0;
int.TryParse(this.txtDeliverID.Value.Trim(), out id);
prizesDeliveQuery.Id = id;
if (prizesDeliveQuery.LogId == "0")
{
if (GameHelper.UpdateOneyuanDelivery(prizesDeliveQuery))
{
this.ShowMsg("保存收货人信息成功！", true);
this.BindData();
return;
}
this.ShowMsg("保存信息失败", false);
return;
}
else
{
if (GameHelper.UpdatePrizesDelivery(prizesDeliveQuery))
{
this.ShowMsg("保存收货人信息成功！", true);
this.BindData();
return;
}
this.ShowMsg("保存信息失败", false);
return;
}
}
protected override void AttachChildControls()
{
int num;
int num2;
int num3;
PageTitle.AddSiteNameTitle("我的奖品");
this.rptList = (VshopTemplatedRepeater)this.FindControl("rptList");
this.txtTotal = (HtmlInputHidden)this.FindControl("txtTotal");
this.txtShowTabNum = (HtmlInputHidden)this.FindControl("txtShowTabNum");
this.litShipTo = (Literal)this.FindControl("litShipTo");
this.litCellPhone = (Literal)this.FindControl("litCellPhone");
this.litAddress = (Literal)this.FindControl("litAddress");
this.rptAddress = (VshopTemplatedRepeater)this.FindControl("rptAddress");
IList <ShippingAddressInfo> shippingAddresses = MemberProcessor.GetShippingAddresses();
//if (CS$<>9__CachedAnonymousMethodDelegate3 == null)
//{
// CS$<>9__CachedAnonymousMethodDelegate3 = new Func<ShippingAddressInfo, bool>(null, (IntPtr) <AttachChildControls>b__0);
//}
//this.rptAddress.DataSource = Enumerable.OrderBy<ShippingAddressInfo, bool>(shippingAddresses, CS$<>9__CachedAnonymousMethodDelegate3);
//this.rptAddress.DataBind();
this.rptAddress.DataSource = from item in shippingAddresses
orderby item.IsDefault
select item;
this.rptAddress.DataBind();
this.litAddAddress = (Literal)this.FindControl("litAddAddress");
this.selectShipTo = (HtmlInputHidden)this.FindControl("selectShipTo");
//if (CS$<>9__CachedAnonymousMethodDelegate4 == null)
//{
// CS$<>9__CachedAnonymousMethodDelegate4 = new Func<ShippingAddressInfo, bool>(null, (IntPtr) <AttachChildControls>b__1);
//}
//ShippingAddressInfo info = Enumerable.FirstOrDefault<ShippingAddressInfo>(shippingAddresses, CS$<>9__CachedAnonymousMethodDelegate4);
ShippingAddressInfo info = shippingAddresses.FirstOrDefault <ShippingAddressInfo>(item => item.IsDefault);
if (info == null)
{
info = (shippingAddresses.Count > 0) ? shippingAddresses[0] : null;
}
if (info != null)
{
this.litShipTo.Text = info.ShipTo;
this.litCellPhone.Text = info.CellPhone;
this.litAddress.Text = info.Address;
this.selectShipTo.SetWhenIsNotNull(info.ShippingId.ToString());
}
this.litAddAddress.Text = " href='/Vshop/AddShippingAddress.aspx?returnUrl=" + Globals.UrlEncode(HttpContext.Current.Request.Url.ToString()) + "'";
string str = Globals.RequestQueryStr("ShowTab");
if (string.IsNullOrEmpty(str))
{
str = "0";
}
PrizesDeliveQuery entity = new PrizesDeliveQuery();
if (!int.TryParse(this.Page.Request.QueryString["page"], out num))
{
num = 1;
}
if (!int.TryParse(this.Page.Request.QueryString["size"], out num2))
{
num2 = 20;
}
string extendLimits = "";
if (str == "0")
{
string str3 = DateTime.Now.ToString("yyyy-MM-dd");
extendLimits = " and (status in(0,1,2) or playtime>'" + str3 + "') ";
}
else
{
extendLimits = " and (status=3 or status=4)";
}
this.txtShowTabNum.Value = str;
entity.Status = -1;
entity.SortBy = "LogId";
entity.SortOrder = SortAction.Desc;
entity.PageIndex = num;
entity.PrizeType = -1;
entity.PageSize = num2;
entity.UserId = Globals.GetCurrentMemberUserId();
Globals.EntityCoding(entity, true);
DbQueryResult result = GameHelper.GetPrizesDeliveryList(entity, extendLimits, "*");
this.rptList.ItemDataBound += new RepeaterItemEventHandler(this.refriendscircle_ItemDataBound);
this.CouponList.Clear();
string str4 = "";
DataTable data = (DataTable)result.Data;
if ((data != null) && (data.Rows.Count > 1))
{
for (num3 = 0; num3 < data.Rows.Count; num3++)
{
if ((data.Rows[num3]["GiveCouponId"] != DBNull.Value) && (data.Rows[num3]["GiveCouponId"].ToString() != ""))
{
str4 = str4 + "," + data.Rows[num3]["GiveCouponId"].ToString();
}
}
}
if (str4.Length > 1)
{
DataTable couponsListByIds = CouponHelper.GetCouponsListByIds(Array.ConvertAll <string, int>(str4.Remove(0, 1).Split(new char[] { ',' }), s => int.Parse(s)));
if ((couponsListByIds != null) && (couponsListByIds.Rows.Count > 0))
{
for (num3 = 0; num3 < couponsListByIds.Rows.Count; num3++)
{
int key = (int)couponsListByIds.Rows[num3]["CouponId"];
if (!this.CouponList.ContainsKey(key))
{
this.CouponList.Add(key, couponsListByIds.Rows[num3]["CouponName"].ToString() + "[面值" + couponsListByIds.Rows[num3]["CouponValue"].ToString() + "元]");
}
}
}
}
this.rptList.DataSource = result.Data;
this.rptList.DataBind();
this.txtTotal.SetWhenIsNotNull(result.TotalRecords.ToString());
}
protected void Page_Load(object sender, System.EventArgs e)
{
this.Did = base.Request.QueryString["LogId"];
string text = Globals.RequestQueryStr("pid");
if (string.IsNullOrEmpty(this.Did))
{
return;
}
PrizesDeliveQuery prizesDeliveQuery = new PrizesDeliveQuery();
prizesDeliveQuery.Status = -1;
prizesDeliveQuery.PageIndex = 1;
prizesDeliveQuery.PageSize = 2;
prizesDeliveQuery.PrizeType = -1;
DbQueryResult dbQueryResult;
if (!string.IsNullOrEmpty(text) && text != "0")
{
prizesDeliveQuery.Pid = text;
dbQueryResult = GameHelper.GetAllPrizesDeliveryList(prizesDeliveQuery, "", "*");
}
else
{
prizesDeliveQuery.LogId = this.Did;
prizesDeliveQuery.SortBy = "LogId";
dbQueryResult = GameHelper.GetPrizesDeliveryList(prizesDeliveQuery, "", "*");
}
System.Data.DataTable dataTable = (System.Data.DataTable)dbQueryResult.Data;
if (dataTable != null && dataTable.Rows.Count > 0)
{
System.Data.DataRow dataRow = dataTable.Rows[0];
this.txtStatus.Text = GameHelper.GetPrizesDeliveStatus(this.Dbnull2str(dataRow["status"]), this.Dbnull2str(dataRow["IsLogistics"]), this.Dbnull2str(dataRow["PrizeType"]), dataRow["gametype"].ToString());
this.txtCourierNumber.Text = this.Dbnull2str(dataRow["CourierNumber"]);
this.txtExpressName.Text = this.Dbnull2str(dataRow["ExpressName"]);
this.txtTel.Text = this.Dbnull2str(dataRow["Tel"]);
this.txtDTel.Text = this.Dbnull2str(dataRow["Tel"]);
this.txtReceiver.Text = this.Dbnull2str(dataRow["Receiver"]);
this.txtDeliever.Text = this.Dbnull2str(dataRow["Receiver"]);
this.txtAddress.Text = this.Dbnull2str(dataRow["Address"]);
this.txtRegionName.Text = this.Dbnull2str(dataRow["ReggionPath"]);
this.txtImage.ImageUrl = ((dataRow["ThumbnailUrl100"] == System.DBNull.Value) ? "/utility/pics/none.gif" : dataRow["ThumbnailUrl100"].ToString());
if (this.txtRegionName.Text.Trim() != "")
{
string[] array = this.txtRegionName.Text.Trim().Split(new char[]
{
','
});
this.txtRegionName.Text = RegionHelper.GetFullRegion(int.Parse(array[array.Length - 1]), ",");
}
if (!string.IsNullOrEmpty(text) && text != "0")
{
if (this.txtTel.Text == "")
{
this.txtTel.Text = this.Dbnull2str(dataRow["Tel"]);
this.txtDTel.Text = this.Dbnull2str(dataRow["Tel"]);
}
this.txtPlayTime.Text = ((System.DateTime)dataRow["WinTime"]).ToString("yyyy-MM-dd HH:mm:ss");
this.txtGameTitle.Text = dataRow["Title"].ToString();
}
else
{
if (this.txtImage.ImageUrl == "/utility/pics/none.gif" && dataRow["PrizeId"] != System.DBNull.Value && Globals.ToNum(dataRow["PrizeId"]) > 0)
{
int num = Globals.ToNum(dataRow["PrizeId"]);
if (num > 0)
{
GamePrizeInfo gamePrizeInfoById = GameHelper.GetGamePrizeInfoById(num);
if (gamePrizeInfoById != null)
{
this.txtImage.ImageUrl = gamePrizeInfoById.PrizeImage;
}
}
}
if (this.txtDeliever.Text == "")
{
this.txtReceiver.Text = this.Dbnull2str(dataRow["RealName"]);
this.txtDeliever.Text = this.Dbnull2str(dataRow["RealName"]);
}
if (this.txtTel.Text == "")
{
this.txtTel.Text = this.Dbnull2str(dataRow["CellPhone"]);
this.txtDTel.Text = this.Dbnull2str(dataRow["CellPhone"]);
}
this.txtGameTitle.Text = dataRow["GameTitle"].ToString();
this.txtPlayTime.Text = ((System.DateTime)dataRow["PlayTime"]).ToString("yyyy-MM-dd HH:mm:ss");
}
this.txtPrizeGrade.Text = GameHelper.GetPrizeGradeName(this.Dbnull2str(dataRow["PrizeGrade"]));
this.txtGameType.Text = GameHelper.GetGameTypeName(dataRow["GameType"].ToString());
this.txtProductName.Text = dataRow["ProductName"].ToString();
}
}
