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