/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.BASE_AFFICHE entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_AFFICHE(");
strSql.Append("AFFICHEID,AFFICHETITLE,AFFICHECONTENTS,AFFICHER,AFFICHEDATE,STATES");
strSql.Append(") values (");
strSql.Append(":AFFICHEID,:AFFICHETITLE,:AFFICHECONTENTS,:AFFICHER,:AFFICHEDATE,:STATES");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":AFFICHEID", OracleType.Number, 4),
new OracleParameter(":AFFICHETITLE", OracleType.VarChar, 60),
new OracleParameter(":AFFICHECONTENTS", OracleType.VarChar, 200),
new OracleParameter(":AFFICHER", OracleType.VarChar, 20),
new OracleParameter(":AFFICHEDATE", OracleType.DateTime),
new OracleParameter(":STATES", OracleType.Number, 4)
};
parameters[0].Value = entity.AFFICHEID;
parameters[1].Value = entity.AFFICHETITLE;
parameters[2].Value = entity.AFFICHECONTENTS;
parameters[3].Value = entity.AFFICHER;
parameters[4].Value = entity.AFFICHEDATE;
parameters[5].Value = entity.STATES;
OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
protected void Page_Load(object sender, EventArgs e)
{
userSession = (Utility.UserSession)Session["user"];
if (!IsPostBack)
{
if ("" == Request.QueryString["aid"] || null == Request.QueryString["aid"])
{
if (this.hidPrimary.Value == "-1")
{
this.LbHeadName.Text = "新建电子公告";//设置标题头名称
this.TxtTime.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
else
{
this.LbHeadName.Text = "编辑电子公告";//设置标题头名称
decimal AFFICHEID = Convert.ToDecimal(this.hidPrimary.Value);
Entity.BASE_AFFICHE model = bll.Getmodel(AFFICHEID);
SetEntity(model);
}
}
else
{
this.LbHeadName.Text = "编辑电子公告";//设置标题头名称
decimal AFFICHEID = Convert.ToDecimal(Request.QueryString["aid"]);
Entity.BASE_AFFICHE model = bll.Getmodel(AFFICHEID);
SetEntity(model);
}
}
}
/// <summary>
/// 设置公告数据
/// </summary>
/// <param name="model">公告实体</param>
private void SetEntity(Entity.BASE_AFFICHE model)
{
this.hidPrimary.Value = model.AFFICHEID.ToString(); //id,主键
this.TxtTitle.Text = model.AFFICHETITLE; //公告标题
model.AFFICHER = userSession.USERNAME; //公告发布人
this.TxtTime.Text = model.AFFICHEDATE.ToString("yyyy-MM-dd"); //公告发布时间
this.TxtContent.Text = model.AFFICHECONTENTS; //公告内容
//model.STATES = 0; //公告状态0:已保存；1：已发布；2：已删除；
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool update(Entity.BASE_AFFICHE model)
{
if (dal.Update(model))
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获得公告实体数据
/// </summary>
/// <param name="states">公告状态</param>
/// <returns></returns>
private Entity.BASE_AFFICHE GetEntity(decimal states)
{
Entity.BASE_AFFICHE model = new Entity.BASE_AFFICHE();
model.AFFICHEID = Convert.ToInt32(this.hidPrimary.Value); //id,主键
model.AFFICHETITLE = this.TxtTitle.Text; //公告标题
model.AFFICHER = userSession.USERNAME; //公告发布人
model.AFFICHEDATE = DateTime.Parse(this.TxtTime.Text); //公告发布时间
model.AFFICHECONTENTS = this.TxtContent.Text; //公告内容
model.STATES = states; //公告状态0:已保存；1：已发布；2：已删除；
return(model);
}
/// <summary>
/// 修改状态
/// </summary>
/// <param name="AFFICHEID"></param>
private void updateState(decimal AFFICHEID)
{
Entity.BASE_AFFICHE model = bll.Getmodel(AFFICHEID);
model.STATES = 2;//设置状态为已删除
if (bll.update(model))
{
Response.Write("<script type='text/javascript'>alert('删除成功！');</script>");
}
else
{
Response.Write("<script type='text/javascript'>alert('删除失败！');</script>");
}
}
/// <summary>
/// 按钮事件：保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Btn_Save_Click(object sender, EventArgs e)
{
//获取实体
Entity.BASE_AFFICHE model = GetEntity(0);
//添加数据
bll.Add(model);
//日志..............添加
Entity.BASE_LOG logmodel = new Entity.BASE_LOG();
logmodel.LOGID = -1; //id,主键
logmodel.LOGTYPE = "电子公告"; //日志类型
logmodel.CREATEDATE = DateTime.Now; //日志创建时间
logmodel.DESCRIPTION = "添加公告"; //日志信息内容
logmodel.OPERATORID = userSession.USERID; //操作人
logmodel.IPADDRESS = Smart.Utility.IpAddress.GetLocationIpAddress(); //ip地址
logbll.Add(logmodel);
/*日志结束***********/
Response.Redirect("Affiche.aspx", true);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_AFFICHE entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_AFFICHE set ");
strSql.Append(" AFFICHEID = :AFFICHEID , ");
strSql.Append(" AFFICHETITLE = :AFFICHETITLE , ");
strSql.Append(" AFFICHECONTENTS = :AFFICHECONTENTS , ");
strSql.Append(" AFFICHER = :AFFICHER , ");
strSql.Append(" AFFICHEDATE = :AFFICHEDATE ,");
strSql.Append(" STATES = :STATES ");
strSql.Append(" where AFFICHEID=:AFFICHEID ");
OracleParameter[] parameters =
{
new OracleParameter(":AFFICHEID", OracleType.Number, 4),
new OracleParameter(":AFFICHETITLE", OracleType.VarChar, 60),
new OracleParameter(":AFFICHECONTENTS", OracleType.VarChar, 200),
new OracleParameter(":AFFICHER", OracleType.VarChar, 20),
new OracleParameter(":AFFICHEDATE", OracleType.DateTime),
new OracleParameter(":STATES", OracleType.Number, 4)
};
parameters[0].Value = entity.AFFICHEID;
parameters[1].Value = entity.AFFICHETITLE;
parameters[2].Value = entity.AFFICHECONTENTS;
parameters[3].Value = entity.AFFICHER;
parameters[4].Value = entity.AFFICHEDATE;
parameters[5].Value = entity.STATES;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_AFFICHE GetEntity(decimal AFFICHEID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select AFFICHEID, AFFICHETITLE, AFFICHECONTENTS, AFFICHER, AFFICHEDATE,STATES ");
strSql.Append(" from BASE_AFFICHE ");
strSql.Append(" where AFFICHEID = :AFFICHEID ");
OracleParameter[] parameters =
{
new OracleParameter(":AFFICHEID", OracleType.Number, 4)
};
parameters[0].Value = AFFICHEID;
Entity.BASE_AFFICHE entity = new Entity.BASE_AFFICHE();
DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["AFFICHEID"].ToString() != "")
{
entity.AFFICHEID = decimal.Parse(dt.Rows[0]["AFFICHEID"].ToString());
}
entity.AFFICHETITLE = dt.Rows[0]["AFFICHETITLE"].ToString();
entity.AFFICHECONTENTS = dt.Rows[0]["AFFICHECONTENTS"].ToString();
entity.AFFICHER = dt.Rows[0]["AFFICHER"].ToString();
if (dt.Rows[0]["AFFICHEDATE"].ToString() != "")
{
entity.AFFICHEDATE = DateTime.Parse(dt.Rows[0]["AFFICHEDATE"].ToString());
}
if (dt.Rows[0]["STATES"].ToString() != "")
{
entity.STATES = decimal.Parse(dt.Rows[0]["STATES"].ToString());
}
return(entity);
}
else
{
return(null);
}
}
/// <summary>
/// 新建公告
/// </summary>
/// <param name="model">公告实体</param>
public void Add(Entity.BASE_AFFICHE model)
{
dal.Add(model);
}
