/// <summary> /// 点击确定按钮处理事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { string title = txtAnnTitle.Text; string content = txtAnnContent.Content; if (string.IsNullOrEmpty(title) || string.IsNullOrEmpty(content)) { MLMGC.COMP.Jscript.ShowMsg("请认真填写以上内容", this); return; } int aid = MLMGC.COMP.Requests.GetQueryInt("aid", 0); E_Announcement data = new E_Announcement(); data.AnnouncementID = aid; data.AnnTitle = title; data.AnnContent = content; bool flag = new T_Announcement().Update(data); if (flag) { MLMGC.COMP.Jscript.AlertAndRedirect(this, "操作成功", "AnnList.aspx"); } else { MLMGC.COMP.Jscript.ShowMsg("操作失败", this); } }
/// <summary> /// 绑定数据 /// </summary> protected void databind() { //得到最新公告 E_Announcement data = new E_Announcement(); data.EnterpriseID = EnterpriceID; data.TeamID = TeamID; data.AnnouncementID = -1; data = new T_Announcement().GetModel(data); if (data != null) { lblTitle.Text = data.AnnTitle; lblAddDate.Text = data.AddDate.ToString("yyyy-MM-dd HH:mm"); lblContent.Text = data.AnnContent; } //获取公告列表 data = new E_Announcement(); data.EnterpriseID = EnterpriceID; data.TeamID = TeamID; //分页参数 data.Page = new MLMGC.DataEntity.E_Page(); data.Page.PageSize = pageSize; data.Page.PageIndex = pageIndex; rpList.DataSource = new T_Announcement().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> protected void databind() { int id = MLMGC.COMP.Requests.GetQueryInt("id", 0); if (id == 0) { MLMGC.COMP.Jscript.AlertAndRedirect(this, "信息不存在", "index.aspx"); return; } E_Announcement data = new E_Announcement(); data.AnnouncementID = id; data = new T_Announcement().GetModel(data); if (data != null) { ltAnnTitle.Text = data.AnnTitle; ltAddDate.Text = string.Format("{0:yyyy-MM-dd HH:mm:ss}", data.AddDate); ltContent.Text = data.AnnContent; } else { MLMGC.COMP.Jscript.AlertAndRedirect(this, "信息不存在", "index.aspx"); return; } }
/// <summary> /// 得到上级公告对象 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2011-10-18</remarks> public E_Announcement GetLeaderModel(E_Announcement data) { SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@AnnouncementID", SqlDbType.BigInt), new SqlParameter("@EnterpriseID", SqlDbType.Int), new SqlParameter("@TeamID", SqlDbType.Int), new SqlParameter("@EPUserTMRID", SqlDbType.Int) }; parms[0].Value = data.AnnouncementID; parms[1].Value = data.EnterpriseID; parms[2].Value = data.TeamID; parms[3].Value = data.EPUserTMRID; DataTable dt = DbHelperSQL.RunProcedureTable("ProcEP_B_AnnouncementS_SelectLeader", parms); if (dt != null && dt.Rows.Count == 1) { data.AnnouncementID = Convert.ToInt64(dt.Rows[0]["AnnouncementID"]); data.AnnTitle = dt.Rows[0]["AnnTitle"].ToString(); data.AnnContent = dt.Rows[0]["AnnContent"].ToString(); data.AddDate = Convert.ToDateTime(dt.Rows[0]["AddDate"]); return(data); } return(null); }
/// <summary> /// 点击确定按钮处理事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { //获取界面数据 string annTitle = txtAnnTitle.Text; string annContent = txtAnnContent.Content; if (annTitle == "" && annContent == "") { MLMGC.COMP.Jscript.ShowMsg("请输入公告标题和内容", this); return; } else if (annTitle == "") { MLMGC.COMP.Jscript.ShowMsg("请输入公告标题和内容", this); return; } else if (annContent == "") { MLMGC.COMP.Jscript.ShowMsg("请输入公告标题和内容", this); return; } //首先根据EPUserTMRID获取TeamID E_User user = new E_User(); user.EnterpriseID = EnterpriceID; user.EPUserTMRID = EPUserTMRID; DataTable dt = new T_Team().GetTeamID(user); if (dt == null || dt.Rows.Count != 1) { return; } int teamID = Convert.ToInt32(dt.Rows[0]["TeamID"]); //添加公告 E_Announcement data = new E_Announcement(); data.EnterpriseID = EnterpriceID; data.TeamID = teamID; data.AnnTitle = annTitle; data.AnnContent = annContent; bool flag = new T_Announcement().Add(data); if (flag) { new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log() { EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "添加公告", IP = MLMGC.COMP.Requests.GetRealIP() }); MLMGC.COMP.Jscript.AlertAndRedirect(this, "添加成功", "AnnouncementList.aspx"); } else { MLMGC.COMP.Jscript.ShowMsg("添加失败", this); } }
/// <summary> /// 获取自身及所有上级的最新公告 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-01-07</remarks> public DataTable GetNewList(E_Announcement data) { SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@EnterpriseID", SqlDbType.Int), new SqlParameter("@TeamID", SqlDbType.Int) }; parms[0].Value = data.EnterpriseID; parms[1].Value = data.TeamID; return(DbHelperSQL.RunProcedureTable("ProcEP_B_AnnouncementS_NewListSelect", parms)); }
/// <summary> /// 获取最新的前几条数据 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-01-12</remarks> public DataTable GetNewList(E_Announcement data) { //参数列表 SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@Count", SqlDbType.Int) }; parms[0].Value = data.Count; DataTable dt = DbHelperSQL.RunProcedureTable("ProcB_Announcement_NewList", parms); return(dt); }
/// <summary> /// 删除公告(个人) /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-01-12</remarks> public bool Delete(E_Announcement data) { //参数列表 SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@AnnouncementID", SqlDbType.BigInt) }; parms[0].Value = data.AnnouncementID; int ReturnValue; DbHelperSQL.RunProcedures("ProcB_Announcement_Delete", parms, out ReturnValue); return(ReturnValue > 0); }
/// <summary> /// 获取分页数据列表 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-01-12</remarks> public DataTable GetList(E_Announcement data) { SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@TotalCount", SqlDbType.Int) }; parms[0].Value = data.Page.PageIndex; parms[1].Value = data.Page.PageSize; parms[2].Direction = ParameterDirection.Output; DataTable dt = DbHelperSQL.RunProcedureTable("ProcB_Announcement_SelectList", parms); data.Page.TotalCount = parms[2].Value == DBNull.Value ? 0 : Convert.ToInt32(parms[2].Value); return(dt); }
/// <summary> /// 数据绑定 /// </summary> public void databind() { E_Announcement data = new E_Announcement(); data.Page = new MLMGC.DataEntity.E_Page(); data.Page.PageIndex = pageIndex; data.Page.PageSize = pageSize; rpList.DataSource = new T_Announcement().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-12</remarks> public bool Update(E_Announcement data) { //参数列表 SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@AnnouncementID", SqlDbType.BigInt), new SqlParameter("@AnnTitle", SqlDbType.VarChar, 128), new SqlParameter("@AnnContent", SqlDbType.VarChar) }; parms[0].Value = data.AnnouncementID; parms[1].Value = data.AnnTitle; parms[2].Value = data.AnnContent; int ReturnValue; DbHelperSQL.RunProcedures("ProcB_Announcement_Update", parms, out ReturnValue); return(ReturnValue > 0); }
/// <summary> /// 根据公告编号获取公告信息 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-01-12</remarks> public E_Announcement GetModel(E_Announcement data) { //参数列表 SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@AnnouncementID", SqlDbType.BigInt) }; parms[0].Value = data.AnnouncementID; DataTable dt = DbHelperSQL.RunProcedureTable("ProcB_Announcement_Select", parms); if (dt != null && dt.Rows.Count == 1) { data.AnnTitle = dt.Rows[0]["AnnTitle"].ToString(); data.AnnContent = dt.Rows[0]["AnnContent"].ToString(); data.AddDate = Convert.ToDateTime(dt.Rows[0]["AddDate"]); return(data); } return(null); }
/// <summary> /// 获取上级公告列表 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2011-10-18</remarks> public DataTable GetLeaderList(E_Announcement data) { SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@EnterpriseID", SqlDbType.Int), new SqlParameter("@TeamID", SqlDbType.Int), new SqlParameter("@EPUserTMRID", SqlDbType.Int), new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@TotalCount", SqlDbType.Int) }; parms[0].Value = data.EnterpriseID; parms[1].Value = data.TeamID; parms[2].Value = data.EPUserTMRID; parms[3].Value = data.Page.PageIndex; parms[4].Value = data.Page.PageSize; parms[5].Direction = ParameterDirection.Output; DataTable dt = DbHelperSQL.RunProcedureTable("ProcEP_B_AnnouncementS_ListSelectLeader", parms); data.Page.TotalCount = Convert.ToInt32(parms[5].Value == DBNull.Value?0:parms[5].Value); return(dt); }
/// <summary> /// 增加企业公告 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks >tianzhenyun 2011-10-17</remarks> public bool Add(E_Announcement data) { int rowsAffected = 0; //参数列表 SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@AnnouncementID", SqlDbType.BigInt), new SqlParameter("@EnterpriseID", SqlDbType.Int), new SqlParameter("@TeamID", SqlDbType.Int), new SqlParameter("@AnnTitle", SqlDbType.VarChar, 128), new SqlParameter("@AnnContent", SqlDbType.VarChar) }; parms[0].Direction = ParameterDirection.Output; parms[1].Value = data.EnterpriseID; parms[2].Value = data.TeamID; parms[3].Value = data.AnnTitle; parms[4].Value = data.AnnContent; DbHelperSQL.ExecProcedure("ProcEP_B_AnnouncementS_Insert", parms, out rowsAffected); data.AnnouncementID = Convert.ToInt32(parms[0].Value); return(rowsAffected > 0); }
/// <summary> /// 获取分页数据列表 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-01-12</remarks> public DataTable GetList(E_Announcement data) { return(dal.GetList(data)); }
/// <summary> /// 根据公告编号获取公告信息 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-01-12</remarks> public E_Announcement GetModel(E_Announcement data) { return(dal.GetModel(data)); }
/// <summary> /// 删除公告(个人) /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-01-12</remarks> public bool Delete(E_Announcement data) { return(dal.Delete(data)); }
/// <summary> /// 修改公告(个人) /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-01-12</remarks> public bool Update(E_Announcement data) { return(dal.Update(data)); }
/// <summary> /// 增加企业公告 /// </summary> /// <param name="data"></param> /// <returns></returns> public bool Add(E_Announcement data) { return(dal.Add(data)); }