public void ExecServerFunc()
{
string values = String.Empty;
foreach (ParamBase param in ParamsIn)
{
string value = param.Value.ToString();
if (param.ParamName == "IP")
{
value = param.ToString();
}
else if (param.Value.GetType().Equals(typeof(DateTime)))
{
value = String.Format("'{0:yyyyMMdd}'", (DateTime)param.Value);
}
else if (param.Value.GetType().Equals(typeof(String)))
{
if (value[0] != '\'')
{
value = "'" + value;
}
if (value[value.Length - 1] != '\'')
{
value += "'";
}
}
values += String.Format(",{0}", value);
}
ResSqlTable = SQLFunction.ExecuteSQL(
String.Format("select * from {0}({1}) order by row_id", FunctionName, values.Remove(0, 1)));
}
DataTable getType()
{
return(SQLFunction.ExecuteSQL("select csType, sqlType from[matchTmpType] "));
}
