public int Add(DataColumnModel model, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("insert into DB_DATACOLUMN("); builder.Append("TABLEPK,COLUMNREMARK,COLUMNNAME,REMARK"); builder.Append(")"); builder.Append(" values ("); builder.Append("'" + model.TABLEPK + "',"); builder.Append("'" + model.COLUMNREMARK + "',"); builder.Append("'" + model.COLUMNNAME + "',"); builder.Append("'" + model.REMARK + "'"); builder.Append(")"); return dbo.ExecutionIsSucess(builder.ToString(), null); }
public DataColumnModel[] GetModels(string strWhere, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append(this.GetSql()); if (strWhere != "") { builder.Append(" where " + strWhere); } OracleParameter[] parameters = null; DataSet set = dbo.BackDataSet(builder.ToString(), parameters, ""); DataColumnModel[] modelArray = null; if (set.Tables[0].Rows.Count <= 0) { return null; } modelArray = new DataColumnModel[set.Tables[0].Rows.Count]; for (int i = 0; i < set.Tables[0].Rows.Count; i++) { modelArray[i] = new DataColumnModel(); modelArray[i] = this.GetModel(set.Tables[0].Rows[i]); } return modelArray; }
public int Update(DataColumnModel model, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("update DB_DATACOLUMN set "); builder.Append("TABLEPK='" + model.TABLEPK + "',"); builder.Append("COLUMNREMARK='" + model.COLUMNREMARK + "',"); builder.Append("COLUMNNAME='" + model.COLUMNNAME + "',"); builder.Append("REMARK='" + model.REMARK + "'"); builder.Append(" where PK='" + model.PK + "' "); return dbo.ExecutionIsSucess(builder.ToString(), null); }