/// <summary> /// 增加一条数据 /// </summary> public int Add(HK_CapitalAccountFreezeInfo model, Database db, DbTransaction transaction) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into HK_CapitalAccountFreeze("); strSql.Append("FreezeTime,FreezeCapitalAmount,ThawTime,FreezeTypeLogo,"); strSql.Append(" EntrustNumber,CapitalAccountLogo,OweCosting,FreezeCost)"); strSql.Append(" values ("); strSql.Append("@FreezeTime,@FreezeCapitalAmount,@ThawTime,@FreezeTypeLogo,"); strSql.Append(" @EntrustNumber,@CapitalAccountLogo,@OweCosting,@FreezeCost)"); strSql.Append(";select @@IDENTITY"); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "FreezeTime", DbType.DateTime, model.FreezeTime); db.AddInParameter(dbCommand, "FreezeCapitalAmount", DbType.Decimal, model.FreezeCapitalAmount); db.AddInParameter(dbCommand, "ThawTime", DbType.DateTime, model.ThawTime); db.AddInParameter(dbCommand, "FreezeTypeLogo", DbType.Int32, model.FreezeTypeLogo); db.AddInParameter(dbCommand, "EntrustNumber", DbType.AnsiString, model.EntrustNumber); db.AddInParameter(dbCommand, "CapitalAccountLogo", DbType.Int32, model.CapitalAccountLogo); db.AddInParameter(dbCommand, "OweCosting", DbType.Decimal, model.OweCosting); db.AddInParameter(dbCommand, "FreezeCost", DbType.Decimal, model.FreezeCost); int result; object obj = db.ExecuteScalar(dbCommand, transaction); if (!int.TryParse(obj.ToString(), out result)) { return(0); } return(result); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(HK_CapitalAccountFreezeInfo model, ReckoningTransaction tm) { StringBuilder strSql = new StringBuilder(); strSql.Append("update HK_CapitalAccountFreeze set "); strSql.Append("FreezeTime=@FreezeTime,"); strSql.Append("FreezeCapitalAmount=@FreezeCapitalAmount,"); strSql.Append("ThawTime=@ThawTime,"); strSql.Append("FreezeTypeLogo=@FreezeTypeLogo,"); strSql.Append("EntrustNumber=@EntrustNumber,"); strSql.Append("CapitalAccountLogo=@CapitalAccountLogo,"); strSql.Append("OweCosting=@OweCosting,"); strSql.Append("FreezeCost=@FreezeCost"); strSql.Append(" where CapitalFreezeLogoId=@CapitalFreezeLogoId "); Database db = tm.Database; DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "FreezeTime", DbType.DateTime, model.FreezeTime); db.AddInParameter(dbCommand, "FreezeCapitalAmount", DbType.Decimal, model.FreezeCapitalAmount); db.AddInParameter(dbCommand, "CapitalFreezeLogoId", DbType.Int32, model.CapitalFreezeLogoId); db.AddInParameter(dbCommand, "ThawTime", DbType.DateTime, model.ThawTime); db.AddInParameter(dbCommand, "FreezeTypeLogo", DbType.Int32, model.FreezeTypeLogo); db.AddInParameter(dbCommand, "EntrustNumber", DbType.AnsiString, model.EntrustNumber); db.AddInParameter(dbCommand, "CapitalAccountLogo", DbType.Int32, model.CapitalAccountLogo); db.AddInParameter(dbCommand, "OweCosting", DbType.Decimal, model.OweCosting); db.AddInParameter(dbCommand, "FreezeCost", DbType.Decimal, model.FreezeCost); db.ExecuteNonQuery(dbCommand, tm.Transaction); }
private int PO_BuildCapitalFreezeRecord(decimal predealCapital, decimal predealCost, Types.TransactionDirection buySellType, ReckoningTransaction tm) { HK_CapitalAccountFreezeInfo caft = new HK_CapitalAccountFreezeInfo(); caft.EntrustNumber = EntrustNumber; //委托单号 //卖不产生冻结金额,只有费用 if (buySellType == Types.TransactionDirection.Buying) { caft.FreezeCapitalAmount = predealCapital; //冻结 预成交金额 } caft.FreezeCost = predealCost; //冻结 预成交费用 caft.FreezeTime = DateTime.Now; //冻结时间 caft.ThawTime = DateTime.Now; //解冻时间 caft.FreezeTypeLogo = (int)Entity.Contants.Types.FreezeType.DelegateFreeze; //冻结类型 caft.OweCosting = 0; caft.CapitalAccountLogo = CapitalAccountId; string format = "港股资金冻结处理HKBuyOrderLogicFlow.PO_BuildCapitalFreezeRecord[委托单号={0},冻结时间={1},解冻时间={2},冻结类型={3},预成交金额={4},预成交费用={5},资金账户ID={6}]"; string desc = string.Format(format, caft.EntrustNumber, caft.FreezeTime, caft.ThawTime, caft.FreezeTypeLogo, caft.FreezeCapitalAmount, caft.FreezeCost, CapitalAccountId); LogHelper.WriteDebug(desc); HK_CapitalAccountFreezeDal dal = new HK_CapitalAccountFreezeDal(); return(dal.Add(caft, tm.Database, tm.Transaction)); }
/// <summary> /// 插入一条空的资金冻结记录 /// </summary> /// <param name="capitalAccountId"></param> /// <param name="entrustNumber"></param> /// <returns></returns> public static int InsertNullCapitalFreeze(int capitalAccountId, string entrustNumber) { HK_CapitalAccountFreezeInfo caf = new HK_CapitalAccountFreezeInfo(); caf.CapitalAccountLogo = capitalAccountId; caf.EntrustNumber = entrustNumber; caf.FreezeTypeLogo = (int)Types.FreezeType.DelegateFreeze; caf.FreezeTime = DateTime.Now; caf.FreezeCapitalAmount = 0; caf.FreezeCost = 0; HK_CapitalAccountFreezeDal dal = new HK_CapitalAccountFreezeDal(); return(dal.Add(caf)); }
/// <summary> /// 对象实体绑定数据 /// <param name="dataReader"></param> /// </summary> public HK_CapitalAccountFreezeInfo ReaderBind(IDataReader dataReader) { HK_CapitalAccountFreezeInfo model = new HK_CapitalAccountFreezeInfo(); object ojb; ojb = dataReader["CapitalFreezeLogoId"]; if (ojb != null && ojb != DBNull.Value) { model.CapitalFreezeLogoId = (int)ojb; } ojb = dataReader["CapitalAccountLogo"]; if (ojb != null && ojb != DBNull.Value) { model.CapitalAccountLogo = (int)ojb; } ojb = dataReader["FreezeTypeLogo"]; if (ojb != null && ojb != DBNull.Value) { model.FreezeTypeLogo = (int)ojb; } model.EntrustNumber = dataReader["EntrustNumber"].ToString(); ojb = dataReader["FreezeCapitalAmount"]; if (ojb != null && ojb != DBNull.Value) { model.FreezeCapitalAmount = (decimal)ojb; } ojb = dataReader["FreezeCost"]; if (ojb != null && ojb != DBNull.Value) { model.FreezeCost = (decimal)ojb; } ojb = dataReader["OweCosting"]; if (ojb != null && ojb != DBNull.Value) { model.OweCosting = (decimal)ojb; } ojb = dataReader["ThawTime"]; if (ojb != null && ojb != DBNull.Value) { model.ThawTime = (DateTime)ojb; } ojb = dataReader["FreezeTime"]; if (ojb != null && ojb != DBNull.Value) { model.FreezeTime = (DateTime)ojb; } return(model); }
/// <summary> /// 得到一个对象实体 ///<param name="CapitalFreezeLogoId"></param> /// </summary> public HK_CapitalAccountFreezeInfo GetModel(int CapitalFreezeLogoId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select CapitalFreezeLogoId,CapitalAccountLogo,FreezeTypeLogo,EntrustNumber,FreezeCapitalAmount,FreezeCost,OweCosting,ThawTime,FreezeTime from HK_CapitalAccountFreeze "); strSql.Append(" where CapitalFreezeLogoId=@CapitalFreezeLogoId "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "CapitalFreezeLogoId", DbType.Int32, CapitalFreezeLogoId); HK_CapitalAccountFreezeInfo model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }