public void Update(CardEntitySNInfo cardEntitySNInfo)
{
IDataParameter[] parms = null;
var SQL_UPDATE = BaiRongDataProvider.TableStructureDao.GetUpdateSqlString(cardEntitySNInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms);
ExecuteNonQuery(SQL_UPDATE, parms);
}
public CardEntitySNInfo GetCardEntitySNInfo(int cardID, string cardSN, string mobile)
{
CardEntitySNInfo cardEntitySNInfo = null;
string SQL_WHERE = $"WHERE {CardEntitySNAttribute.CardID}= {cardID}";
if (!string.IsNullOrEmpty(cardSN))
{
SQL_WHERE += $" AND {CardEntitySNAttribute.SN}='{PageUtils.FilterSql(cardSN)}'";
}
if (!string.IsNullOrEmpty(mobile))
{
SQL_WHERE += $" AND {CardEntitySNAttribute.Mobile}='{PageUtils.FilterSql(mobile)}'";
}
var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, null);
using (var rdr = ExecuteReader(SQL_SELECT))
{
if (rdr.Read())
{
cardEntitySNInfo = new CardEntitySNInfo(rdr);
}
rdr.Close();
}
return(cardEntitySNInfo);
}
public int Insert(CardEntitySNInfo cardEntitySNInfo)
{
var cardEntitySNID = 0;
IDataParameter[] parms = null;
var SQL_INSERT = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(cardEntitySNInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms);
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
ExecuteNonQuery(trans, SQL_INSERT, parms);
cardEntitySNID = BaiRongDataProvider.DatabaseDao.GetSequence(trans, TABLE_NAME);
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=""{Modal.CardEntitySNAdd.GetOpenWindowStringToEdit(
PublishmentSystemID, cardEntitySNInfo.CardID, cardEntitySNInfo.ID)}"">修改</a>";
}
}
public CardEntitySNInfo GetCardEntitySNInfo(int cardEntitySNID)
{
CardEntitySNInfo cardEntitySNInfo = null;
string SQL_WHERE = $"WHERE ID = {cardEntitySNID}";
var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, null);
using (var rdr = ExecuteReader(SQL_SELECT))
{
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 SQL_WHERE = $"WHERE PublishmentSystemID={publishmentSystemID} AND CardID = {cardID}";
string SQL_ORDER = $" ORDER BY {CardEntitySNAttribute.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 cardEntitySNInfo = new CardEntitySNInfo(rdr);
cardEntitySNInfoList.Add(cardEntitySNInfo);
}
rdr.Close();
}
return(cardEntitySNInfoList);
}
public ArrayList GetCardEntitySNInfoArrayList(string filePath)
{
var index = 0;
var cardEntitySNInfoArrayList = new ArrayList();
var cardEntitySNInfoList = CSVUtils.Import(filePath);
if (cardEntitySNInfoList.Count > 0)
{
foreach (var info in cardEntitySNInfoList)
{
index++;
if (index == 1)
{
continue;
}
if (string.IsNullOrEmpty(info))
{
continue;
}
var value = info.Split(',');
var cardEntitySNInfo = new CardEntitySNInfo();
cardEntitySNInfo.PublishmentSystemID = PublishmentSystemID;
cardEntitySNInfo.CardID = cardID;
cardEntitySNInfo.SN = value[0];
cardEntitySNInfo.UserName = value[1];
cardEntitySNInfo.Mobile = value[2];
cardEntitySNInfo.Email = value[3];
cardEntitySNInfo.Address = value[4];
cardEntitySNInfo.Amount = TranslateUtils.ToDecimal(value[5]);
cardEntitySNInfo.Credits = TranslateUtils.ToInt(value[6]);
cardEntitySNInfo.IsBinding = false;
cardEntitySNInfo.AddDate = DateTime.Now;
cardEntitySNInfoArrayList.Add(cardEntitySNInfo);
}
}
return(cardEntitySNInfoArrayList);
}
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);
JsUtils.OpenWindow.CloseModalPage(Page);
}
catch (Exception ex)
{
FailMessage($"实体卡修改失败：{ex.ToString()}");
}
}
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);
JsUtils.OpenWindow.CloseModalPage(Page);
}
catch (Exception ex)
{
FailMessage($"实体卡新增失败：{ex.ToString()}");
}
}
}
}
}
