/// <summary> /// 增加一条数据 /// </summary> public void Add(RelayTest.Model.ModelSYSTEM_LIST model) { try { Log.Info("DalSYSTEM_LIST->Add---START"); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_SYSTEM_LIST("); strSql.Append("F_TYPE,F_VALUE,F_DISPLAY"); strSql.Append(") values ("); strSql.Append(":F_TYPE,:F_VALUE,:F_DISPLAY"); strSql.Append(") "); OracleParameter[] parameters = { new OracleParameter(":F_TYPE", OracleType.VarChar, 50), new OracleParameter(":F_VALUE", OracleType.Number, 4), new OracleParameter(":F_DISPLAY", OracleType.VarChar, 50) }; if (model.F_TYPE == null) { parameters[0].Value = DBNull.Value; } else { parameters[0].Value = model.F_TYPE; } if (model.F_VALUE == null) { parameters[1].Value = DBNull.Value; } else { parameters[1].Value = model.F_VALUE; } if (model.F_DISPLAY == null) { parameters[2].Value = DBNull.Value; } else { parameters[2].Value = model.F_DISPLAY; } ExecuteSql(strSql.ToString(), parameters); } catch (Exception ex) { Log.Error("DalSYSTEM_LIST->Add---FAILED", ex); throw ex; } }
/// <summary> /// 得到一个对象实体 /// </summary> public RelayTest.Model.ModelSYSTEM_LIST GetModel(string F_TYPE, decimal F_VALUE) { try { Log.Info("DalSYSTEM_LIST->GetModel---START"); StringBuilder strSql = new StringBuilder(); strSql.Append("select F_TYPE, F_VALUE, F_DISPLAY "); strSql.Append(" from T_SYSTEM_LIST "); strSql.Append(" where 1=1 AND F_TYPE=:F_TYPE and F_VALUE=:F_VALUE "); OracleParameter[] parameters = { new OracleParameter(":F_TYPE", OracleType.VarChar, 50), new OracleParameter(":F_VALUE", OracleType.Number, 4) }; parameters[0].Value = F_TYPE; parameters[1].Value = F_VALUE; RelayTest.Model.ModelSYSTEM_LIST model = new RelayTest.Model.ModelSYSTEM_LIST(); DataSet ds = Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.F_TYPE = ds.Tables[0].Rows[0]["F_TYPE"].ToString(); if (ds.Tables[0].Rows[0]["F_VALUE"].ToString() != "") { model.F_VALUE = decimal.Parse(ds.Tables[0].Rows[0]["F_VALUE"].ToString()); } model.F_DISPLAY = ds.Tables[0].Rows[0]["F_DISPLAY"].ToString(); return(model); } else { return(null); } } catch (Exception ex) { Log.Error("DalSYSTEM_LIST->GetModel---FAILED", ex); throw ex; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(RelayTest.Model.ModelSYSTEM_LIST model) { try { Log.Info("DalSYSTEM_LIST->Update---START"); StringBuilder strSql = new StringBuilder(); strSql.Append("update T_SYSTEM_LIST set "); strSql.Append(" F_TYPE = :F_TYPE , "); strSql.Append(" F_VALUE = :F_VALUE , "); strSql.Append(" F_DISPLAY = :F_DISPLAY "); strSql.Append(" where F_TYPE=:F_TYPE and F_VALUE=:F_VALUE "); OracleParameter[] parameters = { new OracleParameter(":F_TYPE", OracleType.VarChar, 50), new OracleParameter(":F_VALUE", OracleType.Number, 4), new OracleParameter(":F_DISPLAY", OracleType.VarChar, 50) }; if (model.F_TYPE == null) { parameters[0].Value = DBNull.Value; } else { parameters[0].Value = model.F_TYPE; } if (model.F_VALUE == null) { parameters[1].Value = DBNull.Value; } else { parameters[1].Value = model.F_VALUE; } if (model.F_DISPLAY == null) { parameters[2].Value = DBNull.Value; } else { parameters[2].Value = model.F_DISPLAY; } int rows = ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } } catch (Exception ex) { Log.Error("DalSYSTEM_LIST->Update---FAILED", ex); throw ex; } }