private DataGridViewModel <Dictionary <string, object> > GetDataList(CouponsSearch query) { DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >(); if (query != null) { DbQueryResult couponInfos = CouponHelper.GetCouponInfos(query, ""); dataGridViewModel.rows = DataHelper.DataTableToDictionary(couponInfos.Data); dataGridViewModel.total = couponInfos.TotalRecords; foreach (Dictionary <string, object> row in dataGridViewModel.rows) { CouponInfo couponInfo = row.ToObject <CouponInfo>(); int couponSurplus = CouponHelper.GetCouponSurplus(couponInfo.CouponId); row.Add("LastCount", couponSurplus); int couponObtainUserNum = CouponHelper.GetCouponObtainUserNum(couponInfo.CouponId); int couponObtainNum = CouponHelper.GetCouponObtainNum(couponInfo.CouponId, 0); row.Add("UserCount", couponObtainUserNum); row.Add("UserGetCount", couponObtainNum); int couponUsedNum = CouponHelper.GetCouponUsedNum(couponInfo.CouponId); row.Add("UseCount", couponUsedNum); row.Add("IsCouponEnd", this.IsCouponEnd(couponInfo.ClosingTime)); } } return(dataGridViewModel); }
private void Refresh() { SiteSettings masterSettings = SettingsManager.GetMasterSettings(); this.hidSelectCouponIds.Value = ","; string sWhere = "and COUPONID IN ('" + masterSettings.GiftCouponList.Replace(",", "','") + "')"; DbQueryResult couponInfos = CouponHelper.GetCouponInfos(this.GetCouponsSearch(), sWhere); this.rpCoupons.DataSource = couponInfos.Data; this.rpCoupons.DataBind(); }
private DataGridViewModel <Dictionary <string, object> > GetDataList(CouponsSearch query) { DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >(); if (query != null) { DbQueryResult couponInfos = CouponHelper.GetCouponInfos(query, ""); dataGridViewModel.rows = DataHelper.DataTableToDictionary(couponInfos.Data); dataGridViewModel.total = couponInfos.TotalRecords; foreach (Dictionary <string, object> row in dataGridViewModel.rows) { row.Add("CouponSurplus", this.GetCouponSurplus(row["CouponId"].ToInt(0))); } } return(dataGridViewModel); }
private void BindRegisterCoupons() { SiteSettings masterSettings = SettingsManager.GetMasterSettings(); if (!masterSettings.IsOpenGiftCoupons) { HttpContext.Current.Response.Redirect("RegisteredCouponsEnd.aspx"); } this.hidIsOpenGiftCoupons.Value = (masterSettings.IsOpenGiftCoupons ? "1" : "0"); this.btnToGo.NavigateUrl = ""; string sWhere = "and COUPONID IN ('" + masterSettings.GiftCouponList.Replace(",", "','") + "')"; DbQueryResult couponInfos = CouponHelper.GetCouponInfos(this.GetCouponsSearch(), sWhere); decimal num = default(decimal); if (couponInfos.Data != null) { DataTable data = couponInfos.Data; data.Columns.Add("ItemIndex"); data.Columns.Add("isEnd"); int num2 = 0; foreach (DataRow row in data.Rows) { int couponSurplus = CouponHelper.GetCouponSurplus(row["CouponId"].ToInt(0)); if (couponSurplus <= 0) { row["isEnd"] = "couponed"; } if (row["ClosingTime"].ToDateTime().HasValue&& row["ClosingTime"].ToDateTime().Value < DateTime.Now) { row["isEnd"] = "couponed"; } num += row["Price"].ToDecimal(0); if (data.Rows.Count == num2 + 1 && data.Rows.Count % 2 == 1) { row["ItemIndex"] = -1; } else { row["ItemIndex"] = num2; } num2++; } this.rptRegisterCoupons.DataSource = data; this.rptRegisterCoupons.DataBind(); } this.lblTotalPrice.Text = num.F2ToString("f2"); }
private void BindRegisterCoupons() { SiteSettings masterSettings = SettingsManager.GetMasterSettings(); this.hidIsOpenGiftCoupons.Value = (masterSettings.IsOpenGiftCoupons ? "1" : "0"); this.btnToGo.Text = (masterSettings.IsOpenGiftCoupons ? "去注册" : "去购物"); this.btnToGo.NavigateUrl = (masterSettings.IsOpenGiftCoupons ? "/Register.aspx" : "/"); MemberInfo user = HiContext.Current.User; if (masterSettings.IsOpenGiftCoupons) { string sWhere = "and COUPONID IN ('" + masterSettings.GiftCouponList.Replace(",", "','") + "')"; DbQueryResult couponInfos = CouponHelper.GetCouponInfos(this.GetCouponsSearch(), sWhere); decimal num = default(decimal); if (couponInfos.Data != null) { DataTable data = couponInfos.Data; data.Columns.Add("isEnd"); foreach (DataRow row in data.Rows) { num += row["Price"].ToDecimal(0); int couponSurplus = CouponHelper.GetCouponSurplus(row["CouponId"].ToInt(0)); if (couponSurplus <= 0) { row["isEnd"] = "end"; } if (row["ClosingTime"].ToDateTime().HasValue&& row["ClosingTime"].ToDateTime().Value < DateTime.Now) { row["isEnd"] = "end"; } } this.rptRegisterCoupons.DataSource = couponInfos.Data; this.rptRegisterCoupons.DataBind(); } this.lblTotalPrice.Text = num.F2ToString("f2"); if (user.UserId > 0 && user.IsLogined) { this.btnToGo.NavigateUrl = "RegisteredCoupons.aspx?isOldUser=true"; } } if (this.isOldUser) { this.hidIsOpenGiftCoupons.Value = "2"; this.btnToGo.Text = "去购物"; this.btnToGo.NavigateUrl = "/"; } }
private void BindCouponList() { SiteSettings masterSettings = SettingsManager.GetMasterSettings(); this.ooOpen.SelectedValue = masterSettings.IsOpenGiftCoupons; if (masterSettings.IsOpenGiftCoupons) { this.hidSelectCouponIds.Value = ","; string sWhere = "and COUPONID IN ('" + masterSettings.GiftCouponList.Replace(",", "','") + "')"; DbQueryResult couponInfos = CouponHelper.GetCouponInfos(this.GetCouponsSearch(), sWhere); this.rpCoupons.DataSource = couponInfos.Data; this.rpCoupons.DataBind(); } else { this.hidSelectCouponIds.Value = ""; this.rpCoupons.DataSource = null; this.rpCoupons.DataBind(); } }
private DataGridViewModel <Dictionary <string, object> > GetDataList(CouponsSearch query, string NotInCouponIds = "") { DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >(); if (query != null) { string sWhere = ""; if (!string.IsNullOrWhiteSpace(NotInCouponIds)) { sWhere = "and COUPONID NOT IN ('" + NotInCouponIds.Replace(",", "','") + "')"; } DbQueryResult couponInfos = CouponHelper.GetCouponInfos(query, sWhere); dataGridViewModel.rows = DataHelper.DataTableToDictionary(couponInfos.Data); dataGridViewModel.total = couponInfos.TotalRecords; foreach (Dictionary <string, object> row in dataGridViewModel.rows) { row.Add("CouponSurplus", this.GetCouponSurplus(row["CouponId"].ToInt(0))); } } return(dataGridViewModel); }
private void BindData() { decimal?minValue = null; decimal?maxValue = null; System.DateTime?beginDate = null; System.DateTime?endDate = null; string text = this.txt_name.Text; decimal value = 0m; System.DateTime now = System.DateTime.Now; if (this.bDecimal(this.txt_minVal.Text, ref value)) { minValue = new decimal?(value); } if (this.bDecimal(this.txt_maxVal.Text, ref value)) { maxValue = new decimal?(value); } if (this.bDate(this.calendarStartDate.Text, ref now)) { beginDate = new System.DateTime?(now); } if (this.bDate(this.calendarEndDate.Text, ref now)) { endDate = new System.DateTime?(now); } DbQueryResult couponInfos = CouponHelper.GetCouponInfos(new CouponsSearch { CouponName = text, minValue = minValue, maxValue = maxValue, beginDate = beginDate, endDate = endDate, IsCount = true, PageIndex = this.pager1.PageIndex, PageSize = this.pager1.PageSize, SortBy = "CouponId", SortOrder = SortAction.Desc }); System.Data.DataTable dataTable = (System.Data.DataTable)couponInfos.Data; if (dataTable.Rows.Count > 0) { dataTable.Columns.Add("useConditon"); dataTable.Columns.Add("ReceivNum"); for (int i = 0; i < dataTable.Rows.Count; i++) { decimal d = decimal.Parse(dataTable.Rows[i]["ConditionValue"].ToString()); if (d == 0m) { dataTable.Rows[i]["useConditon"] = "不限制"; } else { dataTable.Rows[i]["useConditon"] = "满" + d.ToString("F2") + "可使用"; } string text2 = dataTable.Rows[i]["maxReceivNum"].ToString(); if (text2 == "0") { dataTable.Rows[i]["ReceivNum"] = "无限制"; } else { dataTable.Rows[i]["ReceivNum"] = text2 + "/张每人"; } } } this.grdCoupondsList.DataSource = dataTable; this.grdCoupondsList.DataBind(); this.pager1.TotalRecords = couponInfos.TotalRecords; }
private void BindData() { string text = ""; string selectedValue = ""; decimal? nullable = null; decimal? nullable2 = null; DateTime?selectedDate = null; DateTime?nullable4 = null; text = this.txt_name.Text; decimal i = 0M; DateTime now = DateTime.Now; if (this.bDecimal(this.txt_minVal.Text, ref i)) { nullable = new decimal?(i); } if (this.bDecimal(this.txt_maxVal.Text, ref i)) { nullable2 = new decimal?(i); } selectedDate = this.calendarStartDate.SelectedDate; nullable4 = this.calendarEndDate.SelectedDate; selectedValue = this.ddlCouponType.SelectedValue; CouponsSearch search = new CouponsSearch { CouponName = text, minValue = nullable, maxValue = nullable2, beginDate = selectedDate, endDate = nullable4, IsCount = true, PageIndex = this.pager1.PageIndex, PageSize = this.pager1.PageSize, SortBy = "CouponId", SortOrder = SortAction.Desc, Finished = new bool?(bFininshed), SearchType = new int?(string.IsNullOrEmpty(selectedValue) ? 0 : int.Parse(selectedValue)) }; DbQueryResult couponInfos = CouponHelper.GetCouponInfos(search); if (couponInfos != null) { DataTable data = (DataTable)couponInfos.Data; if (data.Rows.Count > 0) { data.Columns.Add("useConditon"); data.Columns.Add("ReceivNum"); data.Columns.Add("expire"); for (int j = 0; j < data.Rows.Count; j++) { decimal num3 = decimal.Parse(data.Rows[j]["ConditionValue"].ToString()); if (num3 == 0M) { data.Rows[j]["useConditon"] = "不限制"; } else { data.Rows[j]["useConditon"] = "满" + num3.ToString("F2") + "可使用"; } string str3 = data.Rows[j]["maxReceivNum"].ToString(); if (str3 == "0") { data.Rows[j]["ReceivNum"] = "无限制"; } else { data.Rows[j]["ReceivNum"] = str3 + "/张每人"; } data.Rows[j]["expire"] = DateTime.Parse(data.Rows[j]["EndDate"].ToString()) <= DateTime.Now; } } this.grdCoupondsList.DataSource = data; this.grdCoupondsList.DataBind(); } this.pager1.TotalRecords = couponInfos.TotalRecords; }
private void BindData() { string text = ""; decimal? nullable = null; decimal? nullable2 = null; DateTime?nullable3 = null; DateTime?nullable4 = null; text = this.txt_name.Text; decimal i = 0M; DateTime now = DateTime.Now; if (this.bDecimal(this.txt_minVal.Text, ref i)) { nullable = new decimal?(i); } if (this.bDecimal(this.txt_maxVal.Text, ref i)) { nullable2 = new decimal?(i); } if (this.bDate(this.calendarStartDate.Text, ref now)) { nullable3 = new DateTime?(now); } if (this.bDate(this.calendarEndDate.Text, ref now)) { nullable4 = new DateTime?(now); } CouponsSearch search = new CouponsSearch { CouponName = text, minValue = nullable, maxValue = nullable2, beginDate = nullable3, endDate = nullable4, IsCount = true, PageIndex = this.pager1.PageIndex, PageSize = this.pager1.PageSize, SortBy = "CouponId", SortOrder = SortAction.Desc }; DbQueryResult couponInfos = CouponHelper.GetCouponInfos(search); DataTable data = (DataTable)couponInfos.Data; if (data.Rows.Count > 0) { data.Columns.Add("useConditon"); data.Columns.Add("ReceivNum"); for (int j = 0; j < data.Rows.Count; j++) { decimal num3 = decimal.Parse(data.Rows[j]["ConditionValue"].ToString()); if (num3 == 0M) { data.Rows[j]["useConditon"] = "不限制"; } else { data.Rows[j]["useConditon"] = "满" + num3.ToString("F2") + "可使用"; } string str2 = data.Rows[j]["maxReceivNum"].ToString(); if (str2 == "0") { data.Rows[j]["ReceivNum"] = "无限制"; } else { data.Rows[j]["ReceivNum"] = str2 + "/张每人"; } } } this.grdCoupondsList.DataSource = data; this.grdCoupondsList.DataBind(); this.pager1.TotalRecords = couponInfos.TotalRecords; }
public DbQueryResult GetCouponsTable(HttpContext context) { return(CouponHelper.GetCouponInfos(this.GetCouponsSearch(context))); }
public void LoadCoupon() { if (!string.IsNullOrEmpty(this.context.Request["PageSize"]) && !string.IsNullOrEmpty(this.context.Request["CurrentPage"])) { int pageSize = int.Parse(this.context.Request["PageSize"]); int pageIndex = int.Parse(this.context.Request["CurrentPage"]); int value = 0; int.TryParse(this.context.Request["obtainWay"], out value); int num = 0; MemberInfo user = Users.GetUser(HiContext.Current.UserId); if (user != null) { num = user.UserId; } CouponsSearch couponsSearch = new CouponsSearch(); couponsSearch.ObtainWay = value; couponsSearch.PageIndex = pageIndex; couponsSearch.PageSize = pageSize; couponsSearch.IsValid = true; DbQueryResult couponInfos = CouponHelper.GetCouponInfos(couponsSearch, ""); DataTable data = couponInfos.Data; string str = "{\"totalCount\":\"" + couponInfos.TotalRecords + "\",\"data\":["; string text = ""; for (int i = 0; i < data.Rows.Count; i++) { if (text != "") { text += ","; } object[] obj = new object[24] { text, "{\"CouponId\":\"", data.Rows[i]["CouponId"], "\",\"CouponName\":\"", data.Rows[i]["CouponName"], "\",\"Price\":\"", data.Rows[i]["Price"], "\",\"SendCount\":\"", data.Rows[i]["SendCount"], "\",\"UserLimitCount\":\"", data.Rows[i]["UserLimitCount"], "\",\"OrderUseLimit\":\"", data.Rows[i]["OrderUseLimit"], "\",\"StartTime\":\"", null, null, null, null, null, null, null, null, null, null }; DateTime dateTime = DateTime.Parse(data.Rows[i]["StartTime"].ToString()); obj[14] = dateTime.ToString("yyyy.MM.dd"); obj[15] = "\",\"ClosingTime\":\""; dateTime = DateTime.Parse(data.Rows[i]["ClosingTime"].ToString()); obj[16] = dateTime.ToString("yyyy.MM.dd"); obj[17] = "\",\"CanUseProducts\":\""; obj[18] = data.Rows[i]["CanUseProducts"]; obj[19] = "\",\"ObtainWay\":\""; obj[20] = data.Rows[i]["ObtainWay"]; obj[21] = "\",\"NeedPoint\":\""; obj[22] = data.Rows[i]["NeedPoint"]; obj[23] = "\"}"; text = string.Concat(obj); } str += text; str += "]}"; this.context.Response.Write(str); } }
private void BindData() { decimal?minValue = null; decimal?maxValue = null; System.DateTime?beginDate = null; System.DateTime?endDate = null; string text = this.txt_name.Text; decimal value = 0m; System.DateTime arg_45_0 = System.DateTime.Now; if (this.bDecimal(this.txt_minVal.Text, ref value)) { minValue = new decimal?(value); } if (this.bDecimal(this.txt_maxVal.Text, ref value)) { maxValue = new decimal?(value); } beginDate = this.calendarStartDate.SelectedDate; endDate = this.calendarEndDate.SelectedDate; string selectedValue = this.ddlCouponType.SelectedValue; DbQueryResult couponInfos = CouponHelper.GetCouponInfos(new CouponsSearch { CouponName = text, minValue = minValue, maxValue = maxValue, beginDate = beginDate, endDate = endDate, IsCount = true, PageIndex = this.pager1.PageIndex, PageSize = this.pager1.PageSize, SortBy = "CouponId", SortOrder = SortAction.Desc, Finished = new bool?(CouponsList.bFininshed), SearchType = new int?(string.IsNullOrEmpty(selectedValue) ? 0 : int.Parse(selectedValue)) }); if (couponInfos != null) { System.Data.DataTable dataTable = (System.Data.DataTable)couponInfos.Data; if (dataTable.Rows.Count > 0) { dataTable.Columns.Add("useConditon"); dataTable.Columns.Add("ReceivNum"); dataTable.Columns.Add("expire"); for (int i = 0; i < dataTable.Rows.Count; i++) { decimal d = decimal.Parse(dataTable.Rows[i]["ConditionValue"].ToString()); if (d == 0m) { dataTable.Rows[i]["useConditon"] = "不限制"; } else { dataTable.Rows[i]["useConditon"] = "满" + d.ToString("F2") + "可使用"; } string text2 = dataTable.Rows[i]["maxReceivNum"].ToString(); if (text2 == "0") { dataTable.Rows[i]["ReceivNum"] = "无限制"; } else { dataTable.Rows[i]["ReceivNum"] = text2 + "/张每人"; } dataTable.Rows[i]["expire"] = (System.DateTime.Parse(dataTable.Rows[i]["EndDate"].ToString()) <= System.DateTime.Now); } } this.grdCoupondsList.DataSource = dataTable; this.grdCoupondsList.DataBind(); } this.pager1.TotalRecords = couponInfos.TotalRecords; }