/// <summary> /// 得到一个对象实体 /// </summary> public OnLineTest.Model.Message_table DataRowToModel(DataRow row) { OnLineTest.Model.Message_table model = new OnLineTest.Model.Message_table(); if (row != null) { if (row["MessageId"] != null && row["MessageId"].ToString() != "") { model.MessageId = int.Parse(row["MessageId"].ToString()); } if (row["MessageParentId"] != null && row["MessageParentId"].ToString() != "") { model.MessageParentId = int.Parse(row["MessageParentId"].ToString()); } if (row["MessageTO"] != null && row["MessageTO"].ToString() != "") { model.MessageTO = int.Parse(row["MessageTO"].ToString()); } if (row["MessageFrom"] != null && row["MessageFrom"].ToString() != "") { model.MessageFrom = int.Parse(row["MessageFrom"].ToString()); } if (row["MessageContent"] != null) { model.MessageContent = row["MessageContent"].ToString(); } if (row["MessageSendTime"] != null && row["MessageSendTime"].ToString() != "") { model.MessageSendTime = DateTime.Parse(row["MessageSendTime"].ToString()); } if (row["MessageIsRead"] != null && row["MessageIsRead"].ToString() != "") { if ((row["MessageIsRead"].ToString() == "1") || (row["MessageIsRead"].ToString().ToLower() == "true")) { model.MessageIsRead = true; } else { model.MessageIsRead = false; } } if (row["MessageReadTime"] != null && row["MessageReadTime"].ToString() != "") { model.MessageReadTime = DateTime.Parse(row["MessageReadTime"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(OnLineTest.Model.Message_table model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Message_table set "); strSql.Append("MessageParentId=@MessageParentId,"); strSql.Append("MessageTO=@MessageTO,"); strSql.Append("MessageFrom=@MessageFrom,"); strSql.Append("MessageContent=@MessageContent,"); strSql.Append("MessageSendTime=@MessageSendTime,"); strSql.Append("MessageIsRead=@MessageIsRead,"); strSql.Append("MessageReadTime=@MessageReadTime"); strSql.Append(" where MessageId=@MessageId"); SqlParameter[] parameters = { new SqlParameter("@MessageParentId", SqlDbType.Int, 4), new SqlParameter("@MessageTO", SqlDbType.Int, 4), new SqlParameter("@MessageFrom", SqlDbType.Int, 4), new SqlParameter("@MessageContent", SqlDbType.Text), new SqlParameter("@MessageSendTime", SqlDbType.DateTime), new SqlParameter("@MessageIsRead", SqlDbType.Bit, 1), new SqlParameter("@MessageReadTime", SqlDbType.DateTime), new SqlParameter("@MessageId", SqlDbType.Int, 4) }; parameters[0].Value = model.MessageParentId; parameters[1].Value = model.MessageTO; parameters[2].Value = model.MessageFrom; parameters[3].Value = model.MessageContent; parameters[4].Value = model.MessageSendTime; parameters[5].Value = model.MessageIsRead; parameters[6].Value = model.MessageReadTime; parameters[7].Value = model.MessageId; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(OnLineTest.Model.Message_table model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Message_table("); strSql.Append("MessageParentId,MessageTO,MessageFrom,MessageContent,MessageSendTime,MessageIsRead,MessageReadTime)"); strSql.Append(" values ("); strSql.Append("@MessageParentId,@MessageTO,@MessageFrom,@MessageContent,@MessageSendTime,@MessageIsRead,@MessageReadTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MessageParentId", SqlDbType.Int, 4), new SqlParameter("@MessageTO", SqlDbType.Int, 4), new SqlParameter("@MessageFrom", SqlDbType.Int, 4), new SqlParameter("@MessageContent", SqlDbType.Text), new SqlParameter("@MessageSendTime", SqlDbType.DateTime), new SqlParameter("@MessageIsRead", SqlDbType.Bit, 1), new SqlParameter("@MessageReadTime", SqlDbType.DateTime) }; parameters[0].Value = model.MessageParentId; parameters[1].Value = model.MessageTO; parameters[2].Value = model.MessageFrom; parameters[3].Value = model.MessageContent; parameters[4].Value = model.MessageSendTime; parameters[5].Value = model.MessageIsRead; parameters[6].Value = model.MessageReadTime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public OnLineTest.Model.Message_table GetModel(int MessageId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 MessageId,MessageParentId,MessageTO,MessageFrom,MessageContent,MessageSendTime,MessageIsRead,MessageReadTime from Message_table "); strSql.Append(" where MessageId=@MessageId"); SqlParameter[] parameters = { new SqlParameter("@MessageId", SqlDbType.Int, 4) }; parameters[0].Value = MessageId; OnLineTest.Model.Message_table model = new OnLineTest.Model.Message_table(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }