protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
messlist = messBll.GetModelList(" ");
}
else
{
if (Session["Userinfo"] == null)
{
Response.Redirect("/Users/Login.aspx?action=" + Request.Url);
}
else
{
shaoqi.Model.User model = (shaoqi.Model.User)Session["Userinfo"];
shaoqi.Model.Message messmodel = new shaoqi.Model.Message();
shaoqi.BLL.Message messBll = new shaoqi.BLL.Message();
messmodel.MgeContent = Request.Form["content"];
messmodel.UserId.Id = model.Id;
messmodel.AddTime = DateTime.Now;
messBll.Add(messmodel);
Response.Redirect("/Users/Message.aspx");
//重新绑定
messlist = messBll.GetModelList(" ");
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public shaoqi.Model.Message DataRowToModel(DataRow row)
{
DAL.User userDal = new User();
shaoqi.Model.Message model=new shaoqi.Model.Message();
if (row != null)
{
if(row["Id"]!=null && row["Id"].ToString()!="")
{
model.Id=int.Parse(row["Id"].ToString());
}
if(row["MgeContent"]!=null)
{
model.MgeContent=row["MgeContent"].ToString();
}
if(row["UserId"]!=null && row["UserId"].ToString()!="")
{
model.UserId = userDal.GetModel(int.Parse(row["UserId"].ToString()));
}
if(row["AddTime"]!=null && row["AddTime"].ToString()!="")
{
model.AddTime=DateTime.Parse(row["AddTime"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public shaoqi.Model.Message GetModel(int Id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 Id,MgeContent,UserId,AddTime from Message ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Id", SqlDbType.Int,4)
};
parameters[0].Value = Id;
shaoqi.Model.Message model=new shaoqi.Model.Message();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
