/// <summary> /// ��������б� /// </summary> public List<Maticsoft.Model.Messages.SendedMessages> DataTableToList(DataTable dt) { List<Maticsoft.Model.Messages.SendedMessages> modelList = new List<Maticsoft.Model.Messages.SendedMessages>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Maticsoft.Model.Messages.SendedMessages model; for (int n = 0; n < rowsCount; n++) { model = new Maticsoft.Model.Messages.SendedMessages(); if (dt.Rows[n]["SendMessageId"].ToString() != "") { model.SendMessageId = long.Parse(dt.Rows[n]["SendMessageId"].ToString()); } if (dt.Rows[n]["AddresserId"].ToString() != "") { model.AddresserId = int.Parse(dt.Rows[n]["AddresserId"].ToString()); } if (dt.Rows[n]["AddresseeId"].ToString() != "") { model.AddresseeId = int.Parse(dt.Rows[n]["AddresseeId"].ToString()); } model.Title = dt.Rows[n]["Title"].ToString(); model.PublishContent = dt.Rows[n]["PublishContent"].ToString(); if (dt.Rows[n]["PublishDate"].ToString() != "") { model.PublishDate = DateTime.Parse(dt.Rows[n]["PublishDate"].ToString()); } if (dt.Rows[n]["ReceiveMessageId"].ToString() != "") { model.ReceiveMessageId = long.Parse(dt.Rows[n]["ReceiveMessageId"].ToString()); } modelList.Add(model); } } return modelList; }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public Maticsoft.Model.Messages.SendedMessages GetModel(long SendMessageId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 SendMessageId,AddresserId,AddresseeId,Title,PublishContent,PublishDate,ReceiveMessageId from SA_SendedMessages "); strSql.Append(" where SendMessageId=@SendMessageId"); SqlParameter[] parameters = { new SqlParameter("@SendMessageId", SqlDbType.BigInt) }; parameters[0].Value = SendMessageId; Maticsoft.Model.Messages.SendedMessages model = new Maticsoft.Model.Messages.SendedMessages(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["SendMessageId"].ToString() != "") { model.SendMessageId = long.Parse(ds.Tables[0].Rows[0]["SendMessageId"].ToString()); } if (ds.Tables[0].Rows[0]["AddresserId"].ToString() != "") { model.AddresserId = int.Parse(ds.Tables[0].Rows[0]["AddresserId"].ToString()); } if (ds.Tables[0].Rows[0]["AddresseeId"].ToString() != "") { model.AddresseeId = int.Parse(ds.Tables[0].Rows[0]["AddresseeId"].ToString()); } if (ds.Tables[0].Rows[0]["Title"] != null) { model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); } if (ds.Tables[0].Rows[0]["PublishContent"] != null) { model.PublishContent = ds.Tables[0].Rows[0]["PublishContent"].ToString(); } if (ds.Tables[0].Rows[0]["PublishDate"].ToString() != "") { model.PublishDate = DateTime.Parse(ds.Tables[0].Rows[0]["PublishDate"].ToString()); } if (ds.Tables[0].Rows[0]["ReceiveMessageId"].ToString() != "") { model.ReceiveMessageId = long.Parse(ds.Tables[0].Rows[0]["ReceiveMessageId"].ToString()); } return model; } else { return null; } }