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 BuildGetSQL(PanelContext data, System.Data.IDataParameterCollection parameters)
{
StringBuilder sqlwehre = BuilderWhereSqlByDataKey(data, parameters, "");
string sql = String.Format(SQLLIST, data.Table.Name, sqlwehre, data.Panel.Context.Orders);
return(sql);
}
public string BuildListSQL(PanelContext data, System.Data.IDataParameterCollection parameters, int startindex, int itemcount)
{
StringBuilder sqlwehre = BuildWhereSql(data, parameters);
string sql = "";
if (startindex > 0)
{
string revorders = regex.Replace(data.Orders, delegate(Match m)
{
if (String.Compare(m.Value, "desc", true) == 0)
{
return("ASC");
}
else
{
return("DESC");
}
});
int firstcount = itemcount + startindex;
sql = String.Format(SQLPAGELIST, firstcount, data.Table.Name, sqlwehre, data.Orders, itemcount, revorders, data.Orders);
}
else if (itemcount > 0)
{
sql = String.Format(SQLTOPLIST, itemcount, data.Table.Name, sqlwehre, data.Orders);
}
else
{
sql = String.Format(SQLLIST, data.Table.Name, sqlwehre, data.Orders);
}
return(sql);
}
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));
}
public string BuildDeleteSQL(PanelContext data, System.Data.IDataParameterCollection parameters)
{
StringBuilder sqlwhere = BuilderWhereSqlByDataKey(data, parameters, "");
return(String.Format(SQLDELETE, data.Table.Name, sqlwhere));
}
public string BuildCountSQL(PanelContext data, System.Data.IDataParameterCollection parameters)
{
StringBuilder sqlwehre = BuildWhereSql(data, parameters);
return(String.Format(SQLCOUNT, data.Table.Name, sqlwehre));
}
protected internal ParameterCollectionWrapper(System.Data.IDataParameterCollection paramCollection)
: base(paramCollection)
{
}