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