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);
}