/// <summary>
/// 获取指定大小的一页进场数据表集合
/// </summary>
/// <param name="pageIndex">当前页码</param>
/// <param name="pageSize">分页大小</param>
/// <param name="rowsCount">总记录条数</param>
/// <returns>分页数据</returns>
public ObservableCollection <ApproachInfo> SelectAllCollection(int pageIndex, int pageSize, int rowsCount)
{
ObservableCollection <ApproachInfo> datas = new ObservableCollection <ApproachInfo>();
GenDataReader reader = Session.ExcecuteReader(_dal.SelectAllSqlStatement(), pageIndex, pageSize, rowsCount);
while (reader.Read())
{
ApproachInfo dao = new ApproachInfo();
_dal.DataReaderToEntity(reader, dao);
datas.Add(dao);
}
reader.Close();
return(datas);
}
/// <summary>
/// 获取指定的进场数据表
/// </summary>
/// <param name="iD">顺序号</param>
/// <returns>进场数据表</returns>
public ApproachInfo SelectOne(int iD)
{
SqlStatement stmt = _session.CreateSqlStatement();
stmt.AppendString("select * from ApproachInfo where ID=");
stmt.AppendParameter(_session.MakeInParameter("ID", iD, SqlDbType.Int));
stmt.StatementType = SqlStatementType.Select;
SqlResult result = _session.Excecute(stmt);
ApproachInfo approachInfo = new ApproachInfo();
if (result.RowsAffected > 0)
{
DataRowToEntity(result.Tables[0].Rows[0], approachInfo);
}
return(approachInfo);
}
/// <summary>
/// 获取所有的进场数据表集合
/// </summary>
/// <returns>所有信息</returns>
public ObservableCollection <ApproachInfo> SelectAllCollection()
{
ObservableCollection <ApproachInfo> datas = new ObservableCollection <ApproachInfo>();
SqlStatement stmt = _session.CreateSqlStatement();
stmt.AppendString("select * from ApproachInfo");
stmt.StatementType = SqlStatementType.Select;
GenDataReader reader = _session.ExcecuteReader(stmt);
while (reader.Read())
{
ApproachInfo dao = new ApproachInfo();
DataReaderToEntity(reader, dao);
datas.Add(dao);
}
reader.Close();
return(datas);
}
/// <summary>
/// 新增进场数据表
/// </summary>
/// <param name="dao">数据对象</param>
/// <returns>成功/失败</returns>
public bool Insert(ApproachInfo dao)
{
SqlStatement stmt = _session.CreateSqlStatement();
stmt.AppendString("insert into ApproachInfo(GroupID,ResponderID,ApprochID,ApprochInfo,ApproachType,StartAnnunciatorName,StartAnnunciatorDisplay,EndAnnunciator,ExperiencedResponders,ExperiencedTurnouts,ExperiencedSpeeds,ExperiencedStationSections,AffectedDisasters) values (");
stmt.AppendParameter(_session.MakeInParameter("GroupID", dao.GroupID, SqlDbType.UniqueIdentifier));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("ResponderID", dao.ResponderID, SqlDbType.NVarChar));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("ApprochID", dao.ApprochID, SqlDbType.NVarChar));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("ApprochInfo", dao.ApprochInfo, SqlDbType.NVarChar));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("ApproachType", dao.ApproachType, SqlDbType.NVarChar));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("StartAnnunciatorName", dao.StartAnnunciatorName, SqlDbType.NVarChar));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("StartAnnunciatorDisplay", dao.StartAnnunciatorDisplay, SqlDbType.NVarChar));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("EndAnnunciator", dao.EndAnnunciator, SqlDbType.NVarChar));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("ExperiencedResponders", dao.ExperiencedResponders, SqlDbType.NVarChar));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("ExperiencedTurnouts", dao.ExperiencedTurnouts, SqlDbType.NVarChar));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("ExperiencedSpeeds", dao.ExperiencedSpeeds, SqlDbType.NVarChar));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("ExperiencedStationSections", dao.ExperiencedStationSections, SqlDbType.NVarChar));
stmt.AppendString(",");
stmt.AppendParameter(_session.MakeInParameter("AffectedDisasters", dao.AffectedDisasters, 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(ApproachInfo 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>
/// 更新进场数据表
/// </summary>
/// <param name="dao">数据对象</param>
/// <returns>成功/失败</returns>
public bool Update(ApproachInfo dao)
{
SqlStatement stmt = _session.CreateSqlStatement();
stmt.AppendString("update ApproachInfo set ");
stmt.AppendString("GroupID=");
stmt.AppendParameter(_session.MakeInParameter("GroupID", dao.GroupID, SqlDbType.UniqueIdentifier));
stmt.AppendString(",ResponderID=");
stmt.AppendParameter(_session.MakeInParameter("ResponderID", dao.ResponderID, SqlDbType.NVarChar));
stmt.AppendString(",ApprochID=");
stmt.AppendParameter(_session.MakeInParameter("ApprochID", dao.ApprochID, SqlDbType.NVarChar));
stmt.AppendString(",ApprochInfo=");
stmt.AppendParameter(_session.MakeInParameter("ApprochInfo", dao.ApprochInfo, SqlDbType.NVarChar));
stmt.AppendString(",ApproachType=");
stmt.AppendParameter(_session.MakeInParameter("ApproachType", dao.ApproachType, SqlDbType.NVarChar));
stmt.AppendString(",StartAnnunciatorName=");
stmt.AppendParameter(_session.MakeInParameter("StartAnnunciatorName", dao.StartAnnunciatorName, SqlDbType.NVarChar));
stmt.AppendString(",StartAnnunciatorDisplay=");
stmt.AppendParameter(_session.MakeInParameter("StartAnnunciatorDisplay", dao.StartAnnunciatorDisplay, SqlDbType.NVarChar));
stmt.AppendString(",EndAnnunciator=");
stmt.AppendParameter(_session.MakeInParameter("EndAnnunciator", dao.EndAnnunciator, SqlDbType.NVarChar));
stmt.AppendString(",ExperiencedResponders=");
stmt.AppendParameter(_session.MakeInParameter("ExperiencedResponders", dao.ExperiencedResponders, SqlDbType.NVarChar));
stmt.AppendString(",ExperiencedTurnouts=");
stmt.AppendParameter(_session.MakeInParameter("ExperiencedTurnouts", dao.ExperiencedTurnouts, SqlDbType.NVarChar));
stmt.AppendString(",ExperiencedSpeeds=");
stmt.AppendParameter(_session.MakeInParameter("ExperiencedSpeeds", dao.ExperiencedSpeeds, SqlDbType.NVarChar));
stmt.AppendString(",ExperiencedStationSections=");
stmt.AppendParameter(_session.MakeInParameter("ExperiencedStationSections", dao.ExperiencedStationSections, SqlDbType.NVarChar));
stmt.AppendString(",AffectedDisasters=");
stmt.AppendParameter(_session.MakeInParameter("AffectedDisasters", dao.AffectedDisasters, 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>
/// 获取指定的IDataReader中的ApproachInfo
/// </summary>
/// <param name="reader">IDataReader对象</param>
/// <param name="dao">ApproachInfo实体类</param>
public void DataReaderToEntity(IDataReader reader, ApproachInfo 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["ResponderID"];
if (data == null || data == DBNull.Value)
{
dao.ResponderID = null;
}
else
{
dao.ResponderID = data.ToString();
}
data = reader["ApprochID"];
if (data == null || data == DBNull.Value)
{
dao.ApprochID = null;
}
else
{
dao.ApprochID = data.ToString();
}
data = reader["ApprochInfo"];
if (data == null || data == DBNull.Value)
{
dao.ApprochInfo = null;
}
else
{
dao.ApprochInfo = data.ToString();
}
data = reader["ApproachType"];
if (data == null || data == DBNull.Value)
{
dao.ApproachType = null;
}
else
{
dao.ApproachType = data.ToString();
}
data = reader["StartAnnunciatorName"];
if (data == null || data == DBNull.Value)
{
dao.StartAnnunciatorName = null;
}
else
{
dao.StartAnnunciatorName = data.ToString();
}
data = reader["StartAnnunciatorDisplay"];
if (data == null || data == DBNull.Value)
{
dao.StartAnnunciatorDisplay = null;
}
else
{
dao.StartAnnunciatorDisplay = data.ToString();
}
data = reader["EndAnnunciator"];
if (data == null || data == DBNull.Value)
{
dao.EndAnnunciator = null;
}
else
{
dao.EndAnnunciator = data.ToString();
}
data = reader["ExperiencedResponders"];
if (data == null || data == DBNull.Value)
{
dao.ExperiencedResponders = null;
}
else
{
dao.ExperiencedResponders = data.ToString();
}
data = reader["ExperiencedTurnouts"];
if (data == null || data == DBNull.Value)
{
dao.ExperiencedTurnouts = null;
}
else
{
dao.ExperiencedTurnouts = data.ToString();
}
data = reader["ExperiencedSpeeds"];
if (data == null || data == DBNull.Value)
{
dao.ExperiencedSpeeds = null;
}
else
{
dao.ExperiencedSpeeds = data.ToString();
}
data = reader["ExperiencedStationSections"];
if (data == null || data == DBNull.Value)
{
dao.ExperiencedStationSections = null;
}
else
{
dao.ExperiencedStationSections = data.ToString();
}
data = reader["AffectedDisasters"];
if (data == null || data == DBNull.Value)
{
dao.AffectedDisasters = null;
}
else
{
dao.AffectedDisasters = data.ToString();
}
}
