public int Add(SFZSZXFJModel model, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("insert into GOV_TC_DB_SFZSZXFJ("); builder.Append("EXECUTESTANDARDPK,TERMNAME,TERMVALUE,EXEMIN,EXEMAX,DISCRIPTION"); builder.Append(")"); builder.Append(" values ("); builder.Append(model.EXECUTESTANDARDPK + ","); builder.Append(model.TERMNAME + ","); builder.Append(model.TERMVALUE + ","); builder.Append(model.EXEMIN + ","); builder.Append(model.EXEMAX + ","); builder.Append(model.DISCRIPTION ?? ""); builder.Append(")"); return dbo.ExecutionIsSucess(builder.ToString(), null); }
public SFZSZXFJModel GetModel(DataRow dr) { SFZSZXFJModel model = new SFZSZXFJModel { PK = dr["PK"].ToString(), EXECUTESTANDARDPK = dr["EXECUTESTANDARDPK"].ToString(), TERMNAME = dr["TERMNAME"].ToString() }; if (dr["TERMVALUE"].ToString() != "") { model.TERMVALUE = int.Parse(dr["TERMVALUE"].ToString()); } if (dr["EXEMIN"].ToString() != "") { model.EXEMIN = int.Parse(dr["EXEMIN"].ToString()); } if (dr["EXEMAX"].ToString() != "") { model.EXEMAX = int.Parse(dr["EXEMAX"].ToString()); } model.DISCRIPTION = dr["DISCRIPTION"].ToString(); return model; }
public SFZSZXFJModel[] 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, ""); SFZSZXFJModel[] modelArray = null; if (set.Tables[0].Rows.Count <= 0) { return null; } modelArray = new SFZSZXFJModel[set.Tables[0].Rows.Count]; for (int i = 0; i < set.Tables[0].Rows.Count; i++) { modelArray[i] = new SFZSZXFJModel(); modelArray[i] = this.GetModel(set.Tables[0].Rows[i]); } return modelArray; }
public int Update(SFZSZXFJModel model, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("update GOV_TC_DB_SFZSZXFJ set "); builder.Append("EXECUTESTANDARDPK=" + model.EXECUTESTANDARDPK + ","); builder.Append("TERMNAME=" + model.TERMNAME + ","); builder.Append("TERMVALUE=" + model.TERMVALUE + ","); builder.Append("EXEMIN=" + model.EXEMIN + ","); builder.Append("EXEMAX=" + model.EXEMAX + ","); builder.Append("DISCRIPTION=" + model.DISCRIPTION); builder.Append(" where PK=" + model.PK); return dbo.ExecutionIsSucess(builder.ToString(), null); }