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