public string BuildInsertSQL(PanelContext data, System.Data.IDataParameterCollection parameters)
{
StringBuilder fieldlist = new StringBuilder();
StringBuilder paramlist = new StringBuilder();
foreach (DataField field in data.Row)
{
string paramname = String.Format("@{0}", field.Column.Name);
fieldlist.AppendFormat("[{0}],", field.Column.Name);
paramlist.Append(paramname).Append(",");
if (field.Column.DataType == TypeCode.DateTime)
{
MySqlParameter param = new MySqlParameter(field.Column.Name, MySqlDbType.Datetime);
param.Value = field.Value;
parameters.Add(param);
}
else
{
parameters.Add(new MySqlParameter(paramname, field.Value));
}
}
Utils.TrimEndStringBuilder(fieldlist, ",");
Utils.TrimEndStringBuilder(paramlist, ",");
return(String.Format(SQLINSERT, data.Table.Name, fieldlist, paramlist));
}
public string BuildUpdateSQL(PanelContext data, System.Data.IDataParameterCollection parameters)
{
StringBuilder sqlupdatefield = new StringBuilder();
foreach (DataField field in data.Row)
{
sqlupdatefield.AppendFormat("{0}=@{0},", field.Column.Name);
if (field.Column.DataType == TypeCode.DateTime)
{
MySqlParameter param = new MySqlParameter(field.Column.Name, MySqlDbType.Datetime);
param.Value = field.Value;
parameters.Add(param);
}
else
{
parameters.Add(new MySqlParameter(field.Column.Name, field.Value));
}
}
Utils.TrimEndStringBuilder(sqlupdatefield, ",");
StringBuilder sqlwhere = BuilderWhereSqlByDataKey(data, parameters, "old");
return(String.Format(SQLUPDATE, data.Table.Name, sqlupdatefield, sqlwhere));
}
