public bool Update(Business_DataItemModel model) { StringBuilder builder = new StringBuilder(); builder.Append(" update OPM_Business_DataItem set "); builder.Append(" CodeID='" + model.CodeId + "',"); builder.Append(" PCode='" + model.PCode + "',"); builder.Append(" PName='" + model.PName + "',"); DateTime designDate = model.DesignDate; builder.Append(" DesignDate='" + model.DesignDate + "',"); builder.Append(" Remark='" + model.Remark + "'"); builder.Append(" where UID='" + model.UID + "'"); return(publicDbOpClass.NonQuerySqlString(builder.ToString())); }
public bool Add(Business_DataItemModel model) { StringBuilder builder = new StringBuilder(); builder.Append(" insert into OPM_Business_DataItem(UID,CodeID ,PCode ,PName ,FlowState ,DesignDate ,Remark ,AddUser ,AddTime,IsValid)"); builder.Append(" values( "); builder.Append(" '" + model.UID + "', "); builder.Append(" '" + model.CodeId + "', "); builder.Append(" '" + model.PCode + "', "); builder.Append(" '" + model.PName + "', "); builder.Append(" " + model.FlowState + ", "); DateTime designDate = model.DesignDate; builder.Append(" '" + model.DesignDate + "', "); builder.Append(" '" + model.Remark + "', "); builder.Append(" '" + model.AddUser + "', "); builder.Append(" '" + model.AddTime + "', "); builder.Append(" '" + model.IsValid + "')"); return(publicDbOpClass.NonQuerySqlString(builder.ToString())); }