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++;
}
