/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Entity.BASE_LOG entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_LOG(");
strSql.Append("LOGID,LOGTYPE,CREATEDATE,OPERATORID,DESCRIPTION,IPADDRESS");
strSql.Append(") values (");
strSql.Append(":LOGID,:LOGTYPE,:CREATEDATE,:OPERATORID,:DESCRIPTION,:IPADDRESS");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":LOGID", OracleType.Number, 4),
new OracleParameter(":LOGTYPE", OracleType.VarChar, 50),
new OracleParameter(":CREATEDATE", OracleType.DateTime),
new OracleParameter(":OPERATORID", OracleType.Number, 4),
new OracleParameter(":DESCRIPTION", OracleType.VarChar, 200),
new OracleParameter(":IPADDRESS", OracleType.VarChar, 50)
};
parameters[0].Value = entity.LOGID;
parameters[1].Value = entity.LOGTYPE;
parameters[2].Value = entity.CREATEDATE;
parameters[3].Value = entity.OPERATORID;
parameters[4].Value = entity.DESCRIPTION;
parameters[5].Value = entity.IPADDRESS;
return(OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (ViewState["strAction"].ToString() == "add")//添加部门信息
{
//获取实体
Entity.BASE_DEPT model = GetEntity(Convert.ToDecimal(ViewState["parentId"].ToString()));
//添加数据
int flag = 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 = 17; //操作人编号
logmodel.IPADDRESS = Smart.Utility.IpAddress.GetLocationIpAddress(); //ip地址
logbll.Add(logmodel);
if (flag > 0)
{
ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "", "alert('操作成功');window.close();", true);
}
else
{
AjaxAlert(UpdatePanel1, "操作失败，请检查数据录入是否规范！");
}
}
else //修改部门信息
{
//获取实体
Entity.BASE_DEPT model = GetEntity(0);//编辑时对上级编号不做修改
bool flag = bll.update(model);
//日志..............修改
Entity.BASE_LOG logmodel = new Entity.BASE_LOG();
logmodel.LOGID = -1; //id,主键
logmodel.LOGTYPE = "部门管理"; //日志类型
logmodel.CREATEDATE = DateTime.Now; //日志创建时间
logmodel.DESCRIPTION = "编辑部门"; //日志信息内容
logmodel.OPERATORID = 17; //操作人编号
logmodel.IPADDRESS = Smart.Utility.IpAddress.GetLocationIpAddress(); //ip地址
logbll.Add(logmodel);
if (flag)
{
ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "", "alert('操作成功');window.close();", true);
}
else
{
AjaxAlert(UpdatePanel1, "操作失败，请检查数据录入是否规范！");
}
}
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool update(Entity.BASE_LOG model)
{
if (dal.Update(model))
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 日志添加
/// </summary>
/// <param name="logtype">日志类型</param>
/// <param name="description">日志信息内容</param>
private void LogAdd(string logtype, string description)
{
Entity.BASE_LOG logmodel = new Entity.BASE_LOG();
logmodel.LOGID = -1; //id,主键
logmodel.LOGTYPE = logtype; //日志类型
logmodel.CREATEDATE = DateTime.Now; //日志创建时间
logmodel.DESCRIPTION = description; //日志信息内容
logmodel.OPERATORID = 1; //操作人
logmodel.IPADDRESS = Smart.Utility.IpAddress.GetLocationIpAddress(); //ip地址
logbll.Add(logmodel);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_LOG GetEntity(decimal LOGID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select LOGID, LOGTYPE, CREATEDATE, OPERATORID, DESCRIPTION, IPADDRESS ");
strSql.Append(" from BASE_LOG ");
strSql.Append(" where LOGID=:LOGID ");
OracleParameter[] parameters =
{
new OracleParameter(":LOGID", OracleType.Number, 4)
};
parameters[0].Value = LOGID;
Entity.BASE_LOG entity = new Entity.BASE_LOG();
DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["LOGID"].ToString() != "")
{
entity.LOGID = decimal.Parse(dt.Rows[0]["LOGID"].ToString());
}
entity.LOGTYPE = dt.Rows[0]["LOGTYPE"].ToString();
if (dt.Rows[0]["CREATEDATE"].ToString() != "")
{
entity.CREATEDATE = DateTime.Parse(dt.Rows[0]["CREATEDATE"].ToString());
}
if (dt.Rows[0]["OPERATORID"].ToString() != "")
{
entity.OPERATORID = decimal.Parse(dt.Rows[0]["OPERATORID"].ToString());
}
entity.DESCRIPTION = dt.Rows[0]["DESCRIPTION"].ToString();
entity.IPADDRESS = dt.Rows[0]["IPADDRESS"].ToString();
return(entity);
}
else
{
return(null);
}
}
/// <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_LOG entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_LOG set ");
strSql.Append(" LOGID = :LOGID , ");
strSql.Append(" LOGTYPE = :LOGTYPE , ");
strSql.Append(" CREATEDATE = :CREATEDATE , ");
strSql.Append(" OPERATORID = :OPERATORID , ");
strSql.Append(" DESCRIPTION = :DESCRIPTION , ");
strSql.Append(" IPADDRESS = :IPADDRESS ");
strSql.Append(" where LOGID=:LOGID ");
OracleParameter[] parameters =
{
new OracleParameter(":LOGID", OracleType.Number, 4),
new OracleParameter(":LOGTYPE", OracleType.VarChar, 50),
new OracleParameter(":CREATEDATE", OracleType.DateTime),
new OracleParameter(":OPERATORID", OracleType.Number, 4),
new OracleParameter(":DESCRIPTION", OracleType.VarChar, 200),
new OracleParameter(":IPADDRESS", OracleType.VarChar, 50)
};
parameters[0].Value = entity.LOGID;
parameters[1].Value = entity.LOGTYPE;
parameters[2].Value = entity.CREATEDATE;
parameters[3].Value = entity.OPERATORID;
parameters[4].Value = entity.DESCRIPTION;
parameters[5].Value = entity.IPADDRESS;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加日志
/// </summary>
/// <param name="model">日志实体</param>
public int Add(Entity.BASE_LOG model)
{
return(dal.Add(model));
}
