/// <summary>
/// 获取指定smsReadId的sm_smsread对象
/// </summary>
/// <param name="user">当前操作用户</param>
/// <param name="smsReadId">主键值</param>
/// <returns></returns>
public override ResultModel Get(UserModel user, int smsReadId)
{
ResultModel result = new ResultModel();
if (smsReadId < 1)
{
result.Message = "序号不能小于1";
return result;
}
List<SqlParameter> paras = new List<SqlParameter>();
SqlParameter para = new SqlParameter("@SmsReadId", SqlDbType.Int, 4);
para.Value = smsReadId;
paras.Add(para);
SqlDataReader dr = null;
try
{
dr = SqlHelper.ExecuteReader(ConnectString, CommandType.StoredProcedure, "Sm_SmsReadGet", paras.ToArray());
SmsRead smsread = new SmsRead();
if (dr.Read())
{
int indexSmsReadId = dr.GetOrdinal("SmsReadId");
smsread.SmsReadId = Convert.ToInt32(dr[indexSmsReadId]);
int indexSmsId = dr.GetOrdinal("SmsId");
if (dr["SmsId"] != DBNull.Value)
{
smsread.SmsId = Convert.ToInt32(dr[indexSmsId]);
}
int indexEmpId = dr.GetOrdinal("EmpId");
if (dr["EmpId"] != DBNull.Value)
{
smsread.EmpId = Convert.ToInt32(dr[indexEmpId]);
}
int indexLastReadTime = dr.GetOrdinal("LastReadTime");
if (dr["LastReadTime"] != DBNull.Value)
{
smsread.LastReadTime = Convert.ToDateTime(dr[indexLastReadTime]);
}
int indexReadStatus = dr.GetOrdinal("ReadStatus");
if (dr["ReadStatus"] != DBNull.Value)
{
smsread.ReadStatus = Convert.ToInt32(dr[indexReadStatus]);
}
result.AffectCount = 1;
result.Message = "读取成功";
result.ResultStatus = 0;
result.ReturnValue = smsread;
}
else
{
result.Message = "读取失败或无数据";
result.AffectCount = 0;
}
}
catch (Exception ex)
{
result.Message = ex.Message;
}
finally
{
if (dr != null)
dr.Dispose();
}
return result;
}
/// <summary>
/// 获取sm_smsread集合
/// </summary>
/// <param name="user">当前操作用户</param>
/// <returns></returns>
public override ResultModel Load(UserModel user)
{
ResultModel result = new ResultModel();
try
{
DataTable dt = SqlHelper.ExecuteDataTable(ConnectString, "Sm_SmsReadLoad", null, CommandType.StoredProcedure);
List<SmsRead> smsReads = new List<SmsRead>();
foreach (DataRow dr in dt.Rows)
{
SmsRead smsread = new SmsRead();
smsread.SmsReadId = Convert.ToInt32(dr["SmsReadId"]);
if (dr["SmsId"] != DBNull.Value)
{
smsread.SmsId = Convert.ToInt32(dr["SmsId"]);
}
if (dr["EmpId"] != DBNull.Value)
{
smsread.EmpId = Convert.ToInt32(dr["EmpId"]);
}
if (dr["LastReadTime"] != DBNull.Value)
{
smsread.LastReadTime = Convert.ToDateTime(dr["LastReadTime"]);
}
if (dr["ReadStatus"] != DBNull.Value)
{
smsread.ReadStatus = Convert.ToInt32(dr["ReadStatus"]);
}
smsReads.Add(smsread);
}
result.AffectCount = dt.Rows.Count;
result.Message = "获取列表成功";
result.ResultStatus = 0;
result.ReturnValue = smsReads;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
return result;
}
