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 sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, builder.ToString(), "ORDER BY ID");
using (var rdr = ExecuteReader(sqlSelect))
{
while (rdr.Read())
{
var couponSnInfo = new CouponSnInfo(rdr);
list.Add(couponSnInfo);
}
rdr.Close();
}
return(list);
}
public void Update(CouponSnInfo couponSnInfo)
{
IDataParameter[] parms = null;
var sqlUpdate = BaiRongDataProvider.TableStructureDao.GetUpdateSqlString(couponSnInfo.ToNameValueCollection(), ConnectionString, TableName, out parms);
ExecuteNonQuery(sqlUpdate, parms);
}
public int Insert(CouponSnInfo couponSnInfo)
{
var couponSnid = 0;
IDataParameter[] parms = null;
var sqlInsert = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(couponSnInfo.ToNameValueCollection(), ConnectionString, TableName, out parms);
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
couponSnid = ExecuteNonQueryAndReturnId(trans, sqlInsert, parms);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
return(couponSnid);
}
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 CouponSnInfo GetSnInfo(int snId)
{
CouponSnInfo snInfo = null;
string sqlWhere = $"WHERE ID = {snId}";
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null);
using (var rdr = ExecuteReader(sqlSelect))
{
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 sqlWhere =
$"WHERE {CouponSnAttribute.PublishmentSystemId} = {publishmentSystemId} AND {CouponSnAttribute.CouponId} = {couponId}";
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null);
using (var rdr = ExecuteReader(sqlSelect))
{
while (rdr.Read())
{
var couponSnInfo = new CouponSnInfo(rdr);
couponSnInfoList.Add(couponSnInfo);
}
rdr.Close();
}
return(couponSnInfoList);
}
