/// <summary> /// 更新一条数据 /// </summary> public void Update(ManagementCenter.Model.RC_MatchMachine model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update RC_MatchMachine set "); strSql.Append("MatchMachineName=@MatchMachineName,"); strSql.Append("BourseTypeID=@BourseTypeID,"); strSql.Append("MatchCenterID=@MatchCenterID"); strSql.Append(" where MatchMachineID=@MatchMachineID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "MatchMachineID", DbType.Int32, model.MatchMachineID); db.AddInParameter(dbCommand, "MatchMachineName", DbType.String, model.MatchMachineName); db.AddInParameter(dbCommand, "BourseTypeID", DbType.Int32, model.BourseTypeID); db.AddInParameter(dbCommand, "MatchCenterID", DbType.Int32, model.MatchCenterID); db.ExecuteNonQuery(dbCommand); }
/// <summary> /// 得到一个对象实体 /// </summary> public ManagementCenter.Model.RC_MatchMachine GetModel(int MatchMachineID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select MatchMachineID,MatchMachineName,BourseTypeID,MatchCenterID from RC_MatchMachine "); strSql.Append(" where MatchMachineID=@MatchMachineID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "MatchMachineID", DbType.Int32, MatchMachineID); ManagementCenter.Model.RC_MatchMachine model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 撮合机分页查询 /// </summary> /// <param name="machineQueryEntity">撮合机实休</param> /// <param name="pageNo">当前页</param> /// <param name="pageSize">显示记录数</param> /// <param name="rowCount">总行数</param> /// <returns></returns> public DataSet GetPagingMachine(ManagementCenter.Model.RC_MatchMachine machineQueryEntity, int pageNo, int pageSize, out int rowCount) { string SQL_SELECT_Machine = @" select MatchMachineID,MatchMachineName,BourseTypeID,MatchCenterID FROM RC_MatchMachine where 1=1 "; if (machineQueryEntity.BourseTypeID != int.MaxValue) { SQL_SELECT_Machine += "AND BourseTypeID=@BourseTypeID "; } if (machineQueryEntity.MatchCenterID != int.MaxValue) { SQL_SELECT_Machine += "AND MatchCenterID=@MatchCenterID "; } if (machineQueryEntity.MatchMachineID != int.MaxValue) { SQL_SELECT_Machine += "AND MatchMachineID=@MatchMachineID "; } Database database = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = database.GetSqlStringCommand(SQL_SELECT_Machine); if (machineQueryEntity.BourseTypeID != int.MaxValue) { database.AddInParameter(dbCommand, "BourseTypeID", DbType.Int32, machineQueryEntity.BourseTypeID); } if (machineQueryEntity.MatchCenterID != int.MaxValue) { database.AddInParameter(dbCommand, "MatchCenterID", DbType.Int32, machineQueryEntity.MatchCenterID); } if (machineQueryEntity.MatchMachineID != int.MaxValue) { database.AddInParameter(dbCommand, "MatchMachineID", DbType.Int32, machineQueryEntity.MatchMachineID); } return(CommPager.QueryPager(database, dbCommand, SQL_SELECT_Machine, pageNo, pageSize, out rowCount, "UM_Machine")); }
/// <summary> /// 对象实体绑定数据 /// </summary> public ManagementCenter.Model.RC_MatchMachine ReaderBind(IDataReader dataReader) { ManagementCenter.Model.RC_MatchMachine model = new ManagementCenter.Model.RC_MatchMachine(); object ojb; ojb = dataReader["MatchMachineID"]; if (ojb != null && ojb != DBNull.Value) { model.MatchMachineID = (int)ojb; } model.MatchMachineName = dataReader["MatchMachineName"].ToString(); ojb = dataReader["BourseTypeID"]; if (ojb != null && ojb != DBNull.Value) { model.BourseTypeID = (int)ojb; } ojb = dataReader["MatchCenterID"]; if (ojb != null && ojb != DBNull.Value) { model.MatchCenterID = (int)ojb; } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ManagementCenter.Model.RC_MatchMachine model, DbTransaction tran, Database db) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into RC_MatchMachine("); strSql.Append("MatchMachineName,BourseTypeID,MatchCenterID)"); strSql.Append(" values ("); strSql.Append("@MatchMachineName,@BourseTypeID,@MatchCenterID)"); strSql.Append(";select @@IDENTITY"); if (db == null) { db = DatabaseFactory.CreateDatabase(); } DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "MatchMachineName", DbType.String, model.MatchMachineName); db.AddInParameter(dbCommand, "BourseTypeID", DbType.Int32, model.BourseTypeID); db.AddInParameter(dbCommand, "MatchCenterID", DbType.Int32, model.MatchCenterID); int result; object obj; if (tran == null) { obj = db.ExecuteScalar(dbCommand); } else { obj = db.ExecuteScalar(dbCommand, tran); } if (!int.TryParse(obj.ToString(), out result)) { return(0); } return(result); }
/// <summary> /// 添加撮合机 /// </summary> /// <param name="model">撮合机实体</param> /// <returns></returns> public int Add(ManagementCenter.Model.RC_MatchMachine model) { return(Add(model, null, null)); }