/// <summary> /// 新增RBC信息表 /// </summary> /// <param name="dao">数据对象</param> /// <returns>成功/失败</returns> public bool Insert(RBCInfo dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("insert into RBCInfo(GroupID,Category,StartStationName,EndStationName,AreaID,RBCID,PhoneNum,StartPoint,Cutoff,EndPoint) 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("StartStationName", dao.StartStationName, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("EndStationName", dao.EndStationName, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("AreaID", dao.AreaID, SqlDbType.Int)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("RBCID", dao.RBCID, SqlDbType.Int)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("PhoneNum", dao.PhoneNum, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("StartPoint", dao.StartPoint, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("Cutoff", dao.Cutoff, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("EndPoint", dao.EndPoint, 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="dao">数据对象</param> /// <returns>成功/失败</returns> public bool Update(CoordinateInfo dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("update CoordinateInfo 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(",CoordinateID="); stmt.AppendParameter(_session.MakeInParameter("CoordinateID", dao.CoordinateID, SqlDbType.VarChar)); stmt.AppendString(",CoordinateName="); stmt.AppendParameter(_session.MakeInParameter("CoordinateName", dao.CoordinateName, SqlDbType.VarChar)); stmt.AppendString(",Length="); stmt.AppendParameter(_session.MakeInParameter("Length", dao.Length, SqlDbType.VarChar)); stmt.AppendString(",Remark="); stmt.AppendParameter(_session.MakeInParameter("Remark", dao.Remark, SqlDbType.VarChar)); stmt.AppendString(",IsReversed="); stmt.AppendParameter(_session.MakeInParameter("IsReversed", dao.IsReversed, SqlDbType.VarChar)); stmt.AppendString(",CurrentMileage="); stmt.AppendParameter(_session.MakeInParameter("CurrentMileage", dao.CurrentMileage, SqlDbType.VarChar)); stmt.AppendString(",EdgeMileage="); stmt.AppendParameter(_session.MakeInParameter("EdgeMileage", dao.EdgeMileage, SqlDbType.VarChar)); 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 Update(TransponderLocation dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("update TransponderLocation 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(",TransponderName="); stmt.AppendParameter(_session.MakeInParameter("TransponderName", dao.TransponderName, SqlDbType.NVarChar)); stmt.AppendString(",TransponderID="); stmt.AppendParameter(_session.MakeInParameter("TransponderID", dao.TransponderID, SqlDbType.NVarChar)); stmt.AppendString(",Mileage="); stmt.AppendParameter(_session.MakeInParameter("Mileage", dao.Mileage, SqlDbType.NVarChar)); stmt.AppendString(",Type="); stmt.AppendParameter(_session.MakeInParameter("Type", dao.Type, SqlDbType.NVarChar)); stmt.AppendString(",Usage="); stmt.AppendParameter(_session.MakeInParameter("Usage", dao.Usage, 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(StationInfo dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("insert into StationInfo(GroupID,StationName,RegionID,AreaID,StationID) values ("); stmt.AppendParameter(_session.MakeInParameter("GroupID", dao.GroupID, SqlDbType.UniqueIdentifier)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("StationName", dao.StationName, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("RegionID", dao.RegionID, SqlDbType.Int)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("AreaID", dao.AreaID, SqlDbType.Int)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("StationID", dao.StationID, SqlDbType.Int)); 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="dao">数据对象</param> /// <returns>成功/失败</returns> public bool Update(ChainScissionInfo dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("update ChainScissionInfo set "); stmt.AppendString("GroupID="); stmt.AppendParameter(_session.MakeInParameter("GroupID", dao.GroupID, SqlDbType.UniqueIdentifier)); stmt.AppendString(",LineName="); stmt.AppendParameter(_session.MakeInParameter("LineName", dao.LineName, SqlDbType.NVarChar)); stmt.AppendString(",Category="); stmt.AppendParameter(_session.MakeInParameter("Category", dao.Category, SqlDbType.Int)); stmt.AppendString(",Type="); stmt.AppendParameter(_session.MakeInParameter("Type", dao.Type, SqlDbType.NVarChar)); 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(",LongChain="); stmt.AppendParameter(_session.MakeInParameter("LongChain", dao.LongChain, SqlDbType.Int)); stmt.AppendString(",ShortChain="); stmt.AppendParameter(_session.MakeInParameter("ShortChain", dao.ShortChain, SqlDbType.Int)); 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 Update(GradientInfo dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("update GradientInfo set "); stmt.AppendString("GroupID="); stmt.AppendParameter(_session.MakeInParameter("GroupID", dao.GroupID, SqlDbType.UniqueIdentifier)); stmt.AppendString(",StartStationName="); stmt.AppendParameter(_session.MakeInParameter("StartStationName", dao.StartStationName, SqlDbType.NVarChar)); stmt.AppendString(",EndStationName="); stmt.AppendParameter(_session.MakeInParameter("EndStationName", dao.EndStationName, SqlDbType.NVarChar)); stmt.AppendString(",Category="); stmt.AppendParameter(_session.MakeInParameter("Category", dao.Category, SqlDbType.Int)); stmt.AppendString(",Gradient="); stmt.AppendParameter(_session.MakeInParameter("Gradient", dao.Gradient, SqlDbType.Decimal)); stmt.AppendString(",Length="); stmt.AppendParameter(_session.MakeInParameter("Length", dao.Length, SqlDbType.Int)); stmt.AppendString(",EndMileage="); stmt.AppendParameter(_session.MakeInParameter("EndMileage", dao.EndMileage, SqlDbType.NVarChar)); stmt.AppendString(",Remark="); stmt.AppendParameter(_session.MakeInParameter("Remark", dao.Remark, 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(TransponderLocation dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("insert into TransponderLocation(GroupID,Category,TransponderName,TransponderID,Mileage,Type,Usage,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("TransponderName", dao.TransponderName, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("TransponderID", dao.TransponderID, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("Mileage", dao.Mileage, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("Type", dao.Type, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("Usage", dao.Usage, 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="dao">数据对象</param> /// <returns>成功/失败</returns> public bool Insert(CoordinateInfo dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("insert into CoordinateInfo(GroupID,Category,CoordinateID,CoordinateName,Length,Remark,IsReversed,CurrentMileage,EdgeMileage) 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("CoordinateID", dao.CoordinateID, SqlDbType.VarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("CoordinateName", dao.CoordinateName, SqlDbType.VarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("Length", dao.Length, SqlDbType.VarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("Remark", dao.Remark, SqlDbType.VarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("IsReversed", dao.IsReversed, SqlDbType.VarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("CurrentMileage", dao.CurrentMileage, SqlDbType.VarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("EdgeMileage", dao.EdgeMileage, SqlDbType.VarChar)); 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="dao">数据对象</param> /// <returns>成功/失败</returns> public bool Update(DisasterInfo dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("update DisasterInfo set "); stmt.AppendString("GroupID="); stmt.AppendParameter(_session.MakeInParameter("GroupID", dao.GroupID, SqlDbType.UniqueIdentifier)); stmt.AppendString(",StationName="); stmt.AppendParameter(_session.MakeInParameter("StationName", dao.StationName, SqlDbType.NVarChar)); 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(",WarningRelay="); stmt.AppendParameter(_session.MakeInParameter("WarningRelay", dao.WarningRelay, SqlDbType.NVarChar)); stmt.AppendString(",AffectedSectionName="); stmt.AppendParameter(_session.MakeInParameter("AffectedSectionName", dao.AffectedSectionName, SqlDbType.NVarChar)); stmt.AppendString(",Remark="); stmt.AppendParameter(_session.MakeInParameter("Remark", dao.Remark, 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="sectionName">区段名称</param> /// <param name="stationName">车站名称</param> /// <returns>成功/失败</returns> public bool Delete(string sectionName, string stationName) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("delete from StationSectionMapping where "); stmt.AppendString("SectionName="); stmt.AppendParameter(_session.MakeInParameter("SectionName", sectionName, SqlDbType.NVarChar)); stmt.AppendString(" and StationName="); stmt.AppendParameter(_session.MakeInParameter("StationName", stationName, SqlDbType.NVarChar)); stmt.StatementType = SqlStatementType.Delete; return(_session.Excecute(stmt).RowsAffected > 0); }
/// <summary> /// 删除指定主键的道岔信息表 /// </summary> /// <param name="stationName">车站名称</param> /// <param name="turnoutName">道岔名称</param> /// <returns>成功/失败</returns> public bool Delete(string stationName, int turnoutName) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("delete from TurnoutInfo where "); stmt.AppendString("StationName="); stmt.AppendParameter(_session.MakeInParameter("StationName", stationName, SqlDbType.NVarChar)); stmt.AppendString(" and TurnoutName="); stmt.AppendParameter(_session.MakeInParameter("TurnoutName", turnoutName, SqlDbType.Int)); stmt.StatementType = SqlStatementType.Delete; return(_session.Excecute(stmt).RowsAffected > 0); }
/// <summary> /// 更新分相信息表 /// </summary> /// <param name="dao">数据对象</param> /// <returns>成功/失败</returns> public bool Update(PhaseSplittingInfo dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("update PhaseSplittingInfo 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(",Length="); stmt.AppendParameter(_session.MakeInParameter("Length", dao.Length, SqlDbType.Int)); 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(GradientInfo dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("insert into GradientInfo(GroupID,StartStationName,EndStationName,Category,Gradient,Length,EndMileage,Remark) values ("); stmt.AppendParameter(_session.MakeInParameter("GroupID", dao.GroupID, SqlDbType.UniqueIdentifier)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("StartStationName", dao.StartStationName, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("EndStationName", dao.EndStationName, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("Category", dao.Category, SqlDbType.Int)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("Gradient", dao.Gradient, SqlDbType.Decimal)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("Length", dao.Length, SqlDbType.Int)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("EndMileage", dao.EndMileage, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("Remark", dao.Remark, 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="dao">数据对象</param> /// <returns>成功/失败</returns> public bool Update(StationSectionInfo dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("update StationSectionInfo set "); stmt.AppendString("GroupID="); stmt.AppendParameter(_session.MakeInParameter("GroupID", dao.GroupID, SqlDbType.UniqueIdentifier)); stmt.AppendString(",StationName="); stmt.AppendParameter(_session.MakeInParameter("StationName", dao.StationName, SqlDbType.NVarChar)); stmt.AppendString(",SectionName="); stmt.AppendParameter(_session.MakeInParameter("SectionName", dao.SectionName, SqlDbType.NVarChar)); stmt.AppendString(",SectionCarrirer="); stmt.AppendParameter(_session.MakeInParameter("SectionCarrirer", dao.SectionCarrirer, SqlDbType.NVarChar)); stmt.AppendString(",SectionLength="); stmt.AppendParameter(_session.MakeInParameter("SectionLength", dao.SectionLength, SqlDbType.Int)); stmt.AppendString(",LayerType="); stmt.AppendParameter(_session.MakeInParameter("LayerType", dao.LayerType, SqlDbType.Int)); stmt.AppendString(",TurnoutIDs="); stmt.AppendParameter(_session.MakeInParameter("TurnoutIDs", dao.TurnoutIDs, 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(ChainScissionInfo dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("insert into ChainScissionInfo(GroupID,LineName,Category,Type,StartMileage,EndMileage,LongChain,ShortChain) values ("); stmt.AppendParameter(_session.MakeInParameter("GroupID", dao.GroupID, SqlDbType.UniqueIdentifier)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("LineName", dao.LineName, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("Category", dao.Category, SqlDbType.Int)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("Type", dao.Type, SqlDbType.NVarChar)); 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("LongChain", dao.LongChain, SqlDbType.Int)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("ShortChain", dao.ShortChain, SqlDbType.Int)); 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="dao">数据对象</param> /// <returns>成功/失败</returns> public bool Insert(StationSectionInfo dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("insert into StationSectionInfo(GroupID,StationName,SectionName,SectionCarrirer,SectionLength,LayerType,TurnoutIDs) values ("); stmt.AppendParameter(_session.MakeInParameter("GroupID", dao.GroupID, SqlDbType.UniqueIdentifier)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("StationName", dao.StationName, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("SectionName", dao.SectionName, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("SectionCarrirer", dao.SectionCarrirer, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("SectionLength", dao.SectionLength, SqlDbType.Int)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("LayerType", dao.LayerType, SqlDbType.Int)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("TurnoutIDs", dao.TurnoutIDs, 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="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="iD">顺序号</param> /// <returns>成功/失败</returns> public bool Delete(int iD) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("delete from CoordinateInfo where ID="); stmt.AppendParameter(_session.MakeInParameter("ID", iD, SqlDbType.Int)); stmt.StatementType = SqlStatementType.Delete; return(_session.Excecute(stmt).RowsAffected > 0); }
/// <summary> /// 新增批次信息表 /// </summary> /// <param name="dao">数据对象</param> /// <returns>成功/失败</returns> public bool Insert(GroupInfo dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("insert into GroupInfo(GroupID,GroupName,StartTime,OperatorName,IsSuccessed) values ("); stmt.AppendParameter(_session.MakeInParameter("GroupID", dao.GroupID, SqlDbType.UniqueIdentifier)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("GroupName", dao.GroupName, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("StartTime", dao.StartTime, SqlDbType.DateTime)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("OperatorName", dao.OperatorName, SqlDbType.NVarChar)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("IsSuccessed", dao.IsSuccessed, SqlDbType.Bit)); stmt.AppendString(")"); stmt.StatementType = SqlStatementType.Insert; return(_session.Excecute(stmt).RowsAffected > 0); }
/// <summary> /// 删除指定主键的批次信息表 /// </summary> /// <param name="groupID">批次号</param> /// <returns>成功/失败</returns> public bool Delete(Guid groupID) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("delete from GroupInfo where GroupID="); stmt.AppendParameter(_session.MakeInParameter("GroupID", groupID, SqlDbType.UniqueIdentifier)); stmt.StatementType = SqlStatementType.Delete; return(_session.Excecute(stmt).RowsAffected > 0); }
/// <summary> /// 更新批次信息表 /// </summary> /// <param name="dao">数据对象</param> /// <returns>成功/失败</returns> public bool Update(GroupInfo dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("update GroupInfo set "); stmt.AppendString("GroupName="); stmt.AppendParameter(_session.MakeInParameter("GroupName", dao.GroupName, SqlDbType.NVarChar)); stmt.AppendString(",StartTime="); stmt.AppendParameter(_session.MakeInParameter("StartTime", dao.StartTime, SqlDbType.DateTime)); stmt.AppendString(",OperatorName="); stmt.AppendParameter(_session.MakeInParameter("OperatorName", dao.OperatorName, SqlDbType.NVarChar)); stmt.AppendString(",IsSuccessed="); stmt.AppendParameter(_session.MakeInParameter("IsSuccessed", dao.IsSuccessed, SqlDbType.Bit)); stmt.AppendString(" where "); stmt.AppendString("GroupID="); stmt.AppendParameter(_session.MakeInParameter("GroupID", dao.GroupID, SqlDbType.UniqueIdentifier)); stmt.StatementType = SqlStatementType.Update; return(_session.Excecute(stmt).RowsAffected > 0); }
/// <summary> /// 获取指定的站内轨道区段与道岔映射表 /// </summary> /// <param name="sectionName">区段名称</param> /// <param name="stationName">车站名称</param> /// <returns>站内轨道区段与道岔映射表</returns> public StationSectionMapping SelectOne(string sectionName, string stationName) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("select * from StationSectionMapping where "); stmt.AppendString("SectionName="); stmt.AppendParameter(_session.MakeInParameter("SectionName", sectionName, SqlDbType.NVarChar)); stmt.AppendString(" and StationName="); stmt.AppendParameter(_session.MakeInParameter("StationName", stationName, SqlDbType.NVarChar)); stmt.StatementType = SqlStatementType.Select; SqlResult result = _session.Excecute(stmt); StationSectionMapping stationSectionMapping = new StationSectionMapping(); if (result.RowsAffected > 0) { DataRowToEntity(result.Tables[0].Rows[0], stationSectionMapping); } return(stationSectionMapping); }
/// <summary> /// 获取指定的道岔信息表 /// </summary> /// <param name="stationName">车站名称</param> /// <param name="turnoutName">道岔名称</param> /// <returns>道岔信息表</returns> public TurnoutInfo SelectOne(string stationName, int turnoutName) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("select * from TurnoutInfo where "); stmt.AppendString("StationName="); stmt.AppendParameter(_session.MakeInParameter("StationName", stationName, SqlDbType.NVarChar)); stmt.AppendString(" and TurnoutName="); stmt.AppendParameter(_session.MakeInParameter("TurnoutName", turnoutName, SqlDbType.Int)); stmt.StatementType = SqlStatementType.Select; SqlResult result = _session.Excecute(stmt); TurnoutInfo turnoutInfo = new TurnoutInfo(); if (result.RowsAffected > 0) { DataRowToEntity(result.Tables[0].Rows[0], turnoutInfo); } return(turnoutInfo); }
/// <summary> /// 更新站内轨道区段与道岔映射表 /// </summary> /// <param name="dao">数据对象</param> /// <returns>成功/失败</returns> public bool Update(StationSectionMapping dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("update StationSectionMapping set "); stmt.AppendString("ID="); stmt.AppendParameter(_session.MakeInParameter("ID", dao.ID, SqlDbType.Int)); stmt.AppendString(",GroupID="); stmt.AppendParameter(_session.MakeInParameter("GroupID", dao.GroupID, SqlDbType.UniqueIdentifier)); stmt.AppendString(",TurnoutIDs="); stmt.AppendParameter(_session.MakeInParameter("TurnoutIDs", dao.TurnoutIDs, SqlDbType.NVarChar)); stmt.AppendString(" where "); stmt.AppendString("SectionName="); stmt.AppendParameter(_session.MakeInParameter("SectionName", dao.SectionName, SqlDbType.NVarChar)); stmt.AppendString(" and StationName="); stmt.AppendParameter(_session.MakeInParameter("StationName", dao.StationName, SqlDbType.NVarChar)); stmt.StatementType = SqlStatementType.Update; return(_session.Excecute(stmt).RowsAffected > 0); }
/// <summary> /// 新增制动距离信息表 /// </summary> /// <param name="dao">数据对象</param> /// <returns>成功/失败</returns> public bool Insert(BrakingInfo dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("insert into BrakingInfo(GroupID,Speed,Gradient,LengthFor300T,LengthForPulling,LengthForMessage) values ("); stmt.AppendParameter(_session.MakeInParameter("GroupID", dao.GroupID, SqlDbType.UniqueIdentifier)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("Speed", dao.Speed, SqlDbType.Int)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("Gradient", dao.Gradient, SqlDbType.Decimal)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("LengthFor300T", dao.LengthFor300T, SqlDbType.Int)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("LengthForPulling", dao.LengthForPulling, SqlDbType.Int)); stmt.AppendString(","); stmt.AppendParameter(_session.MakeInParameter("LengthForMessage", dao.LengthForMessage, SqlDbType.Int)); 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="iD">顺序号</param> /// <returns>坐标系信息表</returns> public CoordinateInfo SelectOne(int iD) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("select * from CoordinateInfo where ID="); stmt.AppendParameter(_session.MakeInParameter("ID", iD, SqlDbType.Int)); stmt.StatementType = SqlStatementType.Select; SqlResult result = _session.Excecute(stmt); CoordinateInfo coordinateInfo = new CoordinateInfo(); if (result.RowsAffected > 0) { DataRowToEntity(result.Tables[0].Rows[0], coordinateInfo); } return(coordinateInfo); }
/// <summary> /// 获取指定的应答器位置 /// </summary> /// <param name="iD">顺序号</param> /// <returns>应答器位置</returns> public TransponderLocation SelectOne(int iD) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("select * from TransponderLocation where ID="); stmt.AppendParameter(_session.MakeInParameter("ID", iD, SqlDbType.Int)); stmt.StatementType = SqlStatementType.Select; SqlResult result = _session.Excecute(stmt); TransponderLocation transponderLocation = new TransponderLocation(); if (result.RowsAffected > 0) { DataRowToEntity(result.Tables[0].Rows[0], transponderLocation); } return(transponderLocation); }
/// <summary> /// 获取指定的批次信息表 /// </summary> /// <param name="groupID">批次号</param> /// <returns>批次信息表</returns> public GroupInfo SelectOne(Guid groupID) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("select * from GroupInfo where GroupID="); stmt.AppendParameter(_session.MakeInParameter("GroupID", groupID, SqlDbType.UniqueIdentifier)); stmt.StatementType = SqlStatementType.Select; SqlResult result = _session.Excecute(stmt); GroupInfo groupInfo = new GroupInfo(); if (result.RowsAffected > 0) { DataRowToEntity(result.Tables[0].Rows[0], groupInfo); } return(groupInfo); }
/// <summary> /// 更新制动距离信息表 /// </summary> /// <param name="dao">数据对象</param> /// <returns>成功/失败</returns> public bool Update(BrakingInfo dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("update BrakingInfo set "); stmt.AppendString("GroupID="); stmt.AppendParameter(_session.MakeInParameter("GroupID", dao.GroupID, SqlDbType.UniqueIdentifier)); stmt.AppendString(",Speed="); stmt.AppendParameter(_session.MakeInParameter("Speed", dao.Speed, SqlDbType.Int)); stmt.AppendString(",Gradient="); stmt.AppendParameter(_session.MakeInParameter("Gradient", dao.Gradient, SqlDbType.Decimal)); stmt.AppendString(",LengthFor300T="); stmt.AppendParameter(_session.MakeInParameter("LengthFor300T", dao.LengthFor300T, SqlDbType.Int)); stmt.AppendString(",LengthForPulling="); stmt.AppendParameter(_session.MakeInParameter("LengthForPulling", dao.LengthForPulling, SqlDbType.Int)); stmt.AppendString(",LengthForMessage="); stmt.AppendParameter(_session.MakeInParameter("LengthForMessage", dao.LengthForMessage, SqlDbType.Int)); 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 Update(StationInfo dao) { SqlStatement stmt = _session.CreateSqlStatement(); stmt.AppendString("update StationInfo set "); stmt.AppendString("ID="); stmt.AppendParameter(_session.MakeInParameter("ID", dao.ID, SqlDbType.Int)); stmt.AppendString(",GroupID="); stmt.AppendParameter(_session.MakeInParameter("GroupID", dao.GroupID, SqlDbType.UniqueIdentifier)); stmt.AppendString(",RegionID="); stmt.AppendParameter(_session.MakeInParameter("RegionID", dao.RegionID, SqlDbType.Int)); stmt.AppendString(",AreaID="); stmt.AppendParameter(_session.MakeInParameter("AreaID", dao.AreaID, SqlDbType.Int)); stmt.AppendString(",StationID="); stmt.AppendParameter(_session.MakeInParameter("StationID", dao.StationID, SqlDbType.Int)); stmt.AppendString(" where "); stmt.AppendString("StationName="); stmt.AppendParameter(_session.MakeInParameter("StationName", dao.StationName, SqlDbType.NVarChar)); stmt.StatementType = SqlStatementType.Update; return(_session.Excecute(stmt).RowsAffected > 0); }