/// <summary> /// 增加一条数据 /// </summary> public int Add(ManagementCenter.Model.CM_NotTradeDate model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CM_NotTradeDate("); strSql.Append("NotTradeDay,BourseTypeID)"); strSql.Append(" values ("); strSql.Append("@NotTradeDay,@BourseTypeID)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); //db.AddInParameter(dbCommand, "NotTradeDateID", DbType.Int32, model.NotTradeDateID); db.AddInParameter(dbCommand, "NotTradeDay", DbType.DateTime, model.NotTradeDay); db.AddInParameter(dbCommand, "BourseTypeID", DbType.Int32, model.BourseTypeID); //db.ExecuteNonQuery(dbCommand); int result; object obj = db.ExecuteScalar(dbCommand); if (!int.TryParse(obj.ToString(), out result)) { return(AppGlobalVariable.INIT_INT); } return(result); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ManagementCenter.Model.CM_NotTradeDate model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CM_NotTradeDate set "); //strSql.Append("NotTradeDateMonth=@NotTradeDateMonth,"); strSql.Append("NotTradeDay=@NotTradeDay,"); strSql.Append("BourseTypeID=@BourseTypeID"); strSql.Append(" where NotTradeDateID=@NotTradeDateID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "NotTradeDateID", DbType.Int32, model.NotTradeDateID); //db.AddInParameter(dbCommand, "NotTradeDateMonth", DbType.Int32, model.NotTradeDateMonth); db.AddInParameter(dbCommand, "NotTradeDay", DbType.DateTime, model.NotTradeDay); db.AddInParameter(dbCommand, "BourseTypeID", DbType.Int32, model.BourseTypeID); db.ExecuteNonQuery(dbCommand); return(true); }
/// <summary> /// 得到一个对象实体 /// </summary> public ManagementCenter.Model.CM_NotTradeDate GetModel(int NotTradeDateID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select NotTradeDateID,NotTradeDay,BourseTypeID from CM_NotTradeDate "); strSql.Append(" where NotTradeDateID=@NotTradeDateID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "NotTradeDateID", DbType.Int32, NotTradeDateID); ManagementCenter.Model.CM_NotTradeDate model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 对象实体绑定数据 /// </summary> public ManagementCenter.Model.CM_NotTradeDate ReaderBind(IDataReader dataReader) { ManagementCenter.Model.CM_NotTradeDate model = new ManagementCenter.Model.CM_NotTradeDate(); object ojb; ojb = dataReader["NotTradeDateID"]; if (ojb != null && ojb != DBNull.Value) { model.NotTradeDateID = (int)ojb; } ojb = dataReader["NotTradeDay"]; if (ojb != null && ojb != DBNull.Value) { model.NotTradeDay = (DateTime)ojb; } ojb = dataReader["BourseTypeID"]; if (ojb != null && ojb != DBNull.Value) { model.BourseTypeID = (int)ojb; } return(model); }