public void Update(model.Evaluation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Evaluation set "); strSql.Append("FI_ID='" + model.FI_ID + "',"); strSql.Append("FM_name='" + model.FM_name + "',"); strSql.Append("RF_name='" + model.RF_name + "',"); strSql.Append("ExpertName='" + model.ExpertName + "',"); strSql.Append("FM_score='" + model.FM_score + "',"); strSql.Append("Spare1='" + model.Spare1 + "',"); strSql.Append("Spare2='" + model.Spare2 + "',"); strSql.Append("Spare3='" + model.Spare3 + "',"); strSql.Append("Spare4='" + model.Spare4 + "'"); strSql.Append(" where ID=" + model.ID + " "); DbHelperSQL.ExecuteSql(strSql.ToString()); }
public void Add(model.Evaluation model) { model.ID = GetMaxID() + 1; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Evaluation("); strSql.Append("ID,FI_ID,FM_name,RF_name,ExpertName,FM_score,Spare1,Spare2,Spare3,Spare4"); strSql.Append(")"); strSql.Append(" values ("); strSql.Append("" + model.ID + ","); strSql.Append("'" + model.FI_ID + "',"); strSql.Append("'" + model.FM_name + "',"); strSql.Append("'" + model.RF_name + "',"); strSql.Append("'" + model.ExpertName + "',"); strSql.Append("'" + model.FM_score + "',"); strSql.Append("'" + model.Spare1 + "',"); strSql.Append("'" + model.Spare2 + "',"); strSql.Append("'" + model.Spare3 + "',"); strSql.Append("'" + model.Spare4 + "'"); strSql.Append(")"); DbHelperSQL.ExecuteSql(strSql.ToString()); }