public static void addHashObject(IHashObject obj, string key, object value)
{
if (obj.Keys.Contains(key))
obj[key] = value;
else
obj.Add(key, value);
}
protected void addParam(IHashObject qryParams, string key, object value)
{
if (qryParams.ContainsKey(key))
qryParams[key] = value;
else
qryParams.Add(key, value);
}
private void extractParamFromBaseSQL(IHashObject queryParams)
{
try
{
string[] ss = sql.Split('}');
string[] arry = new string[ss.Length - 1];
string key, value;
int index = 0;
for (int i = 0; i < ss.Length - 1; i++)
{
if (ss[i].IndexOf("{-") > 0) continue;
arry[i] = ss[i].Substring(ss[i].IndexOf("{"), ss[i].Length - ss[i].IndexOf("{")) + "}";
index = arry[i].IndexOf("=");
if (index <= 0) continue;
key = arry[i].Substring(1, index - 1).Trim();
value = arry[i].Substring(index + 1, arry[i].Length - index - 2);
if (!queryParams.ContainsKey(key))
{
queryParams.Add(key.Trim(), value);
}
sql = sql.Replace(arry[i], "");
}
}
catch (Exception e)
{
throw new Exception("SQLHelper抽取参数时出错：" + e.Message);
}
}
