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); }