/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.CLASSIFIERTB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CLASSIFIERTB("); strSql.Append("ID,CLASSNAME,COLUMNNAME,SETSCALE,COMMENTS)"); strSql.Append(" values ("); strSql.Append(":ID,:CLASSNAME,:COLUMNNAME,:SETSCALE,:COMMENTS)"); OracleParameter[] parameters = { new OracleParameter(":ID", OracleType.VarChar, 20), new OracleParameter(":CLASSNAME", OracleType.VarChar, 80), new OracleParameter(":COLUMNNAME", OracleType.VarChar, 20), new OracleParameter(":SETSCALE", OracleType.VarChar, 50), new OracleParameter(":COMMENTS", OracleType.VarChar, 50) }; parameters[0].Value = model.ID; parameters[1].Value = model.CLASSNAME; parameters[2].Value = model.COLUMNNAME; parameters[3].Value = model.SETSCALE; parameters[4].Value = model.COMMENTS; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.CLASSIFIERTB DataRowToModel(DataRow row) { Model.CLASSIFIERTB model = new Model.CLASSIFIERTB(); if (row != null) { if (row["ID"] != null) { model.ID = row["ID"].ToString(); } if (row["CLASSNAME"] != null) { model.CLASSNAME = row["CLASSNAME"].ToString(); } if (row["COLUMNNAME"] != null) { model.COLUMNNAME = row["COLUMNNAME"].ToString(); } if (row["SETSCALE"] != null) { model.SETSCALE = row["SETSCALE"].ToString(); } if (row["COMMENTS"] != null) { model.COMMENTS = row["COMMENTS"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.CLASSIFIERTB GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,CLASSNAME,COLUMNNAME,SETSCALE,COMMENTS from CLASSIFIERTB "); strSql.Append(" where "); OracleParameter[] parameters = { }; Model.CLASSIFIERTB model = new Model.CLASSIFIERTB(); DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.CLASSIFIERTB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CLASSIFIERTB set "); strSql.Append("ID=:ID,"); strSql.Append("CLASSNAME=:CLASSNAME,"); strSql.Append("COLUMNNAME=:COLUMNNAME,"); strSql.Append("SETSCALE=:SETSCALE,"); strSql.Append("COMMENTS=:COMMENTS"); strSql.Append(" where "); OracleParameter[] parameters = { new OracleParameter(":ID", OracleType.VarChar, 20), new OracleParameter(":CLASSNAME", OracleType.VarChar, 80), new OracleParameter(":COLUMNNAME", OracleType.VarChar, 20), new OracleParameter(":SETSCALE", OracleType.VarChar, 50), new OracleParameter(":COMMENTS", OracleType.VarChar, 50) }; parameters[0].Value = model.ID; parameters[1].Value = model.CLASSNAME; parameters[2].Value = model.COLUMNNAME; parameters[3].Value = model.SETSCALE; parameters[4].Value = model.COMMENTS; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.CLASSIFIERTB model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.CLASSIFIERTB model) { return(dal.Add(model)); }