private static string GetColumns <T>(Coltype type)
{
string result = "";
foreach (var pInfo in typeof(T).GetProperties())
{
if (!IsValidColumn(pInfo))
{
continue;
}
switch (type)
{
case Coltype.type1:
result += pInfo.Name + ",";
break;
case Coltype.type2:
result += "@" + pInfo.Name + ",";
break;
case Coltype.type3:
result += pInfo.Name + "=@" + pInfo.Name + ",";
break;
}
}
if (result.Length > 1)
{
result = result.Remove(result.Length - 1);
}
return(result);
}
private static string GetColumns <T>(Coltype type)
{
string result = "";
foreach (var pInfo in typeof(T).GetProperties())
{
if (IsAutoPKColumn(pInfo) || IsIgnoreColumn(pInfo))
{
continue;
}
switch (type)
{
case Coltype.insert:
result += pInfo.Name + ",";
break;
case Coltype.insertv:
result += "@" + pInfo.Name + ",";
break;
case Coltype.update:
if (IsUpdateIgnoreColumn(pInfo))
{
continue;
}
result += pInfo.Name + "=@" + pInfo.Name + ",";
break;
}
}
// remove last ','
if (result.Length > 1)
{
result = result.Remove(result.Length - 1);
}
return(result);
}
