public void Add(model.FMEAItem model)
{
model.ID = GetMaxID() + 1;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into FMEAITEM(");
strSql.Append("ID,UUID,FI_name,FI_describe,FI_startTime,FI_endTime,ExpertNumber,EvaluatedNumber,IsSubmit,IsComplete,Spare1,Spare2,Spare3,Spare4");
strSql.Append(")");
strSql.Append(" values (");
strSql.Append("" + model.ID + ",");
strSql.Append("'" + model.UUID + "',");
strSql.Append("'" + model.FI_name + "',");
strSql.Append("'" + model.FI_describe + "',");
strSql.Append("'" + model.FI_startTime + "',");
strSql.Append("'" + model.FI_endTime + "',");
strSql.Append("'" + model.ExpertNumber + "',");
strSql.Append("'" + model.EvaluatedNumber + "',");
strSql.Append("'" + model.IsSubmit + "',");
strSql.Append("'" + model.IsComplete + "',");
strSql.Append("'" + model.Spare1 + "',");
strSql.Append("'" + model.Spare2 + "',");
strSql.Append("'" + model.Spare3 + "',");
strSql.Append("'" + model.Spare4 + "'");
strSql.Append(")");
DbHelperSQL.ExecuteSql(strSql.ToString());
}
public void Update(model.FMEAItem model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update FMEAITEM set ");
strSql.Append("FI_name='" + model.FI_name + "',");
strSql.Append("UUID='" + model.UUID + "',");
strSql.Append("FI_describe='" + model.FI_describe + "',");
strSql.Append("FI_startTime='" + model.FI_startTime + "',");
strSql.Append("FI_endTime='" + model.FI_endTime + "',");
strSql.Append("ExpertNumber='" + model.ExpertNumber + "',");
strSql.Append("EvaluatedNumber='" + model.EvaluatedNumber + "',");
strSql.Append("IsSubmit='" + model.IsSubmit + "',");
strSql.Append("IsComplete='" + model.IsComplete + "',");
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());
}
