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