public static ArrayList GetSPParamDefaultValue(string spDefinition)
{
var results = new ArrayList();
MatchCollection o = null;
string expr =
"\\s*@(?<nm>\\w+)\\s*" +
"(?<type>[^\\s\\(]+\\s*\\(\\s*((\\w+\\s*\\))|(\\d+\\s*\\))|(\\d+\\s*,\\s*\\d+\\s*\\))))\\s*=\\s*" +
"(?<defvalueStr>((?<!(?-i)N*')(?<defvalue>\\w+)\\s*)|((?-i)N*'" +
"(?<defvalue>(((?<![^']')''(?!'[^']))|([^']))*)" +
"'))\\s*(,|\\))";
regexUtil.regexFun(spDefinition, expr, null, (regexUtil.regexAct) 2, null, 0, 0, ref o, -1);
int idx = 0;
foreach (Match m in o)
{
var spparam = new SPParameters();
spparam.ParamID = new SqlInt32(idx);
spparam.ParamName = new SqlString(m.Groups["nm"].Value);
spparam.ParamType = new SqlString(m.Groups["type"].Value);
spparam.ParamDefaultStr = new SqlString(m.Groups["defvalueStr"].Value);
spparam.ParamDefaultValue = new SqlString(m.Groups["defvalue"].Value);
idx++;
results.Add(spparam);
}
return(results);
}
public static ArrayList GetSPParamDefaultValue(string spDefinition) {
var results = new ArrayList();
MatchCollection o = null;
string expr =
"\\s*@(?<nm>\\w+)\\s*" +
"(?<type>[^\\s\\(]+\\s*\\(\\s*((\\w+\\s*\\))|(\\d+\\s*\\))|(\\d+\\s*,\\s*\\d+\\s*\\))))\\s*=\\s*" +
"(?<defvalueStr>((?<!(?-i)N*')(?<defvalue>\\w+)\\s*)|((?-i)N*'" +
"(?<defvalue>(((?<![^']')''(?!'[^']))|([^']))*)" +
"'))\\s*(,|\\))";
regexUtil.regexFun(spDefinition, expr, null, (regexUtil.regexAct)2, null, 0, 0, ref o, -1);
int idx = 0;
foreach (Match m in o) {
var spparam = new SPParameters();
spparam.ParamID = new SqlInt32(idx);
spparam.ParamName = new SqlString(m.Groups["nm"].Value);
spparam.ParamType = new SqlString(m.Groups["type"].Value);
spparam.ParamDefaultStr = new SqlString(m.Groups["defvalueStr"].Value);
spparam.ParamDefaultValue = new SqlString(m.Groups["defvalue"].Value);
idx++;
results.Add(spparam);
}
return results;
}
