/// <summary> /// 更新一条数据 /// </summary> public void Update(HK_HistoryModifyOrderRequestInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update HK_HistoryModifyOrderRequest set "); strSql.Append("ChannelID=@ChannelID,"); strSql.Append("TraderId=@TraderId,"); strSql.Append("FundAccountId=@FundAccountId,"); strSql.Append("TraderPassword=@TraderPassword,"); strSql.Append("Code=@Code,"); strSql.Append("EntrustNubmer=@EntrustNubmer,"); strSql.Append("OrderPrice=@OrderPrice,"); strSql.Append("OrderAmount=@OrderAmount,"); strSql.Append("Message=@Message,"); strSql.Append("ModifyOrderDateTime=@ModifyOrderDateTime"); strSql.Append(" where ID=@ID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ID", DbType.AnsiString, model.ID); db.AddInParameter(dbCommand, "ChannelID", DbType.AnsiString, model.ChannelID); db.AddInParameter(dbCommand, "TraderId", DbType.AnsiString, model.TraderId); db.AddInParameter(dbCommand, "FundAccountId", DbType.AnsiString, model.FundAccountId); db.AddInParameter(dbCommand, "TraderPassword", DbType.AnsiString, model.TraderPassword); db.AddInParameter(dbCommand, "Code", DbType.AnsiString, model.Code); db.AddInParameter(dbCommand, "EntrustNubmer", DbType.AnsiString, model.EntrustNubmer); db.AddInParameter(dbCommand, "OrderPrice", DbType.Decimal, model.OrderPrice); db.AddInParameter(dbCommand, "OrderAmount", DbType.Int32, model.OrderAmount); db.AddInParameter(dbCommand, "Message", DbType.AnsiString, model.Message); db.AddInParameter(dbCommand, "ModifyOrderDateTime", DbType.DateTime, model.ModifyOrderDateTime); db.ExecuteNonQuery(dbCommand); }
/// <summary> /// 对象实体绑定数据 /// </summary> public HK_HistoryModifyOrderRequestInfo ReaderBind(IDataReader dataReader) { HK_HistoryModifyOrderRequestInfo model = new HK_HistoryModifyOrderRequestInfo(); object ojb; model.ID = dataReader["ID"].ToString(); model.ChannelID = dataReader["ChannelID"].ToString(); model.TraderId = dataReader["TraderId"].ToString(); model.FundAccountId = dataReader["FundAccountId"].ToString(); model.TraderPassword = dataReader["TraderPassword"].ToString(); model.Code = dataReader["Code"].ToString(); model.EntrustNubmer = dataReader["EntrustNubmer"].ToString(); ojb = dataReader["OrderPrice"]; if (ojb != null && ojb != DBNull.Value) { model.OrderPrice = float.Parse(ojb.ToString()); } ojb = dataReader["OrderAmount"]; if (ojb != null && ojb != DBNull.Value) { model.OrderAmount = float.Parse(ojb.ToString()); } model.Message = dataReader["Message"].ToString(); ojb = dataReader["ModifyOrderDateTime"]; if (ojb != null && ojb != DBNull.Value) { model.ModifyOrderDateTime = (DateTime)ojb; } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(HK_HistoryModifyOrderRequestInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into HK_HistoryModifyOrderRequest("); strSql.Append("ID,ChannelID,TraderId,FundAccountId,TraderPassword,Code,EntrustNubmer,OrderPrice,OrderAmount,Message,ModifyOrderDateTime)"); strSql.Append(" values ("); strSql.Append("@ID,@ChannelID,@TraderId,@FundAccountId,@TraderPassword,@Code,@EntrustNubmer,@OrderPrice,@OrderAmount,@Message,@ModifyOrderDateTime)"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ID", DbType.AnsiString, model.ID); db.AddInParameter(dbCommand, "ChannelID", DbType.AnsiString, model.ChannelID); db.AddInParameter(dbCommand, "TraderId", DbType.AnsiString, model.TraderId); db.AddInParameter(dbCommand, "FundAccountId", DbType.AnsiString, model.FundAccountId); db.AddInParameter(dbCommand, "TraderPassword", DbType.AnsiString, model.TraderPassword); db.AddInParameter(dbCommand, "Code", DbType.AnsiString, model.Code); db.AddInParameter(dbCommand, "EntrustNubmer", DbType.AnsiString, model.EntrustNubmer); db.AddInParameter(dbCommand, "OrderPrice", DbType.Decimal, model.OrderPrice); db.AddInParameter(dbCommand, "OrderAmount", DbType.Int32, model.OrderAmount); db.AddInParameter(dbCommand, "Message", DbType.AnsiString, model.Message); db.AddInParameter(dbCommand, "ModifyOrderDateTime", DbType.DateTime, model.ModifyOrderDateTime); db.ExecuteNonQuery(dbCommand); }
/// <summary> /// 得到一个对象实体 /// </summary> public HK_HistoryModifyOrderRequestInfo GetModel(string ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,ChannelID,TraderId,FundAccountId,TraderPassword,Code,EntrustNubmer,OrderPrice,OrderAmount,Message,ModifyOrderDateTime from HK_HistoryModifyOrderRequest "); strSql.Append(" where ID=@ID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ID", DbType.AnsiString, ID); HK_HistoryModifyOrderRequestInfo model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }