/// <summary>
/// 获取实体列表
/// </summary>
/// <param name="showFields">显示字段</param>
/// <param name="reader">IDataReader</param>
/// <returns>返回Remark实体列表</returns>
public static List<RemarkModel> GetList(List<RemarkFields> showFields, IDataReader reader)
{
List< RemarkModel> list = new List< RemarkModel>();
while ( reader.Read() )
{
RemarkModel remark= new RemarkModel();
if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, RemarkFields.RId)) && reader["RId"] !=DBNull.Value)
{
remark.RId = Convert.ToInt32(reader["RId"]);
}
if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, RemarkFields.ROrderSerialNo)) && reader["ROrderSerialNo"] !=DBNull.Value)
{
remark.ROrderSerialNo = reader["ROrderSerialNo"].ToString();
}
if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, RemarkFields.RRemarkType)) && reader["RRemarkType"] !=DBNull.Value)
{
remark.RRemarkType = Convert.ToByte(reader["RRemarkType"]);
}
if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, RemarkFields.RRemarkContent)) && reader["RRemarkContent"] !=DBNull.Value)
{
remark.RRemarkContent = reader["RRemarkContent"].ToString();
}
if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, RemarkFields.RRemarkTime)) && reader["RRemarkTime"] !=DBNull.Value)
{
remark.RRemarkTime = Convert.ToDateTime(reader["RRemarkTime"]);
}
if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, RemarkFields.RRemarkReply)) && reader["RRemarkReply"] !=DBNull.Value)
{
remark.RRemarkReply = reader["RRemarkReply"].ToString();
}
if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, RemarkFields.RReplyTime)) && reader["RReplyTime"] !=DBNull.Value)
{
remark.RReplyTime = Convert.ToDateTime(reader["RReplyTime"]);
}
if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, RemarkFields.RRemarkState)) && reader["RRemarkState"] !=DBNull.Value)
{
remark.RRemarkState = Convert.ToByte(reader["RRemarkState"]);
}
if ( (( showFields == null || showFields.Count == 0 ) || IsExistField(showFields, RemarkFields.RRowValid)) && reader["RRowValid"] !=DBNull.Value)
{
remark.RRowValid = Convert.ToByte(reader["RRowValid"]);
}
list.Add(remark);
}
reader.Close();
return list;
}
/// <summary>
///Remark 添加操作
/// </summary>
/// <param name="remark">Remark实体类</param>
/// <returns>执行成功返回true,否则为false</returns>
public bool Add(RemarkModel remark)
{
return dataAccess.Add(remark);
}
/// <summary>
/// Remark 添加操作
/// </summary>
/// <param name="remark">Remark实体类</param>
/// <param name="transaction">事务</param>
/// <returns>执行成功返回true,否则为false</returns>
public bool Add(RemarkModel remark,DbTransaction transaction)
{
string sqlDescription = "/*" + DatabaseManager.SqlDescription + "/Author:TCSmartFrameWork自动生成/For:Remark表增加操作/File:RemarkAccess.cs/Fun:Add*/";
StringBuilder sql = new StringBuilder();
sql.Append(sqlDescription);
sql.Append("insert ["+ DatabaseManager.Db_JQEBookingDataBase+"].[dbo].[Remark] (ROrderSerialNo,RRemarkType,RRemarkContent,RRemarkTime,RRemarkReply,RReplyTime,RRemarkState,RRowValid) values(@ROrderSerialNo,@RRemarkType,@RRemarkContent,@RRemarkTime,@RRemarkReply,@RReplyTime,@RRemarkState,@RRowValid)");
SqlParameterWrapperCollection Collection = new SqlParameterWrapperCollection();
Collection.Add(new SqlParameterWrapper("@ROrderSerialNo", remark.ROrderSerialNo,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@RRemarkType", remark.RRemarkType,SqlDbType.TinyInt));
Collection.Add(new SqlParameterWrapper("@RRemarkContent", remark.RRemarkContent,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@RRemarkTime", remark.RRemarkTime,SqlDbType.DateTime));
Collection.Add(new SqlParameterWrapper("@RRemarkReply", remark.RRemarkReply,SqlDbType.NVarChar));
Collection.Add(new SqlParameterWrapper("@RReplyTime", remark.RReplyTime,SqlDbType.DateTime));
Collection.Add(new SqlParameterWrapper("@RRemarkState", remark.RRemarkState,SqlDbType.TinyInt));
Collection.Add(new SqlParameterWrapper("@RRowValid", remark.RRowValid,SqlDbType.TinyInt));
return SqlHelper.ExecuteNonQuery(DatabaseFactory.GetWriteDatabase(DatabaseManager.Db_JQEBookingConfig),sql.ToString(),Collection,transaction) > 0;
}