public void Update(CardSNInfo cardSNInfo)
{
IDataParameter[] parms = null;
var SQL_UPDATE = BaiRongDataProvider.TableStructureDao.GetUpdateSqlString(cardSNInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms);
ExecuteNonQuery(SQL_UPDATE, parms);
}
public ArrayList GetUserNameArrayList(int publishmentSystemID, int cardID, string cardSN, string userName)
{
var userNameArrayList = new ArrayList();
string SQL_WHERE = $"WHERE {CardSNAttribute.PublishmentSystemID} = {publishmentSystemID} ";
if (cardID > 0)
{
SQL_WHERE += $" AND CardID = {cardID}";
}
if (!string.IsNullOrEmpty(cardSN))
{
SQL_WHERE += $" AND {CardSNAttribute.SN}='{PageUtils.FilterSql(cardSN)}'";
}
if (!string.IsNullOrEmpty(userName))
{
SQL_WHERE += $" AND {CardSNAttribute.UserName} ='{PageUtils.FilterSql(userName)}'";
}
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 cardSNInfo = new CardSNInfo(rdr);
if (!userNameArrayList.Contains(cardSNInfo.UserName))
{
userNameArrayList.Add(cardSNInfo.UserName);
}
}
rdr.Close();
}
return(userNameArrayList);
}
public int Insert(CardSNInfo cardSNInfo)
{
var cardSNID = 0;
IDataParameter[] parms = null;
var SQL_INSERT = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(cardSNInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms);
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
ExecuteNonQuery(trans, SQL_INSERT, parms);
cardSNID = BaiRongDataProvider.DatabaseDao.GetSequence(trans, TABLE_NAME);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
return(cardSNID);
}
public CardSNInfo GetCardSNInfo(int publishmentSystemID, int cardID, string cardSN, string userName)
{
CardSNInfo cardSNInfo = null;
string SQL_WHERE = $"WHERE {CardSNAttribute.PublishmentSystemID} = {publishmentSystemID} ";
if (cardID > 0)
{
SQL_WHERE += $" AND {CardSNAttribute.CardID}='{cardID}'";
}
if (!string.IsNullOrEmpty(cardSN))
{
SQL_WHERE += $" AND {CardSNAttribute.SN}='{PageUtils.FilterSql(cardSN)}'";
}
if (!string.IsNullOrEmpty(userName))
{
SQL_WHERE += $" AND {CardSNAttribute.UserName}='{PageUtils.FilterSql(userName)}'";
}
var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, null);
using (var rdr = ExecuteReader(SQL_SELECT))
{
if (rdr.Read())
{
cardSNInfo = new CardSNInfo(rdr);
}
rdr.Close();
}
return(cardSNInfo);
}
public decimal GetAmount(int cardSNID, string userName)
{
decimal amount = 0;
string SQL_WHERE = $"WHERE ID = {cardSNID} AND userName='******'";
var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, null);
using (var rdr = ExecuteReader(SQL_SELECT))
{
if (rdr.Read())
{
var cardSNInfo = new CardSNInfo(rdr);
amount = cardSNInfo.Amount;
}
rdr.Close();
}
return(amount);
}
public CardSNInfo GetCardSNInfo(int cardSNID)
{
CardSNInfo cardSNInfo = null;
string SQL_WHERE = $"WHERE ID = {cardSNID}";
var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, null);
using (var rdr = ExecuteReader(SQL_SELECT))
{
if (rdr.Read())
{
cardSNInfo = new CardSNInfo(rdr);
}
rdr.Close();
}
return(cardSNInfo);
}
public List <CardSNInfo> GetCardSNInfoList(int publishmentSystemID, int cardID)
{
var cardSNInfoList = new List <CardSNInfo>();
string SQL_WHERE =
$"WHERE {CardSNAttribute.PublishmentSystemID} = {publishmentSystemID} AND {CardSNAttribute.CardID} = {cardID}";
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 cardSNInfo = new CardSNInfo(rdr);
cardSNInfoList.Add(cardSNInfo);
}
rdr.Close();
}
return(cardSNInfoList);
}
void rptContents_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var cardSNInfo = new CardSNInfo(e.Item.DataItem);
var userInfo = BaiRongDataProvider.UserDao.GetUserInfoByUserName(cardSNInfo.UserName);
var userContactInfo = BaiRongDataProvider.UserContactDao.GetContactInfo(cardSNInfo.UserName);
var ltlItemIndex = e.Item.FindControl("ltlItemIndex") as Literal;
var ltlSN = e.Item.FindControl("ltlSN") as Literal;
var ltlUserName = e.Item.FindControl("ltlUserName") as Literal;
var ltlMobile = e.Item.FindControl("ltlMobile") as Literal;
var ltlAmount = e.Item.FindControl("ltlAmount") as Literal;
var ltlCredits = e.Item.FindControl("ltlCredits") as Literal;
var ltlAddDate = e.Item.FindControl("ltlAddDate") as Literal;
var ltlIsDisabled = e.Item.FindControl("ltlIsDisabled") as Literal;
var ltlConsumeUrl = e.Item.FindControl("ltlConsumeUrl") as Literal;
var ltlRechargeUrl = e.Item.FindControl("ltlRechargeUrl") as Literal;
var ltlCreditesUrl = e.Item.FindControl("ltlCreditesUrl") as Literal;
ltlItemIndex.Text = (e.Item.ItemIndex + 1).ToString();
ltlSN.Text = cardSNInfo.SN;
if (userInfo != null)
{
ltlUserName.Text = userInfo.DisplayName;
ltlMobile.Text = userInfo.Mobile;
}
ltlAmount.Text = cardSNInfo.Amount.ToString();
ltlAddDate.Text = DateUtils.GetDateAndTimeString(cardSNInfo.AddDate);
ltlIsDisabled.Text = cardSNInfo.IsDisabled ? "使用" : "冻结";
ltlConsumeUrl.Text =
$@"<a href=""javascript:;"" onclick=""{Modal.CardConsume.GetOpenWindowString(PublishmentSystemID,
cardSNInfo.CardID, cardSNInfo.ID)}"">消费</a>";
ltlRechargeUrl.Text =
$@"<a href=""javascript:;"" onclick=""{Modal.CardRecharge.GetOpenWindowString(PublishmentSystemID,
cardSNInfo.CardID, cardSNInfo.ID)}"">充值</a>";
ltlCreditesUrl.Text =
$@"<a href=""javascript:;"" onclick=""{Modal.CardCredits.GetOpenWindowString(PublishmentSystemID,
cardSNInfo.CardID, cardSNInfo.ID)}"">积分</a>";
}
}
public override void Submit_OnClick(object sender, EventArgs e)
{
if (Page.IsPostBack && Page.IsValid)
{
try
{
if (!string.IsNullOrEmpty(tbUserNameList.Text))
{
var userNameList = TranslateUtils.StringCollectionToStringList(tbUserNameList.Text);
foreach (var userName in userNameList)
{
var cardSNInfo = new CardSNInfo();
cardSNInfo.PublishmentSystemID = PublishmentSystemID;
cardSNInfo.CardID = cardID;
cardSNInfo.SN = DataProviderWX.CardSNDAO.GetNextCardSN(PublishmentSystemID, cardID);
cardSNInfo.Amount = 0;
cardSNInfo.UserName = userName;
cardSNInfo.IsDisabled = true;
cardSNInfo.AddDate = DateTime.Now;
var isExist = DataProviderWX.CardSNDAO.isExists(PublishmentSystemID, cardID, userName);
if (!isExist)
{
DataProviderWX.CardSNDAO.Insert(cardSNInfo);
}
}
}
LogUtils.AddLog(BaiRongDataProvider.AdministratorDao.UserName, "领取会员卡成功",
$"会员卡:{tbUserNameList.Text}");
SuccessMessage("领取会员卡成功！");
}
catch (Exception ex)
{
FailMessage(ex, "领取会员卡失败！");
}
}
}
public override void Submit_OnClick(object sender, EventArgs e)
{
if (IsPostBack && IsValid)
{
UserInfo userInfo = null;
CardSNInfo cardSNInfo = null;
if (cardSNID > 0)
{
cardSNInfo = DataProviderWX.CardSNDAO.GetCardSNInfo(cardSNID);
}
else
{
if (ddlKeyWordType.SelectedValue == "cardSN")
{
cardSNInfo = DataProviderWX.CardSNDAO.GetCardSNInfo(PublishmentSystemID, TranslateUtils.ToInt(ddlCard.SelectedValue), tbKeyWord.Text, string.Empty);
}
else if (ddlKeyWordType.SelectedValue == "mobile")
{
var userID = BaiRongDataProvider.UserDao.GetUserIdByEmailOrMobile(string.Empty, tbKeyWord.Text);
userInfo = BaiRongDataProvider.UserDao.GetUserInfo(userID);
if (userInfo != null)
{
cardSNInfo = DataProviderWX.CardSNDAO.GetCardSNInfo(PublishmentSystemID, TranslateUtils.ToInt(ddlCard.SelectedValue), string.Empty, userInfo.UserName);
}
}
}
if (cardSNInfo == null)
{
FailMessage("会员卡不存在");
return;
}
var cardCashLogInfo = new CardCashLogInfo();
cardCashLogInfo.PublishmentSystemID = PublishmentSystemID;
cardCashLogInfo.UserName = cardSNInfo.UserName;
cardCashLogInfo.CardID = cardSNInfo.CardID;
cardCashLogInfo.CardSNID = cardSNInfo.ID;
cardCashLogInfo.Amount = TranslateUtils.ToInt(tbRechargeAmount.Text);
cardCashLogInfo.CurAmount = cardSNInfo.Amount + TranslateUtils.ToDecimal(tbRechargeAmount.Text);
cardCashLogInfo.CashType = ECashTypeUtils.GetValue(ECashType.Recharge);
cardCashLogInfo.Operator = ddlOperator.SelectedValue;
cardCashLogInfo.Description = tbDescription.Text;
cardCashLogInfo.AddDate = DateTime.Now;
try
{
DataProviderWX.CardCashLogDAO.Insert(cardCashLogInfo);
DataProviderWX.CardSNDAO.Recharge(cardSNInfo.ID, cardSNInfo.UserName, TranslateUtils.ToDecimal(tbRechargeAmount.Text));
tbRechargeAmount.Text = string.Empty;
SuccessMessage("充值成功！");
//JsUtils.OpenWindow.CloseModalPage(Page);
}
catch (Exception ex)
{
FailMessage(ex, "充值失败！");
}
}
}
public override void Submit_OnClick(object sender, EventArgs e)
{
if (IsPostBack && IsValid)
{
UserInfo userInfo = null;
CardSNInfo cardSNInfo = null;
if (cardSNID > 0)
{
cardSNInfo = DataProviderWX.CardSNDAO.GetCardSNInfo(cardSNID);
userInfo = BaiRongDataProvider.UserDao.GetUserInfoByUserName(cardSNInfo != null? cardSNInfo.UserName:string.Empty);
}
else
{
if (ddlKeyWordType.SelectedValue == "cardSN")
{
cardSNInfo = DataProviderWX.CardSNDAO.GetCardSNInfo(PublishmentSystemID, TranslateUtils.ToInt(ddlCard.SelectedValue), tbKeyWord.Text, string.Empty);
userInfo = BaiRongDataProvider.UserDao.GetUserInfoByUserName(cardSNInfo != null ? cardSNInfo.UserName : string.Empty);
}
else if (ddlKeyWordType.SelectedValue == "mobile")
{
var userID = BaiRongDataProvider.UserDao.GetUserIdByEmailOrMobile(string.Empty, tbKeyWord.Text);
userInfo = BaiRongDataProvider.UserDao.GetUserInfo(userID);
}
}
if (userInfo == null)
{
FailMessage("会员不存在");
return;
}
var userCreditsLogInfo = new UserCreditsLogInfo();
userCreditsLogInfo.UserName = userInfo.UserName;
userCreditsLogInfo.ProductId = AppManager.WeiXin.AppID;
userCreditsLogInfo.Num = TranslateUtils.ToInt(tbCredits.Text);
userCreditsLogInfo.AddDate = DateTime.Now;
try
{
if (ddlOperatType.SelectedValue == "add")
{
userCreditsLogInfo.IsIncreased = true;
userCreditsLogInfo.Action = "手动添加积分";
BaiRongDataProvider.UserCreditsLogDao.Insert(userCreditsLogInfo);
BaiRongDataProvider.UserDao.AddCredits(userInfo.UserName, TranslateUtils.ToInt(tbCredits.Text));
}
else if (ddlOperatType.SelectedValue == "reduce")
{
userCreditsLogInfo.IsIncreased = false;
userCreditsLogInfo.Action = "手动扣除积分";
BaiRongDataProvider.UserCreditsLogDao.Insert(userCreditsLogInfo);
BaiRongDataProvider.UserDao.AddCredits(userInfo.UserName, -TranslateUtils.ToInt(tbCredits.Text));
}
tbCredits.Text = string.Empty;
SuccessMessage("操作成功！");
//JsUtils.OpenWindow.CloseModalPage(Page);
}
catch (Exception ex)
{
FailMessage(ex, "操作失败！");
}
}
}
public override void Submit_OnClick(object sender, EventArgs e)
{
if (IsPostBack && IsValid)
{
UserInfo userInfo = null;
CardSNInfo cardSNInfo = null;
if (cardSNID > 0)
{
cardSNInfo = DataProviderWX.CardSNDAO.GetCardSNInfo(cardSNID);
}
else
{
if (ddlKeyWordType.SelectedValue == "cardSN")
{
cardSNInfo = DataProviderWX.CardSNDAO.GetCardSNInfo(PublishmentSystemID, TranslateUtils.ToInt(ddlCard.SelectedValue), tbKeyWord.Text, string.Empty);
}
else if (ddlKeyWordType.SelectedValue == "mobile")
{
var userID = BaiRongDataProvider.UserDao.GetUserIdByEmailOrMobile(string.Empty, tbKeyWord.Text);
userInfo = BaiRongDataProvider.UserDao.GetUserInfo(userID);
if (userInfo != null)
{
cardSNInfo = DataProviderWX.CardSNDAO.GetCardSNInfo(PublishmentSystemID, TranslateUtils.ToInt(ddlCard.SelectedValue), string.Empty, userInfo.UserName);
}
}
}
if (cardSNInfo == null)
{
FailMessage("会员卡不存在");
return;
}
var consumeType = EConsumeTypeUtils.GetEnumType(ddlConsumeType.SelectedValue);
if (consumeType == EConsumeType.CardAmount)
{
var amount = DataProviderWX.CardSNDAO.GetAmount(cardSNInfo.ID, cardSNInfo.UserName);
if (amount < TranslateUtils.ToDecimal(tbConsumeAmount.Text))
{
FailMessage("会员卡余额不足");
return;
}
}
var cardCashLogInfo = new CardCashLogInfo();
cardCashLogInfo.PublishmentSystemID = PublishmentSystemID;
cardCashLogInfo.UserName = cardSNInfo.UserName;
cardCashLogInfo.CardID = cardSNInfo.CardID;
cardCashLogInfo.CardSNID = cardSNInfo.ID;
cardCashLogInfo.Amount = TranslateUtils.ToDecimal(tbConsumeAmount.Text);
cardCashLogInfo.CurAmount = cardSNInfo.Amount;
if (consumeType == EConsumeType.CardAmount)
{
cardCashLogInfo.CurAmount = cardSNInfo.Amount - TranslateUtils.ToInt(tbConsumeAmount.Text);
}
cardCashLogInfo.CashType = ECashTypeUtils.GetValue(ECashType.Consume);
cardCashLogInfo.ConsumeType = ddlConsumeType.SelectedValue;
cardCashLogInfo.Operator = ddlOperator.SelectedValue;
cardCashLogInfo.AddDate = DateTime.Now;
try
{
DataProviderWX.CardCashLogDAO.Insert(cardCashLogInfo);
if (consumeType == EConsumeType.CardAmount)
{
DataProviderWX.CardSNDAO.Consume(cardSNInfo.ID, cardSNInfo.UserName, TranslateUtils.ToDecimal(tbConsumeAmount.Text));
if (PublishmentSystemInfo.Additional.Card_IsClaimCardCredits)
{
var amount = TranslateUtils.ToDecimal(tbConsumeAmount.Text);
var consumeAmount = PublishmentSystemInfo.Additional.Card_ConsumeAmount;
var giveCredits = PublishmentSystemInfo.Additional.Card_GiveCredits;
//var userCreditsLogInfo = new UserCreditsLogInfo();
//userCreditsLogInfo.UserName = cardSNInfo.UserName;
//userCreditsLogInfo.ProductId = AppManager.WeiXin.AppID;
//userCreditsLogInfo.Num = (int)Math.Round(amount * (giveCredits / consumeAmount), 0);
//userCreditsLogInfo.AddDate = DateTime.Now;
//userCreditsLogInfo.IsIncreased = true;
//userCreditsLogInfo.Action = "消费送积分";
//BaiRongDataProvider.UserCreditsLogDao.Insert(userCreditsLogInfo);
//BaiRongDataProvider.UserDao.AddCredits(cardSNInfo.UserName, (int)Math.Round(amount * (giveCredits / consumeAmount), 0));
}
}
tbConsumeAmount.Text = string.Empty;
SuccessMessage("操作成功！");
//JsUtils.OpenWindow.CloseModalPage(Page);
}
catch (Exception ex)
{
FailMessage(ex, "操作失败！");
}
}
}
