public string SqlInsert(string tableName, List <FieldInfo> fields)
{
//Oracle没有自增字段，如果检测到自增字段，则替换
string currentID = "PK_SEQ_" + tableName + ".NEXTVAL";
string sql = "Insert Into " + tableName + " (";
sql = sql + FactoryHelper.CreateFieldList(fields, true, false, "");
sql = sql + ")Values(" + FactoryHelper.CreateFieldList(fields, true, false, ParaSymbol) + ")";
sql = sql.Replace(ParaSymbol + AUTO_INCREASE_FIELD, currentID);
return(sql);
}
public string SqlInsert(string tableName, List <FieldInfo> fields)
{
FieldInfo pk = fields.Find(s => s.IsPrimaryKey);
if (pk == null)
{
return("");
}
string sql = "Insert Into " + tableName + " (";
//如果主键是自增，则不包括主键和自增
if (pk.IsAutoIncrease)
{
sql = sql + FactoryHelper.CreateFieldList(fields, false, false, "");
sql = sql + ")Values(" + FactoryHelper.CreateFieldList(fields, false, false, ParaSymbol) + ")";
}
else
{
//如果主键不是自增，则必须手动输入主键，因此包括主键字段
sql = sql + FactoryHelper.CreateFieldList(fields, true, false, "");
sql = sql + ")Values(" + FactoryHelper.CreateFieldList(fields, true, false, ParaSymbol) + ")";
}
return(sql);
}
public string SqlSelect(string tableName, List <FieldInfo> fields)
{
string sql = "Select " + FactoryHelper.CreateFieldList(fields, true, true, "") + " From " + tableName + " Where ";
return(sql);
}
public string SqlAllFields(List <FieldInfo> fields)
{
return(FactoryHelper.CreateFieldList(fields, true, true, ""));
}