public int Add(OprateToInformationModel model, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into GOV_TC_DB_OPRATETOINFORMATION(");
builder.Append("COMPANYPK,OPRATETACHEPK,BUILDINGPROPK,PAPERSPK,NAME,IFMUST,REMARK");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + model.COMPANYPK + "',");
builder.Append("'" + model.OPRATETACHEPK + "',");
builder.Append("'" + model.BUILDINGPROPK + "',");
builder.Append("'" + model.PAPERSPK + "',");
builder.Append("'" + model.NAME + "',");
builder.Append("'" + model.IFMUST + "',");
builder.Append("'" + model.REMARK + "'");
builder.Append(")");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public OprateToInformationModel[] 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, "");
OprateToInformationModel[] modelArray = null;
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
modelArray = new OprateToInformationModel[set.Tables[0].Rows.Count];
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
modelArray[i] = new OprateToInformationModel();
modelArray[i] = this.GetModel(set.Tables[0].Rows[i]);
}
return modelArray;
}
public int Update(OprateToInformationModel model, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("update GOV_TC_DB_OPRATETOINFORMATION set ");
builder.Append("COMPANYPK='" + model.COMPANYPK + "',");
builder.Append("OPRATETACHEPK='" + model.OPRATETACHEPK + "',");
builder.Append("BUILDINGPROPK='" + model.BUILDINGPROPK + "',");
builder.Append("PAPERSPK='" + model.PAPERSPK + "',");
builder.Append("NAME='" + model.NAME + "',");
builder.Append("IFMUST='" + model.IFMUST + "',");
builder.Append("REMARK='" + model.REMARK + "'");
builder.Append(" where PK='" + model.PK + "' ");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}