public void Update(CouponSNInfo couponSNInfo) { IDataParameter[] parms = null; var SQL_UPDATE = BaiRongDataProvider.TableStructureDao.GetUpdateSqlString(couponSNInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms); ExecuteNonQuery(SQL_UPDATE, parms); }
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 List <CouponSNInfo> GetSNInfoByCookieSN(int publishmentSystemID, string cookieSN, string uniqueID) { var list = new List <CouponSNInfo>(); StringBuilder builder; if (string.IsNullOrEmpty(uniqueID)) { builder = new StringBuilder( $"WHERE {CouponSNAttribute.PublishmentSystemID} = {publishmentSystemID} AND {CouponSNAttribute.CookieSN} = '{PageUtils.FilterSql(cookieSN)}'"); } else { builder = new StringBuilder( $"WHERE {CouponSNAttribute.PublishmentSystemID} = {publishmentSystemID} AND {CouponSNAttribute.WXOpenID} = '{uniqueID}'"); } var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, builder.ToString(), "ORDER BY ID"); using (var rdr = ExecuteReader(SQL_SELECT)) { while (rdr.Read()) { var couponSnInfo = new CouponSNInfo(rdr); list.Add(couponSnInfo); } rdr.Close(); } return(list); }
public int Insert(CouponSNInfo couponSNInfo) { var couponSNID = 0; IDataParameter[] parms = null; var SQL_INSERT = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(couponSNInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms); using (var conn = GetConnection()) { conn.Open(); using (var trans = conn.BeginTransaction()) { try { ExecuteNonQuery(trans, SQL_INSERT, parms); couponSNID = BaiRongDataProvider.DatabaseDao.GetSequence(trans, TABLE_NAME); trans.Commit(); } catch { trans.Rollback(); throw; } } } return(couponSNID); }
public CouponSNInfo GetSNInfo(int snID) { CouponSNInfo snInfo = null; string SQL_WHERE = $"WHERE ID = {snID}"; var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, null); using (var rdr = ExecuteReader(SQL_SELECT)) { if (rdr.Read()) { snInfo = new CouponSNInfo(rdr); } rdr.Close(); } return(snInfo); }
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 List <CouponSNInfo> GetCouponSNInfoList(int publishmentSystemID, int couponID) { var couponSNInfoList = new List <CouponSNInfo>(); string SQL_WHERE = $"WHERE {CouponSNAttribute.PublishmentSystemID} = {publishmentSystemID} AND {CouponSNAttribute.CouponID} = {couponID}"; var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, null); using (var rdr = ExecuteReader(SQL_SELECT)) { while (rdr.Read()) { var couponSNInfo = new CouponSNInfo(rdr); couponSNInfoList.Add(couponSNInfo); } rdr.Close(); } return(couponSNInfoList); }