private void BuildInsertValue(AttributeFieldMap field, object value) { if (InsertFields.Length > 0) { InsertFields += ", "; } InsertFields += String.Format("[{0}]", field.FieldName); if (InsertValues.Length > 0) { InsertValues += ", "; } InsertValues += "@" + ParamIndex; var param = Command.CreateParameter(); param.ParameterName = "@" + ParamIndex; param.Value = value; Command.Parameters.Add(param); ParamIndex++; }
private void BuildUpdateValue(AttributeFieldMap field, object value) { if (UpdateFields.Length > 0) { UpdateFields += ", "; } UpdateFields += String.Format("[{0}] = @{1}", field.FieldName, ParamIndex); if (InsertFields.Length > 0) { InsertFields += ", "; } InsertFields += String.Format("[{0}]", field.FieldName); if (InsertValues.Length > 0) { InsertValues += ", "; } InsertValues += "@" + ParamIndex; var param = Command.CreateParameter(); param.ParameterName = "@" + ParamIndex; if (value == null) { param.Value = DBNull.Value; } else if (String.IsNullOrEmpty(value.ToString())) { param.Value = DBNull.Value; } else { param.Value = value; } Command.Parameters.Add(param); ParamIndex++; }