/// <summary> /// 更新桥梁隧道信息表 /// </summary> /// <param name="dao">数据对象</param> /// <returns>成功/失败</returns> public bool Update(BridgeAndTunnelInfo dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("update BridgeAndTunnelInfo set "); stmt.AppendString("GroupID="); stmt.AppendParameter(_session.MakeInParameter("GroupID", dao.GroupID, SqlDbType.UniqueIdentifier)); stmt.AppendString(",Category="); stmt.AppendParameter(_session.MakeInParameter("Category", dao.Category, SqlDbType.Int)); stmt.AppendString(",StartMileage="); stmt.AppendParameter(_session.MakeInParameter("StartMileage", dao.StartMileage, SqlDbType.NVarChar)); stmt.AppendString(",EndMileage="); stmt.AppendParameter(_session.MakeInParameter("EndMileage", dao.EndMileage, SqlDbType.NVarChar)); stmt.AppendString(",Type="); stmt.AppendParameter(_session.MakeInParameter("Type", dao.Type, SqlDbType.NVarChar)); stmt.AppendString(",Remark1="); stmt.AppendParameter(_session.MakeInParameter("Remark1", dao.Remark1, SqlDbType.NVarChar)); stmt.AppendString(",Remark2="); stmt.AppendParameter(_session.MakeInParameter("Remark2", dao.Remark2, SqlDbType.NVarChar)); stmt.AppendString(" where "); stmt.AppendString("ID="); stmt.AppendParameter(_session.MakeInParameter("ID", dao.ID, SqlDbType.Int)); stmt.StatementType = SqlStatementType.Update; return(_session.Excecute(stmt).RowsAffected > 0); }
/// <summary> /// 新增桥梁隧道信息表 /// </summary> /// <param name="dao">数据对象</param> /// <returns>成功/失败</returns> public bool Insert(BridgeAndTunnelInfo dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("insert into BridgeAndTunnelInfo(GroupID,Category,StartMileage,EndMileage,Type,Remark1,Remark2) values ("); stmt.AppendParameter(_session.MakeInParameter("GroupID", dao.GroupID, SqlDbType.UniqueIdentifier)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("Category", dao.Category, SqlDbType.Int)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("StartMileage", dao.StartMileage, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("EndMileage", dao.EndMileage, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("Type", dao.Type, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("Remark1", dao.Remark1, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("Remark2", dao.Remark2, SqlDbType.NVarChar)); stmt.AppendString(");select SCOPE_IDENTITY();"); stmt.StatementType = SqlStatementType.Identity; SqlResult result = _session.Excecute(stmt); if (result.Data != null) { dao.ID = int.Parse(result.Data.ToString()); return(true); } return(false); }
/// <summary> /// 获取指定大小的一页桥梁隧道信息表集合 /// </summary> /// <param name="pageIndex">当前页码</param> /// <param name="pageSize">分页大小</param> /// <param name="rowsCount">总记录条数</param> /// <returns>分页数据</returns> public ObservableCollection <BridgeAndTunnelInfo> SelectAllCollection(int pageIndex, int pageSize, int rowsCount) { ObservableCollection <BridgeAndTunnelInfo> datas = new ObservableCollection <BridgeAndTunnelInfo>(); GenDataReader reader = Session.ExcecuteReader(_dal.SelectAllSqlStatement(), pageIndex, pageSize, rowsCount); while (reader.Read()) { BridgeAndTunnelInfo dao = new BridgeAndTunnelInfo(); _dal.DataReaderToEntity(reader, dao); datas.Add(dao); } reader.Close(); return(datas); }
/// <summary> /// 获取指定的桥梁隧道信息表 /// </summary> /// <param name="iD">顺序号</param> /// <returns>桥梁隧道信息表</returns> public BridgeAndTunnelInfo SelectOne(int iD) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("select * from BridgeAndTunnelInfo where ID="); stmt.AppendParameter(_session.MakeInParameter("ID", iD, SqlDbType.Int)); stmt.StatementType = SqlStatementType.Select; SqlResult result = _session.Excecute(stmt); BridgeAndTunnelInfo bridgeAndTunnelInfo = new BridgeAndTunnelInfo(); if (result.RowsAffected > 0) { DataRowToEntity(result.Tables[0].Rows[0], bridgeAndTunnelInfo); } return(bridgeAndTunnelInfo); }
/// <summary> /// 获取所有的桥梁隧道信息表集合 /// </summary> /// <returns>所有信息</returns> public ObservableCollection <BridgeAndTunnelInfo> SelectAllCollection() { ObservableCollection <BridgeAndTunnelInfo> datas = new ObservableCollection <BridgeAndTunnelInfo>(); SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("select * from BridgeAndTunnelInfo"); stmt.StatementType = SqlStatementType.Select; GenDataReader reader = _session.ExcecuteReader(stmt); while (reader.Read()) { BridgeAndTunnelInfo dao = new BridgeAndTunnelInfo(); DataReaderToEntity(reader, dao); datas.Add(dao); } reader.Close(); return(datas); }
/// <summary> /// 新增桥梁隧道信息表 /// </summary> /// <param name="dao">数据对象</param> /// <returns>成功/失败</returns> public bool Insert(BridgeAndTunnelInfo dao) { bool ret = false; try { Session.Open(); Session.BeginTransaction(); ret = _dal.Insert(dao); Session.CommitTransaction(); } catch (Exception err) { ret = false; Log.Error(dao, err); Session.RollBackTransaction(); } finally { Session.Close(); } return(ret); }
/// <summary> /// 获取指定的IDataReader中的BridgeAndTunnelInfo /// </summary> /// <param name="reader">IDataReader对象</param> /// <param name="dao">BridgeAndTunnelInfo实体类</param> public void DataReaderToEntity(IDataReader reader, BridgeAndTunnelInfo dao) { object data; data = reader["ID"]; if (data == null || data == DBNull.Value) { dao.ID = int.MinValue; } else { dao.ID = int.Parse(data.ToString()); } data = reader["GroupID"]; if (data == null || data == DBNull.Value) { dao.GroupID = Guid.NewGuid(); } else { dao.GroupID = Guid.Parse(data.ToString()); } data = reader["Category"]; if (data == null || data == DBNull.Value) { dao.Category = int.MinValue; } else { dao.Category = int.Parse(data.ToString()); } data = reader["StartMileage"]; if (data == null || data == DBNull.Value) { dao.StartMileage = null; } else { dao.StartMileage = data.ToString(); } data = reader["EndMileage"]; if (data == null || data == DBNull.Value) { dao.EndMileage = null; } else { dao.EndMileage = data.ToString(); } data = reader["Type"]; if (data == null || data == DBNull.Value) { dao.Type = null; } else { dao.Type = data.ToString(); } data = reader["Remark1"]; if (data == null || data == DBNull.Value) { dao.Remark1 = null; } else { dao.Remark1 = data.ToString(); } data = reader["Remark2"]; if (data == null || data == DBNull.Value) { dao.Remark2 = null; } else { dao.Remark2 = data.ToString(); } }
/// <summary> /// 获取指定的数据行DataRow转换成BridgeAndTunnelInfo /// </summary> /// <param name="dr">DataRow数据</param> /// <param name="dao">BridgeAndTunnelInfo实体类</param> public void DataRowToEntity(DataRow dr, BridgeAndTunnelInfo dao) { if (dr["ID"] == null || dr["ID"] == DBNull.Value) { dao.ID = int.MinValue; } else { dao.ID = int.Parse(dr["ID"].ToString()); } if (dr["GroupID"] == null || dr["GroupID"] == DBNull.Value) { dao.GroupID = Guid.NewGuid(); } else { dao.GroupID = Guid.Parse(dr["GroupID"].ToString()); } if (dr["Category"] == null || dr["Category"] == DBNull.Value) { dao.Category = int.MinValue; } else { dao.Category = int.Parse(dr["Category"].ToString()); } if (dr["StartMileage"] == null || dr["StartMileage"] == DBNull.Value) { dao.StartMileage = null; } else { dao.StartMileage = dr["StartMileage"].ToString(); } if (dr["EndMileage"] == null || dr["EndMileage"] == DBNull.Value) { dao.EndMileage = null; } else { dao.EndMileage = dr["EndMileage"].ToString(); } if (dr["Type"] == null || dr["Type"] == DBNull.Value) { dao.Type = null; } else { dao.Type = dr["Type"].ToString(); } if (dr["Remark1"] == null || dr["Remark1"] == DBNull.Value) { dao.Remark1 = null; } else { dao.Remark1 = dr["Remark1"].ToString(); } if (dr["Remark2"] == null || dr["Remark2"] == DBNull.Value) { dao.Remark2 = null; } else { dao.Remark2 = dr["Remark2"].ToString(); } }