private void BindData(Int64 nd, Int64 ns)
{
XYECOM.Business.News ne = new XYECOM.Business.News();
nsname = ne.GetNewsName(ns);
this.caption.InnerHtml = nsname;
ndinfo = ndis.GetItem(nd);
if (ndinfo.U_ID.ToString() == "0")
this.lbname.Text = ndinfo.U_Name+"(游客)";
else
this.lbname.Text = ndinfo.U_Name+"(会员)";
this.lbtime.Text = ndinfo.ND_AddTime.ToString();
this.tbcontent.Text = ndinfo.ND_Content.Replace("</n>", "</br>");
if (ndinfo.ND_IsShow == true)
{
this.rbisshowtrue.Checked = true;
}
else
{
this.rbisshowfalse.Checked = true;
}
}
/// <summary>
/// ��ȡָ����ŵ����۶���
/// </summary>
/// <param name="ndid">ָ�������۱��</param>
/// <returns>�ñ�ŵ����۶���</returns>
public NewsDiscussInfo GetItem(Int64 ndid)
{
NewsDiscussInfo newsdiscuss = null;
SqlParameter [] parm = new SqlParameter[]
{
new SqlParameter("@strWhere"," Where ND_ID="+ndid.ToString()),
new SqlParameter("@strTableName","n_NewsDiscuss"),
new SqlParameter("@strOrder","")
};
using (SqlDataReader rdr = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "XYP_SelectByWhere", parm))
{
if (rdr.Read())
newsdiscuss = new NewsDiscussInfo(Convert.ToInt64(rdr["ND_ID"]),
Convert.ToInt64(rdr["U_ID"]),
rdr["U_Name"].ToString(),
Convert.ToInt64(rdr["NS_ID"]),
rdr["ND_Content"].ToString(),
Convert.ToDateTime(rdr["ND_AddTime"]),
Convert.ToBoolean(rdr["ND_IsShow"]),
rdr["IPAddress"].ToString(),
Convert.ToBoolean(rdr["IPIsShow"]));
}
return newsdiscuss;
}
/// <summary>
/// ���������۶���
/// </summary>
/// <param name="nd">Ҫ�ĵ��������۶���</param>
/// <returns>����,���ڻ����0���ijɹ�,����ʧ��</returns>
public int Update(NewsDiscussInfo nd)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@ND_ID",nd.ND_ID),
new SqlParameter("@U_ID",nd.U_ID),
new SqlParameter("@U_Name",nd.U_Name),
new SqlParameter("@NS_ID",nd.NS_ID),
new SqlParameter("@NS_Content",nd.ND_Content),
new SqlParameter("@ND_AddTime",nd.ND_AddTime),
new SqlParameter("@ND_IsShow",nd.ND_IsShow),
new SqlParameter("@IPAddress",nd.IpAddress),
new SqlParameter("@IPIsShow",nd.IpIsShow)
};
int rowAffected = XYECOM.Core.Data.SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "XYP_UpdateNewsDiscuss", param);
return rowAffected;
}
/// <summary>
/// �����µ����۶���
/// </summary>
/// <param name="nd">Ҫ������������۶���</param>
/// <param name="ndid">����ɹ�������۱��</param>
/// <returns>����,���ڻ����0�����ɹ�,�����ʧ��</returns>
public int Insert(NewsDiscussInfo nd)
{
return DAL.Insert(nd);
}
/// <summary>
/// ����ָ�����������۶���
/// </summary>
/// <param name="nd">Ҫ���µ���������</param>
/// <returns>����,���ڻ����0����³ɹ�,����ʧ��</returns>
public int Update(NewsDiscussInfo nd)
{
return DAL.Update(nd);
}
