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