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, "操作失败!"); } } }