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