private int Gen(int pwdlen, int cardNoLen, int count)
{
if (_config == null)
{
throw new InvalidOperationException("no config found");
}
FINCard newCard;
List <FINCard> list = new List <FINCard>();
//need to know card with the same prefix count number.
int i = _BLL.CountCardsExist(_configId);
int r = i + count;
for (; i < r; i++)
{
newCard = new FINCard();
newCard.Id = _config.CardPrefix + GenCardNo(cardNoLen, i + 1);
newCard.CardConfigId = _configId;
newCard.Password = GenPassword(pwdlen);
newCard.Status = AppConfigs.SingleCardStatus.NeverUsed;
newCard.StatusDay = DateTime.Now;
newCard.FailTimes = 0;
list.Add(newCard);
Thread.Sleep(3);
}
return(this._BLL.BulkAdd(GenCardListTable(list))?1:0);
}
public int Update(FINCard card)
{
_sb = new StringBuilder();
_sb.Append(@"UPDATE FINCards
SET
Memo = @Memo
,UserId=@UserId
,ActivatedDay = @ActivatedDay
,Status = @Status
,StatusDay = @StatusDay
,Password = @Password
,CardConfigId = @CardConfigId
,EndDay = @EndDay
,FailTimes = @FailTimes
,LockedEndTime = @LockedEndTime");
_sb.Append($" where Id=@Id");
var parmlist = TableToModel <FINCard> .FillDbParams(card, DbConfig.DbProviderType.SqlServer);
_dbfunc.ConnectionString = connstr;
return(_dbfunc.ExecuteNonQuery(_sb.ToString(), parmlist.ToArray()));
}
public int Add(FINCard model)
{
return(_DAL.Add(model));
}
public int Update(FINCard card)
{
return(_DAL.Update(card));
}
public int Add(FINCard model)
{
_sb = new StringBuilder();
throw new NotImplementedException();
}
