/// <summary> /// 发布微博 /// </summary> public void Add() { nv.Clear(); nv = HttpContext.Current.Request.Form; string detail = nv["weibo"]; if (string.IsNullOrEmpty(detail)) { HttpContext.Current.Response.Write("参数错误"); return; } E_Weibo data = new E_Weibo(); data.PersonalID = pp.PersonalID; data.UserID = pp.UserID; data.Detail = MLMGC.COMP.Weibo.WeiboContent(detail); data.AddDate = DateTime.Now; bool flag = new T_Weibo().Add(data); if (flag) { HttpContext.Current.Response.Write("succ"); //HttpContext.Current.Response.Write("{\"type\":\"succ\",\"data\":{\"weiboid\":" + data.WeiboID.ToString() + ",\"username\": \"" + data.RealName + "\",\"date\": \"" + data.AddDate.ToString("HH:mm") + "\",\"showdate\":\"" + WEIBOHelper.ShowTime(data.AddDate) + "\",\"weibo\": \"" + data.Detail.Replace("\"", "'") + "\",\"img\":\"" + MLMGC.COMP.Config.GetPersonalAvatarUrl(data.Avatar) + "\"}}"); } else { //HttpContext.Current.Response.Write("{\"type\":\"error\",\"data\":{\"weiboid\":0}}"); HttpContext.Current.Response.Write("error"); } }
/// <summary> /// 发布微博 /// </summary> public void Add() { nv.Clear(); nv = HttpContext.Current.Request.Form; string detail = nv["weibo"]; if (string.IsNullOrEmpty(detail)) { HttpContext.Current.Response.Write("参数错误"); return; } E_Weibo data = new E_Weibo(); data.EnterpriseID = ep.EnterpriceID; data.UserID = ep.UserID; data.Detail = MLMGC.COMP.Weibo.WeiboContent(detail); data.AddDate = DateTime.Now; bool flag = new T_Weibo().Add(data); if (flag) { //添加操作日志 new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log() { EnterpriseID = ep.EnterpriceID, UserID = ep.UserID, LogTitle = "发布微博", IP = MLMGC.COMP.Requests.GetRealIP() }); //HttpContext.Current.Response.Write("{\"type\":\"succ\",\"data\":{\"weiboid\":" + data.WeiboID.ToString() + ",\"username\": \"" + data.TrueName + "\",\"date\": \"" + data.AddDate.ToString("HH:mm") + "\",\"showdate\":\"" + WEIBOHelper.ShowTime(data.AddDate) + "\",\"weibo\": \"" + data.Detail.Replace("\"", "'") + "\",\"img\":\"" + MLMGC.COMP.Config.GetEnterpriseAvatarUrl(data.Avatar) + "\"}}"); HttpContext.Current.Response.Write("succ"); } else { HttpContext.Current.Response.Write("error"); //HttpContext.Current.Response.Write("{\"type\":\"error\",\"data\":{\"weiboid\":0}}"); } }
/// <summary> /// 获取最新微博信息 /// </summary> public void NewList() { int weiboid = 0; if (!int.TryParse(nv["weiboid"], out weiboid)) { //return; } E_Weibo data = new E_Weibo(); data.EnterpriseID = ep.EnterpriceID; data.WeiboID = weiboid; T_Weibo bll = new T_Weibo(); DataTable dt = bll.GetNewList(data); JsonArrayCollection jac = new JsonArrayCollection(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { JsonObjectCollection colDR = new JsonObjectCollection(); colDR.Add(new JsonStringValue("weiboid", dr["weiboid"].ToString())); colDR.Add(new JsonStringValue("username", dr["TrueName"].ToString())); colDR.Add(new JsonStringValue("date", dr["AddDate"].ToString())); colDR.Add(new JsonStringValue("showdate", WEIBOHelper.ShowTime(dr["AddDate"].ToString()))); colDR.Add(new JsonStringValue("weibo", dr["Detail"].ToString())); colDR.Add(new JsonStringValue("img", MLMGC.COMP.Config.GetEnterpriseAvatarUrl(dr["Avatar"].ToString()))); jac.Add(colDR); } } HttpContext.Current.Response.Write("{\"list\":" + jac.ToString() + "}"); }
protected void databind() { //获取该用户的基本信息 E_User dataEP = new E_User(); dataEP.EnterpriseID = EnterpriceID; dataEP.UserID = UserID; dataEP = new T_User().GetEPModel(dataEP); if (dataEP == null) { Response.Redirect("../main.aspx"); } ltName.Text = dataEP.TrueName; imgAvatar.ImageUrl = MLMGC.COMP.Config.GetEnterpriseAvatarUrl(dataEP.Avatar); T_Weibo bll = new T_Weibo(); E_Weibo data = new E_Weibo(); data.EnterpriseID = EnterpriceID; data.Page = new E_Page(); data.Page.PageSize = pagesize; data.Page.PageIndex = pageindex; rpList.DataSource = bll.GetList(data); rpList.DataBind(); //设置分页样式 pageList1.PageSize = pagesize; pageList1.CurrentPageIndex = pageindex; pageList1.RecordCount = data.Page.TotalCount; pageList1.CustomInfoHTML = string.Format("共有 <span class='red_font'>{0}</span> 条微博", pageList1.RecordCount); pageList1.TextAfterPageIndexBox = " 页/" + pageList1.PageCount + " "; }
/// <summary> /// 发布微博 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-01-05</remarks> public bool Add(E_Weibo data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseID", SqlDbType.Int), new SqlParameter("@UserID", SqlDbType.Int), new SqlParameter("@Detail", SqlDbType.VarChar,512), new SqlParameter("@AddDate", SqlDbType.SmallDateTime) }; parms[0].Value = data.EnterpriseID; parms[1].Value = data.UserID; parms[2].Value = data.Detail; parms[3].Value = data.AddDate; DataTable dt = DbHelperSQL.RunProcedureTable("ProcEP_B_Weibo_Insert", parms); if (dt != null && dt.Rows.Count == 1) { data.WeiboID = Convert.ToInt32(dt.Rows[0]["WeiboID"].ToString()); data.Detail = dt.Rows[0]["Detail"].ToString(); data.AddDate = Convert.ToDateTime(dt.Rows[0]["AddDate"].ToString()); data.TrueName = dt.Rows[0]["TrueName"].ToString(); data.Avatar = dt.Rows[0]["Avatar"].ToString(); return(true); } return(false); //data.WeiboID = ReturnValue; //return ReturnValue > 0; }
/// <summary> /// 获取首页显示微博数据 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>qipengfei 2012-01-07</remarks> public DataTable GetMainList(E_Weibo data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseID", SqlDbType.Int) }; parms[0].Value = data.EnterpriseID; return(DbHelperSQL.RunProcedureTable("ProcEP_B_WeiboS_SelectTop", parms)); }
/// <summary> /// 获取新微博数据 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-01-12</remarks> public DataTable GetNewList(E_Weibo data) { SqlParameter[] parms = { new SqlParameter("@WeiboID", SqlDbType.Int) }; parms[0].Value = data.WeiboID; return(DbHelperSQL.RunProcedureTable("ProcPI_B_WeiboS_SelectNew", parms)); }
/// <summary> /// 后台管理员删除个人微博 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-03-08</remarks> public bool AdminDelete(E_Weibo data) { SqlParameter[] parms = { new SqlParameter("@WeiboIDs", SqlDbType.NVarChar) }; parms[0].Value = data.WeiboIDs; int ReturnValue; DbHelperSQL.RunProcedures("ProcPI_B_WeiboS_AdminDelete", parms, out ReturnValue); return(ReturnValue > 0); }
/// <summary> /// 个人用户删除自己发布的微博 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-02-02</remarks> public bool Delete(E_Weibo data) { SqlParameter[] parms = { new SqlParameter("@PersonalID", SqlDbType.Int), new SqlParameter("@WeiboID", SqlDbType.Int) }; parms[0].Value = data.PersonalID; parms[1].Value = data.WeiboID; int ReturnValue; DbHelperSQL.RunProcedures("ProcPI_B_WeiboS_Delete", parms, out ReturnValue); return(ReturnValue > 0); }
/// <summary> /// 企业用户删除自己发布的微博 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-02-02</remarks> public bool Delete(E_Weibo data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseID", SqlDbType.Int), new SqlParameter("@UserID", SqlDbType.Int), new SqlParameter("@WeiboID", SqlDbType.Int) }; parms[0].Value = data.EnterpriseID; parms[1].Value = data.UserID; parms[2].Value = data.WeiboID; int ReturnValue; DbHelperSQL.RunProcedures("ProcEP_B_Weibo_Delete", parms, out ReturnValue); return(ReturnValue > 0); }
/// <summary> /// 删除自己发布的微博 /// </summary> public void Delete() { int weiboid = 0; if (!int.TryParse(nv["weiboid"], out weiboid)) { return; } E_Weibo data = new E_Weibo(); data.PersonalID = pp.PersonalID; data.WeiboID = weiboid; bool flag = new T_Weibo().Delete(data); HttpContext.Current.Response.Write(flag?"1":"0"); }
/// <summary> /// 获取微博列表 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-01-12</remarks> public DataTable GetList(E_Weibo data) { SqlParameter[] parms = { new SqlParameter("@PageSize", SqlDbType.TinyInt), new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@TotalCount", SqlDbType.Int) }; parms[0].Value = data.Page.PageSize; parms[1].Value = data.Page.PageIndex; parms[2].Direction = ParameterDirection.Output; DataTable dt = DbHelperSQL.RunProcedureTable("ProcPI_B_WeiboS_Select", parms); data.Page.TotalCount = Convert.ToInt32(DBNull.Value.Equals(parms[2].Value) ? "0" : parms[2].Value); return(dt); }
/// <summary> /// 后台管理员删除个人微博 /// </summary> private void DeleteWeibo() { string ids = nv["ids"]; if (!MLMGC.COMP.StringUtil.IsStringArrayList(ids))//判断格式是否正确 格式:1,21,321 { HttpContext.Current.Response.Write("参数错误"); return; } E_Weibo data = new E_Weibo(); data.WeiboIDs = ids; bool flag = new T_Weibo().AdminDelete(data); HttpContext.Current.Response.Write(flag ? "1" : "0"); }
public void databind() { //微博信息 T_Weibo bll = new T_Weibo(); E_Weibo data = new E_Weibo(); data.PersonalID = type == "personal"? PersonalID:0; data.WeiboID = Requests.GetQueryInt("weiboid", 0); data.Page = new E_Page(); data.Page.PageSize = pagesize; data.Page.PageIndex = pageindex; rpList.DataSource = bll.List(data); rpList.DataBind(); //设置分页样式 mlmgcPaging.PageSize = pagesize; mlmgcPaging.RecordCount = data.Page.TotalCount; mlmgcPaging.CurrentPage = pageindex; }
/// <summary> /// 后台管理员查看所有个人微博列表 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-03-08</remarks> public DataTable AdminList(E_Weibo data) { SqlParameter[] parms = { new SqlParameter("@Detail", SqlDbType.NVarChar, 512), new SqlParameter("@PersonalID", SqlDbType.Int), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@TotalCount", SqlDbType.Int) }; parms[0].Value = data.Detail; parms[1].Value = data.PersonalID; parms[2].Value = data.Page.PageSize; parms[3].Value = data.Page.PageIndex; parms[4].Direction = ParameterDirection.Output; DataTable dt = DbHelperSQL.RunProcedureTable("ProcPI_B_WeiboS_AdminSelectList", parms); data.Page.TotalCount = parms[4].Value == DBNull.Value ? 0 : Convert.ToInt32(parms[4].Value); return(dt); }
protected void databind() { //个人信息 E_Personal dataPersonal = new E_Personal(); dataPersonal.UserID = UserID; dataPersonal.PersonalID = PersonalID; dataPersonal = new T_Personal().GetModel(dataPersonal); if (dataPersonal == null) { Response.Redirect("../main.aspx"); } ltName.Text = dataPersonal.RealName; imgAvatar.ImageUrl = MLMGC.COMP.Config.GetPersonalAvatarUrl(dataPersonal.Avatar); //微博信息 T_Weibo bll = new T_Weibo(); E_Weibo data = new E_Weibo(); data.PersonalID = PersonalID; data.Page = new E_Page(); data.Page.PageSize = pagesize; data.Page.PageIndex = pageindex; rpList.DataSource = bll.SelfList(data); rpList.DataBind(); //设置分页样式 pageList1.PageSize = pagesize; pageList1.CurrentPageIndex = pageindex; pageList1.RecordCount = data.Page.TotalCount; pageList1.CustomInfoHTML = string.Format("共有 <span class='red_font'>{0}</span> 条微博", pageList1.RecordCount); pageList1.TextAfterPageIndexBox = " 页/" + pageList1.PageCount + " "; //获取最新的n条公告信息 rpListAnn.DataSource = new T_Announcement().GetNewList(new E_Announcement() { Count = 15 }); rpListAnn.DataBind(); }
/// <summary> /// 发布微博 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-01-12</remarks> public bool Add(E_Weibo data) { SqlParameter[] parms = { new SqlParameter("@PersonalID", SqlDbType.Int), new SqlParameter("@Detail", SqlDbType.VarChar,512), new SqlParameter("@AddDate", SqlDbType.SmallDateTime) }; parms[0].Value = data.PersonalID; parms[1].Value = data.Detail; parms[2].Value = data.AddDate; DataTable dt = DbHelperSQL.RunProcedureTable("ProcPI_B_WeiboS_Insert", parms); if (dt != null && dt.Rows.Count == 1) { data.WeiboID = Convert.ToInt32(dt.Rows[0]["WeiboID"].ToString()); data.Detail = dt.Rows[0]["Detail"].ToString(); data.AddDate = Convert.ToDateTime(dt.Rows[0]["AddDate"].ToString()); data.RealName = dt.Rows[0]["RealName"].ToString(); data.Avatar = dt.Rows[0]["Avatar"].ToString(); return(true); } return(false); }
/// <summary> /// 数据绑定 /// </summary> protected void databind() { //绑定人员信息 DataTable dt = new T_Personal().DataList(); ddlPersonal.Items.Add(new ListItem("", "-1")); foreach (DataRow row in dt.Rows) { ddlPersonal.Items.Add(new ListItem(row["RealName"].ToString(), row["PersonalID"].ToString())); } int personalid; E_Weibo data = new E_Weibo(); data.Detail = Requests.GetQueryString("detail"); //获取内容 txtDetail.Text = data.Detail; int.TryParse(Requests.GetQueryString("personalid"), out personalid); //个人编号 data.PersonalID = personalid; ddlPersonal.SelectedValue = personalid.ToString(); data.Page = new MLMGC.DataEntity.E_Page(); data.Page.PageIndex = pageIndex; data.Page.PageSize = pageSize; DataTable dtList = new T_Weibo().AdminList(data); rpList.DataSource = dtList; rpList.DataBind(); //设置分页样式 pageList1.PageSize = pageSize; pageList1.CurrentPageIndex = pageIndex; pageList1.RecordCount = data.Page.TotalCount; pageList1.CustomInfoHTML = string.Format("共有记录 <span class='red_font'>{0}</span> 条", pageList1.RecordCount); pageList1.TextAfterPageIndexBox = " 页/" + pageList1.PageCount + " "; }
/// <summary> /// 后台管理员删除个人微博 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-03-08</remarks> public bool AdminDelete(E_Weibo data) { return(dal.AdminDelete(data)); }
/// <summary> /// 获取首页显示微博数据 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-01-12</remarks> public DataTable GetMainList(E_Weibo data) { return(dal.GetMainList(data)); }
/// <summary> /// 发布微博 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-01-12</remarks> public bool Add(E_Weibo data) { return(dal.Add(data)); }
/// <summary> /// 个人用户获取自己的微博列表 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-02-02</remarks> public DataTable SelfList(E_Weibo data) { return(dal.SelfList(data)); }
/// <summary> /// 个人用户删除自己发布的微博 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-02-02</remarks> public bool Delete(E_Weibo data) { return(dal.Delete(data)); }
/// <summary> /// 个人微博列表 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-02-21</remarks> public DataTable List(E_Weibo data) { return(dal.List(data)); }
/// <summary> /// 后台管理员查看所有个人微博列表 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-03-08</remarks> public DataTable AdminList(E_Weibo data) { return(dal.AdminList(data)); }