void rptContents_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var cardCashLogInfo = new CardCashLogInfo(e.Item.DataItem);
var cardSNInfo = DataProviderWX.CardSNDAO.GetCardSNInfo(cardCashLogInfo.CardSNID);
var userInfo = BaiRongDataProvider.UserDao.GetUserInfoByUserName(cardCashLogInfo.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 ltlBeforeAmount = e.Item.FindControl("ltlBeforeAmount") as Literal;
var ltlAfterAmount = e.Item.FindControl("ltlAfterAmount") as Literal;
var ltlAddDate = e.Item.FindControl("ltlAddDate") as Literal;
var ltlOperator = e.Item.FindControl("ltlOperator") as Literal;
ltlItemIndex.Text = (e.Item.ItemIndex + 1).ToString();
ltlAmount.Text = cardCashLogInfo.Amount.ToString();
ltlBeforeAmount.Text = (cardCashLogInfo.CurAmount - cardCashLogInfo.Amount).ToString();
ltlAfterAmount.Text = cardCashLogInfo.CurAmount.ToString();
ltlOperator.Text = cardCashLogInfo.Operator;
ltlUserName.Text = userInfo != null ? userInfo.UserName : string.Empty;
ltlMobile.Text = userInfo != null ? userInfo.Mobile : string.Empty;
ltlSN.Text = cardSNInfo != null ? cardSNInfo.SN : string.Empty;
ltlAddDate.Text = DateUtils.GetDateAndTimeString(cardCashLogInfo.AddDate);
}
}
public List <CardCashLogInfo> GetCardCashLogInfoList(int cardID, int cardSNID, string userName, string startDate, string endDate)
{
var cardCashLogInfoList = new List <CardCashLogInfo>();
string SQL_WHERE =
$"WHERE CardID = {cardID} AND CardSNID={cardSNID} AND UserName='******'";
if (!string.IsNullOrEmpty(startDate))
{
SQL_WHERE += $" AND AddDate >='{startDate}' AND AddDate < '{endDate}'";
}
string SQL_ORDER = $" ORDER BY {CardCashLogAttribute.AddDate} DESC";
var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, SQL_ORDER);
using (var rdr = ExecuteReader(SQL_SELECT))
{
while (rdr.Read())
{
var cardCashLogInfo = new CardCashLogInfo(rdr);
cardCashLogInfoList.Add(cardCashLogInfo);
}
rdr.Close();
}
return(cardCashLogInfoList);
}
public void Update(CardCashLogInfo cardCashLogInfo)
{
IDataParameter[] parms = null;
var SQL_UPDATE = BaiRongDataProvider.TableStructureDao.GetUpdateSqlString(cardCashLogInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms);
ExecuteNonQuery(SQL_UPDATE, parms);
}
public int Insert(CardCashLogInfo cardCashLogInfo)
{
var cardCashLogID = 0;
IDataParameter[] parms = null;
var SQL_INSERT = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(cardCashLogInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms);
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
ExecuteNonQuery(trans, SQL_INSERT, parms);
cardCashLogID = BaiRongDataProvider.DatabaseDao.GetSequence(trans, TABLE_NAME);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
return(cardCashLogID);
}
public List <CardCashLogInfo> GetCardCashLogInfoList(int cardId, int cardSnid, string userName, string startDate, string endDate)
{
var cardCashLogInfoList = new List <CardCashLogInfo>();
string sqlWhere =
$"WHERE CardID = {cardId} AND CardSNID={cardSnid} AND UserName='******'";
if (!string.IsNullOrEmpty(startDate))
{
sqlWhere += $" AND AddDate >='{startDate}' AND AddDate < '{endDate}'";
}
string sqlOrder = $" ORDER BY {CardCashLogAttribute.AddDate} DESC";
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, sqlOrder);
using (var rdr = ExecuteReader(sqlSelect))
{
while (rdr.Read())
{
var cardCashLogInfo = new CardCashLogInfo(rdr);
cardCashLogInfoList.Add(cardCashLogInfo);
}
rdr.Close();
}
return(cardCashLogInfoList);
}
public void Update(CardCashLogInfo cardCashLogInfo)
{
IDataParameter[] parms;
var sqlUpdate = BaiRongDataProvider.TableStructureDao.GetUpdateSqlString(cardCashLogInfo.ToNameValueCollection(), ConnectionString, TableName, out parms);
ExecuteNonQuery(sqlUpdate, parms);
}
public int Insert(CardCashLogInfo cardCashLogInfo)
{
int cardCashLogId;
IDataParameter[] parms;
var sqlInsert = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(cardCashLogInfo.ToNameValueCollection(), ConnectionString, TableName, out parms);
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
cardCashLogId = ExecuteNonQueryAndReturnId(trans, sqlInsert, parms);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
return(cardCashLogId);
}
public void Recharge(int cardSNID, string userName, decimal amount, CardCashLogInfo cardCashInfo, IDbTransaction trans)
{
DataProviderWX.CardCashLogDAO.Insert(cardCashInfo);
string sqlString =
$"UPDATE {TABLE_NAME} SET {CardSNAttribute.Amount} = {CardSNAttribute.Amount}+{amount} WHERE ID = {cardSNID} AND UserName='******' ";
ExecuteNonQuery(trans, sqlString);
}
public CardCashLogInfo GetCardCashLogInfo(int cardCashLogID)
{
CardCashLogInfo cardCashLogInfo = null;
string SQL_WHERE = $"WHERE ID = {cardCashLogID}";
var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, null);
using (var rdr = ExecuteReader(SQL_SELECT))
{
if (rdr.Read())
{
cardCashLogInfo = new CardCashLogInfo(rdr);
}
rdr.Close();
}
return(cardCashLogInfo);
}
public CardCashLogInfo GetCardCashLogInfo(int cardCashLogId)
{
CardCashLogInfo cardCashLogInfo = null;
string sqlWhere = $"WHERE ID = {cardCashLogId}";
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null);
using (var rdr = ExecuteReader(sqlSelect))
{
if (rdr.Read())
{
cardCashLogInfo = new CardCashLogInfo(rdr);
}
rdr.Close();
}
return(cardCashLogInfo);
}
public List <CardCashLogInfo> GetCardCashLogInfoList(int publishmentSystemID, int cardID, int cardSNID)
{
var cardCashLogInfoList = new List <CardCashLogInfo>();
string SQL_WHERE =
$"WHERE PublishmentSystemID={publishmentSystemID} AND CardID = {cardID} AND CardSNID = {cardSNID}";
string SQL_ORDER = $" ORDER BY {CardCashLogAttribute.AddDate} DESC";
var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, SQL_ORDER);
using (var rdr = ExecuteReader(SQL_SELECT))
{
while (rdr.Read())
{
var cardCashLogInfo = new CardCashLogInfo(rdr);
cardCashLogInfoList.Add(cardCashLogInfo);
}
rdr.Close();
}
return(cardCashLogInfoList);
}
public List <CardCashLogInfo> GetCardCashLogInfoList(int publishmentSystemId, int cardId, int cardSnid)
{
var cardCashLogInfoList = new List <CardCashLogInfo>();
string sqlWhere =
$"WHERE PublishmentSystemID={publishmentSystemId} AND CardID = {cardId} AND CardSNID = {cardSnid}";
string sqlOrder = $" ORDER BY {CardCashLogAttribute.AddDate} DESC";
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, sqlOrder);
using (var rdr = ExecuteReader(sqlSelect))
{
while (rdr.Read())
{
var cardCashLogInfo = new CardCashLogInfo(rdr);
cardCashLogInfoList.Add(cardCashLogInfo);
}
rdr.Close();
}
return(cardCashLogInfoList);
}
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.WxCardIsClaimCardCredits)
{
var amount = TranslateUtils.ToDecimal(TbConsumeAmount.Text);
var consumeAmount = PublishmentSystemInfo.Additional.WxCardConsumeAmount;
var giveCredits = PublishmentSystemInfo.Additional.WxCardGiveCredits;
//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("操作成功！");
//PageUtils.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 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)
{
var isChanged = false;
try
{
if (!isEntity)
{
DataProviderWX.CardSNDAO.UpdateStatus(cardID, TranslateUtils.ToBool(ddlIsDisabled.SelectedValue), TranslateUtils.StringCollectionToIntList(Request.QueryString["IDCollection"]));
}
else
{
var cardEntitySNIDList = TranslateUtils.StringCollectionToIntList(Request.QueryString["IDCollection"]);
if (cardEntitySNIDList.Count > 0)
{
for (var i = 0; i < cardEntitySNIDList.Count; i++)
{
var cardEntitySNInfo = DataProviderWX.CardEntitySNDAO.GetCardEntitySNInfo(cardEntitySNIDList[i]);
var userID = BaiRongDataProvider.UserDao.GetUserIdByEmailOrMobile(string.Empty, cardEntitySNInfo.Mobile);
var userInfo = BaiRongDataProvider.UserDao.GetUserInfo(userID);
if (userInfo != null)
{
var cardSNInfo = DataProviderWX.CardSNDAO.GetCardSNInfo(PublishmentSystemID, cardID, string.Empty, userInfo.UserName);
var cardCashLogInfo = new CardCashLogInfo();
cardCashLogInfo.PublishmentSystemID = PublishmentSystemID;
cardCashLogInfo.UserName = userInfo.UserName;
cardCashLogInfo.CardID = cardSNInfo.CardID;
cardCashLogInfo.CardSNID = cardSNInfo.ID;
cardCashLogInfo.Amount = cardEntitySNInfo.Amount;
cardCashLogInfo.CurAmount += cardEntitySNInfo.Amount;;
cardCashLogInfo.CashType = ECashTypeUtils.GetValue(ECashType.Recharge);
cardCashLogInfo.Operator = AdminManager.Current.UserName;
cardCashLogInfo.Description = "绑定实体卡充值";
cardCashLogInfo.AddDate = DateTime.Now;
var userCreditsLogInfo = new UserCreditsLogInfo();
userCreditsLogInfo.UserName = userInfo.UserName;
userCreditsLogInfo.ProductId = AppManager.WeiXin.AppID;
userCreditsLogInfo.Num = cardEntitySNInfo.Credits;
userCreditsLogInfo.IsIncreased = true;
userCreditsLogInfo.Action = "绑定实体卡添加积分";
userCreditsLogInfo.AddDate = DateTime.Now;
if (!cardEntitySNInfo.IsBinding)
{
cardEntitySNInfo.IsBinding = true;
DataProviderWX.CardEntitySNDAO.Update(cardEntitySNInfo);
DataProviderWX.CardCashLogDAO.Insert(cardCashLogInfo);
DataProviderWX.CardSNDAO.Recharge(cardSNInfo.ID, userInfo.UserName, cardEntitySNInfo.Amount);
BaiRongDataProvider.UserCreditsLogDao.Insert(userCreditsLogInfo);
BaiRongDataProvider.UserDao.AddCredits(userInfo.UserName, cardEntitySNInfo.Credits);
}
}
}
}
}
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "失败：" + ex.Message);
}
if (isChanged)
{
JsUtils.OpenWindow.CloseModalPage(Page);
}
}
