public void Update(CardEntitySnInfo cardEntitySnInfo) { IDataParameter[] parms = null; var sqlUpdate = BaiRongDataProvider.TableStructureDao.GetUpdateSqlString(cardEntitySnInfo.ToNameValueCollection(), ConnectionString, TableName, out parms); ExecuteNonQuery(sqlUpdate, parms); }
public CardEntitySnInfo GetCardEntitySnInfo(int cardId, string cardSn, string mobile) { CardEntitySnInfo cardEntitySnInfo = null; string sqlWhere = $"WHERE {CardEntitySnAttribute.CardId}= {cardId}"; if (!string.IsNullOrEmpty(cardSn)) { sqlWhere += $" AND {CardEntitySnAttribute.Sn}='{PageUtils.FilterSql(cardSn)}'"; } if (!string.IsNullOrEmpty(mobile)) { sqlWhere += $" AND {CardEntitySnAttribute.Mobile}='{PageUtils.FilterSql(mobile)}'"; } var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null); using (var rdr = ExecuteReader(sqlSelect)) { if (rdr.Read()) { cardEntitySnInfo = new CardEntitySnInfo(rdr); } rdr.Close(); } return(cardEntitySnInfo); }
public int Insert(CardEntitySnInfo cardEntitySnInfo) { var cardEntitySnid = 0; IDataParameter[] parms = null; var sqlInsert = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(cardEntitySnInfo.ToNameValueCollection(), ConnectionString, TableName, out parms); using (var conn = GetConnection()) { conn.Open(); using (var trans = conn.BeginTransaction()) { try { cardEntitySnid = ExecuteNonQueryAndReturnId(trans, sqlInsert, parms); trans.Commit(); } catch { trans.Rollback(); throw; } } } return(cardEntitySnid); }
void rptContents_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { var cardEntitySnInfo = new CardEntitySnInfo(e.Item.DataItem); 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 ltlIsBinding = e.Item.FindControl("ltlIsBinding") as Literal; var ltlEditUrl = e.Item.FindControl("ltlEditUrl") as Literal; ltlItemIndex.Text = (e.Item.ItemIndex + 1).ToString(); ltlSn.Text = cardEntitySnInfo.Sn; ltlUserName.Text = cardEntitySnInfo.UserName; ltlMobile.Text = cardEntitySnInfo.Mobile; ltlAmount.Text = cardEntitySnInfo.Amount.ToString(); ltlCredits.Text = cardEntitySnInfo.Credits.ToString(); ltlAddDate.Text = DateUtils.GetDateAndTimeString(cardEntitySnInfo.AddDate); ltlIsBinding.Text = cardEntitySnInfo.IsBinding ? "已绑定" : "未绑定"; ltlEditUrl.Text = $@"<a href=""javascript:;"" onclick=""{ModalCardEntitySnAdd.GetOpenWindowStringToEdit( PublishmentSystemId, cardEntitySnInfo.CardId, cardEntitySnInfo.Id)}"">修改</a>"; } }
public CardEntitySnInfo GetCardEntitySnInfo(int cardEntitySnid) { CardEntitySnInfo cardEntitySnInfo = null; string sqlWhere = $"WHERE ID = {cardEntitySnid}"; var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null); using (var rdr = ExecuteReader(sqlSelect)) { if (rdr.Read()) { cardEntitySnInfo = new CardEntitySnInfo(rdr); } rdr.Close(); } return(cardEntitySnInfo); }
public List <CardEntitySnInfo> GetCardEntitySnInfoList(int publishmentSystemId, int cardId) { var cardEntitySnInfoList = new List <CardEntitySnInfo>(); string sqlWhere = $"WHERE PublishmentSystemID={publishmentSystemId} AND CardID = {cardId}"; string sqlOrder = $" ORDER BY {CardEntitySnAttribute.AddDate} DESC"; var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, sqlOrder); using (var rdr = ExecuteReader(sqlSelect)) { while (rdr.Read()) { var cardEntitySnInfo = new CardEntitySnInfo(rdr); cardEntitySnInfoList.Add(cardEntitySnInfo); } rdr.Close(); } return(cardEntitySnInfoList); }
public override void Submit_OnClick(object sender, EventArgs e) { if (IsPostBack && IsValid) { var cardEntitySnInfo = new CardEntitySnInfo(); if (_cardEntitySnid > 0) { cardEntitySnInfo = DataProviderWx.CardEntitySnDao.GetCardEntitySnInfo(_cardEntitySnid); } cardEntitySnInfo.PublishmentSystemId = PublishmentSystemId; cardEntitySnInfo.CardId = _cardId; cardEntitySnInfo.Sn = TbCardSn.Text; cardEntitySnInfo.UserName = TbUserName.Text; cardEntitySnInfo.Amount = TranslateUtils.ToDecimal(TbAmount.Text); cardEntitySnInfo.Credits = TranslateUtils.ToInt(TbCredits.Text); cardEntitySnInfo.Mobile = TbMobile.Text; cardEntitySnInfo.Email = TbEmail.Text; cardEntitySnInfo.Address = TbAddress.Text; if (_cardEntitySnid > 0) { try { DataProviderWx.CardEntitySnDao.Update(cardEntitySnInfo); PageUtils.CloseModalPage(Page); } catch (Exception ex) { FailMessage($"实体卡修改失败:{ex}"); } } else { var isExist = DataProviderWx.CardEntitySnDao.IsExist(PublishmentSystemId, _cardId, cardEntitySnInfo.Sn); var isExistMobile = DataProviderWx.CardEntitySnDao.IsExistMobile(PublishmentSystemId, _cardId, cardEntitySnInfo.Mobile); if (isExistMobile) { FailMessage("手机号使用,请更换手机号!"); return; } if (isExist) { FailMessage($"{cardEntitySnInfo.Sn}实体卡号已存在!"); return; } else { try { cardEntitySnInfo.IsBinding = false; cardEntitySnInfo.AddDate = DateTime.Now; DataProviderWx.CardEntitySnDao.Insert(cardEntitySnInfo); PageUtils.CloseModalPage(Page); } catch (Exception ex) { FailMessage($"实体卡新增失败:{ex}"); } } } } }