/// <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; }