/// <summary>
/// 更新道岔信息表
/// </summary>
/// <param name="dao">数据对象</param>
/// <returns>成功/失败</returns>
public bool Update(TurnoutInfo dao)
{
SqlStatement stmt = _session.CreateSqlStatement();
stmt.AppendString("update TurnoutInfo 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(",Category=");
stmt.AppendParameter(_session.MakeInParameter("Category", dao.Category, SqlDbType.Int));
stmt.AppendString(",Mileage=");
stmt.AppendParameter(_session.MakeInParameter("Mileage", dao.Mileage, SqlDbType.NVarChar));
stmt.AppendString(",Siding=");
stmt.AppendParameter(_session.MakeInParameter("Siding", dao.Siding, SqlDbType.NVarChar));
stmt.AppendString(",Speed=");
stmt.AppendParameter(_session.MakeInParameter("Speed", dao.Speed, SqlDbType.Int));
stmt.AppendString(",TFLine=");
stmt.AppendParameter(_session.MakeInParameter("TFLine", dao.TFLine, SqlDbType.NVarChar));
stmt.AppendString(",default1=");
stmt.AppendParameter(_session.MakeInParameter("default1", dao.Default1, SqlDbType.NVarChar));
stmt.AppendString(",default2=");
stmt.AppendParameter(_session.MakeInParameter("default2", dao.Default2, SqlDbType.NVarChar));
stmt.AppendString(",default3=");
stmt.AppendParameter(_session.MakeInParameter("default3", dao.Default3, SqlDbType.NVarChar));
stmt.AppendString(",default4=");
stmt.AppendParameter(_session.MakeInParameter("default4", dao.Default4, SqlDbType.NVarChar));
stmt.AppendString(" where ");
stmt.AppendString("StationName=");
stmt.AppendParameter(_session.MakeInParameter("StationName", dao.StationName, SqlDbType.NVarChar));
stmt.AppendString(" and TurnoutName=");
stmt.AppendParameter(_session.MakeInParameter("TurnoutName", dao.TurnoutName, SqlDbType.Int));
stmt.StatementType = SqlStatementType.Update;
return(_session.Excecute(stmt).RowsAffected > 0);
}
/// <summary>
/// 获取指定大小的一页道岔信息表集合
/// </summary>
/// <param name="pageIndex">当前页码</param>
/// <param name="pageSize">分页大小</param>
/// <param name="rowsCount">总记录条数</param>
/// <returns>分页数据</returns>
public ObservableCollection <TurnoutInfo> SelectAllCollection(int pageIndex, int pageSize, int rowsCount)
{
ObservableCollection <TurnoutInfo> datas = new ObservableCollection <TurnoutInfo>();
GenDataReader reader = Session.ExcecuteReader(_dal.SelectAllSqlStatement(), pageIndex, pageSize, rowsCount);
while (reader.Read())
{
TurnoutInfo dao = new TurnoutInfo();
_dal.DataReaderToEntity(reader, dao);
datas.Add(dao);
}
reader.Close();
return(datas);
}
/// <summary>
/// 获取所有的道岔信息表集合
/// </summary>
/// <returns>所有信息</returns>
public ObservableCollection <TurnoutInfo> SelectAllCollection()
{
ObservableCollection <TurnoutInfo> datas = new ObservableCollection <TurnoutInfo>();
SqlStatement stmt = _session.CreateSqlStatement();
stmt.AppendString("select * from TurnoutInfo");
stmt.StatementType = SqlStatementType.Select;
GenDataReader reader = _session.ExcecuteReader(stmt);
while (reader.Read())
{
TurnoutInfo dao = new TurnoutInfo();
DataReaderToEntity(reader, dao);
datas.Add(dao);
}
reader.Close();
return(datas);
}
/// <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 Insert(TurnoutInfo dao)
{
SqlStatement stmt = _session.CreateSqlStatement();
stmt.AppendString("insert into TurnoutInfo(GroupID,Category,StationName,TurnoutName,Mileage,Siding,Speed,TFLine,default1,default2,default3,default4) 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("StationName", dao.StationName, SqlDbType.NVarChar));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("TurnoutName", dao.TurnoutName, SqlDbType.Int));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("Mileage", dao.Mileage, SqlDbType.NVarChar));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("Siding", dao.Siding, SqlDbType.NVarChar));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("Speed", dao.Speed, SqlDbType.Int));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("TFLine", dao.TFLine, SqlDbType.NVarChar));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("default1", dao.Default1, SqlDbType.NVarChar));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("default2", dao.Default2, SqlDbType.NVarChar));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("default3", dao.Default3, SqlDbType.NVarChar));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("default4", dao.Default4, 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(TurnoutInfo dao)
{
bool ret = false;
try
{
Session.Open();
Session.BeginTransaction();
ret = _dal.Update(dao);
Session.CommitTransaction();
}
catch (Exception err)
{
ret = false;
Log.Error(dao, err);
Session.RollBackTransaction();
}
finally
{
Session.Close();
}
return(ret);
}
/// <summary>
/// 获取指定的IDataReader中的TurnoutInfo
/// </summary>
/// <param name="reader">IDataReader对象</param>
/// <param name="dao">TurnoutInfo实体类</param>
public void DataReaderToEntity(IDataReader reader, TurnoutInfo 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 = null;
}
else
{
dao.Category = int.Parse(data.ToString());
}
data = reader["StationName"];
if (data == null || data == DBNull.Value)
{
dao.StationName = null;
}
else
{
dao.StationName = data.ToString();
}
data = reader["TurnoutName"];
if (data == null || data == DBNull.Value)
{
dao.TurnoutName = int.MinValue;
}
else
{
dao.TurnoutName = int.Parse(data.ToString());
}
data = reader["Mileage"];
if (data == null || data == DBNull.Value)
{
dao.Mileage = null;
}
else
{
dao.Mileage = data.ToString();
}
data = reader["Siding"];
if (data == null || data == DBNull.Value)
{
dao.Siding = null;
}
else
{
dao.Siding = data.ToString();
}
data = reader["Speed"];
if (data == null || data == DBNull.Value)
{
dao.Speed = int.MinValue;
}
else
{
dao.Speed = int.Parse(data.ToString());
}
data = reader["TFLine"];
if (data == null || data == DBNull.Value)
{
dao.TFLine = null;
}
else
{
dao.TFLine = data.ToString();
}
data = reader["default1"];
if (data == null || data == DBNull.Value)
{
dao.Default1 = null;
}
else
{
dao.Default1 = data.ToString();
}
data = reader["default2"];
if (data == null || data == DBNull.Value)
{
dao.Default2 = null;
}
else
{
dao.Default2 = data.ToString();
}
data = reader["default3"];
if (data == null || data == DBNull.Value)
{
dao.Default3 = null;
}
else
{
dao.Default3 = data.ToString();
}
data = reader["default4"];
if (data == null || data == DBNull.Value)
{
dao.Default4 = null;
}
else
{
dao.Default4 = data.ToString();
}
}
/// <summary>
/// 获取指定的数据行DataRow转换成TurnoutInfo
/// </summary>
/// <param name="dr">DataRow数据</param>
/// <param name="dao">TurnoutInfo实体类</param>
public void DataRowToEntity(DataRow dr, TurnoutInfo 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 = null;
}
else
{
dao.Category = int.Parse(dr["Category"].ToString());
}
if (dr["StationName"] == null || dr["StationName"] == DBNull.Value)
{
dao.StationName = null;
}
else
{
dao.StationName = dr["StationName"].ToString();
}
if (dr["TurnoutName"] == null || dr["TurnoutName"] == DBNull.Value)
{
dao.TurnoutName = int.MinValue;
}
else
{
dao.TurnoutName = int.Parse(dr["TurnoutName"].ToString());
}
if (dr["Mileage"] == null || dr["Mileage"] == DBNull.Value)
{
dao.Mileage = null;
}
else
{
dao.Mileage = dr["Mileage"].ToString();
}
if (dr["Siding"] == null || dr["Siding"] == DBNull.Value)
{
dao.Siding = null;
}
else
{
dao.Siding = dr["Siding"].ToString();
}
if (dr["Speed"] == null || dr["Speed"] == DBNull.Value)
{
dao.Speed = int.MinValue;
}
else
{
dao.Speed = int.Parse(dr["Speed"].ToString());
}
if (dr["TFLine"] == null || dr["TFLine"] == DBNull.Value)
{
dao.TFLine = null;
}
else
{
dao.TFLine = dr["TFLine"].ToString();
}
if (dr["default1"] == null || dr["default1"] == DBNull.Value)
{
dao.Default1 = null;
}
else
{
dao.Default1 = dr["default1"].ToString();
}
if (dr["default2"] == null || dr["default2"] == DBNull.Value)
{
dao.Default2 = null;
}
else
{
dao.Default2 = dr["default2"].ToString();
}
if (dr["default3"] == null || dr["default3"] == DBNull.Value)
{
dao.Default3 = null;
}
else
{
dao.Default3 = dr["default3"].ToString();
}
if (dr["default4"] == null || dr["default4"] == DBNull.Value)
{
dao.Default4 = null;
}
else
{
dao.Default4 = dr["default4"].ToString();
}
}
