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