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 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 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 OracleParameter(":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); }
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.Version); 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); }
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.PathAndQuery; } this.JscriptMsg("数据保存成功", this.ReturnUrl, "Success"); } }
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); }