protected void btnSend_Click(object sender, EventArgs e)
{
int id = int.Parse(Request.QueryString["Id"]);
BLL.Leaveword bll = new BLL.Leaveword();
Model.Leaveword model = new Model.Leaveword();
model.Fk_News_Id = id;
if (Session["LoginUser"] != null)
{
model.FK_Users_Id = (int)Session["LoginUser"];
}
else
{
model.FK_Users_Id = -1;
}
model.Contents = txtContent.Text;
model.AddTimes = DateTime.Now;
try
{
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "留言成功！", "Newss.aspx?id=" + Request["id"]);
}
catch
{
Maticsoft.Common.MessageBox.Show(this, "留言失败！");
}
}
public QPS.NEW.Model.Leaveword GetModel(int Id)
{
QPS.NEW.Model.Leaveword leaveeord = null;
string strSql = "select * from Leaveword where Id=@id";
DataTable dt = sqlHelper_.GetDataTable(
strSql,
CommandType.Text,
new SqlParameter[]
{
new SqlParameter("@id", Id)
}
);
if (dt != null && dt.Rows.Count > 0)
{
leaveeord = new Model.Leaveword();
leaveeord.Id = Id;
leaveeord.UserID = Convert.ToInt32(dt.Rows[0]["UserID"]);
leaveeord.title = dt.Rows[0]["title"].ToString();
leaveeord.Content = dt.Rows[0]["Content"].ToString();
}
return(leaveeord);
}
private void ShowInfo(int Id)
{
Maticsoft.BLL.Reply bll = new Maticsoft.BLL.Reply();
Maticsoft.Model.Reply model = bll.GetModel(Id);
this.lblId.Text = model.Id.ToString();
BLL.Leaveword BLLLeaveword = new BLL.Leaveword();
Model.Leaveword ModelLeaveword = BLLLeaveword.GetModel((int)model.Fk_Leaveword_Id);
this.lblFk_Leaveword_Id.Text = ModelLeaveword.Id.ToString();
this.lblContents.Text = model.Contents;
BLL.Users BLLUsers = new BLL.Users();
Model.Users ModelUsers = BLLUsers.GetModel((int)model.Fk_Users_Id);
this.lblFk_Users_Id.Text = ModelUsers.Name;
this.lblAddTimes.Text = model.AddTimes.ToString();
}
public QPS.NEW.Model.Leaveword GetModel(int Id)
{
QPS.NEW.Model.Leaveword leaveeord = null;
string strSql = "select * from Leaveword where Id=@id";
DataTable dt = sqlHelper_.GetDataTable(
strSql,
CommandType.Text,
new SqlParameter[]
{
new SqlParameter("@id",Id)
}
);
if (dt != null && dt.Rows.Count > 0)
{
leaveeord = new Model.Leaveword();
leaveeord.Id = Id;
leaveeord.UserID = Convert.ToInt32( dt.Rows[0]["UserID"]);
leaveeord.title = dt.Rows[0]["title"].ToString();
leaveeord.Content = dt.Rows[0]["Content"].ToString();
}
return leaveeord;
}
