public List <string> GetUserNameList(int publishmentSystemId, int cardId, string cardSn, string userName) { var userNameList = new List <string>(); string sqlWhere = $"WHERE {CardSnAttribute.PublishmentSystemId} = {publishmentSystemId} "; if (cardId > 0) { sqlWhere += $" AND CardID = {cardId}"; } if (!string.IsNullOrEmpty(cardSn)) { sqlWhere += $" AND {CardSnAttribute.Sn}='{PageUtils.FilterSql(cardSn)}'"; } if (!string.IsNullOrEmpty(userName)) { sqlWhere += $" AND {CardSnAttribute.UserName} ='{PageUtils.FilterSql(userName)}'"; } var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null); using (var rdr = ExecuteReader(sqlSelect)) { while (rdr.Read()) { var cardSnInfo = new CardSnInfo(rdr); if (!userNameList.Contains(cardSnInfo.UserName)) { userNameList.Add(cardSnInfo.UserName); } } rdr.Close(); } return(userNameList); }
public void Update(CardSnInfo cardSnInfo) { IDataParameter[] parms = null; var sqlUpdate = BaiRongDataProvider.TableStructureDao.GetUpdateSqlString(cardSnInfo.ToNameValueCollection(), ConnectionString, TableName, out parms); ExecuteNonQuery(sqlUpdate, parms); }
public int Insert(CardSnInfo cardSnInfo) { var cardSnid = 0; IDataParameter[] parms = null; var sqlInsert = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(cardSnInfo.ToNameValueCollection(), ConnectionString, TableName, out parms); using (var conn = GetConnection()) { conn.Open(); using (var trans = conn.BeginTransaction()) { try { cardSnid = ExecuteNonQueryAndReturnId(trans, sqlInsert, parms); trans.Commit(); } catch { trans.Rollback(); throw; } } } return(cardSnid); }
public CardSnInfo GetCardSnInfo(int publishmentSystemId, int cardId, string cardSn, string userName) { CardSnInfo cardSnInfo = null; string sqlWhere = $"WHERE {CardSnAttribute.PublishmentSystemId} = {publishmentSystemId} "; if (cardId > 0) { sqlWhere += $" AND {CardSnAttribute.CardId}='{cardId}'"; } if (!string.IsNullOrEmpty(cardSn)) { sqlWhere += $" AND {CardSnAttribute.Sn}='{PageUtils.FilterSql(cardSn)}'"; } if (!string.IsNullOrEmpty(userName)) { sqlWhere += $" AND {CardSnAttribute.UserName}='{PageUtils.FilterSql(userName)}'"; } var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null); using (var rdr = ExecuteReader(sqlSelect)) { if (rdr.Read()) { cardSnInfo = new CardSnInfo(rdr); } rdr.Close(); } return(cardSnInfo); }
public decimal GetAmount(int cardSnid, string userName) { decimal amount = 0; string sqlWhere = $"WHERE ID = {cardSnid} AND userName='******'"; var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null); using (var rdr = ExecuteReader(sqlSelect)) { if (rdr.Read()) { var cardSnInfo = new CardSnInfo(rdr); amount = cardSnInfo.Amount; } rdr.Close(); } return(amount); }
public CardSnInfo GetCardSnInfo(int cardSnid) { CardSnInfo cardSnInfo = null; string sqlWhere = $"WHERE ID = {cardSnid}"; var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null); using (var rdr = ExecuteReader(sqlSelect)) { 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 sqlWhere = $"WHERE {CardSnAttribute.PublishmentSystemId} = {publishmentSystemId} AND {CardSnAttribute.CardId} = {cardId}"; var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null); using (var rdr = ExecuteReader(sqlSelect)) { 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=""{ModalCardConsume.GetOpenWindowString(PublishmentSystemId, cardSnInfo.CardId, cardSnInfo.Id)}"">消费</a>"; ltlRechargeUrl.Text = $@"<a href=""javascript:;"" onclick=""{ModalCardRecharge.GetOpenWindowString(PublishmentSystemId, cardSnInfo.CardId, cardSnInfo.Id)}"">充值</a>"; ltlCreditesUrl.Text = $@"<a href=""javascript:;"" onclick=""{ModalCardCredits.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.AddAdminLog(Body.AdministratorName, "领取会员卡成功", $"会员卡:{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 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("充值成功!"); //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); 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("操作成功!"); // //PageUtils.CloseModalPage(Page); //} //catch (Exception ex) //{ // FailMessage(ex, "操作失败!"); //} } }