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