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