public static string GetRedirectUrl(int publishmentSystemId, ELotteryType lotteryType)
{
return(PageUtils.GetWeiXinUrl(nameof(PageLottery), new NameValueCollection
{
{ "publishmentSystemId", publishmentSystemId.ToString() },
{ "lotteryType", ELotteryTypeUtils.GetValue(lotteryType) }
}));
}
public static string GetEndImageUrl(PublishmentSystemInfo publishmentSystemInfo, ELotteryType lotteryType, string endImageUrl)
{
if (!string.IsNullOrEmpty(endImageUrl))
{
return(PageUtils.AddProtocolToUrl(PageUtility.ParseNavigationUrl(publishmentSystemInfo, endImageUrl)));
}
var directoryName = "img" + ELotteryTypeUtils.GetValue(lotteryType);
return(PageUtils.AddProtocolToUrl(SiteFilesAssets.GetUrl(publishmentSystemInfo.Additional.ApiUrl, $"weixin/lottery/{directoryName}/end.jpg")));
}
public static string GetOpenWindowStringByLottery(int publishmentSystemID, ELotteryType lotteryType, int lotteryID)
{
var arguments = new NameValueCollection();
arguments.Add("publishmentSystemID", publishmentSystemID.ToString());
arguments.Add("lotteryType", ELotteryTypeUtils.GetValue(lotteryType));
arguments.Add("lotteryID", lotteryID.ToString());
return(JsUtils.OpenWindow.GetOpenWindowString("导出CSV", "modal_export.aspx", arguments, 400, 240, true));
}
public static string GetOpenWindowStringByLottery(int publishmentSystemId, ELotteryType lotteryType, int lotteryId)
{
return(PageUtils.GetOpenWindowString("导出CSV",
PageUtils.GetWeiXinUrl(nameof(ModalExport), new NameValueCollection
{
{ "publishmentSystemId", publishmentSystemId.ToString() },
{ "lotteryType", ELotteryTypeUtils.GetValue(lotteryType) },
{ "lotteryId", lotteryId.ToString() }
}), 400, 240, true));
}
public static string GetRedirectUrl(int publishmentSystemId, ELotteryType lotteryType, int lotteryId, int awardId, string returnUrl)
{
return(PageUtils.GetWeiXinUrl(nameof(PageLotteryWinner), new NameValueCollection
{
{ "publishmentSystemId", publishmentSystemId.ToString() },
{ "lotteryType", ELotteryTypeUtils.GetValue(lotteryType) },
{ "lotteryId", lotteryId.ToString() },
{ "awardId", awardId.ToString() },
{ "returnUrl", StringUtils.ValueToUrl(returnUrl) }
}));
}
public static string GetContentAwardImageUrl(PublishmentSystemInfo publishmentSystemInfo, ELotteryType lotteryType, string contentImageUrl, int awardCount)
{
if (!string.IsNullOrEmpty(contentImageUrl))
{
return(PageUtils.AddProtocolToUrl(PageUtility.ParseNavigationUrl(publishmentSystemInfo, contentImageUrl)));
}
var fileName = awardCount + ".png";
if (awardCount < 2 || awardCount > 9)
{
fileName = "contentAward.png";
}
var directoryName = "img" + ELotteryTypeUtils.GetValue(lotteryType);
return(PageUtils.AddProtocolToUrl(SiteFilesAssets.GetUrl(publishmentSystemInfo.Additional.ApiUrl, $"weixin/lottery/{directoryName}/{fileName}")));
}
public int GetTotalNum(int publishmentSystemID, ELotteryType lotteryType, int lotteryID)
{
string sqlString =
$"SELECT COUNT(*) FROM {TABLE_NAME} WHERE {LotteryWinnerAttribute.PublishmentSystemID} = {publishmentSystemID} AND {LotteryWinnerAttribute.LotteryType} = '{ELotteryTypeUtils.GetValue(lotteryType)}'";
if (lotteryID > 0)
{
sqlString =
$"SELECT COUNT(*) FROM {TABLE_NAME} WHERE {LotteryWinnerAttribute.PublishmentSystemID} = {publishmentSystemID} AND {LotteryWinnerAttribute.LotteryID} = {lotteryID}";
}
return(BaiRongDataProvider.DatabaseDao.GetIntResult(sqlString));
}
public List <LotteryWinnerInfo> GetWinnerInfoList(int publishmentSystemID, ELotteryType lotteryType, int lotteryID)
{
var winnerInfoList = new List <LotteryWinnerInfo>();
string SQL_WHERE =
$"WHERE {LotteryWinnerAttribute.PublishmentSystemID} = {publishmentSystemID} AND {LotteryWinnerAttribute.LotteryType} = '{ELotteryTypeUtils.GetValue(lotteryType)}'";
if (lotteryID > 0)
{
SQL_WHERE =
$"WHERE {LotteryWinnerAttribute.PublishmentSystemID} = {publishmentSystemID} AND {LotteryWinnerAttribute.LotteryID} = {lotteryID}";
}
var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, "ORDER BY ID DESC");
using (var rdr = ExecuteReader(SQL_SELECT))
{
while (rdr.Read())
{
var winnerInfo = new LotteryWinnerInfo(rdr);
winnerInfoList.Add(winnerInfo);
}
rdr.Close();
}
return(winnerInfoList);
}
public List <LotteryWinnerInfo> GetWinnerInfoList(int publishmentSystemId, ELotteryType lotteryType, int lotteryId)
{
var winnerInfoList = new List <LotteryWinnerInfo>();
string sqlWhere =
$"WHERE {LotteryWinnerAttribute.PublishmentSystemId} = {publishmentSystemId} AND {LotteryWinnerAttribute.LotteryType} = '{ELotteryTypeUtils.GetValue(lotteryType)}'";
if (lotteryId > 0)
{
sqlWhere =
$"WHERE {LotteryWinnerAttribute.PublishmentSystemId} = {publishmentSystemId} AND {LotteryWinnerAttribute.LotteryId} = {lotteryId}";
}
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, "ORDER BY ID DESC");
using (var rdr = ExecuteReader(sqlSelect))
{
while (rdr.Read())
{
var winnerInfo = new LotteryWinnerInfo(rdr);
winnerInfoList.Add(winnerInfo);
}
rdr.Close();
}
return(winnerInfoList);
}
public List <int> GetLotteryIDList(int publishmentSystemID, ELotteryType lotteryType)
{
var lotteryIDList = new List <int>();
string SQL_WHERE =
$"WHERE {LotteryAttribute.PublishmentSystemID} = {publishmentSystemID} AND {LotteryAttribute.LotteryType} = '{ELotteryTypeUtils.GetValue(lotteryType)}'";
var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, LotteryAttribute.ID, SQL_WHERE, null);
using (var rdr = ExecuteReader(SQL_SELECT))
{
while (rdr.Read())
{
lotteryIDList.Add(rdr.GetInt32(0));
}
rdr.Close();
}
return(lotteryIDList);
}
public string GetSelectString(int publishmentSystemID, ELotteryType lotteryType)
{
string whereString =
$"WHERE {LotteryAttribute.PublishmentSystemID} = {publishmentSystemID} AND {LotteryAttribute.LotteryType} = '{ELotteryTypeUtils.GetValue(lotteryType)}'";
return(BaiRongDataProvider.TableStructureDao.GetSelectSqlString(TABLE_NAME, SqlUtils.Asterisk, whereString));
}
public int GetFirstIDByKeywordID(int publishmentSystemID, ELotteryType lotteryType, int keywordID)
{
string sqlString =
$"SELECT TOP 1 ID FROM {TABLE_NAME} WHERE {LotteryAttribute.PublishmentSystemID} = {publishmentSystemID} AND {LotteryAttribute.LotteryType} = '{ELotteryTypeUtils.GetValue(lotteryType)}' AND {LotteryAttribute.IsDisabled} <> '{true}' AND {LotteryAttribute.KeywordID} = {keywordID}";
return(BaiRongDataProvider.DatabaseDao.GetIntResult(sqlString));
}
public List <int> GetLotteryIdList(int publishmentSystemId, ELotteryType lotteryType)
{
var lotteryIdList = new List <int>();
string sqlWhere =
$"WHERE {LotteryAttribute.PublishmentSystemId} = {publishmentSystemId} AND {LotteryAttribute.LotteryType} = '{ELotteryTypeUtils.GetValue(lotteryType)}'";
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, LotteryAttribute.Id, sqlWhere, null);
using (var rdr = ExecuteReader(sqlSelect))
{
while (rdr.Read())
{
lotteryIdList.Add(rdr.GetInt32(0));
}
rdr.Close();
}
return(lotteryIdList);
}
public List <LotteryInfo> GetLotteryInfoListByKeywordId(int publishmentSystemId, ELotteryType lotteryType, int keywordId)
{
var lotteryInfoList = new List <LotteryInfo>();
string sqlWhere =
$"WHERE {LotteryAttribute.PublishmentSystemId} = {publishmentSystemId} AND {LotteryAttribute.LotteryType} = '{ELotteryTypeUtils.GetValue(lotteryType)}' AND {LotteryAttribute.IsDisabled} <> '{true}'";
if (keywordId > 0)
{
sqlWhere += $" AND {LotteryAttribute.KeywordId} = {keywordId}";
}
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null);
using (var rdr = ExecuteReader(sqlSelect))
{
while (rdr.Read())
{
var lotteryInfo = new LotteryInfo(rdr);
lotteryInfoList.Add(lotteryInfo);
}
rdr.Close();
}
return(lotteryInfoList);
}
public static string GetRedirectUrl(int publishmentSystemID, ELotteryType lotteryType, int lotteryID, int awardID, string returnUrl)
{
return(PageUtils.GetWXUrl(
$"background_lotteryWinner.aspx?publishmentSystemID={publishmentSystemID}&lotteryType={ELotteryTypeUtils.GetValue(lotteryType)}&lotteryID={lotteryID}&awardID={awardID}&returnUrl={StringUtils.ValueToUrl(returnUrl)}"));
}
public static string GetRedirectUrl(int publishmentSystemID, ELotteryType lotteryType)
{
return(PageUtils.GetWXUrl(
$"background_lottery.aspx?PublishmentSystemID={publishmentSystemID}&lotteryType={ELotteryTypeUtils.GetValue(lotteryType)}"));
}
public string GetSelectString(int publishmentSystemID, ELotteryType lotteryType, int lotteryID, int awardID)
{
string whereString =
$"WHERE {LotteryWinnerAttribute.PublishmentSystemID} = {publishmentSystemID} AND {LotteryWinnerAttribute.LotteryType} = '{ELotteryTypeUtils.GetValue(lotteryType)}'";
if (lotteryID > 0)
{
whereString =
$"WHERE {LotteryWinnerAttribute.PublishmentSystemID} = {publishmentSystemID} AND {LotteryWinnerAttribute.LotteryID} = {lotteryID}";
}
if (awardID > 0)
{
whereString = $" AND {LotteryWinnerAttribute.AwardID} = {awardID}";
}
return(BaiRongDataProvider.TableStructureDao.GetSelectSqlString(TABLE_NAME, SqlUtils.Asterisk, whereString));
}
public List <LotteryInfo> GetLotteryInfoListByKeywordID(int publishmentSystemID, ELotteryType lotteryType, int keywordID)
{
var lotteryInfoList = new List <LotteryInfo>();
string SQL_WHERE =
$"WHERE {LotteryAttribute.PublishmentSystemID} = {publishmentSystemID} AND {LotteryAttribute.LotteryType} = '{ELotteryTypeUtils.GetValue(lotteryType)}' AND {LotteryAttribute.IsDisabled} <> '{true}'";
if (keywordID > 0)
{
SQL_WHERE += $" AND {LotteryAttribute.KeywordID} = {keywordID}";
}
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 lotteryInfo = new LotteryInfo(rdr);
lotteryInfoList.Add(lotteryInfo);
}
rdr.Close();
}
return(lotteryInfoList);
}
public override void Submit_OnClick(object sender, EventArgs e)
{
if (Page.IsPostBack && Page.IsValid)
{
var selectedStep = 0;
if (phStep1.Visible)
{
selectedStep = 1;
}
else if (phStep2.Visible)
{
selectedStep = 2;
}
else if (phStep3.Visible)
{
selectedStep = 3;
}
else if (phStep4.Visible)
{
selectedStep = 4;
}
else if (phStep5.Visible)
{
selectedStep = 5;
}
phStep1.Visible = phStep2.Visible = phStep3.Visible = phStep4.Visible = phStep5.Visible = false;
if (selectedStep == 1)
{
var isConflict = false;
var conflictKeywords = string.Empty;
if (!string.IsNullOrEmpty(tbKeywords.Text))
{
if (lotteryID > 0)
{
var lotteryInfo = DataProviderWX.LotteryDAO.GetLotteryInfo(lotteryID);
isConflict = KeywordManager.IsKeywordUpdateConflict(PublishmentSystemID, lotteryInfo.KeywordID, PageUtils.FilterXSS(tbKeywords.Text), out conflictKeywords);
}
else
{
isConflict = KeywordManager.IsKeywordInsertConflict(PublishmentSystemID, PageUtils.FilterXSS(tbKeywords.Text), out conflictKeywords);
}
}
if (isConflict)
{
FailMessage($"触发关键词“{conflictKeywords}”已存在，请设置其他关键词");
phStep1.Visible = true;
}
else
{
phStep2.Visible = true;
}
}
else if (selectedStep == 2)
{
phStep3.Visible = true;
}
else if (selectedStep == 3)
{
var isItemReady = true;
var awardMaxCount = TranslateUtils.ToInt(tbAwardMaxCount.Text);
var awardMaxDailyCount = TranslateUtils.ToInt(tbAwardMaxDailyCount.Text);
if (awardMaxDailyCount > awardMaxCount)
{
FailMessage("摇摇乐保存失败，每人每天最多允许抽奖次数必须小于每人最多抽奖次数");
isItemReady = false;
}
if (isItemReady)
{
var itemCount = TranslateUtils.ToInt(Request.Form["itemCount"]);
if (itemCount < 1)
{
FailMessage("摇摇乐保存失败，至少需要设置一个奖项");
isItemReady = false;
}
else
{
var itemIDList = TranslateUtils.StringCollectionToIntList(Request.Form["itemID"]);
var awardNameList = TranslateUtils.StringCollectionToStringList(Request.Form["itemAwardName"]);
var titleList = TranslateUtils.StringCollectionToStringList(Request.Form["itemTitle"]);
var totalNumList = TranslateUtils.StringCollectionToIntList(Request.Form["itemTotalNum"]);
var probabilityList = TranslateUtils.StringCollectionToDecimalList(Request.Form["itemProbability"]);
decimal probabilityAll = 0;
var awardInfoList = new List <LotteryAwardInfo>();
for (var i = 0; i < itemCount; i++)
{
var awardInfo = new LotteryAwardInfo {
ID = itemIDList[i], PublishmentSystemID = PublishmentSystemID, LotteryID = lotteryID, AwardName = awardNameList[i], Title = titleList[i], TotalNum = totalNumList[i], Probability = probabilityList[i]
};
if (string.IsNullOrEmpty(awardInfo.AwardName))
{
FailMessage("保存失败，奖项名称为必填项");
isItemReady = false;
}
if (string.IsNullOrEmpty(awardInfo.Title))
{
FailMessage("保存失败，奖品名为必填项");
isItemReady = false;
}
if (awardInfo.Probability < 0 || awardInfo.Probability > 100)
{
FailMessage("保存失败，各项中奖概率总和不能超过100%");
isItemReady = false;
}
probabilityAll += awardInfo.Probability;
awardInfoList.Add(awardInfo);
}
if (probabilityAll <= 0 || probabilityAll > 100)
{
FailMessage("摇摇乐保存失败，获奖概率之和必须在1%到100%之间");
isItemReady = false;
}
if (isItemReady)
{
DataProviderWX.LotteryAwardDAO.DeleteAllNotInIDList(PublishmentSystemID, lotteryID, itemIDList);
foreach (var awardInfo in awardInfoList)
{
var newAwardInfo = DataProviderWX.LotteryAwardDAO.GetAwardInfo(awardInfo.ID);
if (awardInfo.ID > 0)
{
var wonNum = DataProviderWX.LotteryWinnerDAO.GetTotalNum(awardInfo.ID);
if (awardInfo.TotalNum < wonNum)
{
awardInfo.TotalNum = wonNum;
}
awardInfo.WonNum = newAwardInfo.WonNum;
DataProviderWX.LotteryAwardDAO.Update(awardInfo);
}
else
{
DataProviderWX.LotteryAwardDAO.Insert(awardInfo);
}
}
}
}
}
if (isItemReady)
{
phStep4.Visible = true;
}
else
{
phStep3.Visible = true;
}
}
else if (selectedStep == 4)
{
phStep5.Visible = true;
btnSubmit.Text = "确 认";
}
else if (selectedStep == 5)
{
var lotteryInfo = new LotteryInfo();
if (lotteryID > 0)
{
lotteryInfo = DataProviderWX.LotteryDAO.GetLotteryInfo(lotteryID);
}
lotteryInfo.PublishmentSystemID = PublishmentSystemID;
lotteryInfo.LotteryType = ELotteryTypeUtils.GetValue(ELotteryType.YaoYao);
lotteryInfo.KeywordID = DataProviderWX.KeywordDAO.GetKeywordID(PublishmentSystemID, lotteryID > 0, tbKeywords.Text, EKeywordType.YaoYao, lotteryInfo.KeywordID);
lotteryInfo.IsDisabled = !cbIsEnabled.Checked;
lotteryInfo.StartDate = dtbStartDate.DateTime;
lotteryInfo.EndDate = dtbEndDate.DateTime;
lotteryInfo.Title = PageUtils.FilterXSS(tbTitle.Text);
lotteryInfo.ImageUrl = imageUrl.Value;;
lotteryInfo.Summary = tbSummary.Text;
lotteryInfo.ContentImageUrl = contentImageUrl.Value;
lotteryInfo.ContentUsage = tbContentUsage.Text;
lotteryInfo.AwardUsage = tbAwardUsage.Text;
lotteryInfo.IsAwardTotalNum = cbIsAwardTotalNum.Checked;
lotteryInfo.AwardMaxCount = TranslateUtils.ToInt(tbAwardMaxCount.Text);
lotteryInfo.AwardMaxDailyCount = TranslateUtils.ToInt(tbAwardMaxDailyCount.Text);
lotteryInfo.AwardCode = tbAwardCode.Text;
lotteryInfo.AwardImageUrl = awardImageUrl.Value;
lotteryInfo.IsFormRealName = cbIsFormRealName.Checked;
lotteryInfo.FormRealNameTitle = tbFormRealNameTitle.Text;
lotteryInfo.IsFormMobile = cbIsFormMobile.Checked;
lotteryInfo.FormMobileTitle = tbFormMobileTitle.Text;
lotteryInfo.IsFormEmail = cbIsFormEmail.Checked;
lotteryInfo.FormEmailTitle = tbFormEmailTitle.Text;
lotteryInfo.IsFormAddress = cbIsFormAddress.Checked;
lotteryInfo.FormAddressTitle = tbFormAddressTitle.Text;
lotteryInfo.EndTitle = tbEndTitle.Text;
lotteryInfo.EndImageUrl = endImageUrl.Value;
lotteryInfo.EndSummary = tbEndSummary.Text;
try
{
if (lotteryID > 0)
{
DataProviderWX.LotteryDAO.Update(lotteryInfo);
LogUtils.AddLog(BaiRongDataProvider.AdministratorDao.UserName, "修改摇摇乐",
$"摇摇乐:{tbTitle.Text}");
SuccessMessage("修改摇摇乐成功！");
}
else
{
lotteryID = DataProviderWX.LotteryDAO.Insert(lotteryInfo);
DataProviderWX.LotteryAwardDAO.UpdateLotteryID(PublishmentSystemID, lotteryID);
LogUtils.AddLog(BaiRongDataProvider.AdministratorDao.UserName, "添加摇摇乐",
$"摇摇乐:{tbTitle.Text}");
SuccessMessage("添加摇摇乐成功！");
}
var redirectUrl = BackgroundLottery.GetRedirectUrl(PublishmentSystemID, ELotteryType.YaoYao);
AddWaitAndRedirectScript(redirectUrl);
}
catch (Exception ex)
{
FailMessage(ex, "摇摇乐设置失败！");
}
}
}
}
private static string GetLotteryUrl(PublishmentSystemInfo publishmentSystemInfo, LotteryInfo lotteryInfo)
{
var fileName = ELotteryTypeUtils.GetValue(ELotteryTypeUtils.GetEnumType(lotteryInfo.LotteryType)).ToLower();
return(PageUtils.AddProtocolToUrl(SiteFilesAssets.GetUrl(publishmentSystemInfo.Additional.ApiUrl, $"weixin/lottery/{fileName}.html")));
}
