/// <summary>
/// 执行指定的SqlMapObject
/// </summary>
/// <param name="map">指定的SqlMapObject，该对象封装了SqlCommand的必要属性</param>
/// <returns></returns>
public static SqlResult ExecuteMapObject(SqlMapObject map)
{
if (map == null)
{
return(null);
}
SqlResult result;
StatementType stype = map.GetStatementType();
CommandType ctype = map.GetCommandType();
string cmdText = map.Sql;
SqlParameter[] paras = map.GetParameters();
// TODO:是否使用事务 from map object
//bool useTrans = false;
switch (stype)
{
case StatementType.Insert:
int rowAffected = DBHelper.ExecuteNonQuery(ctype, cmdText, paras);
result = new SqlResult(rowAffected, stype);
break;
case StatementType.Update:
int rowUpdated = DBHelper.ExecuteNonQuery(ctype, cmdText, paras);
result = new SqlResult(rowUpdated, stype);
break;
case StatementType.Delete:
int rowDeleted = DBHelper.ExecuteNonQuery(ctype, cmdText, paras);
result = new SqlResult(rowDeleted, stype);
break;
case StatementType.Select:
DataSet ds = DBHelper.ExecuteDataSet(ctype, cmdText, paras);
result = new SqlResult(ds, stype);
break;
default:
result = null;
break;
}
return(result);
}
/// <summary>
/// 执行指定的Sql命令
/// </summary>
/// <param name="blockName"></param>
/// <param name="commandName"></param>
/// <returns></returns>
public static SqlResult ExecuteMapObject(string blockName, string commandName)
{
SqlMapObject map = GetSqlMapObject(blockName, commandName);
return(ExecuteMapObject(map));
}
