aramsObject.Count(); i++)
{
SqlParameter sqlParameter = new SqlParameter(paramsObject[i].Key, paramsObject[i].Value);
sqlCmd.Parameters.Add(sqlParameter);
}
}
SqlDataAdapter sda = new SqlDataAdapter(sqlCmd);
sda.Fill(ResponseDs);
}
}
}
catch (Exception e)
{
ResponseBool = false;
ResponseMsg = $"查询存储过程时出现异常,存储过程:【{storedProcedureName}】\n 异常原因:【{e.Message}】\n 异常详细信息:【{e.StackTrace}】!";
}
return ResponseDs;
}
执行sql语句,进行增删改操作
/// <summary>
/// 增删改数据
/// </summary>
/// <param name="sqlConnStr, ">数据库连接字符串</param>
/// <param name="sql">执行的sql语句</param>
/// <param name="paramsObject">输入参数</param>
/// <returns></returns>
public static int SQLExecuteData(string sqlConnStr, string sql, params Paramete