public void ResumeMessage(M_UserMessage model)
{
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@ResumeContent", SqlDbType.Text), new SqlParameter("@ResumeTime", SqlDbType.NVarChar) };
commandParameters[0].Value = model.Id;
commandParameters[1].Value = model.UserId;
commandParameters[2].Value = model.ResumeContent;
commandParameters[3].Value = model.ResumeTime;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "Up_UserMessage_Resume", commandParameters);
}
public void AddMessage(M_UserMessage model)
{
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.NVarChar), new SqlParameter("@Content", SqlDbType.Text), new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@AnounName", SqlDbType.NVarChar), new SqlParameter("@HomePage", SqlDbType.NVarChar), new SqlParameter("@IsPrivacy", SqlDbType.Bit, 1), new SqlParameter("@IsResume", SqlDbType.Bit, 1), new SqlParameter("@ResumeContent", SqlDbType.Text), new SqlParameter("@PostTime", SqlDbType.NVarChar) };
commandParameters[0].Value = model.Id;
commandParameters[1].Value = model.Title;
commandParameters[2].Value = model.Content;
commandParameters[3].Value = model.UserId;
commandParameters[4].Value = model.AnounName;
commandParameters[5].Value = model.HomePage;
commandParameters[6].Value = model.IsPrivacy;
commandParameters[7].Value = model.IsResume;
commandParameters[8].Value = model.ResumeContent;
commandParameters[9].Value = model.PostTime;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "Up_UserMessage_Set", commandParameters);
}
public void ResumeMessage(M_UserMessage model)
{
this.IUM.ResumeMessage(model);
}
public void AddMessage(M_UserMessage model)
{
this.IUM.AddMessage(model);
}