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