private void DoAction(string Action)
{
string s = "{\"state\":false,\"msg\":\"未定义操作\"}";
int num = Globals.RequestFormNum("pageIndex");
string str2 = Globals.RequestFormStr("ActivityId");
if (!((num <= 0) || string.IsNullOrEmpty(str2)))
{
OneyuanTaoPartInQuery query = new OneyuanTaoPartInQuery {
PageIndex = num,
PageSize = 10,
ActivityId = str2,
IsPay = 1,
SortBy = "Pid"
};
DbQueryResult oneyuanPartInDataTable = OneyuanTaoHelp.GetOneyuanPartInDataTable(query);
IsoDateTimeConverter converter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
};
string str3 = JsonConvert.SerializeObject(oneyuanPartInDataTable.Data, new JsonConverter[] { converter });
s = "{\"state\":true,\"msg\":\"读取成功\",\"Data\":" + str3 + "}";
}
else
{
s = "{\"state\":false,\"msg\":\"参数不正确\"}";
}
this.Page.Response.ClearContent();
this.Page.Response.ContentType = "application/json";
this.Page.Response.Write(s);
this.Page.Response.End();
}
private void DoAction(string Action)
{
string s = "{\"state\":false,\"msg\":\"未定义操作\"}";
int num = Globals.RequestFormNum("pageIndex");
if (num > 0)
{
OneyuanTaoPartInQuery query = new OneyuanTaoPartInQuery {
PageIndex = num,
PageSize = 10,
ActivityId = "",
UserId = Globals.GetCurrentMemberUserId(false),
state = 1,
SortBy = "BuyTime",
IsPay = -1
};
DbQueryResult oneyuanPartInDataTable = OneyuanTaoHelp.GetOneyuanPartInDataTable(query);
IsoDateTimeConverter converter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
};
string str2 = JsonConvert.SerializeObject(oneyuanPartInDataTable.Data, new JsonConverter[] { converter });
s = "{\"state\":true,\"msg\":\"读取成功\",\"Data\":" + str2 + "}";
}
else
{
s = "{\"state\":false,\"msg\":\"参数不正确\"}";
}
this.Page.Response.ClearContent();
this.Page.Response.ContentType = "application/json";
this.Page.Response.Write(s);
this.Page.Response.End();
}
private void BindData()
{
OneyuanTaoPartInQuery query = new OneyuanTaoPartInQuery
{
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
ActivityId = this.VaidStr,
IsPay = 1,
SortBy = "Pid",
UserName = this.NickName
};
if (this.ShowType)
{
query.state = 3;
}
DbQueryResult oneyuanPartInDataTable = OneyuanTaoHelp.GetOneyuanPartInDataTable(query);
IList <LuckInfo> luckWinlist = OneyuanTaoHelp.getLuckInfoList(true, this.VaidStr);
IList <LuckInfo> luckLoselist = OneyuanTaoHelp.getLuckInfoList(false, this.VaidStr);
this.initLuckDic(luckWinlist, luckLoselist);
this.Datalist.DataSource = oneyuanPartInDataTable.Data;
this.Datalist.DataBind();
this.pager.TotalRecords = oneyuanPartInDataTable.TotalRecords;
}
private void DoAction(string Action)
{
string s = "{\"state\":false,\"msg\":\"未定义操作\"}";
int num = Globals.RequestFormNum("pageIndex");
if (num > 0)
{
OneyuanTaoPartInQuery query = new OneyuanTaoPartInQuery {
PageIndex = num,
PageSize = 10,
ActivityId = "",
UserId = Globals.GetCurrentMemberUserId(false),
state = 2,
SortBy = "BuyTime",
IsPay = -1
};
DbQueryResult oneyuanPartInDataTable = OneyuanTaoHelp.GetOneyuanPartInDataTable(query);
DataTable data = new DataTable();
IsoDateTimeConverter converter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
};
if (oneyuanPartInDataTable.Data != null)
{
data = (DataTable)oneyuanPartInDataTable.Data;
data = (DataTable)oneyuanPartInDataTable.Data;
data.Columns.Add("LuckNumList");
data.Columns.Add("AState");
foreach (DataRow row in data.Rows)
{
IList <LuckInfo> list = OneyuanTaoHelp.getWinnerLuckInfoList(row["ActivityId"].ToString(), "");
if (list != null)
{
row["LuckNumList"] = JsonConvert.SerializeObject(list, new JsonConverter[] { converter });
}
OneyuanTaoInfo info = OneyuanTaoHelp.DataRowToOneyuanTaoInfo(row);
OneTaoPrizeState state = OneyuanTaoHelp.getPrizeState(info);
row["AState"] = state;
if (info.IsSuccess)
{
row["AState"] = "已开奖";
}
else if (info.HasCalculate)
{
row["AState"] = "已结束（开奖失败）";
}
}
}
string str2 = JsonConvert.SerializeObject(data, new JsonConverter[] { converter });
s = "{\"state\":true,\"msg\":\"读取成功\",\"Data\":" + str2 + "}";
}
else
{
s = "{\"state\":false,\"msg\":\"参数不正确\"}";
}
this.Page.Response.ClearContent();
this.Page.Response.ContentType = "application/json";
this.Page.Response.Write(s);
this.Page.Response.End();
}
private void BindData()
{
OneyuanTaoPartInQuery oneyuanTaoPartInQuery = new OneyuanTaoPartInQuery();
oneyuanTaoPartInQuery.PageIndex = this.pager.PageIndex;
oneyuanTaoPartInQuery.PageSize = this.pager.PageSize;
oneyuanTaoPartInQuery.ActivityId = this.VaidStr;
oneyuanTaoPartInQuery.IsPay = 1;
oneyuanTaoPartInQuery.SortBy = "Pid";
oneyuanTaoPartInQuery.UserName = this.NickName;
if (this.ShowType)
{
oneyuanTaoPartInQuery.state = 3;
}
DbQueryResult oneyuanPartInDataTable = OneyuanTaoHelp.GetOneyuanPartInDataTable(oneyuanTaoPartInQuery);
System.Collections.Generic.IList <LuckInfo> luckInfoList = OneyuanTaoHelp.getLuckInfoList(true, this.VaidStr);
System.Collections.Generic.IList <LuckInfo> luckInfoList2 = OneyuanTaoHelp.getLuckInfoList(false, this.VaidStr);
this.initLuckDic(luckInfoList, luckInfoList2);
this.Datalist.DataSource = oneyuanPartInDataTable.Data;
this.Datalist.DataBind();
this.pager.TotalRecords = oneyuanPartInDataTable.TotalRecords;
}
private void BindData()
{
OneyuanTaoPartInQuery query = new OneyuanTaoPartInQuery {
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
IsPay = 1,
SortBy = "Pid",
UserName = this.UserName,
PayWay = this.PayWay,
CellPhone = this.phone,
Atitle = this.atitle
};
if (this.state == 0)
{
query.state = 5;
}
else
{
query.state = 4;
}
DbQueryResult oneyuanPartInDataTable = OneyuanTaoHelp.GetOneyuanPartInDataTable(query);
if (oneyuanPartInDataTable.Data != null)
{
DataTable data = (DataTable)oneyuanPartInDataTable.Data;
data.Columns.Add("ActionBtn");
data.Columns.Add("ASate");
foreach (DataRow row in data.Rows)
{
if ((bool)row["IsRefund"])
{
row["ASate"] = "<span class='green'>已退款</span>";
}
else if ((bool)row["RefundErr"])
{
row["ASate"] = "<span class='red'>退款错误</span>";
}
else
{
row["ASate"] = "<span class='red'>待退款</span>";
}
string str = string.Concat(new object[] { "<a class=\"btn btn-xs btn-danger\" onclick=\"DoRefund('", row["Pid"], "','", row["PayWay"], "')\" >退款</a> " });
if ((bool)row["RefundErr"])
{
str = "<a class=\"btn btn-xs btn-primary\" Remark='" + Globals.HtmlEncode(row["Remark"].ToString()) + "' onclick=\"AView(this)\" >原因</a> " + str;
}
if ((bool)row["IsRefund"])
{
str = "";
if (row["RefundTime"] != DBNull.Value)
{
str = "<span>" + ((DateTime)row["RefundTime"]).ToString("yyyy-MM-dd") + "</span> ";
}
this.actionTd.InnerText = "退款时间";
}
row["ActionBtn"] = str;
}
this.Datalist.DataSource = data;
this.Datalist.DataBind();
this.pager.TotalRecords = oneyuanPartInDataTable.TotalRecords;
int hasRefund = 0;
this.ListWait.Text = "待退款(" + OneyuanTaoHelp.GetRefundTotalNum(out hasRefund).ToString() + ")";
this.ListEnd.Text = "已退款(" + hasRefund.ToString() + ")";
}
}
private void DoAction(string Action)
{
string s = "{\"state\":false,\"msg\":\"未定义操作\"}";
int num = Globals.RequestFormNum("pageIndex");
if (num > 0)
{
int userid = Globals.GetCurrentMemberUserId(false);
OneyuanTaoPartInQuery query = new OneyuanTaoPartInQuery {
PageIndex = num,
PageSize = 10,
ActivityId = "",
UserId = Globals.GetCurrentMemberUserId(false),
state = 3,
SortBy = "BuyTime",
IsPay = -1
};
DbQueryResult oneyuanPartInDataTable = OneyuanTaoHelp.GetOneyuanPartInDataTable(query);
DataTable data = new DataTable();
if (oneyuanPartInDataTable.Data != null)
{
data = (DataTable)oneyuanPartInDataTable.Data;
data.Columns.Add("LuckNumList");
data.Columns.Add("PostSate");
data.Columns.Add("PostBtn");
data.Columns.Add("tabid");
foreach (DataRow dataRow in (InternalDataCollectionBase)data.Rows)
{
DataRow Item = dataRow;
IList <LuckInfo> list1 = (IList <LuckInfo>)Enumerable.ToList <LuckInfo>(Enumerable.Where <LuckInfo>((IEnumerable <LuckInfo>)OneyuanTaoHelp.getLuckInfoList(true, Item["ActivityId"].ToString()), (Func <LuckInfo, bool>)(t => t.UserId == userid && t.Pid == Item["Pid"].ToString())));
Item["PostBtn"] = (object)"0";
Item["tabid"] = (object)"0";
if (list1 != null)
{
List <string> list2 = new List <string>();
foreach (LuckInfo luckInfo in (IEnumerable <LuckInfo>)list1)
{
list2.Add(luckInfo.PrizeNum);
}
Item["LuckNumList"] = (object)string.Join(",", (IEnumerable <string>)list2);
DataTable dataTable2 = OneyuanTaoHelp.PrizesDeliveryRecord(Item["Pid"].ToString());
if (dataTable2 == null || dataTable2.Rows.Count == 0)
{
Item["PostSate"] = (object)"收货地址未确认";
}
else
{
Item["PostSate"] = (object)OneyuanTaoHelp.GetPrizesDeliveStatus(dataTable2.Rows[0]["status"].ToString());
Item["PostBtn"] = (object)dataTable2.Rows[0]["status"].ToString();
Item["tabid"] = (object)dataTable2.Rows[0]["Id"].ToString();
}
}
}
//using (IEnumerator enumerator = data.Rows.GetEnumerator())
//{
// while (enumerator.MoveNext())
// {
// Func<LuckInfo, bool> predicate = null;
// DataRow Item = (DataRow) enumerator.Current;
// if (predicate == null)
// {
// predicate = t => (t.UserId == userid) && (t.Pid == Item["Pid"].ToString());
// }
// IList<LuckInfo> list = OneyuanTaoHelp.getLuckInfoList(true, Item["ActivityId"].ToString()).Where<LuckInfo>(predicate).ToList<LuckInfo>();
// Item["PostBtn"] = "0";
// Item["tabid"] = "0";
// if (list != null)
// {
// List<string> values = new List<string>();
// foreach (LuckInfo info in list)
// {
// values.Add(info.PrizeNum);
// }
// Item["LuckNumList"] = string.Join(",", values);
// DataTable table2 = OneyuanTaoHelp.PrizesDeliveryRecord(Item["Pid"].ToString());
// if ((table2 == null) || (table2.Rows.Count == 0))
// {
// Item["PostSate"] = "收货地址未确认";
// }
// else
// {
// Item["PostSate"] = OneyuanTaoHelp.GetPrizesDeliveStatus(table2.Rows[0]["status"].ToString());
// Item["PostBtn"] = table2.Rows[0]["status"].ToString();
// Item["tabid"] = table2.Rows[0]["Id"].ToString();
// }
// }
// }
//}
}
IsoDateTimeConverter converter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
};
string str2 = JsonConvert.SerializeObject(data, new JsonConverter[] { converter });
s = "{\"state\":true,\"msg\":\"读取成功\",\"Data\":" + str2 + "}";
}
else
{
s = "{\"state\":false,\"msg\":\"参数不正确\"}";
}
this.Page.Response.ClearContent();
this.Page.Response.ContentType = "application/json";
this.Page.Response.Write(s);
this.Page.Response.End();
}
public static DbQueryResult GetOneyuanPartInDataTable(OneyuanTaoPartInQuery query)
{
return(new OneyuanTaoDao().GetOneyuanPartInDataTable(query));
}
public DbQueryResult GetOneyuanPartInDataTable(OneyuanTaoPartInQuery query)
{
StringBuilder builder = new StringBuilder();
builder.Append(" 1=1 ");
if (!string.IsNullOrEmpty(query.UserName))
{
builder.AppendFormat(" and UserName like '%{0}%' ", query.UserName);
}
if (!string.IsNullOrEmpty(query.Atitle))
{
builder.AppendFormat(" and title like '%{0}%' ", query.Atitle);
}
if (!string.IsNullOrEmpty(query.CellPhone))
{
builder.AppendFormat(" and CellPhone like '%{0}%' ", query.CellPhone);
}
if (!string.IsNullOrEmpty(query.PayWay))
{
builder.AppendFormat(" and PayWay = '{0}' ", query.PayWay);
}
if (!string.IsNullOrEmpty(query.ActivityId))
{
builder.AppendFormat(" and ActivityId='{0}' ", query.ActivityId);
}
if (!string.IsNullOrEmpty(query.Pid))
{
builder.AppendFormat(" and Pid='{0}' ", query.Pid);
}
if (query.UserId > 0)
{
builder.AppendFormat(" and UserId={0} ", query.UserId);
}
if (query.IsPay > -1)
{
builder.AppendFormat(" and IsPay={0} ", query.IsPay);
}
if (query.state > 0)
{
if (query.state == 1)
{
builder.Append(" and (IsEnd=0 and EndTime>GETDATE()) ");
}
else if (query.state == 2)
{
builder.Append(" and (IsEnd=1 or EndTime<GETDATE()) ");
}
else if (query.state == 3)
{
builder.Append(" and IsWin=1");
}
else if (query.state == 4)
{
builder.Append(" and IsRefund=1");
}
else if (query.state == 5)
{
builder.Append(" and (HasCalculate=1 and IsSuccess=0 and IsRefund=0)");
}
}
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Vshop_OneyuanPartInList", "Pid", (builder.Length > 0) ? builder.ToString() : null, "*"));
}
private void BindData()
{
OneyuanTaoPartInQuery oneyuanTaoPartInQuery = new OneyuanTaoPartInQuery();
oneyuanTaoPartInQuery.PageIndex = this.pager.PageIndex;
oneyuanTaoPartInQuery.PageSize = this.pager.PageSize;
oneyuanTaoPartInQuery.IsPay = 1;
oneyuanTaoPartInQuery.SortBy = "Pid";
oneyuanTaoPartInQuery.UserName = this.UserName;
oneyuanTaoPartInQuery.PayWay = this.PayWay;
oneyuanTaoPartInQuery.CellPhone = this.phone;
oneyuanTaoPartInQuery.Atitle = this.atitle;
if (this.state == 0)
{
oneyuanTaoPartInQuery.state = 5;
}
else
{
oneyuanTaoPartInQuery.state = 4;
}
DbQueryResult oneyuanPartInDataTable = OneyuanTaoHelp.GetOneyuanPartInDataTable(oneyuanTaoPartInQuery);
if (oneyuanPartInDataTable.Data != null)
{
System.Data.DataTable dataTable = (System.Data.DataTable)oneyuanPartInDataTable.Data;
dataTable.Columns.Add("ActionBtn");
dataTable.Columns.Add("ASate");
foreach (System.Data.DataRow dataRow in dataTable.Rows)
{
if ((bool)dataRow["IsRefund"])
{
dataRow["ASate"] = "<span class='green'>已退款</span>";
}
else if ((bool)dataRow["RefundErr"])
{
dataRow["ASate"] = "<span class='red'>退款错误</span>";
}
else
{
dataRow["ASate"] = "<span class='red'>待退款</span>";
}
string text = string.Concat(new object[]
{
"<a class=\"btn btn-xs btn-danger\" onclick=\"DoRefund('",
dataRow["Pid"],
"','",
dataRow["PayWay"],
"')\" >退款</a> "
});
if ((bool)dataRow["RefundErr"])
{
text = "<a class=\"btn btn-xs btn-primary\" Remark='" + Globals.HtmlEncode(dataRow["Remark"].ToString()) + "' onclick=\"AView(this)\" >原因</a> " + text;
}
if ((bool)dataRow["IsRefund"])
{
text = "";
if (dataRow["RefundTime"] != System.DBNull.Value)
{
text = "<span>" + ((System.DateTime)dataRow["RefundTime"]).ToString("yyyy-MM-dd") + "</span> ";
}
this.actionTd.InnerText = "退款时间";
}
dataRow["ActionBtn"] = text;
}
this.Datalist.DataSource = dataTable;
this.Datalist.DataBind();
this.pager.TotalRecords = oneyuanPartInDataTable.TotalRecords;
int num = 0;
int refundTotalNum = OneyuanTaoHelp.GetRefundTotalNum(out num);
this.ListWait.Text = "待退款(" + refundTotalNum.ToString() + ")";
this.ListEnd.Text = "已退款(" + num.ToString() + ")";
}
}
private void DoAction(string Action)
{
string str = "{\"state\":false,\"msg\":\"未定义操作\"}";
int num = Globals.RequestFormNum("pageIndex");
if (num <= 0)
{
str = "{\"state\":false,\"msg\":\"参数不正确\"}";
}
else
{
int currentMemberUserId = Globals.GetCurrentMemberUserId(false);
OneyuanTaoPartInQuery oneyuanTaoPartInQuery = new OneyuanTaoPartInQuery()
{
PageIndex = num,
PageSize = 10,
ActivityId = "",
UserId = Globals.GetCurrentMemberUserId(false),
state = 3,
SortBy = "BuyTime",
IsPay = -1
};
DbQueryResult oneyuanPartInDataTable = OneyuanTaoHelp.GetOneyuanPartInDataTable(oneyuanTaoPartInQuery);
DataTable dataTable = new DataTable();
if (oneyuanPartInDataTable.Data != null)
{
dataTable = (DataTable)oneyuanPartInDataTable.Data;
dataTable.Columns.Add("LuckNumList");
dataTable.Columns.Add("PostSate");
dataTable.Columns.Add("PostBtn");
dataTable.Columns.Add("tabid");
foreach (DataRow row in dataTable.Rows)
{
IList <LuckInfo> luckInfoList = OneyuanTaoHelp.getLuckInfoList(true, row["ActivityId"].ToString());
luckInfoList = (
from t in luckInfoList
where (t.UserId != currentMemberUserId ? false : t.Pid == row["Pid"].ToString())
select t).ToList <LuckInfo>();
row["PostBtn"] = "0";
row["tabid"] = "0";
if (luckInfoList != null)
{
List <string> strs = new List <string>();
foreach (LuckInfo luckInfo in luckInfoList)
{
strs.Add(luckInfo.PrizeNum);
}
row["LuckNumList"] = string.Join(",", strs);
DataTable dataTable1 = OneyuanTaoHelp.PrizesDeliveryRecord(row["Pid"].ToString());
if ((dataTable1 == null ? false : dataTable1.Rows.Count != 0))
{
row["PostSate"] = OneyuanTaoHelp.GetPrizesDeliveStatus(dataTable1.Rows[0]["status"].ToString());
row["PostBtn"] = dataTable1.Rows[0]["status"].ToString();
row["tabid"] = dataTable1.Rows[0]["Id"].ToString();
}
else
{
row["PostSate"] = "收货地址未确认";
}
}
}
}
IsoDateTimeConverter isoDateTimeConverter = new IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
};
JsonConverter[] jsonConverterArray = new JsonConverter[] { isoDateTimeConverter };
string str1 = JsonConvert.SerializeObject(dataTable, jsonConverterArray);
str = string.Concat("{\"state\":true,\"msg\":\"读取成功\",\"Data\":", str1, "}");
}
this.Page.Response.ClearContent();
this.Page.Response.ContentType = "application/json";
this.Page.Response.Write(str);
this.Page.Response.End();
}
