public RPCResult <List <Account> > GetAccounts()
{
try
{
List <Account> accounts = AccountDB.GetAccounts();
return(new RPCResult <List <Account> >(true, accounts, ""));
}
catch (Exception ex)
{
LogHelper.LogError("SMSService", "SMSService.GetAccounts", ex.ToString());
return(new RPCResult <List <Account> >(false, null, "获取账号出现异常！"));
}
}
public void Test()
{
var account = AccountDB.GetAccounts().First();
Assert.IsNotNull(account);
SMS sms = new SMS()
{
Account = account.AccountID,
Audit = AuditType.Auto,
AuditTime = DateTime.Now.ToString(),
AuditUser = "******",
Channel = "default",
Content = "ceshi neirong",
Level = LevelType.Level0,
IsSplit = true,
SendTime = DateTime.Now,
SerialNumber = guid,
Signature = "【1111】",
LinkID = guid.ToString(),
SPNumber = "1234",
StatusReport = StatusReportType.Enabled,
Extend = null,
FailureCase = "",
Filter = FilterType.Failure,
Number = new List <string> {
"123", "1235", "234"
},
NumberCount = 3,
WapURL = "wapurl"
};
var b = AuditFailureDB.Add(sms, "失败原因");
Assert.IsTrue(b);
var fl = AuditFailureDB.GetFailureSMSByAccount(account.AccountID);
Assert.IsNotNull(fl);
Assert.IsTrue(fl.Count > 0);
var sms_1 = fl.First(s => s.SerialNumber == sms.SerialNumber);
Assert.AreEqual(sms.WapURL, sms_1.WapURL);
Assert.AreEqual(sms.SMSTimer.ToString(), sms_1.SMSTimer.ToString());
var fl2 = AuditFailureDB.GetFailureSMSByAccount(DateTime.MinValue, DateTime.Now);
Assert.IsNotNull(fl2);
Assert.IsTrue(fl2.Count > 0);
b = AuditFailureDB.Del(sms.SerialNumber);
Assert.IsTrue(b);
fl = AuditFailureDB.GetFailureSMSByAccount(account.AccountID);
Assert.IsNull(fl.FirstOrDefault(s => s.SerialNumber == sms.SerialNumber));
}
private void TextAccount_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
// Apaga a lista antiga
if (accounts != null)
{
accounts.Clear();
}
ComboAccount.Items.Clear();
if (TextAccount.Text.Length > 0)
{
var db = new AccountDB();
var dbError = db.Open();
if (dbError.Number != 0)
{
var errorText = $"Cannot connect to database {Environment.NewLine}";
errorText += $"Error Number: {dbError.Number}{Environment.NewLine}";
errorText += $"Error Message: {dbError.Message}";
MessageBox.Show(errorText);
}
else
{
if (db.Connected)
{
accounts = db.GetAccounts(TextAccount.Text.Trim().ToLower());
FillComboAccount();
AccountLabel.Text = $"Account: {accounts.Count} result(s).";
}
else
{
MessageBox.Show("Database is not connected.");
}
}
db.Close();
}
}
}
public void Test()
{
var account = AccountDB.GetAccounts().First();
Assert.IsNotNull(account);
AuditRecord record = new AuditRecord()
{
AccountID = account.AccountID,
AuditTime = DateTime.Now,
Content = "123456",
SerialNumber = System.Guid.NewGuid(),
SendTime = DateTime.Now,
Result = false
};
AuditRecord record2 = new AuditRecord()
{
AccountID = account.AccountID,
AuditTime = DateTime.Now,
Content = "123456",
SerialNumber = System.Guid.NewGuid(),
SendTime = DateTime.Now,
Result = true
};
var b = AuditRecordDB.Add(record);
Assert.IsTrue(b);
b = AuditRecordDB.Add(record2);
Assert.IsTrue(b);
var r = AuditRecordDB.GetAudit(record2.SerialNumber);
Assert.IsNotNull(record2);
Assert.AreEqual(record2.Result, r.Result);
Assert.AreEqual(record2.SendTime.ToString(), r.SendTime.ToString());
var list = AuditRecordDB.GetAudit(DateTime.MinValue, DateTime.MaxValue);
Assert.IsNotNull(list);
Assert.IsTrue(list.Count > 1);
}
public void AccountTest()
{
Account account = new Account()
{
AccountID = guid.ToString(),
SMSNumber = 10
};
var b = AccountDB.CreateAccount(account);
Assert.IsTrue(b);
b = AccountDB.AccountPrepaid(account.AccountID, 10);
Assert.IsTrue(b);
int c = AccountDB.GetSMSNumberByAccount(account.AccountID);
Assert.AreEqual(20, c);
var a = AccountDB.GetAccount(account.AccountID);
Assert.IsNotNull(a);
Assert.AreEqual(a.AccountID, account.AccountID);
Assert.AreEqual(a.SMSNumber, 20);
b = AccountDB.DeductAccountSMSCharge(account.AccountID, 10);
Assert.IsTrue(b);
c = AccountDB.GetSMSNumberByAccount(account.AccountID);
Assert.AreEqual(10, c);
b = AccountDB.ReAccountSMSCharge(account.AccountID, 10);
Assert.IsTrue(b);
c = AccountDB.GetSMSNumberByAccount(account.AccountID);
Assert.AreEqual(20, c);
var accs = AccountDB.GetAccounts();
Assert.IsNotNull(accs);
Assert.IsTrue(accs.Count > 0);
b = AccountDB.DelAccount(account.AccountID);
Assert.IsTrue(b);
}
