/// <summary> /// 删除一条数据 /// </summary> public ReturnResult DeleteRole(string F_ROLECODE) { ReturnResult result = new ReturnResult(); StringBuilder strSql = new StringBuilder(); DbAPI dbHelper = new DbAPI(); try { dbHelper.OpenConn(""); dbHelper.OpenTrans(); strSql.Append("delete from ROLEINFO "); strSql.Append(" where F_ROLECODE=:F_ROLECODE "); OracleParameter[] parameters = { new OracleParameter(":F_ROLECODE", dbHelper.CheckDBNull(F_ROLECODE)) }; int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { strSql.Clear(); strSql.Append("delete from ROLEFUNCTION "); strSql.Append(" where F_ROLECODE=:F_ROLECODE "); OracleParameter[] parameters1 = { new OracleParameter(":F_ROLECODE", dbHelper.CheckDBNull(F_ROLECODE)) }; 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), "DeleteRole 程序段的异常" + ex); goto Over; } Over: result.success = false; result.Message = "操作失败"; dbHelper.RollBack(); dbHelper.CloseConn(); return(result); }
public string SearchEqipment(DEVICEATTACH model) { StringBuilder strSql = new StringBuilder(); DbAPI dbHelper = new DbAPI(); OracleParameter[] parameters = null; strSql.Append("select * "); strSql.Append(" FROM DEVICEFULL WHERE 1=1 "); if (model.SEAAREA != "全部") { strSql.Append(" AND SEAAREA = '" + model.SEAAREA + "'"); } if (model.PROVINCE != "全部") { strSql.Append(" AND PROVINCE LIKE '%" + dbHelper.CheckDBNull(model.PROVINCE).ToString() + "%'"); } if (model.BAY != "全部") { strSql.Append(" AND BAY = '" + model.BAY + "'"); } if (model.BUREAUDEVICE != "全部") { strSql.Append(" AND BUREAUDEVICE ='" + model.BUREAUDEVICE + "'"); } if (model.LOCALDEVICE != "全部") { strSql.Append(" AND LOCALDEVICE = '" + model.LOCALDEVICE + "'"); } if (model.SERVICE != "全部") { strSql.Append(" AND SERVICE = '" + model.SERVICE + "'"); } try { dbHelper.OpenConn(""); DataTable dt = new DataTable(); dt = dbHelper.GetDataTable(strSql.ToString(), parameters); dbHelper.CloseConn(); string result = JsonConvert.SerializeObject(dt, new DataTableConverter()); return(result); } catch (Exception ex) { LogBN.WriteLog(typeof(DEVICEATTACH_BN), "SearchEqipment 程序段的异常" + ex); return(""); } }
/// <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); }