/// <summary> /// 增加一条数据 /// </summary> public bool Add(Entity.SYSTEMLOG model) { StringBuilder strSql = new StringBuilder(); DbAPI dbHelper = new DbAPI(); strSql.Append("insert into SYSTEMLOG("); strSql.Append("LOG_ID,LOGNAME,TYPE,CONTENT,F_ACCOUNT,REMARK,DATETIME"); strSql.Append(") values ("); strSql.Append(":LOG_ID,:LOGNAME,:TYPE,:CONTENT,:F_ACCOUNT,:REMARK,:DATETIME"); strSql.Append(") "); OracleParameter[] parameters = { new OracleParameter(":LOG_ID", OracleType.VarChar, 36), new OracleParameter(":LOGNAME", OracleType.VarChar, 256), new OracleParameter(":TYPE", OracleType.VarChar, 36), new OracleParameter(":CONTENT", OracleType.VarChar, 1000), new OracleParameter(":F_ACCOUNT", OracleType.VarChar, 36), new OracleParameter(":REMARK", OracleType.VarChar, 128), new OracleParameter(":DATETIME", OracleType.DateTime) }; parameters[0].Value = dbHelper.GUID(); parameters[1].Value = model.LOGNAME; parameters[2].Value = model.TYPE; parameters[3].Value = model.CONTENT; parameters[4].Value = model.F_ACCOUNT; parameters[5].Value = model.REMARK; parameters[6].Value = model.DATETIME; try { dbHelper.OpenConn(""); int result = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters); dbHelper.CloseConn(); if (result > 0) { return(true); } else { return(false); } } catch (Exception ex) { LogBN.WriteLog(typeof(SYSTEMLOG_BN), "Add 程序段的异常" + ex); return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public ReturnResult AddRole(ROLEINFO model, string[] rolefunlist) { ReturnResult result = new ReturnResult(); StringBuilder strSql = new StringBuilder(); DbAPI dbHelper = new DbAPI(); try { dbHelper.OpenConn(""); dbHelper.OpenTrans(); model.F_ROLECODE = dbHelper.GUID(); strSql.Append("insert into ROLEINFO("); strSql.Append("F_ROLECODE,F_NAME,F_DESCRIPTION"); strSql.Append(") values ("); strSql.Append(":F_ROLECODE,:F_NAME,:F_DESCRIPTION"); strSql.Append(") "); OracleParameter[] parameters = { new OracleParameter(":F_ROLECODE", dbHelper.CheckDBNull(model.F_ROLECODE)), new OracleParameter(":F_NAME", dbHelper.CheckDBNull(model.F_NAME)), new OracleParameter(":F_DESCRIPTION", dbHelper.CheckDBNull(model.F_DESCRIPTION)) }; int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { for (int i = 0; i < rolefunlist.Length; i++) { strSql.Clear(); strSql.Append("insert into ROLEFUNCTION("); strSql.Append("F_ID,F_ROLECODE,F_FUNCTIONCODE"); strSql.Append(") values ("); strSql.Append(":F_ID,:F_ROLECODE,:F_FUNCTIONCODE"); strSql.Append(") "); OracleParameter[] parameters1 = { new OracleParameter(":F_ID", dbHelper.CheckDBNull(dbHelper.GUID())), new OracleParameter(":F_ROLECODE", dbHelper.CheckDBNull(model.F_ROLECODE)), new OracleParameter(":F_FUNCTIONCODE", dbHelper.CheckDBNull(rolefunlist[i])) }; int rows1 = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters1); if (rows1 <= 0) { goto Over; } } result.success = true; result.Message = "操作成功"; dbHelper.CommitTrans(); dbHelper.CloseConn(); return(result); } else { goto Over; } } catch (Exception ex) { LogBN.WriteLog(typeof(ROLEINFO_BN), "SaveRole 程序段的异常" + ex); goto Over; } Over: result.success = false; result.Message = "操作失败"; dbHelper.RollBack(); dbHelper.CloseConn(); return(result); }