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