/// <summary>
/// 返回受影响的条数
/// </summary>
/// <param name="db"></param>
/// <param name="action"></param>
/// <returns></returns>
public int execSQL(ADODB db, string action /*, HttpContext context*/)
{
int result = -1;
string sql = "";
if (lst != null)
{
action = action.ToLower();
switch (action)
{
case "add": //增加 应该一次只加一条数据
foreach (Dictionary <string, object> dic in lst)
{
sql = getAddSQL(dic);
}
break;
case "delete":
sql = getDeleteSQL();
break;
case "edit": //修改 应该一次只修改一条数据
foreach (Dictionary <string, object> dic in lst)
{
sql = getUpdateSQL(dic);
}
break;
default:
break;
}
if (sql.Length > 0)
{
msql = sql;
//context.Response.Write(sql);
result = db.execNonQuery(sql);
}
}
return(result);
}
