void rptContents_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { var snInfo = new CouponSNInfo(e.Item.DataItem); var ltlItemIndex = e.Item.FindControl("ltlItemIndex") as Literal; var ltlSN = e.Item.FindControl("ltlSN") as Literal; var ltlStatus = e.Item.FindControl("ltlStatus") as Literal; var ltlHoldDate = e.Item.FindControl("ltlHoldDate") as Literal; var ltlHoldMobile = e.Item.FindControl("ltlHoldMobile") as Literal; var ltlHoldEmail = e.Item.FindControl("ltlHoldEmail") as Literal; var ltlHoldRealName = e.Item.FindControl("ltlHoldRealName") as Literal; var ltlCashDate = e.Item.FindControl("ltlCashDate") as Literal; var ltlCashUserName = e.Item.FindControl("ltlCashUserName") as Literal; ltlItemIndex.Text = (e.Item.ItemIndex + 1).ToString(); ltlSN.Text = snInfo.SN; var status = ECouponStatusUtils.GetEnumType(snInfo.Status); ltlStatus.Text = ECouponStatusUtils.GetText(status); if (status == ECouponStatus.Cash || status == ECouponStatus.Hold) { ltlHoldDate.Text = DateUtils.GetDateAndTimeString(snInfo.HoldDate); ltlHoldMobile.Text = snInfo.HoldMobile; ltlHoldEmail.Text = snInfo.HoldEmail; ltlHoldRealName.Text = snInfo.HoldRealName; } if (status == ECouponStatus.Cash) { ltlCashDate.Text = DateUtils.GetDateAndTimeString(snInfo.CashDate); ltlCashUserName.Text = snInfo.HoldRealName; } } }
public void Page_Load(object sender, EventArgs e) { if (IsForbidden) { return; } couponID = TranslateUtils.ToInt(GetQueryString("couponID")); if (!IsPostBack) { ECouponStatusUtils.AddListItems(ddlStatus); } }
public void Page_Load(object sender, EventArgs e) { if (IsForbidden) { return; } _couponId = Body.GetQueryInt("couponID"); if (!IsPostBack) { ECouponStatusUtils.AddListItems(DdlStatus); } }
public void UpdateStatus(ECouponStatus status, List <int> snIdList) { string sqlString = $"UPDATE {TableName} SET {CouponSnAttribute.Status} = '{ECouponStatusUtils.GetValue(status)}' WHERE ID IN ({TranslateUtils.ToSqlInStringWithoutQuote(snIdList)})"; if (status == ECouponStatus.Cash) { sqlString = $"UPDATE {TableName} SET {CouponSnAttribute.Status} = '{ECouponStatusUtils.GetValue(status)}', {CouponSnAttribute.HoldDate} = getdate(), {CouponSnAttribute.CashDate} = getdate() WHERE ID IN ({TranslateUtils.ToSqlInStringWithoutQuote(snIdList)})"; } else if (status == ECouponStatus.Hold) { sqlString = $"UPDATE {TableName} SET {CouponSnAttribute.Status} = '{ECouponStatusUtils.GetValue(status)}', {CouponSnAttribute.HoldDate} = getdate() WHERE ID IN ({TranslateUtils.ToSqlInStringWithoutQuote(snIdList)})"; } ExecuteNonQuery(sqlString); }
public static int AddApplication(int publishmentSystemID, int actID, string uniqueID, string realName, string mobile, string email, string address) { try { var couponInfoList = DataProviderWX.CouponDAO.GetCouponInfoList(publishmentSystemID, actID); var snID = 0; var couponID = 0; var cookieSN = WeiXinManager.GetCookieSN(); snID = DataProviderWX.CouponSNDAO.Hold(publishmentSystemID, actID, cookieSN); var newCouponSNInfo = DataProviderWX.CouponSNDAO.GetSNInfo(snID); couponID = newCouponSNInfo.CouponID; var couponSNInfo = new CouponSNInfo(); couponSNInfo.PublishmentSystemID = publishmentSystemID; couponSNInfo.CookieSN = cookieSN; couponSNInfo.CouponID = couponID; couponSNInfo.ID = snID; couponSNInfo.HoldDate = DateTime.Now; couponSNInfo.HoldRealName = realName; couponSNInfo.HoldMobile = mobile; couponSNInfo.HoldEmail = email; couponSNInfo.HoldAddress = address; couponSNInfo.CashDate = DateTime.Now; couponSNInfo.Status = ECouponStatusUtils.GetValue(ECouponStatus.Hold); couponSNInfo.WXOpenID = uniqueID; if (newCouponSNInfo.Status == ECouponStatusUtils.GetValue(ECouponStatus.Cash)) { couponSNInfo.Status = ECouponStatusUtils.GetValue(ECouponStatus.Cash); } DataProviderWX.CouponSNDAO.Update(couponSNInfo); return(newCouponSNInfo.ID); } catch (Exception ex) { return(0); } }
public override void Submit_OnClick(object sender, EventArgs e) { var isChanged = false; try { DataProviderWX.CouponSNDAO.UpdateStatus(ECouponStatusUtils.GetEnumType(ddlStatus.SelectedValue), TranslateUtils.StringCollectionToIntList(Request.QueryString["IDCollection"])); isChanged = true; } catch (Exception ex) { FailMessage(ex, "失败:" + ex.Message); } if (isChanged) { JsUtils.OpenWindow.CloseModalPage(Page); } }
public int Hold(int publishmentSystemId, int actId, string cookieSn) { var snId = 0; string sqlString = $@"SELECT ID FROM wx_CouponSN WHERE PublishmentSystemID = {publishmentSystemId} AND CookieSN = '{cookieSn}' AND Status <> '{ECouponStatusUtils.GetValue(ECouponStatus.Unused)}' AND CouponID IN (SELECT ID FROM wx_Coupon WHERE ActID = {actId})"; using (var rdr = ExecuteReader(sqlString)) { if (rdr.Read()) { snId = rdr.GetInt32(0); } rdr.Close(); } if (snId == 0) { sqlString = $@"SELECT TOP 1 ID FROM wx_CouponSN WHERE PublishmentSystemID = {publishmentSystemId} AND Status = '{ECouponStatusUtils.GetValue(ECouponStatus.Unused)}' AND CouponID IN (SELECT ID FROM wx_Coupon WHERE ActID = {actId}) ORDER BY ID"; using (var rdr = ExecuteReader(sqlString)) { if (rdr.Read()) { snId = rdr.GetInt32(0); } rdr.Close(); } } return(snId); }
public void Insert(int publishmentSystemId, int couponId, List <string> snList) { foreach (var sn in snList) { if (!string.IsNullOrEmpty(sn)) { string sqlString = $"INSERT INTO {TableName} (PublishmentSystemID, CouponID, SN, Status) VALUES ({publishmentSystemId}, {couponId}, '{sn}', '{ECouponStatusUtils.GetValue(ECouponStatus.Unused)}')"; ExecuteNonQuery(sqlString); } } DataProviderWx.CouponDao.UpdateTotalNum(couponId, DataProviderWx.CouponSnDao.GetTotalNum(publishmentSystemId, couponId)); }
public void Insert(int publishmentSystemId, int couponId, int totalNum) { var couponSnList = CouponManager.GetCouponSN(totalNum); foreach (var sn in couponSnList) { string sqlString = $"INSERT INTO {TableName} (PublishmentSystemID, CouponID, SN, Status) VALUES ({publishmentSystemId}, {couponId}, '{sn}', '{ECouponStatusUtils.GetValue(ECouponStatus.Unused)}')"; ExecuteNonQuery(sqlString); } DataProviderWx.CouponDao.UpdateTotalNum(couponId, DataProviderWx.CouponSnDao.GetTotalNum(publishmentSystemId, couponId)); }
public int GetCashNum(int publishmentSystemId, int couponId) { string sqlString = $"SELECT COUNT(*) FROM {TableName} WHERE {CouponSnAttribute.PublishmentSystemId} = {publishmentSystemId} AND {CouponSnAttribute.CouponId} = {couponId} AND {CouponSnAttribute.Status} = '{ECouponStatusUtils.GetValue(ECouponStatus.Cash)}'"; return(BaiRongDataProvider.DatabaseDao.GetIntResult(sqlString)); }
public int GetHoldNum(int publishmentSystemID, int couponID) { string sqlString = $"SELECT COUNT(*) FROM {TABLE_NAME} WHERE {CouponSNAttribute.PublishmentSystemID} = {publishmentSystemID} AND {CouponSNAttribute.CouponID} = {couponID} AND ({CouponSNAttribute.Status} = '{ECouponStatusUtils.GetValue(ECouponStatus.Hold)}')"; return(BaiRongDataProvider.DatabaseDao.GetIntResult(sqlString)); }