public bool CheckExists(CurrencyBlacklist objCurrencyBlacklist)
{
string sql = null;
List<DbParameter> parameterList = new List<DbParameter>();
sql = " select count(*) from tbl_currency_blacklist where CurrencyNumber=@CurrencyNumber ";
parameterList.Add(new MySqlParameter("@CurrencyNumber", objCurrencyBlacklist.CurrencyNumber));
return int.Parse(DbHelper.ExecuteScalar(sql, CommandType.Text, parameterList.ToArray()).ToString()) > 0;
}
public void GetCurrencyNumberBytesTest()
{
CurrencyBlacklist item = new CurrencyBlacklist()
{
CurrencyKindCode = 0,
FaceAmount = 100,
CurrencyVersion = 2005,
CurrencyNumber = "HD12345678"
};
byte[] actual;
actual = BlackTableHelper.GetCurrencyNumberBytes(item);
var temp = Unity.GetCurrencyNo(actual, 5);
Assert.IsTrue(temp == item.CurrencyNumber);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (this.IsValid)
{
ICurrencyService service = ServiceFactory.GetService<ICurrencyService>();
CurrencyBlacklist entity = null;
if (this.IsInsert)
{
entity = new CurrencyBlacklist()
{
CurrencyKindCode = this.ddlCurrencyKind.SelectedValue.ToByte(0),
FaceAmount = this.txtFaceAmount.Text.Trim().ToShort(0),
CurrencyVersion = this.txtCurrencyVersion.Text.Trim().ToShort(0),
CurrencyNumber = this.txtCurrencyNumber.Text.Trim()
};
if (service.CheckExists_Blacklist(entity))
{
this.JscriptMsg("纸币号码已存在", null, "Error");
return;
}
}
service.Save_Blacklist(entity);
if (this.IsInsert && (sender as Button).CommandName == "SubmitContinue")
{
this.ReturnUrl = this.Request.Url.AbsolutePath;
}
this.JscriptMsg("数据保存成功", this.ReturnUrl, "Success");
}
}
public void Save(CurrencyBlacklist objCurrencyBlacklist)
{
string sql = null;
List<DbParameter> parameterList = new List<DbParameter>();
if (objCurrencyBlacklist.PkId == 0)
{
sql = " insert into tbl_currency_blacklist(CurrencyKindCode, FaceAmount, CurrencyVersion, CurrencyNumber) " +
" values(@CurrencyKindCode, @FaceAmount, @CurrencyVersion, @CurrencyNumber) ";
parameterList.Add(new MySqlParameter("@CurrencyKindCode", objCurrencyBlacklist.CurrencyKindCode));
parameterList.Add(new MySqlParameter("@FaceAmount", objCurrencyBlacklist.FaceAmount));
parameterList.Add(new MySqlParameter("@CurrencyVersion", objCurrencyBlacklist.CurrencyVersion));
parameterList.Add(new MySqlParameter("@CurrencyNumber", objCurrencyBlacklist.CurrencyNumber));
}
else
{
sql = " update tbl_currency_blacklist set CurrencyKindCode=@CurrencyKindCode, FaceAmount=@FaceAmount, " +
" CurrencyVersion=@CurrencyVersion, CurrencyNumber=@CurrencyNumber where PkId=@PkId ";
parameterList.Add(new MySqlParameter("@CurrencyKindCode", objCurrencyBlacklist.CurrencyKindCode));
parameterList.Add(new MySqlParameter("@FaceAmount", objCurrencyBlacklist.FaceAmount));
parameterList.Add(new MySqlParameter("@CurrencyVersion", objCurrencyBlacklist.CurrencyVersion));
parameterList.Add(new MySqlParameter("@CurrencyNumber", objCurrencyBlacklist.CurrencyNumber));
parameterList.Add(new MySqlParameter("@PkId", objCurrencyBlacklist.PkId));
}
DbHelper.ExecuteNonQuery(sql, CommandType.Text, parameterList.ToArray());
}
public void Save(CurrencyBlacklist objCurrencyBlacklist)
{
string sql = null;
List<DbParameter> parameterList = new List<DbParameter>();
if (objCurrencyBlacklist.PkId == 0)
{
sql = " insert into tbl_currency_blacklist(PkId, CurrencyKindCode, FaceAmount, CurrencyVersion, CurrencyNumber) " +
" values(TCB_PKID.NEXTVAL, :CurrencyKindCode, :FaceAmount, :CurrencyVersion, :CurrencyNumber) ";
parameterList.Add(new OracleParameter(":CurrencyKindCode", objCurrencyBlacklist.CurrencyKindCode));
parameterList.Add(new OracleParameter(":FaceAmount", objCurrencyBlacklist.FaceAmount));
parameterList.Add(new OracleParameter(":CurrencyVersion", objCurrencyBlacklist.CurrencyVersion));
parameterList.Add(new OracleParameter(":CurrencyNumber", objCurrencyBlacklist.CurrencyNumber));
}
else
{
sql = " update tbl_currency_blacklist set CurrencyKindCode=:CurrencyKindCode, FaceAmount=:FaceAmount, " +
" CurrencyVersion=:CurrencyVersion, CurrencyNumber=:CurrencyNumber where PkId=:PkId ";
parameterList.Add(new OracleParameter(":CurrencyKindCode", objCurrencyBlacklist.CurrencyKindCode));
parameterList.Add(new OracleParameter(":FaceAmount", objCurrencyBlacklist.FaceAmount));
parameterList.Add(new OracleParameter(":CurrencyVersion", objCurrencyBlacklist.CurrencyVersion));
parameterList.Add(new OracleParameter(":CurrencyNumber", objCurrencyBlacklist.CurrencyNumber));
parameterList.Add(new OracleParameter(":PkId", objCurrencyBlacklist.PkId));
}
DbHelper.ExecuteNonQuery(sql, CommandType.Text, parameterList.ToArray());
}
public static byte[] GetCurrencyNumberBytes(CurrencyBlacklist item)
{
var buff = new byte[18];
buff[0] = item.CurrencyKindCode;
var tmp = BitConverter.GetBytes(item.FaceAmount);
buff[1] = tmp[1];
buff[2] = tmp[0];
tmp = BitConverter.GetBytes(item.CurrencyVersion);
buff[3] = tmp[1];
buff[4] = tmp[0];
tmp = System.Text.Encoding.ASCII.GetBytes(item.CurrencyNumber);
for (int i = 0; i < tmp.Length; i++)
{
buff[i + 5] = tmp[i];
}
return buff;
}
public bool CheckExists_Blacklist(CurrencyBlacklist objCurrencyBlacklist)
{
var repository = ServiceFactory.GetService<ICurrencyBlacklistRepository>();
return repository.CheckExists(objCurrencyBlacklist);
}
public void Save_Blacklist(CurrencyBlacklist objCurrencyBlacklist)
{
var repository = ServiceFactory.GetService<ICurrencyBlacklistRepository>();
repository.Save(objCurrencyBlacklist);
}
