public int Update(WFBusinessClass model) { StringBuilder builder = new StringBuilder(); builder.Append("update WF_Business_Class set "); builder.Append("BusinessClassName='" + model.BusinessClassName + "'"); builder.Append(" where BusinessCode='" + model.BusinessCode + "'"); builder.Append(" and BusinessClass='" + model.BusinessClass + "'"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
public int Add(WFBusinessClass model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into WF_Business_Class("); builder.Append("BusinessCode,BusinessClass,BusinessClassName"); builder.Append(")"); builder.Append(" values ("); builder.Append("'" + model.BusinessCode + "',"); builder.Append("'" + model.BusinessClass + "',"); builder.Append("'" + model.BusinessClassName + "'"); builder.Append(")"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }