/// <summary> /// 更新一条数据 /// </summary> public void Update(QH_CapitalAccountFreezeTableInfo model, ReckoningTransaction tm) { StringBuilder strSql = new StringBuilder(); strSql.Append("update QH_CapitalAccountFreezeTable set "); strSql.Append("FreezeTime=@FreezeTime,"); strSql.Append("FreezeAmount=@FreezeAmount,"); strSql.Append("ThawTime=@ThawTime,"); strSql.Append("CapitalAccountLogo=@CapitalAccountLogo,"); strSql.Append("FreezeTypeLogo=@FreezeTypeLogo,"); strSql.Append("EntrustNumber=@EntrustNumber,"); strSql.Append("OweCosting=@OweCosting,"); strSql.Append("FreezeCost=@FreezeCost"); strSql.Append(" where CapitalFreezeLogoId=@CapitalFreezeLogoId "); Database db = tm.Database; DbTransaction trans = tm.Transaction; DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "CapitalFreezeLogoId", DbType.Int32, model.CapitalFreezeLogoId); db.AddInParameter(dbCommand, "FreezeTime", DbType.DateTime, model.FreezeTime); db.AddInParameter(dbCommand, "FreezeAmount", DbType.Decimal, model.FreezeAmount); db.AddInParameter(dbCommand, "ThawTime", DbType.DateTime, model.ThawTime); db.AddInParameter(dbCommand, "CapitalAccountLogo", DbType.Int32, model.CapitalAccountLogo); db.AddInParameter(dbCommand, "FreezeTypeLogo", DbType.Int32, model.FreezeTypeLogo); db.AddInParameter(dbCommand, "EntrustNumber", DbType.AnsiString, model.EntrustNumber); db.AddInParameter(dbCommand, "OweCosting", DbType.Decimal, model.OweCosting); db.AddInParameter(dbCommand, "FreezeCost", DbType.Decimal, model.FreezeCost); db.ExecuteNonQuery(dbCommand, trans); }
/// <summary> /// 增加一条数据 /// </summary> public bool AddRecord(QH_CapitalAccountFreezeTableInfo model, ReckoningTransaction tm) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into QH_CapitalAccountFreezeTable("); strSql.Append( "FreezeTime,FreezeAmount,ThawTime,CapitalAccountLogo,FreezeTypeLogo,EntrustNumber,OweCosting,FreezeCost)"); strSql.Append(" values ("); strSql.Append( "@FreezeTime,@FreezeAmount,@ThawTime,@CapitalAccountLogo,@FreezeTypeLogo,@EntrustNumber,@OweCosting,@FreezeCost)"); strSql.Append(";select @@IDENTITY"); Database db = tm.Database; DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "FreezeTime", DbType.DateTime, model.FreezeTime); db.AddInParameter(dbCommand, "FreezeAmount", DbType.Decimal, model.FreezeAmount); db.AddInParameter(dbCommand, "ThawTime", DbType.DateTime, model.ThawTime); db.AddInParameter(dbCommand, "CapitalAccountLogo", DbType.Int32, model.CapitalAccountLogo); db.AddInParameter(dbCommand, "FreezeTypeLogo", DbType.Int32, model.FreezeTypeLogo); db.AddInParameter(dbCommand, "EntrustNumber", DbType.AnsiString, model.EntrustNumber); db.AddInParameter(dbCommand, "OweCosting", DbType.Decimal, model.OweCosting); db.AddInParameter(dbCommand, "FreezeCost", DbType.Decimal, model.FreezeCost); int result; object obj = db.ExecuteScalar(dbCommand, tm.Transaction); if (!int.TryParse(obj.ToString(), out result)) { return(false); } model.CapitalFreezeLogoId = result; return(true); }
/// <summary> /// 插入一条空的资金冻结记录 /// </summary> /// <param name="capitalAccountId"></param> /// <param name="entrustNumber"></param> /// <returns></returns> public static int InsertNullCapitalFreeze(int capitalAccountId, string entrustNumber) { QH_CapitalAccountFreezeTableInfo caf = new QH_CapitalAccountFreezeTableInfo(); caf.CapitalAccountLogo = capitalAccountId; caf.EntrustNumber = entrustNumber; caf.FreezeTypeLogo = (int)Types.FreezeType.DelegateFreeze; caf.FreezeTime = DateTime.Now; caf.FreezeAmount = 0; caf.FreezeCost = 0; QH_CapitalAccountFreezeTableDal dal = new QH_CapitalAccountFreezeTableDal(); return(dal.Add(caf)); }
/// <summary> /// 对象实体绑定数据 /// </summary> public QH_CapitalAccountFreezeTableInfo ReaderBind(IDataReader dataReader) { QH_CapitalAccountFreezeTableInfo model = new QH_CapitalAccountFreezeTableInfo(); object ojb; ojb = dataReader["CapitalFreezeLogoId"]; if (ojb != null && ojb != DBNull.Value) { model.CapitalFreezeLogoId = (int)ojb; } ojb = dataReader["FreezeTime"]; if (ojb != null && ojb != DBNull.Value) { model.FreezeTime = (DateTime)ojb; } ojb = dataReader["FreezeAmount"]; if (ojb != null && ojb != DBNull.Value) { model.FreezeAmount = (decimal)ojb; } ojb = dataReader["ThawTime"]; if (ojb != null && ojb != DBNull.Value) { model.ThawTime = (DateTime)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["OweCosting"]; if (ojb != null && ojb != DBNull.Value) { model.OweCosting = (decimal)ojb; } ojb = dataReader["FreezeCost"]; if (ojb != null && ojb != DBNull.Value) { model.FreezeCost = (decimal)ojb; } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public QH_CapitalAccountFreezeTableInfo GetModel(int CapitalFreezeLogoId) { StringBuilder strSql = new StringBuilder(); strSql.Append( "select CapitalFreezeLogoId,FreezeTime,FreezeAmount,ThawTime,CapitalAccountLogo,FreezeTypeLogo,EntrustNumber,OweCosting,FreezeCost from QH_CapitalAccountFreezeTable "); strSql.Append(" where CapitalFreezeLogoId=@CapitalFreezeLogoId "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "CapitalFreezeLogoId", DbType.Int32, CapitalFreezeLogoId); QH_CapitalAccountFreezeTableInfo model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }